Skip to content

HKJC Guru is an independent statistics service and is not affiliated with, endorsed by, or connected to The Hong Kong Jockey Club.

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

8 rows shown
HKJC Pool Investments: Sample
race_datevenue_coderace_numberrace_idvenuerace_classdistancedistance_categorypool_idodds_typepool_categorypool_statussell_statusleg_numberinvestment_amountlast_update_timesnapshot_timestampminutes_to_postupdated_atid
2026-11-14 00:00:00ST1ST_20261114_R01Sha TinClass 4 (Restricted)1200SprintMTG_20261114_0001DBL1DBLMulti-RaceINITIALSTOP_SELL1——2026-11-12 01:10:4330802026-11-12 01:10:43a5d3b31bb21122103ea49697c18855c9
2026-11-14 00:00:00ST1ST_20261114_R01Sha TinClass 4 (Restricted)1200SprintMTG_20261114_0001DBL1DBLMulti-RaceINITIALSTOP_SELL1——2026-11-12 05:50:3828002026-11-12 05:50:38655d1d7330da1c8e26ea62e023dddc29
2026-11-14 00:00:00ST1ST_20261114_R01Sha TinClass 4 (Restricted)1200SprintMTG_20261114_0001DBL1DBLMulti-RaceDEFINEDSTOP_SELL1——2026-11-12 06:10:0727802026-11-12 06:10:0786ac61f3731667464fa0fba1413160d6
2026-11-14 00:00:00ST1ST_20261114_R01Sha TinClass 4 (Restricted)1200SprintMTG_20261114_0001DBL1DBLMulti-RaceDEFINEDSTOP_SELL1——2026-11-12 08:20:2726502026-11-12 08:20:274e914a41531e0f8a640d0c31b7e98aff
2026-11-14 00:00:00ST1ST_20261114_R01Sha TinClass 4 (Restricted)1200SprintMTG_20261114_0001DBL1DBLMulti-RaceDEFINEDSTOP_SELL1——2026-11-12 08:50:5926202026-11-12 08:50:59410675d43d1811608d5ff0398e62edd3
2026-11-14 00:00:00ST1ST_20261114_R01Sha TinClass 4 (Restricted)1200SprintMTG_20261114_0001DBL1DBLMulti-RaceDEFINEDSTOP_SELL1——2026-11-13 01:40:1216102026-11-13 01:40:1243fc473296575fb554a342bfff3bdb46
2026-11-14 00:00:00ST1ST_20261114_R01Sha TinClass 4 (Restricted)1200SprintMTG_20261114_0001DBL1DBLMulti-RaceDEFINEDSTOP_SELL1——2026-11-13 02:11:3815792026-11-13 02:11:385fffbd8a6852081a7bcec2038d56735e
2026-11-14 00:00:00ST1ST_20261114_R01Sha TinClass 4 (Restricted)1200SprintMTG_20261114_0001DBL1DBLMulti-RaceDEFINEDSTOP_SELL1——2026-11-13 03:30:1615002026-11-13 03:30:16fb15a843177fbb11fb472a934eadcef8

Both open directly in a spreadsheet.

Also as compressed CSV, JSON

Question about this table? Ask us. (opens in new tab)

Columns

20
HKJC Pool Investments: 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

Get a key on renavon.com (opens in new tab)

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 sample

One-off archive

24 January 2026 to present · does not update

US$199

Buy the archive Pool Investments

Racing 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 Pro

Prices and checkout are handled entirely by Renavon. HKJC Guru does not process these payments.

See all pricing