賽馬數據
HKJC Odds Movements
Hong Kong horse racing live odds history and market movements
hkjc_odds_combinations
行數
1,068,111,437
涵蓋期間
2021年12月至2026年10月
欄位數目
15
最新數據
2026-10-01
樣本
| race_date | venue_code | race_number | race_id | odds_type | odds_category | combination | odds_value | is_hot_favourite | snapshot_timestamp | timestamp_source | observed_at | sell_status | updated_at | id |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2026-09-27 00:00:00 | ST | 1 | ST_20260927_R01 | WINPre | Win/Place | 01 | 5.5 | false | 2026-09-26 22:18:10 | hkjc_published | 2026-09-26 22:52:05 | STOP_SELL | 2026-09-26 22:18:10 | 00355f8ea01291feb77df6d7691e4fa0 |
| 2026-09-27 00:00:00 | ST | 1 | ST_20260927_R01 | WINPre | Win/Place | 02 | 7.3 | false | 2026-09-26 22:18:10 | hkjc_published | 2026-09-26 22:52:05 | STOP_SELL | 2026-09-26 22:18:10 | ac5482c5d01fde8b1a86465a4a3ccefc |
| 2026-09-27 00:00:00 | ST | 1 | ST_20260927_R01 | WINPre | Win/Place | 03 | 8.7 | false | 2026-09-26 22:18:10 | hkjc_published | 2026-09-26 22:52:05 | STOP_SELL | 2026-09-26 22:18:10 | 416cd9b150a88cf38ae93ad00405ecd8 |
| 2026-09-27 00:00:00 | ST | 1 | ST_20260927_R01 | WINPre | Win/Place | 04 | 20.0 | false | 2026-09-26 22:18:10 | hkjc_published | 2026-09-26 22:52:05 | STOP_SELL | 2026-09-26 22:18:10 | 9d465c402acac549a1da7aef0277eb20 |
| 2026-09-27 00:00:00 | ST | 1 | ST_20260927_R01 | WINPre | Win/Place | 05 | 13.0 | false | 2026-09-26 22:18:10 | hkjc_published | 2026-09-26 22:52:05 | STOP_SELL | 2026-09-26 22:18:10 | 0c49d7227a3f4abe9439c0102861d07d |
| 2026-09-27 00:00:00 | ST | 1 | ST_20260927_R01 | WINPre | Win/Place | 06 | 3.0 | true | 2026-09-26 22:18:10 | hkjc_published | 2026-09-26 22:52:05 | STOP_SELL | 2026-09-26 22:18:10 | e0a44ca878699fe8e433f9bf1ea6855c |
| 2026-09-27 00:00:00 | ST | 1 | ST_20260927_R01 | WINPre | Win/Place | 07 | 31.0 | false | 2026-09-26 22:18:10 | hkjc_published | 2026-09-26 22:52:05 | STOP_SELL | 2026-09-26 22:18:10 | fbb150a8d71be1a032fed12fb56b0d70 |
| 2026-09-27 00:00:00 | ST | 1 | ST_20260927_R01 | WINPre | Win/Place | 08 | 30.0 | false | 2026-09-26 22:18:10 | hkjc_published | 2026-09-26 22:52:05 | STOP_SELL | 2026-09-26 22:18:10 | 176903f3586fdbebe99d8c9d9501d151 |
兩者均可直接用試算表開啟。
欄位
| 欄位名稱 | 類型 | 說明 |
|---|---|---|
| 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) |
| 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') }} |
| snapshot_timestamp | date and time | {{ doc('hkjc_odds_snapshot_timestamp') }} |
| timestamp_source | text | {{ doc('hkjc_odds_timestamp_source') }} |
| observed_at | date and time | {{ doc('hkjc_odds_observed_at') }} |
| sell_status | text | {{ doc('hkjc_odds_sell_status') }} |
| 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. |
查詢數據
每個數據表均可透過 Renavon 帳戶，以 SQL、API 或 AI 助理查詢。
SELECT * FROM renavon_exports.hkjc_odds_combinations LIMIT 10取得此數據表的方式
免費樣本
Race 1 of the latest completed race date, Win and Place pools first (pool codes in reverse order: WINPre, WIN, PWIN1, PWIN0, PLAPre, PLA), each newest update first, then the race's other pools, until the file's 10,000-row limit. For a Hong Kong meeting that is essentially every runner's Win price at each HKJC update running back from the off; where more than one venue ran a race 1 that day, their rows follow one another within each pool (venue codes in reverse order). The full product carries every race and pool in the same columns.
免費
下載樣本Racing Pass Enterprise
滾動 24 個月期間，現時由2024年10月起另包含 15 個數據表
$499/mo
訂閱 Racing Pass Enterprise （在新分頁開啟）