| 9115 | CCodeDefinitionV3 | Commodity code (product code) definitions for all futures, and the ccode -> SpiderRock ticker map. Sourced from listing exchange product definitions. Also covers exchange and user-defined spreads, including spreads used as option underliers; SpiderRock uses a compact form of the exchange spread product ID as the ccode where no human-readable exchange ticker exists. A family head begins with '@'; no product key or uplink does. |
| 9009 | CalendarDefinitionV3 | One row per calendar: what its weekend looks like, which calendars it composes, and the settlement |
| 9148 | CorpActionDefinitionV3 | THE FUNDAMENTAL EVENT, once: a 3:2 split is ONE row here and thousands of KeyTransform edges. Machine-coded AND legal/textual. Carries the lifecycle - announced, REVISED, effective, cancelled - under a STABLE actionKey: revisions change terms, never identity (the occurrence-identity lesson) |
| 9169 | DeliveryBasketDefinitionV3 | One row per delivery basket: what one adjusted option contract settles into when a corporate action leaves it |
| 9106 | EquityDefinitionV3 | THE EQUITY LINE - one row per equity-family ticker: a share class, ETF, ADR, depositary receipt or |
| 9166 | FamilyPrimaryElectionV3 | One row per futures family, keyed by the family head: CCodeDefinitionV3 (9115) familyHead, @[line]-[venue]-FUT for a |
| 9121 | FutExpiryDefinitionV3 | One row per futures contract - the expiry-rung counterpart of OptExpiryDefinitionV3. |
| 9306 | FutSpreadDefinitionV3 | One row per exchange-listed strategy whose legs are all futures: a calendar, butterfly, condor, pack, |
| 9012 | HolidayCalendarV3 | The holiday calendar of record: one calendar's content - its weekend, the variance-time shape of its trading day |
| 9109 | IndexDefinitionV3 | THE INDEX KEY IS THE LINE: every root and ccode that settles on this index points at this key, its live level |
| 9151 | KeyTransformV3 | THE EDGE: one row per (transit, childKey, parentKey) pair - a |
| 9142 | MarketHoursV3 | The expected market schedule for one product group on one trade date - the session times a client needs to know when orders are accepted and when each session opens and closes. |
| 9045 | MaterialEventOccurrenceV3 | one dated instance of a series. The pkey is DELIBERATELY date-free: the date is the field that MOVES (estimate -> published), so identity survives the Forecast -> Announced migration and a firmed-up date is a state change, never a delete/insert |
| 9042 | MaterialEventSeriesV3 | one record per recurring series of date/time-definite repricing events: bank meetings, gov reports, inventory numbers, auctions, earnings, production policy |
| 9212 | ObligorDefinitionV3 | one record per legal entity that owes - the CDS reference entity, the bond obligor, the muni obligated person the first ENTITY-layer record: section 18's second identity layer as an actual object |
| 9118 | OptExpiryDefinitionV3 | This table maps option root/expiration combinations to their deliverable future. Mappings are sourced fromm listing exchange product definitions. |
| 9172 | OptionContractSizeOverride | The deliverable of ONE option series where it differs from its root/expiry. Euronext adjusts a chain for a corporate |
| 9130 | ProductExchMappingV3 | EXCHANGE-ASSIGNED IDENTIFIERS - one row per (instrument, venue). The ephemeral, hot half of what |
| 9112 | RootDefinitionV3 | One row per option root: its underlier, its delivery and exercise terms, and its pricing conventions. Sourced from the listing exchange for future options and from OCC for US equity options, and updated as SpiderRock receives changes. |
| 9057 | ScheduleDefinitionV3 | The trading schedule that applies to a group of products: which holiday calendar it keeps, which rotation window sets its trade-date boundary, and which venue lists it. |
| 9100 | TickerKeyDefinitionV3 | One row per (TickerKey, tickerClass) - the join spine at the ticker rung. Holds only what is true |
| 9015 | TradingPeriodDefinitionV3 | THE ROTATION RULE: how a timestamp becomes a trade date. One row per TradingPeriod value. |
| 9139 | VenueListingDefinitionV3 | A LISTING IS A CONTEXT, NOT AN INSTRUMENT. The fungible line - one ISIN - gets ONE SR ticker key, |
| 9160 | VenueTradingRulesV3 | THE VENUE'S TRADING RULES FOR ONE PRODUCT - one row per (product, venue). Block-trade (Eurex TES), |