| project | VARCHAR(7) | The DEX project |
| protocol | VARCHAR(14) | The protocol used by the DEX project |
| owner | VARCHAR(16777216) | Address of the liquidity position owner |
| pool | VARCHAR(16777216) | The liquidity pool address |
| position | VARCHAR(16777216) | The liquidity position address |
| token0 | VARCHAR(44) | Token0’s mint address |
| token1 | VARCHAR(44) | Token1’s mint address |
| raw_delta0 | VARCHAR(16777216) | Raw amount change for token0 |
| raw_delta1 | VARCHAR(16777216) | Raw amount change for token1 |
| action | VARCHAR(16777216) | The liquidity position action performed. Choices are create_position, close_position, add_liquidity, remove_liquidity, claim_fee, rebalancing |
| block_slot | NUMBER(38,0) | Block slot of the transaction |
| block_height | NUMBER(38,0) | Block height of the transaction |
| block_timestamp | TIMESTAMP_NTZ(9) | Block timestamp of the transaction |
| block_hash | VARCHAR(44) | Block hash of the transaction |
| txn_id | VARCHAR(88) | Transaction ID |
| txn_index | NUMBER(38,0) | Transaction index within the block |
| instruction_index | NUMBER(38,0) | Instruction index within the transaction |
| inner_instruction_index | NUMBER(38,0) | Inner instruction index within the parent instruction |
| 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. |
| token0_symbol | VARCHAR(16777216) | Token0’s symbol, if available |
| token1_symbol | VARCHAR(16777216) | Token1’s symbol, if available |
| token0_decimals | NUMBER(38,0) | Token0’s decimal places |
| token1_decimals | NUMBER(38,0) | Token1’s decimal places |
| delta0 | FLOAT | Normalized amount change for token0 |
| delta1 | FLOAT | Normalized amount change for token1 |
| token0_price_usd | FLOAT | Token0 price in USD at the time of the event |
| token1_price_usd | FLOAT | Token1 price in USD at the time of the event |
| delta0_usd | FLOAT | USD value of token0 amount change |
| delta1_usd | FLOAT | USD value of token1 amount change |
| usd_amount_total | FLOAT | Total USD value of the liquidity event |
| _created_at | TIMESTAMP_LTZ(9) | Timestamp of when the entry was created in the database. |
| _updated_at | TIMESTAMP_LTZ(9) | Timestamp of when the entry was last updated in the database. |
