DEX

Our data tables capture key metrics on trades, liquidity pools, and user activity.

Key Tables:

• Pools: Details of liquidity pools, including token pairs, liquidity provided, and fee rates.

• LP Position Snapshot: Snapshots of liquidity provider positions, tracking token amounts and USD values.

• Pool Snapshot: Snapshot of individuals pools, including token volume, fees, and transaction data.

• Trades: Records of user trades, capturing swap amounts, tokens involved, and fees.\

Pools

Property	Description	Type
chain_id	The standard id of the chain.	number
creation_block_number	The block this pool was created in.	number
timestamp	The timestamp of the block that this pool was created in.	number
pool_address	The contract address of the LP pool.	string
lp_token_address	The token address of the LP token for this pool.	string
lp_token_symbol	The symbol of the LP token.	string
token_address	The token address of the pool token at token_index.	string
token_symbol	The symbol of the pool token.	string
token_decimals	The decimals of the pool token.	string
token_index	The index in the pool smart contract that this token appears at, default 0 (ie, one entry per token in a pool).	number
fee_rate	The fee rate of the pool, as a percentage (ie, 2.3% as 0.023).	number
dex_type	The type of the DEX (ie, CPMM, CLMM, Orderbook).	string

LP Position Snapshot

Property	Description	Type
timestamp	The timestamp of the snapshot.	number
block_date	The timestamp truncated (ie, YYYY-MM-DD format for daily snapshots and YYYY-MM-DD HH:00:00 for hourly snapshots).	date
chain_id	The standard id of the chain.	number
pool_address	The contract address of the pool.	string
user_address	The address of the liquidity provider.	string
token_index	The token index based on the smart contract.	number
token_address	The contract address of the token provided as liquidity.	string
token_symbol	The symbol of the token.	string
token_amount	The amount of the underlying liquidity position in the pool, decimal normalized (ie, the amount of USDC provided by the LPer in a USDC/WETH pool).	number
token_amount_usd	The amount of the token in USD.	number

Pool Snapshot

Property	Description	Type
timestamp	The timestamp of the snapshot.	number
block_date	The timestamp truncated (ie, YYYY-MM-DD format for daily snapshots and YYYY-MM-DD HH:00:00 for hourly snapshots).	date
chain_id	The standard id of the chain.	number
pool_address	The contract address of the LP pool.	string
token_index	The token index in the smart contract.	number
token_address	The contract address of the token in the pool.	string
token_symbol	The symbol of the token.	string
token_amount	The amount of the token in this pool at the snapshot.	number
token_amount_usd	The amount of the token in USD.	number
volume_amount	The volume of the token transacted in this pool during the given snapshot, decimal normalized.	number
volume_usd	The volume transacted in the given snapshot, in USD.	number
fee_rate	The fee rate of the pool, as a percentage (ie, 2.3% as 0.023).	number
total_fees_usd	The total amount of revenue and fees paid in this pool in the given snapshot, in USD.	number
user_fees_usd	The amount of total fees accrued to liquidity providers of the protocol, in USD.	number
protocol_fees_usd	The amount of total fees accrued to the protocol, in USD.	number

Trades

Property	Description	Type
timestamp	The timestamp of the transaction.	number
chain_id	The standard id of the chain.	number
block_number	The block number of the trade.	number
log_index	The event log. For transactions that don't emit event, create arbitrary index starting from 0.	number
transaction_hash	The hash of the transaction.	string
user_address	The address that initiates the transaction (ie, the transaction signer).	string
taker_address	The taker, the address that receives the output of the swap (ie, could be the same as user_address unless a proxy contract/router is used).	string
pair_name	The name of the token pair.	string
pool_address	The contract address of the LP pool being traded in.	string
input_token_address	The contract address of the input token (ie, the tokenIn or the token being sold to the pool).	string
input_token_symbol	The symbol of the input token.	string
input_token_amount	The amount of the input token, decimal normalized.	number
output_token_address	The contract address of the output token (ie, the tokenOut of the token being bought by the user and sent to the taker).	string
output_token_symbol	The symbol of the output token.	string
output_token_amount	The amount of the output token, decimal normalized.	number
spot_price_after_swap	The spot price in the pool after the swap is complete. This is the price ratio a user would get if they made an infinitesimal swap immediately after this one.	number
swap_amount_usd	The amount of the swap in USD.	number
fees_usd	The fees paid by the user.	number