Skip to main content

Table Details

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

Table Columns

Column NameData TypeDescription
eventVARCHAR(134217728)Name of the Uniswap V2 event (e.g., Swap, Mint, Burn, Sync).
projectVARCHAR(134217728)Name of the project (e.g., uniswap)
protocolVARCHAR(134217728)Protocol Name (e.g., uniswap_v2)
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, which can be the Router
recipient_addressVARCHAR(42)Address of the recipient of the event log, which can be the Router
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 the time of the event
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 the time of the event
usd_amountFLOATUSD value of the event
transaction_feesFLOATFees paid at the transaction level
transaction_fees_usdFLOATFees paid in USD
fee_detailsVARIANTAdditional fee details of the transaction (gas, gas price, etc.)
selectorVARCHAR(134217728)Call data selector at the transaction level
transaction_from_addressVARCHAR(42)The address of the sending party of this transaction
transaction_to_addressVARCHAR(42)The address of the receiving party of this transaction
transaction_hashVARCHAR(66)Transaction hash of this event
transaction_indexNUMBER(38,0)Transaction index of this event in the block
log_indexNUMBER(38,0)Log index of this event
block_timestampTIMESTAMP_NTZ(9)Block timestamp of this event
block_numberNUMBER(38,0)Block number of this event
block_hashVARCHAR(66)Block hash of this event
unique_idVARCHAR(134217728)Unique ID of each event
_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.