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;
Was this section helpful?