| event | VARCHAR(16777216) | Tron staking event type. Includes v1_stake, v1_unstake, v2_stake, v2_unstake, v2_cancel_unstaking, v2_withdraw_unstaked, claim_reward, and others. |
| project | VARCHAR(16777216) | Business name of the protocol being used (e.g. uniswap, aave, lido, paraswap). Consistent across verticals — every table with a project column uses this field to identify the top-level protocol brand. |
| protocol | VARCHAR(16777216) | Specific version or variant of the protocol (e.g. uniswap_v3, aave_v2, stargate_v2). Qualifies the project field with version information. |
| factory_address | VARCHAR(42) | Address of the factory contract that deployed this liquidity pool. Factory contracts create and track pool instances for a given protocol version. |
| liquidity_pool_address | VARCHAR(42) | Contract address of the liquidity pool where this trade was executed. Null when the routing path is not emitted by the event (common for aggregator trades). |
| owner_address | VARCHAR(42) | Address of the token or position owner. In NFT contexts, the wallet that holds the token; in staking contexts, the account that initiated the stake. |
| sender_address | VARCHAR(42) | Address that initiated the bridge transfer on the source chain. |
| recipient_address | VARCHAR(42) | Address that will receive the tokens on the destination chain. May be null if the destination address is not emitted in the source-chain event. |
| token0_address | VARCHAR(42) | Contract address of the first token in a liquidity pool (token0 is the lower address by convention in Uniswap-style AMMs). |
| token0_name | VARCHAR(16777216) | Full name of token0 in the liquidity pool. |
| token0_symbol | VARCHAR(16777216) | Ticker symbol of token0 in the liquidity pool. |
| token0_decimals | NUMBER(38,0) | Decimal precision of token0 in the liquidity pool. |
| token0_amount_raw_str | VARCHAR(16777216) | Raw (not decimal-adjusted) amount of token0 as a string. |
| token0_amount_raw | FLOAT | Raw amount of token0 involved in this event, not decimal-adjusted. |
| token0_amount_str | VARCHAR(16777216) | Decimal-adjusted amount of token0 as a string for full precision. |
| token0_amount | FLOAT | Decimal-adjusted amount of token0 involved in this event. |
| token0_amount_usd | FLOAT | USD value of the token0 amount in this event. |
| token0_price_usd | FLOAT | USD price per unit of token0 at the time of this event. |
| token1_address | VARCHAR(42) | Contract address of the second token in a liquidity pool (token1 is the higher address by convention in Uniswap-style AMMs). |
| token1_name | VARCHAR(16777216) | Full name of token1 in the liquidity pool. |
| token1_symbol | VARCHAR(16777216) | Ticker symbol of token1 in the liquidity pool. |
| token1_decimals | NUMBER(38,0) | Decimal precision of token1 in the liquidity pool. |
| token1_amount_raw_str | VARCHAR(16777216) | Raw (not decimal-adjusted) amount of token1 as a string. |
| token1_amount_raw | FLOAT | Raw amount of token1 involved in this event, not decimal-adjusted. |
| token1_amount_str | VARCHAR(16777216) | Decimal-adjusted amount of token1 as a string for full precision. |
| token1_amount | FLOAT | Decimal-adjusted amount of token1 involved in this event. |
| token1_amount_usd | FLOAT | USD value of the token1 amount in this event. |
| token1_price_usd | FLOAT | USD price per unit of token1 at the time of this event. |
| usd_amount | FLOAT | USD value of the token amount at the time of the event, computed using the hourly USD exchange rate. |
| liquidity | VARCHAR(16777216) | Current active liquidity of the pool or position. In Uniswap V3/V4, this is the liquidity available within the current tick range. |
| fee | NUMBER(38,0) | Fee tier of the liquidity pool, expressed in hundredths of a basis point (e.g. 3000 = 0.3%). Paid by traders to liquidity providers on each swap. |
| tick_spacing | NUMBER(38,0) | Minimum tick interval between initializable price ticks in this pool. Higher fee tiers typically have larger tick spacing. |
| sqrt_price_x96 | VARCHAR(16777216) | Square root of the current spot price of the pool, stored as a Q64.96 fixed-point number (multiplied by 2^96). Used in Uniswap V3/V4 math. |
| tick | FLOAT | Current price tick of the AMM pool. In Uniswap V3/V4, the price is represented as 1.0001^tick. Only meaningful for concentrated liquidity AMMs. |
| tick_lower | FLOAT | Lower tick boundary for concentrated liquidity position |
| tick_upper | FLOAT | Upper tick boundary for concentrated liquidity position |
| price_lower_0_1 | VARCHAR(16777216) | Lower bound of the Uniswap v3 position’s price range, expressed as token0 per token1. |
| price_upper_0_1 | VARCHAR(16777216) | Upper bound of the Uniswap v3 position’s price range, expressed as token0 per token1. |
| price_lower_1_0 | VARCHAR(16777216) | Lower bound of the Uniswap v3 position’s price range, expressed as token1 per token0 (inverse of price_upper_0_1). |
| price_upper_1_0 | VARCHAR(16777216) | Upper bound of the Uniswap v3 position’s price range, expressed as token1 per token0 (inverse of price_lower_0_1). |
| transaction_from_address | VARCHAR(42) | Address of the externally-owned account (EOA) that signed and submitted the transaction. This is the wallet that paid gas, which may differ from the from_address of an individual token transfer if a contract is routing tokens on behalf of a user. |
| transaction_to_address | VARCHAR(42) | Address the transaction was sent to (the top-level to field of the transaction). May be a router, aggregator, or bridge contract rather than the direct recipient of assets. |
| transaction_hash | VARCHAR(66) | Hash of the transaction that produced this record. Uniquely identifies a transaction within the blockchain. |
| transaction_index | NUMBER(38,0) | Zero-based position of the transaction within its block. The first transaction in a block has index 0. |
| transaction_fees | FLOAT | Total gas fees paid for this transaction in the chain’s native token. |
| transaction_fees_usd | FLOAT | Total gas fees paid for this transaction, converted to USD. |
| fee_details | VARIANT | JSON object containing a breakdown of fee components (e.g. protocol fee, gas rebate, relayer fee). Structure varies by bridge protocol. |
| selector | VARCHAR(16777216) | First 4 bytes of the transaction calldata, identifying the function being called. Null for plain native-currency transfers. Also known as the function selector. |
| log_index | NUMBER(38,0) | Zero-based position of this event log within its transaction. The first log emitted by a transaction has index 0. |
| block_timestamp | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the block that contains this record. |
| block_number | NUMBER(38,0) | Sequential number of the block that contains this record. Starts at 0 (genesis block) and increments by 1 for each new block. |
| block_hash | VARCHAR(66) | Cryptographic hash of the block header that contains this record. Uniquely identifies a block. |
| unique_id | VARCHAR(16777216) | Allium’s deterministic unique identifier for this row. Generated from the fields that uniquely identify the record (e.g. transaction hash + log index). Stable across full refreshes. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |
| _changed_since_full_refresh | BOOLEAN | Indicates if the record has changed since the last full data refresh. |
