Skip to main content

Trades Dataset

Overview​

The "TRADES" dataset provides information about executed transactions across trading venues. It includes detailed data about trade prices, sizes, and execution timestamps.

This dataset helps users:

  • Track individual transaction details and execution prices
  • Access historical trade data across multiple venues
  • Monitor trading activity and market liquidity
  • Analyze price impact and trade size patterns
  • Evaluate execution quality and market efficiency

Table Details​

Name: LISTINGS.PUBLIC.TRADES

Name: LISTINGS.PUBLIC.TRADESUNISWAP

Schema​

CREATE OR REPLACE TABLE LISTINGS.PUBLIC.TRADES (
    symbol_id             VARCHAR(100),
    time_exchange         TIMESTAMP_NTZ(9),
    time_coinapi          TIMESTAMP_NTZ(9),
    uuid                  VARCHAR(36),

    Standard UUID length
    price                 NUMBER(38,8),
    size                  NUMBER(38,8),
    taker_side            VARCHAR(4),

    'BUY' or 'SELL'
    id_trade              VARCHAR(100),
    
    Exchange-specific trade ID
    id_order_maker        VARCHAR(100),
    id_order_taker        VARCHAR(100)
);