❄ Snowflake
Trades Dataset
Access CoinAPI Trades data through Snowflake data warehouse
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;