| chain | VARCHAR(8) | Slug identifying the blockchain this record belongs to. |
| block_number | NUMBER(38,0) | Sequential number of the block that contains this JIT event. |
| block_timestamp | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the block that contains this JIT event. |
| signer | VARCHAR(42) | Address that signed the JIT liquidity transactions. |
| project | VARCHAR(16777216) | DEX project of the pool the JIT liquidity was provided to. |
| liquidity_pool_address | VARCHAR(42) | Contract address of the liquidity pool. |
| pool_name | VARCHAR(16777216) | Human-readable name of the pool. |
| jit_action | VARCHAR(16777216) | JIT action classification for this event. |
| token0_address | VARCHAR(42) | Contract address of the pool’s first token. |
| token0_symbol | VARCHAR(16777216) | Symbol of the pool’s first token. |
| token0_amount_mint | FLOAT | Amount of token0 added in the mint leg. |
| token0_amount_burn | FLOAT | Amount of token0 removed in the burn leg. |
| token0_delta | FLOAT | Net change in token0 across the mint/burn pair. |
| token0_delta_usd | FLOAT | USD value of the net token0 change. |
| token1_address | VARCHAR(42) | Contract address of the pool’s second token. |
| token1_symbol | VARCHAR(16777216) | Symbol of the pool’s second token. |
| token1_amount_mint | FLOAT | Amount of token1 added in the mint leg. |
| token1_amount_burn | FLOAT | Amount of token1 removed in the burn leg. |
| token1_delta | FLOAT | Net change in token1 across the mint/burn pair. |
| token1_price_usd | FLOAT | USD price of token1 at the event. |
| token1_delta_usd | FLOAT | USD value of the net token1 change. |
| jit_swaps | VARIANT | Details of the swaps sandwiched by the JIT mint/burn pair. |
| jit_swap_volume_usd | FLOAT | USD volume of the sandwiched swaps. |
| jit_swap_count | NUMBER(18,0) | Number of sandwiched swaps. |
| liquidity_mint | VARCHAR(16777216) | Liquidity amount added in the mint leg. |
| tick_lower_mint | FLOAT | Lower tick bound of the minted position. |
| tick_upper_mint | FLOAT | Upper tick bound of the minted position. |
| liquidity_burn | VARCHAR(16777216) | Liquidity amount removed in the burn leg. |
| tick_lower_burn | FLOAT | Lower tick bound of the burned position. |
| tick_upper_burn | FLOAT | Upper tick bound of the burned position. |
| transaction_hash_mint | VARCHAR(66) | Hash of the mint-leg transaction. |
| transaction_index_mint | NUMBER(38,0) | Position of the mint-leg transaction within its block. |
| log_index_mint | NUMBER(38,0) | Log index of the mint event. |
| txn_fees_mint | FLOAT | Transaction fees paid for the mint leg, in the native token. |
| txn_fees_usd_mint | FLOAT | USD value of the mint-leg transaction fees. |
| transaction_hash_burn | VARCHAR(66) | Hash of the burn-leg transaction. |
| transaction_index_burn | NUMBER(38,0) | Position of the burn-leg transaction within its block. |
| log_index_burn | NUMBER(38,0) | Log index of the burn event. |
| txn_fees_burn | FLOAT | Transaction fees paid for the burn leg, in the native token. |
| txn_fees_usd_burn | FLOAT | USD value of the burn-leg transaction fees. |
| _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. |
