instrument

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

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/instrument.parquet', Lineage.fiboModule = 'SEC', Lineage.fiboConcept = 'FinancialInstrument', Lineage.datasetTitle = 'Financial Instruments'}
// Master record of every traded financial instrument the system knows about, with asset class, issuer, currency, and effective dating.
Class fibo::sec::FinancialInstrument
{
    // InstrumentSurrogateID: Internal surrogate key uniquely identifying a financial instrument within this system. External identifiers (ISIN, CUSIP, FIGI) live in instrument_identifier.
    instrumentId : Integer[1];
    // AssetClass: Top-level kind of financial instrument (equity, bond, FRN, future, listed option, OTC derivative, index, FX).
    assetClass : String[1];
    // Issuer: A legal entity that creates and offers a financial instrument (e.g., a corporation issuing shares or bonds, a government issuing sovereign debt).
    issuerLei : String[0..1];
    // ISO4217CurrencyCode: Three-letter code (e.g., USD, EUR, JPY) that uniquely identifies a currency under ISO 4217.
    currencyCode : String[1];
    // IssueDate: The date on which a financial instrument was first sold to investors by its issuer.
    issueDate : StrictDate[0..1];
    // Description: Free-text human-readable label for the record.
    description : String[0..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).
    validFrom : StrictDate[1];
    // ValidToDate: The date a record\'s information stopped being effective. NULL means still in force.
    validTo : StrictDate[0..1];
    // IsCurrent: Flag indicating whether a versioned record is the currently active version for its natural key.
    isCurrent : Boolean[1];
}

    // parquet: out/parquet/instrument.parquet
    Table instrument (instrument_id INT PRIMARY KEY, asset_class VARCHAR(255), issuer_lei VARCHAR(255), currency_code VARCHAR(255), issue_date DATE, description VARCHAR(255), valid_from DATE, valid_to DATE, is_current BIT)

    fibo::sec::FinancialInstrument : Relational
    {
        ~mainTable [FiboParquet]instrument
        instrumentId : [FiboParquet]instrument.instrument_id,
        assetClass : [FiboParquet]instrument.asset_class,
        issuerLei : [FiboParquet]instrument.issuer_lei,
        currencyCode : [FiboParquet]instrument.currency_code,
        issueDate : [FiboParquet]instrument.issue_date,
        description : [FiboParquet]instrument.description,
        validFrom : [FiboParquet]instrument.valid_from,
        validTo : [FiboParquet]instrument.valid_to,
        isCurrent : [FiboParquet]instrument.is_current
    }

// 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'
)