賽馬數據
HKJC Pool Investments
投注額資料收錄3,529,039筆記錄,資料來自香港賽馬會公布的投注額資料,涵蓋2026年1月至2026年11月,每小時更新。
Hong Kong horse racing betting pool investment data
hkjc_pool_investments
行數
3,529,039
涵蓋期間
2026年1月至2026年11月
欄位數目
20
最新數據
2026-11-14
樣本
| 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-11-14 00:00:00 | ST | 1 | ST_20261114_R01 | Sha Tin | Class 4 (Restricted) | 1200 | Sprint | MTG_20261114_0001DBL1 | DBL | Multi-Race | INITIAL | STOP_SELL | 1 | — | — | 2026-11-12 01:10:43 | 3080 | 2026-11-12 01:10:43 | a5d3b31bb21122103ea49697c18855c9 |
| 2026-11-14 00:00:00 | ST | 1 | ST_20261114_R01 | Sha Tin | Class 4 (Restricted) | 1200 | Sprint | MTG_20261114_0001DBL1 | DBL | Multi-Race | INITIAL | STOP_SELL | 1 | — | — | 2026-11-12 05:50:38 | 2800 | 2026-11-12 05:50:38 | 655d1d7330da1c8e26ea62e023dddc29 |
| 2026-11-14 00:00:00 | ST | 1 | ST_20261114_R01 | Sha Tin | Class 4 (Restricted) | 1200 | Sprint | MTG_20261114_0001DBL1 | DBL | Multi-Race | DEFINED | STOP_SELL | 1 | — | — | 2026-11-12 06:10:07 | 2780 | 2026-11-12 06:10:07 | 86ac61f3731667464fa0fba1413160d6 |
| 2026-11-14 00:00:00 | ST | 1 | ST_20261114_R01 | Sha Tin | Class 4 (Restricted) | 1200 | Sprint | MTG_20261114_0001DBL1 | DBL | Multi-Race | DEFINED | STOP_SELL | 1 | — | — | 2026-11-12 08:20:27 | 2650 | 2026-11-12 08:20:27 | 4e914a41531e0f8a640d0c31b7e98aff |
| 2026-11-14 00:00:00 | ST | 1 | ST_20261114_R01 | Sha Tin | Class 4 (Restricted) | 1200 | Sprint | MTG_20261114_0001DBL1 | DBL | Multi-Race | DEFINED | STOP_SELL | 1 | — | — | 2026-11-12 08:50:59 | 2620 | 2026-11-12 08:50:59 | 410675d43d1811608d5ff0398e62edd3 |
| 2026-11-14 00:00:00 | ST | 1 | ST_20261114_R01 | Sha Tin | Class 4 (Restricted) | 1200 | Sprint | MTG_20261114_0001DBL1 | DBL | Multi-Race | DEFINED | STOP_SELL | 1 | — | — | 2026-11-13 01:40:12 | 1610 | 2026-11-13 01:40:12 | 43fc473296575fb554a342bfff3bdb46 |
| 2026-11-14 00:00:00 | ST | 1 | ST_20261114_R01 | Sha Tin | Class 4 (Restricted) | 1200 | Sprint | MTG_20261114_0001DBL1 | DBL | Multi-Race | DEFINED | STOP_SELL | 1 | — | — | 2026-11-13 02:11:38 | 1579 | 2026-11-13 02:11:38 | 5fffbd8a6852081a7bcec2038d56735e |
| 2026-11-14 00:00:00 | ST | 1 | ST_20261114_R01 | Sha Tin | Class 4 (Restricted) | 1200 | Sprint | MTG_20261114_0001DBL1 | DBL | Multi-Race | DEFINED | STOP_SELL | 1 | — | — | 2026-11-13 03:30:16 | 1500 | 2026-11-13 03:30:16 | fb15a843177fbb11fb472a934eadcef8 |
兩者均可直接用試算表開啟。
欄位
| 欄位名稱 | 類型 | 說明 |
|---|---|---|
| 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. |
查詢數據
每個數據表均可透過 Renavon 帳戶,以 SQL、API 或 AI 助理查詢。
SELECT * FROM renavon_exports.hkjc_pool_investments LIMIT 10
取得此數據表的方式
免費樣本
Last 12 months of pool investments per race, full schema. Use to gauge liquidity by pool type before committing.
免費
下載樣本Racing Pass Pro
滾動 24 個月期間,現時由2024年11月起另包含 13 個數據表
US$1,490/年
按年收費 · 或每月 US$149 Racing Pass Pro
訂閱 Racing Pass Pro價格及付款程序均由 Renavon 全權處理,駿眼並不經手有關付款。
Renavon 的付款頁面只提供英文版本。