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)
);

Example Query​

SELECT 
    symbol_id,
    time_exchange,
    time_coinapi,
    uuid,
    price,
    size,
    taker_side,
    id_trade,
    id_order_maker,
    id_order_taker,
FROM TRADESUNISWAP
WHERE symbol_id IS NOT NULL
    AND price > 0  -- Ensure valid price
    AND size > 0   -- Ensure valid size
ORDER BY time_coinapi DESC  -- Most recent trades first
LIMIT 50;