Racing data
HKJC Closing Odds
HKJC Closing Odds holds 5,215,116 records from the Hong Kong Jockey Club's published closing odds, covering December 2021 to November 2026, and is updated hourly.
Hong Kong horse racing closing odds and market data
hkjc_odds_final
Rows
5,215,116
Coverage
December 2021 to November 2026
Columns
21
Latest data
2026-11-14
Sample
| odds_final_key | race_date | venue_code | race_number | race_id | racename | venue | distance_category | track_condition_category | field_size | odds_type | odds_category | combination | odds_value | is_hot_favourite | final_odds_timestamp | race_start_time | minutes_before_start | odds_format | updated_at | id |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 64d9d14ea07198bfda93920e4bd77a8a | 2026-11-14 00:00:00 | ST | 1 | ST_20261114_R01 | PANASONIC WATER DISPENSER HANDICAP | Sha Tin | Sprint | Good | 14 | DBL | Double | 01/01 | 52.0 | false | 2026-11-14 04:32:04 | 2026-11-14 04:30:00 | -2 | graphql_v2 | 2026-11-14 04:32:04 | 64d9d14ea07198bfda93920e4bd77a8a |
| bed02eaa34555fbff1d5393aa0bb4123 | 2026-11-14 00:00:00 | ST | 1 | ST_20261114_R01 | PANASONIC WATER DISPENSER HANDICAP | Sha Tin | Sprint | Good | 14 | DBL | Double | 01/02 | 110.0 | false | 2026-11-14 04:32:04 | 2026-11-14 04:30:00 | -2 | graphql_v2 | 2026-11-14 04:32:04 | bed02eaa34555fbff1d5393aa0bb4123 |
| 5119b73b8820cd5f5b23e83cbd4c3169 | 2026-11-14 00:00:00 | ST | 1 | ST_20261114_R01 | PANASONIC WATER DISPENSER HANDICAP | Sha Tin | Sprint | Good | 14 | DBL | Double | 01/03 | 80.0 | false | 2026-11-14 04:32:04 | 2026-11-14 04:30:00 | -2 | graphql_v2 | 2026-11-14 04:32:04 | 5119b73b8820cd5f5b23e83cbd4c3169 |
| babda37a6f2ccb9be22d4b96dd6bfe65 | 2026-11-14 00:00:00 | ST | 1 | ST_20261114_R01 | PANASONIC WATER DISPENSER HANDICAP | Sha Tin | Sprint | Good | 14 | DBL | Double | 01/04 | 84.0 | false | 2026-11-14 04:32:04 | 2026-11-14 04:30:00 | -2 | graphql_v2 | 2026-11-14 04:32:04 | babda37a6f2ccb9be22d4b96dd6bfe65 |
| 929ca347c850b44a40baf912885ab915 | 2026-11-14 00:00:00 | ST | 1 | ST_20261114_R01 | PANASONIC WATER DISPENSER HANDICAP | Sha Tin | Sprint | Good | 14 | DBL | Double | 01/05 | 96.0 | false | 2026-11-14 04:32:04 | 2026-11-14 04:30:00 | -2 | graphql_v2 | 2026-11-14 04:32:04 | 929ca347c850b44a40baf912885ab915 |
| dffbeaa948b8c8da47472af49006073f | 2026-11-14 00:00:00 | ST | 1 | ST_20261114_R01 | PANASONIC WATER DISPENSER HANDICAP | Sha Tin | Sprint | Good | 14 | DBL | Double | 01/06 | 34.0 | false | 2026-11-14 04:32:04 | 2026-11-14 04:30:00 | -2 | graphql_v2 | 2026-11-14 04:32:04 | dffbeaa948b8c8da47472af49006073f |
| ee57fa6c87f613d86fe9db75344560d3 | 2026-11-14 00:00:00 | ST | 1 | ST_20261114_R01 | PANASONIC WATER DISPENSER HANDICAP | Sha Tin | Sprint | Good | 14 | DBL | Double | 01/07 | 82.0 | false | 2026-11-14 04:32:04 | 2026-11-14 04:30:00 | -2 | graphql_v2 | 2026-11-14 04:32:04 | ee57fa6c87f613d86fe9db75344560d3 |
| 0423cbaa78c972db8f8d6baae42e2d50 | 2026-11-14 00:00:00 | ST | 1 | ST_20261114_R01 | PANASONIC WATER DISPENSER HANDICAP | Sha Tin | Sprint | Good | 14 | DBL | Double | 01/08 | 245.0 | false | 2026-11-14 04:32:04 | 2026-11-14 04:30:00 | -2 | graphql_v2 | 2026-11-14 04:32:04 | 0423cbaa78c972db8f8d6baae42e2d50 |
Both open directly in a spreadsheet.
Also as compressed CSV, JSON
Columns
| Column | Type | Description |
|---|---|---|
| odds_final_key | text | {{ doc('hkjc_odds_final_key') }} |
| race_date | date and time | {{ doc('hkjc_odds_race_date') }} |
| venue_code | text | {{ doc('hkjc_odds_venue_code') }} |
| race_number | number | {{ doc('hkjc_odds_race_number') }} |
| race_id | text | Unique race identifier for joining with hkjc_races (format: ST_20250928_R01) |
| racename | text | {{ doc('hkjc_odds_racename') }} |
| venue | text | {{ doc('hkjc_odds_venue') }} |
| distance_category | text | {{ doc('hkjc_odds_distance_category') }} |
| track_condition_category | text | {{ doc('hkjc_odds_track_condition_category') }} |
| field_size | number | {{ doc('hkjc_odds_field_size') }} |
| odds_type | text | {{ doc('hkjc_odds_type') }} |
| odds_category | text | {{ doc('hkjc_odds_category') }} |
| combination | text | {{ doc('hkjc_odds_combination') }} |
| odds_value | number | {{ doc('hkjc_odds_value') }} |
| is_hot_favourite | yes/no | {{ doc('hkjc_odds_is_hot_favourite') }} |
| final_odds_timestamp | date and time | {{ doc('hkjc_odds_final_odds_timestamp') }} |
| race_start_time | date and time | {{ doc('hkjc_odds_race_start_time') }} |
| minutes_before_start | number | {{ doc('hkjc_odds_minutes_before_start') }} |
| odds_format | text | {{ doc('hkjc_odds_format') }} |
| updated_at | date and time | {{ doc('hkjc_odds_updated_at') }} |
| 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_odds_final LIMIT 10
Ways to get this table
Free sample
Closing odds for every pool of the latest completed meeting, from race 1 onward. The file stops at 10,000 rows, which is about the first seven races of a meeting.
Free
Download the sampleOne-off archive
8 December 2021 to present · does not update
US$299
Buy the archive Closing Odds — Full ArchiveRacing Pass Enterprise
A rolling 24-month window, currently from November 2024with 15 other tables
US$4,990/yr
billed yearly · or US$499/mo Racing Pass Enterprise
Subscribe to Racing Pass EnterprisePrices and checkout are handled entirely by Renavon. HKJC Guru does not process these payments.