跳至內容

駿眼統計為獨立資訊服務,與香港賽馬會並無任何關聯、認可或授權關係。

賽馬數據

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

樣本

顯示 8 行
HKJC Pool Investments: 樣本
race_datevenue_coderace_numberrace_idvenuerace_classdistancedistance_categorypool_idodds_typepool_categorypool_statussell_statusleg_numberinvestment_amountlast_update_timesnapshot_timestampminutes_to_postupdated_atid
2026-11-14 00:00:00ST1ST_20261114_R01Sha TinClass 4 (Restricted)1200SprintMTG_20261114_0001DBL1DBLMulti-RaceINITIALSTOP_SELL1——2026-11-12 01:10:4330802026-11-12 01:10:43a5d3b31bb21122103ea49697c18855c9
2026-11-14 00:00:00ST1ST_20261114_R01Sha TinClass 4 (Restricted)1200SprintMTG_20261114_0001DBL1DBLMulti-RaceINITIALSTOP_SELL1——2026-11-12 05:50:3828002026-11-12 05:50:38655d1d7330da1c8e26ea62e023dddc29
2026-11-14 00:00:00ST1ST_20261114_R01Sha TinClass 4 (Restricted)1200SprintMTG_20261114_0001DBL1DBLMulti-RaceDEFINEDSTOP_SELL1——2026-11-12 06:10:0727802026-11-12 06:10:0786ac61f3731667464fa0fba1413160d6
2026-11-14 00:00:00ST1ST_20261114_R01Sha TinClass 4 (Restricted)1200SprintMTG_20261114_0001DBL1DBLMulti-RaceDEFINEDSTOP_SELL1——2026-11-12 08:20:2726502026-11-12 08:20:274e914a41531e0f8a640d0c31b7e98aff
2026-11-14 00:00:00ST1ST_20261114_R01Sha TinClass 4 (Restricted)1200SprintMTG_20261114_0001DBL1DBLMulti-RaceDEFINEDSTOP_SELL1——2026-11-12 08:50:5926202026-11-12 08:50:59410675d43d1811608d5ff0398e62edd3
2026-11-14 00:00:00ST1ST_20261114_R01Sha TinClass 4 (Restricted)1200SprintMTG_20261114_0001DBL1DBLMulti-RaceDEFINEDSTOP_SELL1——2026-11-13 01:40:1216102026-11-13 01:40:1243fc473296575fb554a342bfff3bdb46
2026-11-14 00:00:00ST1ST_20261114_R01Sha TinClass 4 (Restricted)1200SprintMTG_20261114_0001DBL1DBLMulti-RaceDEFINEDSTOP_SELL1——2026-11-13 02:11:3815792026-11-13 02:11:385fffbd8a6852081a7bcec2038d56735e
2026-11-14 00:00:00ST1ST_20261114_R01Sha TinClass 4 (Restricted)1200SprintMTG_20261114_0001DBL1DBLMulti-RaceDEFINEDSTOP_SELL1——2026-11-13 03:30:1615002026-11-13 03:30:16fb15a843177fbb11fb472a934eadcef8

兩者均可直接用試算表開啟。

亦提供 壓縮 CSV 檔, JSON 格式

對此數據表有疑問?歡迎查詢。 (在新分頁開啟)

欄位

20
HKJC Pool Investments: 欄位
欄位名稱 類型 說明
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

在 renavon.com 取得金鑰 (在新分頁開啟)

取得此數據表的方式

免費樣本

Last 12 months of pool investments per race, full schema. Use to gauge liquidity by pool type before committing.

免費

下載樣本

一次性存檔

2026年1月24日至今 · 不會更新

US$199

購買存檔 Pool Investments

Racing Pass Pro

滾動 24 個月期間,現時由2024年11月起另包含 13 個數據表

US$1,490/年

按年收費 · 或每月 US$149 Racing Pass Pro

訂閱 Racing Pass Pro

價格及付款程序均由 Renavon 全權處理,駿眼並不經手有關付款。

Renavon 的付款頁面只提供英文版本。

查看所有價格