Skip to main content

Table Details

PropertyValue
Table Namecelo.dex.uniswap_v3_events
Table StatusProduction-Ready
Unique Keyblock_timestamp, unique_id
Clustering Key(s)block_timestamp::date

Table Columns

Column NameData TypeDescription
eventVARCHAR(134217728)Event log name (e.g. mint, burn, swap, swap, flash, flash_paid)
projectVARCHAR(134217728)Name of the project (e.g., uniswap)
protocolVARCHAR(134217728)DEX protocol or project contract (e.g., uniswap_v3)
factory_addressVARCHAR(42)The factory address that deployed the liquidity pool
liquidity_pool_addressVARCHAR(42)The liquidity pool address which emitted the event
owner_addressVARCHAR(42)Owner address
sender_addressVARCHAR(42)Address of the sender of the event log
recipient_addressVARCHAR(42)Address of the recipient of the event log
token0_addressVARCHAR(42)Token0 contract address
token0_nameVARCHAR(134217728)Token0 name
token0_symbolVARCHAR(134217728)Token0 symbol
token0_decimalsNUMBER(38,0)Token0 decimals
token0_amount_raw_strVARCHAR(134217728)Token0 amount unnormalized, in string format for precision
token0_amount_rawFLOATToken0 amount unnormalized
token0_amount_strVARCHAR(134217728)Token0 amount normalized, in string format for precision
token0_amountFLOATToken0 amount normalized
token0_amount_usdFLOATToken0 USD amount
token0_price_usdFLOATToken0 hourly USD price at event time
token1_addressVARCHAR(42)Token1 contract address
token1_nameVARCHAR(134217728)Token1 name
token1_symbolVARCHAR(134217728)Token1 symbol
token1_decimalsNUMBER(38,0)Token1 decimals
token1_amount_raw_strVARCHAR(134217728)Token1 amount unnormalized, in string format for precision
token1_amount_rawFLOATToken1 amount unnormalized
token1_amount_strVARCHAR(134217728)Token1 amount normalized, in string format for precision
token1_amountFLOATToken1 amount normalized
token1_amount_usdFLOATToken1 USD amount
token1_price_usdFLOATToken1 hourly USD price at event time
usd_amountFLOATUSD value of the event
liquidityVARCHAR(134217728)Liquidity field
feeNUMBER(38,0)Fee denomination of the pool address
tick_spacingNUMBER(38,0)Tick spacing of the pool address
sqrt_price_x96VARCHAR(134217728)Square root 96 price
tickFLOATPrice tick
tick_lowerFLOATThe lower tick of the position
tick_upperFLOATThe upper tick of the position
price_lower_0_1VARCHAR(134217728)Lower bound price of token0 per token1
price_upper_0_1VARCHAR(134217728)Upper bound price of token0 per token1
price_lower_1_0VARCHAR(134217728)Lower bound price of token1 per token0
price_upper_1_0VARCHAR(134217728)Upper bound price of token1 per token0
transaction_from_addressVARCHAR(42)The sending party address
transaction_to_addressVARCHAR(42)The receiving party address
transaction_hashVARCHAR(66)Transaction hash
transaction_indexNUMBER(38,0)Transaction index in the block
transaction_feesFLOATFees paid at the transaction level
transaction_fees_usdFLOATFees paid in USD
fee_detailsVARIANTAdditional fee details (gas, gas price, etc.)
selectorVARCHAR(134217728)Call data selector at transaction level
log_indexNUMBER(38,0)Log index of this trade
block_timestampTIMESTAMP_NTZ(9)Block timestamp
block_numberNUMBER(38,0)Block number
block_hashVARCHAR(66)Block hash
unique_idVARCHAR(134217728)Unique ID of each trade
_created_atTIMESTAMP_NTZ(9)Timestamp of when the entry was created in the database.
_updated_atTIMESTAMP_NTZ(9)Timestamp of when the entry was last updated in the database.
_changed_since_full_refreshBOOLEANIndicates if the record has changed since the last full data refresh.