trade

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

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/trade/**/*.parquet', Lineage.fiboModule = 'FBC', Lineage.fiboConcept = 'Trade', Lineage.datasetTitle = 'Trades'}
// Booked trades in accounts — the canonical post-allocation record used for position keeping and accounting.
Class fibo::fbc::Trade
{
    // TradeIdentifier: Internal surrogate key for a booked trade.
    tradeId : Integer[1];
    // AllocationIdentifier: Internal surrogate key for an allocation.
    allocationId : Integer[0..1];
    // AccountIdentifier: Internal surrogate key uniquely identifying an account within this system.
    accountId : Integer[1];
    // InstrumentSurrogateID: Internal surrogate key uniquely identifying a financial instrument within this system. External identifiers (ISIN, CUSIP, FIGI) live in instrument_identifier.
    instrumentId : Integer[1];
    // OrderSide: Direction of the order (buy, sell, short sell, cover).
    side : String[1];
    // Quantity: Number of units (shares, contracts, face value) held or traded.
    quantity : Decimal[1];
    // ExecutedPrice: Price at which an execution actually occurred.
    price : Decimal[1];
    // ISO4217CurrencyCode: Three-letter code (e.g., USD, EUR, JPY) that uniquely identifies a currency under ISO 4217.
    currencyCode : String[1];
    // TradeDate: Date on which a trade was executed.
    tradeDate : StrictDate[1];
    // SettlementDate: Date on which cash and securities exchange hands to complete a trade (commonly T+1 or T+2 for equities).
    settlementDate : StrictDate[1];
    // Counterparty: The other party to a financial contract or trade.
    counterpartyLei : String[0..1];
    // GrossAmount: Trade quantity × price, before commissions and fees.
    grossAmount : Decimal[1];
    // NetAmount: Gross amount adjusted for commissions and fees — the cash that actually moves between accounts.
    netAmount : Decimal[1];
    // Commission: Fee paid to a broker for executing a trade.
    commission : Decimal[0..1];
    // Fees: Other transaction costs charged by venues, regulators, or clearing houses.
    fees : Decimal[0..1];
}

    // parquet: out/parquet/trade/**/*.parquet
    Table trade (trade_id INT PRIMARY KEY, allocation_id INT, account_id INT, instrument_id INT, side VARCHAR(255), quantity DECIMAL(20,6), price DECIMAL(28,10), currency_code VARCHAR(255), trade_date DATE, settlement_date DATE, counterparty_lei VARCHAR(255), gross_amount DECIMAL(20,4), net_amount DECIMAL(20,4), commission DECIMAL(20,6), fees DECIMAL(20,6))

    fibo::fbc::Trade : Relational
    {
        ~mainTable [FiboParquet]trade
        tradeId : [FiboParquet]trade.trade_id,
        allocationId : [FiboParquet]trade.allocation_id,
        accountId : [FiboParquet]trade.account_id,
        instrumentId : [FiboParquet]trade.instrument_id,
        side : [FiboParquet]trade.side,
        quantity : [FiboParquet]trade.quantity,
        price : [FiboParquet]trade.price,
        currencyCode : [FiboParquet]trade.currency_code,
        tradeDate : [FiboParquet]trade.trade_date,
        settlementDate : [FiboParquet]trade.settlement_date,
        counterpartyLei : [FiboParquet]trade.counterparty_lei,
        grossAmount : [FiboParquet]trade.gross_amount,
        netAmount : [FiboParquet]trade.net_amount,
        commission : [FiboParquet]trade.commission,
        fees : [FiboParquet]trade.fees
    }

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