DexOnChain Swaps

CoinAPI

DEX on-chain swap events available as CSV and Parquet files.

Get This Dataset

Category⛓️On-chain

Update Frequencyhourly

SizeMedium to high

CoverageUNISWAP-V3, UNISWAP-V2, SUSHISWAP-V2, CURVE-FINANCE, DODO-V2, BALANCER-V2

FormatsCSV.gz, Parquet

Overview

DEX on-chain swap events available as CSV and Parquet files.

CoinAPI packages this dataset for teams that need analysis-ready market data with clear schema documentation, representative samples, and commercial access across CoinAPI datasets.

Product and Channel Availability

Where applicable for this dataset, access is available through: Flat Files (Snowflake, S3 Pull, S3 Push, GCS Push), REST API, Market Data API, WebSocket API (v1, v2), FIX API.

File Format

Formats: CSV.gz, Parquet
Refresh frequency: hourly
Size profile: Medium to high

Coverage

UNISWAP-V3, UNISWAP-V2, SUSHISWAP-V2, CURVE-FINANCE, DODO-V2, BALANCER-V2

Data Structure

dexonchain_swaps: DEX on-chain swap events.

The schema and sample rows below document the available fields, data types, nullability, and example values for this dataset.

Tables

Column	Type	Nullable	Description	Example
exchange_id	`string`	No	Protocol or venue identifier.	`UNISWAP-V3`
pool_id	`string`	No	Liquidity pool smart contract identifier.	`0xpool123`
timestamp	`number`	No	Event timestamp as Unix seconds.	`1711286104`
block_number	`number`	No	Blockchain block number.	`19400211`
tx_hash	`string`	No	Transaction hash.	`0xtxhash123`
log_index	`number`	No	Log index within the transaction receipt.	`12`
sender	`string`	No	Swap initiator address.	`0xsender`
recipient	`string`	No	Recipient address.	`0xrecipient`
token0_id	`string`	No	Token0 contract address or identifier.	`0xwbtc`
token0_symbol	`string`	No	Token0 symbol.	`WBTC`
token1_id	`string`	No	Token1 contract address or identifier.	`0xusdc`
token1_symbol	`string`	No	Token1 symbol.	`USDC`
amount0	`number`	No	Token0 amount.	`-0.125`
amount1	`number`	No	Token1 amount.	`8432.5`
amount_usd	`number`	No	USD notional estimate.	`8432.5`
sqrt_price_x96	`string`	No	Protocol-specific sqrt price value when available.	`123456789012345678901234`
tick	`number`	Yes	Tick index for concentrated-liquidity protocols.	`205120`
gas_used	`string`	No	Gas used for the transaction.	`210000`
gas_price	`string`	No	Gas price for the transaction.	`25000000000`

Sample Data

dexonchain_swaps

exchange_id	pool_id	timestamp	block_number	tx_hash	log_index	sender	recipient	token0_id	token0_symbol	token1_id	token1_symbol	amount0	amount1	amount_usd	sqrt_price_x96	tick	gas_used	gas_price
UNISWAP-V3	0xpool123	1711286104	19400211	0xtxhash123	12	0xsender	0xrecipient	0xwbtc	WBTC	0xusdc	USDC	-0.125	8432.5	8432.5	123456789012345678901234	205120	210000	25000000000