Racing data
HKJC Closing Odds
Hong Kong horse racing closing odds and market data
hkjc_odds_final
Rows
4,664,377
Coverage
December 2021 to October 2026
Columns
21
Latest data
2026-10-01
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9a4341d76075b71bd9e9eb8cf19bb5ad | 2026-09-27 00:00:00 | ST | 1 | ST_20260927_R01 | TROPICBIRD HANDICAP | Sha Tin | Sprint | Good | 12 | DBL | Double | 01/01 | 99.0 | false | 2026-09-27 04:44:59 | 2026-09-27 04:45:00 | 1 | graphql_v2 | 2026-09-27 04:44:59 | 9a4341d76075b71bd9e9eb8cf19bb5ad |
| 4a394ee36ddef791f482fff03245ab9b | 2026-09-27 00:00:00 | ST | 1 | ST_20260927_R01 | TROPICBIRD HANDICAP | Sha Tin | Sprint | Good | 12 | DBL | Double | 01/02 | 146.0 | false | 2026-09-27 04:44:59 | 2026-09-27 04:45:00 | 1 | graphql_v2 | 2026-09-27 04:44:59 | 4a394ee36ddef791f482fff03245ab9b |
| f2b1d8f47365326cf44368b2a74893c7 | 2026-09-27 00:00:00 | ST | 1 | ST_20260927_R01 | TROPICBIRD HANDICAP | Sha Tin | Sprint | Good | 12 | DBL | Double | 01/03 | 602.0 | false | 2026-09-27 04:44:59 | 2026-09-27 04:45:00 | 1 | graphql_v2 | 2026-09-27 04:44:59 | f2b1d8f47365326cf44368b2a74893c7 |
| e5bf7dce0a17ea68f7f834f8590a5a2a | 2026-09-27 00:00:00 | ST | 1 | ST_20260927_R01 | TROPICBIRD HANDICAP | Sha Tin | Sprint | Good | 12 | DBL | Double | 01/04 | 22.0 | false | 2026-09-27 04:44:59 | 2026-09-27 04:45:00 | 1 | graphql_v2 | 2026-09-27 04:44:59 | e5bf7dce0a17ea68f7f834f8590a5a2a |
| a2cfc0de66a0972b0f72a4cdbc0210da | 2026-09-27 00:00:00 | ST | 1 | ST_20260927_R01 | TROPICBIRD HANDICAP | Sha Tin | Sprint | Good | 12 | DBL | Double | 01/05 | 126.0 | false | 2026-09-27 04:44:59 | 2026-09-27 04:45:00 | 1 | graphql_v2 | 2026-09-27 04:44:59 | a2cfc0de66a0972b0f72a4cdbc0210da |
| 06802f273c6a0ecea33aa33ac4d365bb | 2026-09-27 00:00:00 | ST | 1 | ST_20260927_R01 | TROPICBIRD HANDICAP | Sha Tin | Sprint | Good | 12 | DBL | Double | 01/06 | 283.0 | false | 2026-09-27 04:44:59 | 2026-09-27 04:45:00 | 1 | graphql_v2 | 2026-09-27 04:44:59 | 06802f273c6a0ecea33aa33ac4d365bb |
| 5ed9a4e22ea85a2476f7aff880bd740b | 2026-09-27 00:00:00 | ST | 1 | ST_20260927_R01 | TROPICBIRD HANDICAP | Sha Tin | Sprint | Good | 12 | DBL | Double | 01/07 | 34.0 | false | 2026-09-27 04:44:59 | 2026-09-27 04:45:00 | 1 | graphql_v2 | 2026-09-27 04:44:59 | 5ed9a4e22ea85a2476f7aff880bd740b |
| e1f9ab2b55947ff40ee213715f863d5a | 2026-09-27 00:00:00 | ST | 1 | ST_20260927_R01 | TROPICBIRD HANDICAP | Sha Tin | Sprint | Good | 12 | DBL | Double | 01/08 | 10.0 | false | 2026-09-27 04:44:59 | 2026-09-27 04:45:00 | 1 | graphql_v2 | 2026-09-27 04:44:59 | e1f9ab2b55947ff40ee213715f863d5a |
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 10Ways 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
$299
Buy the archive Closing Odds — Full Archive (opens in new tab)Racing Pass Enterprise
A rolling 24-month window, currently from October 2024with 15 other tables
$499/mo
Subscribe to Racing Pass Enterprise (opens in new tab)