project | VARCHAR | Name of the project (e.g., uniswap) |
protocol | VARCHAR | Protocol Name (e.g., uniswap_v2) |
factory_address | VARCHAR | The factory address that deployed the liquidity pool |
liquidity_pool_address | VARCHAR | The liquidity pool address which emitted the event |
owner_address | VARCHAR | Owner address |
sender_address | VARCHAR | Address of the sender of the event log, which can be the Router |
recipient_address | VARCHAR | Address of the recipient of the event log, which can be the Router |
token0_address | VARCHAR | Token0 contract address |
token0_name | VARCHAR | Token0 name |
token0_symbol | VARCHAR | Token0 symbol |
token0_decimals | INTEGER | Token0 decimals |
token0_amount_raw_str | VARCHAR | Token0 amount unnormalized, in string format for precision |
token0_amount_raw | FLOAT | Token0 amount unnormalized |
token0_amount_str | VARCHAR | Token0 amount normalized, in string format for precision |
token0_amount | FLOAT | Token0 amount normalized |
token0_amount_usd | FLOAT | Token0 USD amount |
token0_price_usd | FLOAT | Token0 hourly USD price at the time of the event |
token1_address | VARCHAR | Token1 contract address |
token1_name | VARCHAR | Token1 name |
token1_symbol | VARCHAR | Token1 symbol |
token1_decimals | INTEGER | Token1 decimals |
token1_amount_raw_str | VARCHAR | Token1 amount unnormalized, in string format for precision |
token1_amount_raw | FLOAT | Token1 amount unnormalized |
token1_amount_str | VARCHAR | Token1 amount normalized, in string format for precision |
token1_amount | FLOAT | Token1 amount normalized |
token1_amount_usd | FLOAT | Token1 USD amount |
token1_price_usd | FLOAT | Token1 hourly USD price at the time of the event |
usd_amount | FLOAT | USD value of the event |
transaction_fees | FLOAT | Fees paid at the transaction level |
transaction_fees_usd | FLOAT | Fees paid in USD |
fee_details | OBJECT | Additional fee details of the transaction (gas, gas price, etc.) |
selector | VARCHAR | Call data selector at the transaction level |
transaction_from_address | VARCHAR | The address of the sending party of this transaction |
transaction_to_address | VARCHAR | The address of the receiving party of this transaction |
transaction_hash | VARCHAR | Transaction hash of this event |
transaction_index | INTEGER | Transaction index of this event in the block |
log_index | INTEGER | Log index of this event |
block_timestamp | TIMESTAMP_NTZ(9) | Block timestamp of this event |
block_number | INTEGER | Block number of this event |
block_hash | VARCHAR | Block hash of this event |
unique_id | VARCHAR | Unique ID of each event |
created_at | TIMESTAMP_NTZ(9) | Timestamp of the entry creation |
updated_at | TIMESTAMP_NTZ(9) | Timestamp of the entry update |
changed_since_full_refresh | BOOLEAN | Boolean indicator on whether this table was full-refreshed |