Racing data
HKJC Pool Investments
Hong Kong horse racing betting pool investment data
hkjc_pool_investments
Rows
3,082,526
Coverage
January 2026 to October 2026
Columns
20
Latest data
2026-10-01
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-10-01 00:00:00 | ST | 1 | ST_20261001_R01 | Sha Tin | Class 5 | 1200 | Sprint | MTG_20261001_0001DBL1 | DBL | Multi-Race | INITIAL | STOP_SELL | 1 | — | — | 2026-09-28 01:10:40 | 4550 | 2026-09-28 01:10:40 | 1f7b0a47dbf25df44f5561551ffcc85d |
| 2026-10-01 00:00:00 | ST | 1 | ST_20261001_R01 | Sha Tin | Class 5 | 1200 | Sprint | MTG_20261001_0001DBL1 | DBL | Multi-Race | INITIAL | STOP_SELL | 1 | — | — | 2026-09-28 04:40:25 | 4340 | 2026-09-28 04:40:25 | 5a5b01db467036490dbe4ca88f415c3b |
| 2026-10-01 00:00:00 | ST | 1 | ST_20261001_R01 | Sha Tin | Class 5 | 1200 | Sprint | MTG_20261001_0001DBL1 | DBL | Multi-Race | DEFINED | STOP_SELL | 1 | — | — | 2026-09-28 05:40:05 | 4280 | 2026-09-28 05:40:05 | 44959a7f20f23169cbed3185a14393ba |
| 2026-10-01 00:00:00 | ST | 1 | ST_20261001_R01 | Sha Tin | Class 5 | 1200 | Sprint | MTG_20261001_0001DBL1 | DBL | Multi-Race | DEFINED | STOP_SELL | 1 | — | — | 2026-09-29 08:00:48 | 2700 | 2026-09-29 08:00:48 | 42e14c12d9dbfb2d55bc02a3745297bf |
| 2026-10-01 00:00:00 | ST | 1 | ST_20261001_R01 | Sha Tin | Class 5 | 1200 | Sprint | MTG_20261001_0001DBL1 | DBL | Multi-Race | DEFINED | STOP_SELL | 1 | — | — | 2026-09-30 03:50:07 | 1510 | 2026-09-30 03:50:07 | e52e102d0c1dbab60978dd2c7be9a959 |
| 2026-10-01 00:00:00 | ST | 1 | ST_20261001_R01 | Sha Tin | Class 5 | 1200 | Sprint | MTG_20261001_0001DBL1 | DBL | Multi-Race | START_SELL | START_SELL | 1 | 0 | 2026-09-30 04:00:03 | 2026-09-30 04:00:23 | 1500 | 2026-09-30 04:00:23 | 431bae2b22cf1763423e7426f77a39c1 |
| 2026-10-01 00:00:00 | ST | 1 | ST_20261001_R01 | Sha Tin | Class 5 | 1200 | Sprint | MTG_20261001_0001DBL1 | DBL | Multi-Race | START_SELL | START_SELL | 1 | 1360 | 2026-09-30 04:10:02 | 2026-09-30 04:10:19 | 1490 | 2026-09-30 04:10:19 | ff19d665f2e6835027bb827b17ac41a1 |
| 2026-10-01 00:00:00 | ST | 1 | ST_20261001_R01 | Sha Tin | Class 5 | 1200 | Sprint | MTG_20261001_0001DBL1 | DBL | Multi-Race | START_SELL | START_SELL | 1 | 5480 | 2026-09-30 04:20:02 | 2026-09-30 04:21:01 | 1479 | 2026-09-30 04:21:01 | 826f961022454e7f7e0b6d0fe0598c58 |
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 |
| 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 10Ways 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
$149
Buy the archive Pool Investments (opens in new tab)Racing Pass Pro
A rolling 24-month window, currently from October 2024with 13 other tables
$149/mo
Subscribe to Racing Pass Pro (opens in new tab)