Racing data
HKJC Pool Investments
HKJC Pool Investments holds 3,529,039 records from the Hong Kong Jockey Club's published pool investment figures, covering January 2026 to November 2026, and is updated hourly.
Hong Kong horse racing betting pool investment data
hkjc_pool_investments
Rows
3,529,039
Coverage
January 2026 to November 2026
Columns
20
Latest data
2026-11-14
Sample
| race_date | venue_code | race_number | race_id | venue | race_class | distance | distance_category | pool_id | odds_type | pool_category | pool_status | sell_status | leg_number | investment_amount | last_update_time | snapshot_timestamp | minutes_to_post | updated_at | id |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2026-11-14 00:00:00 | ST | 1 | ST_20261114_R01 | Sha Tin | Class 4 (Restricted) | 1200 | Sprint | MTG_20261114_0001DBL1 | DBL | Multi-Race | INITIAL | STOP_SELL | 1 | — | — | 2026-11-12 01:10:43 | 3080 | 2026-11-12 01:10:43 | a5d3b31bb21122103ea49697c18855c9 |
| 2026-11-14 00:00:00 | ST | 1 | ST_20261114_R01 | Sha Tin | Class 4 (Restricted) | 1200 | Sprint | MTG_20261114_0001DBL1 | DBL | Multi-Race | INITIAL | STOP_SELL | 1 | — | — | 2026-11-12 05:50:38 | 2800 | 2026-11-12 05:50:38 | 655d1d7330da1c8e26ea62e023dddc29 |
| 2026-11-14 00:00:00 | ST | 1 | ST_20261114_R01 | Sha Tin | Class 4 (Restricted) | 1200 | Sprint | MTG_20261114_0001DBL1 | DBL | Multi-Race | DEFINED | STOP_SELL | 1 | — | — | 2026-11-12 06:10:07 | 2780 | 2026-11-12 06:10:07 | 86ac61f3731667464fa0fba1413160d6 |
| 2026-11-14 00:00:00 | ST | 1 | ST_20261114_R01 | Sha Tin | Class 4 (Restricted) | 1200 | Sprint | MTG_20261114_0001DBL1 | DBL | Multi-Race | DEFINED | STOP_SELL | 1 | — | — | 2026-11-12 08:20:27 | 2650 | 2026-11-12 08:20:27 | 4e914a41531e0f8a640d0c31b7e98aff |
| 2026-11-14 00:00:00 | ST | 1 | ST_20261114_R01 | Sha Tin | Class 4 (Restricted) | 1200 | Sprint | MTG_20261114_0001DBL1 | DBL | Multi-Race | DEFINED | STOP_SELL | 1 | — | — | 2026-11-12 08:50:59 | 2620 | 2026-11-12 08:50:59 | 410675d43d1811608d5ff0398e62edd3 |
| 2026-11-14 00:00:00 | ST | 1 | ST_20261114_R01 | Sha Tin | Class 4 (Restricted) | 1200 | Sprint | MTG_20261114_0001DBL1 | DBL | Multi-Race | DEFINED | STOP_SELL | 1 | — | — | 2026-11-13 01:40:12 | 1610 | 2026-11-13 01:40:12 | 43fc473296575fb554a342bfff3bdb46 |
| 2026-11-14 00:00:00 | ST | 1 | ST_20261114_R01 | Sha Tin | Class 4 (Restricted) | 1200 | Sprint | MTG_20261114_0001DBL1 | DBL | Multi-Race | DEFINED | STOP_SELL | 1 | — | — | 2026-11-13 02:11:38 | 1579 | 2026-11-13 02:11:38 | 5fffbd8a6852081a7bcec2038d56735e |
| 2026-11-14 00:00:00 | ST | 1 | ST_20261114_R01 | Sha Tin | Class 4 (Restricted) | 1200 | Sprint | MTG_20261114_0001DBL1 | DBL | Multi-Race | DEFINED | STOP_SELL | 1 | — | — | 2026-11-13 03:30:16 | 1500 | 2026-11-13 03:30:16 | fb15a843177fbb11fb472a934eadcef8 |
Both open directly in a spreadsheet.
Also as compressed CSV, JSON
Columns
| Column | Type | Description |
|---|---|---|
| race_date | date and time | Date of the race |
| venue_code | text | Venue code (ST=Sha Tin, HV=Happy Valley) |
| race_number | number | Race number |
| race_id | text | Generated race identifier for joins |
| venue | text | Full venue name |
| race_class | text | Race class (denormalized from races) |
| distance | number | Race distance in meters |
| distance_category | text | Distance category (Sprint/Mile/Middle/Long) |
| pool_id | text | Unique pool identifier |
| odds_type | text | Pool type (WIN, PLA, QIN, QPL, FCT, TCE, TRI, etc.) |
| pool_category | text | Pool category grouping |
| pool_status | text | Current pool status as HKJC publishes it: INITIAL/DEFINED (set up), START_SELL (selling), STOP_SELL/CLOSED (betting closed), PAYOUT (dividends declared), REFUND_BEFORE_CLOSE or REFUND_AFTER_CLOSE (bets refunded, e.g. an abandoned race), CLOSED_AFTER_REFUND |
| sell_status | text | Selling status (open/closed) |
| leg_number | number | Leg number for multi-leg pools |
| investment_amount | number | Total investment in pool (HKD) |
| last_update_time | date and time | Time of last investment update |
| snapshot_timestamp | date and time | When this snapshot was captured |
| minutes_to_post | number | Minutes until race post time (negative = after post) |
| updated_at | date and time | Timestamp when record was last scraped |
| id | text | Stable unique identifier for this row — the last column of every export. Use it to deduplicate, to key an incremental load, or to reference one specific row. It is additive: the entity and join keys you already use (race_id, horse_id, and the like) are unchanged. |
Query it
Every table can be queried with SQL, the API or an AI assistant, using a Renavon account.
SELECT * FROM renavon_exports.hkjc_pool_investments LIMIT 10
Ways to get this table
Free sample
Last 12 months of pool investments per race, full schema. Use to gauge liquidity by pool type before committing.
Free
Download the sampleOne-off archive
24 January 2026 to present · does not update
US$199
Buy the archive Pool InvestmentsRacing Pass Pro
A rolling 24-month window, currently from November 2024with 13 other tables
US$1,490/yr
billed yearly · or US$149/mo Racing Pass Pro
Subscribe to Racing Pass ProPrices and checkout are handled entirely by Renavon. HKJC Guru does not process these payments.