listing

S3 / causeway-data / dev / main / fibo / listing

Auto-generated from fibo-data-gen/pure/ — column-level lineage from the FIBO-grounded class to its physical store. Structured mappings point at parquet columns; Object mappings point at object-storage paths for audio, video, documents, and transcripts.

// AUTO-GENERATED by generators/pure_export.py — do not edit by hand.
// Source: metadata/datasets/*.json

###Pure

Profile fibo::Lineage
{
    stereotypes: [parquetBacked, objectBacked];
    tags: [parquetPath, fiboModule, fiboConcept, datasetTitle, glossaryTerm, objectPath, mediaTypes];
}

<<Lineage.parquetBacked>>
{Lineage.parquetPath = 'out/parquet/listing.parquet', Lineage.fiboModule = 'SEC', Lineage.fiboConcept = 'Listing', Lineage.datasetTitle = 'Instrument Listings'}
// Mapping of instruments to the trading venues on which they are admitted to trading, including primary and cross-listings.
Class fibo::sec::Listing
{
    // InstrumentSurrogateID: Internal surrogate key uniquely identifying a financial instrument within this system. External identifiers (ISIN, CUSIP, FIGI) live in instrument_identifier.
    instrumentId : Integer[1];
    // MarketIdentifierCode: Four-letter ISO 10383 code uniquely identifying a trading venue (e.g., XNYS for NYSE, XLON for LSE).
    micCode : String[1];
    // PrimaryListing: The principal venue on which an instrument is listed; secondary or cross-listings exist on additional venues.
    isPrimaryListing : Boolean[1];
    // ValidFromDate: The date a record\'s information became effective. Together with Valid To Date and Is Current, supports point-in-time history (slowly-changing dimension).
    listedFrom : StrictDate[1];
    // ValidToDate: The date a record\'s information stopped being effective. NULL means still in force.
    delistedOn : StrictDate[0..1];
    // Ticker: A short alphabetic code by which an instrument is referred to on a particular trading venue.
    localTicker : String[0..1];
}

    // parquet: out/parquet/listing.parquet
    Table listing (instrument_id INT PRIMARY KEY, mic_code VARCHAR(255) PRIMARY KEY, is_primary_listing BIT, listed_from DATE PRIMARY KEY, delisted_on DATE, local_ticker VARCHAR(255))

    fibo::sec::Listing : Relational
    {
        ~mainTable [FiboParquet]listing
        instrumentId : [FiboParquet]listing.instrument_id,
        micCode : [FiboParquet]listing.mic_code,
        isPrimaryListing : [FiboParquet]listing.is_primary_listing,
        listedFrom : [FiboParquet]listing.listed_from,
        delistedOn : [FiboParquet]listing.delisted_on,
        localTicker : [FiboParquet]listing.local_ticker
    }

// AUTO-GENERATED by generators/pure_export.py — do not edit by hand.

Store store::object::CausewayObjectStore
(
  backend: S3
  bucket:  'causeway-data'
  region:  'us-east-1'
)