賽馬數據
HKJC Pool Investments
Hong Kong horse racing betting pool investment data
hkjc_pool_investments
行數
3,082,526
涵蓋期間
2026年1月至2026年10月
欄位數目
20
最新數據
2026-10-01
樣本
| 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-10-01 00:00:00 | ST | 1 | ST_20261001_R01 | Sha Tin | Class 5 | 1200 | Sprint | MTG_20261001_0001DBL1 | DBL | Multi-Race | INITIAL | STOP_SELL | 1 | — | — | 2026-09-28 01:10:40 | 4550 | 2026-09-28 01:10:40 | 1f7b0a47dbf25df44f5561551ffcc85d |
| 2026-10-01 00:00:00 | ST | 1 | ST_20261001_R01 | Sha Tin | Class 5 | 1200 | Sprint | MTG_20261001_0001DBL1 | DBL | Multi-Race | INITIAL | STOP_SELL | 1 | — | — | 2026-09-28 04:40:25 | 4340 | 2026-09-28 04:40:25 | 5a5b01db467036490dbe4ca88f415c3b |
| 2026-10-01 00:00:00 | ST | 1 | ST_20261001_R01 | Sha Tin | Class 5 | 1200 | Sprint | MTG_20261001_0001DBL1 | DBL | Multi-Race | DEFINED | STOP_SELL | 1 | — | — | 2026-09-28 05:40:05 | 4280 | 2026-09-28 05:40:05 | 44959a7f20f23169cbed3185a14393ba |
| 2026-10-01 00:00:00 | ST | 1 | ST_20261001_R01 | Sha Tin | Class 5 | 1200 | Sprint | MTG_20261001_0001DBL1 | DBL | Multi-Race | DEFINED | STOP_SELL | 1 | — | — | 2026-09-29 08:00:48 | 2700 | 2026-09-29 08:00:48 | 42e14c12d9dbfb2d55bc02a3745297bf |
| 2026-10-01 00:00:00 | ST | 1 | ST_20261001_R01 | Sha Tin | Class 5 | 1200 | Sprint | MTG_20261001_0001DBL1 | DBL | Multi-Race | DEFINED | STOP_SELL | 1 | — | — | 2026-09-30 03:50:07 | 1510 | 2026-09-30 03:50:07 | e52e102d0c1dbab60978dd2c7be9a959 |
| 2026-10-01 00:00:00 | ST | 1 | ST_20261001_R01 | Sha Tin | Class 5 | 1200 | Sprint | MTG_20261001_0001DBL1 | DBL | Multi-Race | START_SELL | START_SELL | 1 | 0 | 2026-09-30 04:00:03 | 2026-09-30 04:00:23 | 1500 | 2026-09-30 04:00:23 | 431bae2b22cf1763423e7426f77a39c1 |
| 2026-10-01 00:00:00 | ST | 1 | ST_20261001_R01 | Sha Tin | Class 5 | 1200 | Sprint | MTG_20261001_0001DBL1 | DBL | Multi-Race | START_SELL | START_SELL | 1 | 1360 | 2026-09-30 04:10:02 | 2026-09-30 04:10:19 | 1490 | 2026-09-30 04:10:19 | ff19d665f2e6835027bb827b17ac41a1 |
| 2026-10-01 00:00:00 | ST | 1 | ST_20261001_R01 | Sha Tin | Class 5 | 1200 | Sprint | MTG_20261001_0001DBL1 | DBL | Multi-Race | START_SELL | START_SELL | 1 | 5480 | 2026-09-30 04:20:02 | 2026-09-30 04:21:01 | 1479 | 2026-09-30 04:21:01 | 826f961022454e7f7e0b6d0fe0598c58 |
兩者均可直接用試算表開啟。
欄位
| 欄位名稱 | 類型 | 說明 |
|---|---|---|
| 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 |
| 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.
免費
下載樣本