HolidayCalendarV3
The holiday calendar of record: one calendar's content - its weekend, the variance-time shape of its trading day and its dated exceptions - keyed by that content. THE KEY IS THE CONTENT. calendarKey is a ContentKey tagged Calendar over the SHA-256 of the canonical form (CALENDAR_CONTENT_KEY.md), byte 0 dropped for the tag. A loader hashes what it built and publishes; two producers building the same calendar publish the same row, and nobody mints an id. A row is immutable: a changed calendar is a new row under a new key, and a deleted row is content withdrawn. THE NAME LIVES ELSEWHERE. ScheduleDefinitionV3 (9057) points a product group at a key and carries the Manual / Loader / Bridge ladder; CalendarDefinitionV3 (9009) is the human registry of adopted names (XCME, USNY) pointing at their current key. The compiled tables are the floor beneath both and keep their names. desc is the producer's memo - 'union of XAMS, XEUR', 'XCME 2026 refresh' - readability, never identity.
METADATA
| Attribute | Value |
|---|---|
| Topic | 9000-product-def-authority |
| MLink Token | ClientLive |
| Product | SRReference |
| accessType | SELECT |
| MLink Endpoint | MLink-Live |
Table Definition
| Field | Type | Key | Default Value | Comment |
|---|---|---|---|---|
| calendarKey_ct | enum - ContentKeyType | PRI | 'None' | content key Calendar tag 15 bytes of the SHA256 of the canonical form CALENDARCONTENTKEYmd |
| calendarKey_id | VARCHAR(37) | PRI | '' | content key Calendar tag 15 bytes of the SHA256 of the canonical form CALENDARCONTENTKEYmd |
| timestamp | DATETIME(6) | '1900-01-01 00:00:00.000000' | ||
| desc | TINYTEXT | '' | the producers memo what this content is | |
| weekendMask | TINYINT UNSIGNED | 0 | bit per weekday bit0Mon 0x60 SatSun part of the key | |
| v3Source | enum - V3Source | 'None' | who published this content provenance never precedence | |
| vtRatio | DOUBLE | 0 | 0 1 proportion of variance that occurs during market hours D252 | |
| mktVTimeOpen | TIME(6) | '00:00:00.000000' | vTime market open time in sysRegion timezone | |
| mktVTimeClose | TIME(6) | '00:00:00.000000' | vTime market close time in sysRegion timezone | |
| mktVTimeEarlyCls | TIME(6) | '00:00:00.000000' | vTime market early close time in sysRegion timezone | |
| HolidayList | JSON | 'JSON_ARRAY()' |
PRIMARY KEY DEFINITION (Unique)
| Field | Sequence |
|---|---|
| calendarKey_ct | 1 |
| calendarKey_id | 2 |
JSON Block (HolidayList)
| Field | Type | Comment |
|---|---|---|
| date | enum - date | |
| marketDayType | enum - MarketDayType | Regular Modified MarketClosed |
| settleDayType | enum - SettleDayType | SettlementOpen or SettlementClosed |
SELECT TABLE EXAMPLE QUERY
SELECT *
FROM `SRReference`.`MsgHolidayCalendarV3`
WHERE
/* Replace with a ENUM('None','SpreadId','ContractType','Calendar') */
`calendarKey_ct` = 'NONE'
AND
/* Replace with a VARCHAR(37) */
`calendarKey_id` = 'Example_calendarKey_id';
Doc Columns Query
SELECT * FROM SRReference.doccolumns WHERE TABLE_NAME='HolidayCalendarV3' ORDER BY ordinal_position ASC;