# Robinhood table reference

> Full schema for the Supanode Robinhood Chain Historical Data Indexer - 25 tables covering decoded Uniswap v3/v4 swaps and pools, ERC-20 token metadata, and eight launchpads, with every column and type.

The `robinhood` database holds decoded activity from Robinhood Chain, an Ethereum-compatible Arbitrum Layer 2. This page documents every table, column, type, and description. For runnable patterns see [Query examples](https://supanode.xyz/docs/robinhood/examples); for connection details see [Indexer overview](https://supanode.xyz/docs/robinhood/indexer).

<Note>
**Schema snapshot: 1 September 2026.** History starts 22 May 2026 - the chain itself is young, so every table is short by the standards of our Solana or Polymarket sets. Row counts grow continuously.
</Note>

## Summary

Two kinds of surface live here. **Tables** hold decoded rows on disk and report a size. **Views** are computed when you query them, so the catalog reports no rows for them - query one and you get data back.

| Table | Kind | Rows | Size | History |
|---|---|---|---|---|
| [`uniswap_v3_trades`](#uniswapv3trades) | table | 131,160,440 | 34.14 GB | 2026-05-22 → 2026-09-01 |
| [`uniswap_v4_trades`](#uniswapv4trades) | table | 69,102,106 | 16.34 GB | 2026-05-22 → 2026-09-01 |
| [`uniswap_v3_pools`](#uniswapv3pools) | table | 657,565 | 238.1 MB | 2026-06-18 → 2026-09-01 |
| [`uniswap_v4_pools`](#uniswapv4pools) | table | 554,327 | 215.9 MB | 2026-05-22 → 2026-09-01 |
| [`tokens`](#tokens) | table | 64,440 | 31.4 MB | 2026-07-08 → 2026-09-01 |
| [`pons_curve_trades`](#ponscurvetrades) | table | 5,155,554 | 1.41 GB | 2026-07-21 → 2026-09-01 |
| [`pons_creations`](#ponscreations) | table | 143,892 | 56.9 MB | 2026-08-03 → 2026-09-01 |
| [`pons_migrations`](#ponsmigrations) | table | 1,758 | 747.2 KB | 2026-08-04 → 2026-09-01 |
| [`pons_trading`](#ponstrading) | view | - | - | inherited |
| [`flap_curve_trades`](#flapcurvetrades) | table | 1,295,777 | 352.8 MB | 2026-07-08 → 2026-09-01 |
| [`flap_creations`](#flapcreations) | table | 295,316 | 118.4 MB | 2026-07-08 → 2026-09-01 |
| [`flap_migrations`](#flapmigrations) | view | - | - | inherited |
| [`flap_trading`](#flaptrading) | view | - | - | inherited |
| [`doppler_creations`](#dopplercreations) | table | 288,585 | 127.0 MB | 2026-07-01 → 2026-09-01 |
| [`doppler_trading`](#dopplertrading) | view | - | - | inherited |
| [`noxa_creations`](#noxacreations) | table | 60,143 | 24.9 MB | 2026-06-16 → 2026-07-11 |
| [`noxa_trading`](#noxatrading) | view | - | - | inherited |
| [`nox_creations`](#noxcreations) | table | 1,086 | 411.4 KB | 2026-07-22 → 2026-08-30 |
| [`nox_trading`](#noxtrading) | view | - | - | inherited |
| [`letscash_creations`](#letscashcreations) | table | 9,867 | 4.5 MB | 2026-07-10 → 2026-09-01 |
| [`letscash_trading`](#letscashtrading) | view | - | - | inherited |
| [`varo_creations`](#varocreations) | table | 8,912 | 4.7 MB | 2026-07-26 → 2026-09-01 |
| [`varo_trading`](#varotrading) | view | - | - | inherited |
| [`long_creations`](#longcreations) | view | - | - | inherited |
| [`long_trading`](#longtrading) | view | - | - | inherited |

<Tip>
**Every launchpad follows the same two-part shape.** The `_creations` table is the launch record - who deployed the token, its metadata, and the pool it opened against. The `_trading` surface is the swap stream for those pools. Where a launchpad graduates tokens onto a public AMM there is also a `_migrations` table, and where it runs its own bonding curve there is `_curve_trades`. Learn the pattern once and all eight read the same way.
</Tip>

<Warning>
**Amounts are raw base units.** Every `amount*`, `value` and fee column is an unscaled integer. Divide by 10 to the power of the token's `decimals` (from [`tokens`](#tokens)) before showing a human number. Prices arrive as `sqrt_price_x96`, a Q64.96 fixed-point integer, not a decimal price.
</Warning>

<Note>
**Every decoded row carries its execution envelope.** Block number, log index, transaction hash, gas used and the EIP-1559 fee fields sit on each event, so you can reproduce ordering and attribute cost without a second provider.
</Note>


## uniswap_v3_trades

Decoded Uniswap v3 swaps, one row per swap event: signed token deltas, post-swap price and liquidity, the tick, and the full transaction envelope. The largest table here and the starting point for most price and volume work.

**Rows:** 131,160,440 · **Size:** 34.14 GB · **Columns:** 27  
**Partition key:** `toYYYYMMDD(block_timestamp)`  
**History:** 2026-05-22 → 2026-09-01

| Column | Type | Description |
|---|---|---|
| `pool_address` | String | Address of the Uniswap v3 pool contract |
| `sender` | String | Address that initiated the swap callback |
| `recipient` | String | Address that received the swap output |
| `amount0` | Int256 | Signed change in the pool's token0 balance, in raw token units |
| `amount1` | Int256 | Signed change in the pool's token1 balance, in raw token units |
| `sqrt_price_x96` | UInt256 | Pool square-root price after the swap as a Q64.96 integer |
| `liquidity` | UInt128 | In-range pool liquidity after the swap |
| `tick` | Int32 | Pool tick after the swap |
| `event_id` | String | Unique identifier for the decoded contract event |
| `block_number` | UInt64 | EVM block number containing the event |
| `log_index` | UInt32 | Event log index within the transaction receipt |
| `transaction_index` | UInt32 | Transaction index within the block |
| `contract_address` | String | Address of the contract that emitted the event |
| `block_hash` | String | Hash of the block containing the event |
| `block_timestamp` | DateTime | UTC timestamp of the block containing the event |
| `gas_used` | UInt64 | Gas consumed by the transaction |
| `gas_limit` | UInt64 | Transaction gas limit |
| `base_fee_per_gas` | UInt256 | Block base fee per gas in wei |
| `transaction_hash` | String | Hash of the transaction containing the event |
| `transaction_from` | String | Address that submitted the transaction |
| `transaction_to` | String | Transaction destination address |
| `transaction_value` | UInt256 | Native ETH value sent with the transaction, in wei |
| `transaction_gas` | UInt64 | Gas limit declared by the transaction |
| `transaction_nonce` | UInt64 | Sender nonce used by the transaction |
| `max_fee_per_gas` | UInt256 | Maximum EIP-1559 fee per gas in wei |
| `max_priority_fee_per_gas` | UInt256 | Maximum EIP-1559 priority fee per gas in wei |
| `inserted_at` | DateTime | UTC timestamp when the record was inserted into ClickHouse |

## uniswap_v4_trades

Decoded Uniswap v4 swaps. Same shape as the v3 stream plus a per-swap `fee`, which v4 hooks are free to vary.

**Rows:** 69,102,106 · **Size:** 16.34 GB · **Columns:** 27  
**Partition key:** `toYYYYMMDD(block_timestamp)`  
**History:** 2026-05-22 → 2026-09-01

| Column | Type | Description |
|---|---|---|
| `pool_id` | String | Uniswap v4 pool identifier derived from its PoolKey |
| `sender` | String | Address recorded as the swap sender |
| `amount0` | Int128 | Signed change in the pool's currency0 balance, in raw units |
| `amount1` | Int128 | Signed change in the pool's currency1 balance, in raw units |
| `sqrt_price_x96` | UInt256 | Pool square-root price after the swap as a Q64.96 integer |
| `liquidity` | UInt128 | In-range pool liquidity after the swap |
| `tick` | Int32 | Pool tick after the swap |
| `fee` | UInt32 | Swap fee applied to this event in hundredths of a basis point |
| `event_id` | String | Unique identifier for the decoded contract event |
| `block_number` | UInt64 | EVM block number containing the event |
| `log_index` | UInt32 | Event log index within the transaction receipt |
| `transaction_index` | UInt32 | Transaction index within the block |
| `contract_address` | String | Address of the contract that emitted the event |
| `block_hash` | String | Hash of the block containing the event |
| `block_timestamp` | DateTime | UTC timestamp of the block containing the event |
| `gas_used` | UInt64 | Gas consumed by the transaction |
| `gas_limit` | UInt64 | Transaction gas limit |
| `base_fee_per_gas` | UInt256 | Block base fee per gas in wei |
| `transaction_hash` | String | Hash of the transaction containing the event |
| `transaction_from` | String | Address that submitted the transaction |
| `transaction_to` | String | Transaction destination address |
| `transaction_value` | UInt256 | Native ETH value sent with the transaction, in wei |
| `transaction_gas` | UInt64 | Gas limit declared by the transaction |
| `transaction_nonce` | UInt64 | Sender nonce used by the transaction |
| `max_fee_per_gas` | UInt256 | Maximum EIP-1559 fee per gas in wei |
| `max_priority_fee_per_gas` | UInt256 | Maximum EIP-1559 priority fee per gas in wei |
| `inserted_at` | DateTime | UTC timestamp when the record was inserted into ClickHouse |

## uniswap_v3_pools

One row per Uniswap v3 pool creation: the token pair, fee tier and tick spacing. Join it to the v3 swaps on `pool_id` to know what a swap was actually trading.

**Rows:** 657,565 · **Size:** 238.1 MB · **Columns:** 24  
**History:** 2026-06-18 → 2026-09-01

| Column | Type | Description |
|---|---|---|
| `pool_address` | String | Address of the Uniswap v3 pool contract |
| `token0` | String | Address of token0 in the pool |
| `token1` | String | Address of token1 in the pool |
| `fee` | UInt32 | Pool swap fee in hundredths of a basis point |
| `tick_spacing` | Int32 | Permitted spacing between initialized ticks |
| `event_id` | String | Unique identifier for the decoded contract event |
| `block_number` | UInt64 | EVM block number containing the event |
| `log_index` | UInt32 | Event log index within the transaction receipt |
| `transaction_index` | UInt32 | Transaction index within the block |
| `contract_address` | String | Address of the contract that emitted the event |
| `block_hash` | String | Hash of the block containing the event |
| `block_timestamp` | DateTime | UTC timestamp of the block containing the event |
| `gas_used` | UInt64 | Gas consumed by the transaction |
| `gas_limit` | UInt64 | Transaction gas limit |
| `base_fee_per_gas` | UInt256 | Block base fee per gas in wei |
| `transaction_hash` | String | Hash of the transaction containing the event |
| `transaction_from` | String | Address that submitted the transaction |
| `transaction_to` | String | Transaction destination address |
| `transaction_value` | UInt256 | Native ETH value sent with the transaction, in wei |
| `transaction_gas` | UInt64 | Gas limit declared by the transaction |
| `transaction_nonce` | UInt64 | Sender nonce used by the transaction |
| `max_fee_per_gas` | UInt256 | Maximum EIP-1559 fee per gas in wei |
| `max_priority_fee_per_gas` | UInt256 | Maximum EIP-1559 priority fee per gas in wei |
| `inserted_at` | DateTime | UTC timestamp when the record was inserted into ClickHouse |

## uniswap_v4_pools

One row per Uniswap v4 pool initialization: the two currencies, fee, tick spacing, the hooks contract, and the pool's opening price and tick.

**Rows:** 554,327 · **Size:** 215.9 MB · **Columns:** 27  
**History:** 2026-05-22 → 2026-09-01

| Column | Type | Description |
|---|---|---|
| `pool_id` | String | Uniswap v4 pool identifier derived from its PoolKey |
| `currency0` | String | Address of currency0, or the native-currency sentinel |
| `currency1` | String | Address of currency1, or the native-currency sentinel |
| `fee` | UInt32 | Pool swap fee in hundredths of a basis point |
| `tick_spacing` | Int32 | Permitted spacing between initialized ticks |
| `hooks` | String | Address of the hooks contract configured for the pool |
| `init_sqrt_price_x96` | UInt256 | Initial square-root price encoded as a Q64.96 integer |
| `init_tick` | Int32 | Pool tick at initialization |
| `event_id` | String | Unique identifier for the decoded contract event |
| `block_number` | UInt64 | EVM block number containing the event |
| `log_index` | UInt32 | Event log index within the transaction receipt |
| `transaction_index` | UInt32 | Transaction index within the block |
| `contract_address` | String | Address of the contract that emitted the event |
| `block_hash` | String | Hash of the block containing the event |
| `block_timestamp` | DateTime | UTC timestamp of the block containing the event |
| `gas_used` | UInt64 | Gas consumed by the transaction |
| `gas_limit` | UInt64 | Transaction gas limit |
| `base_fee_per_gas` | UInt256 | Block base fee per gas in wei |
| `transaction_hash` | String | Hash of the transaction containing the event |
| `transaction_from` | String | Address that submitted the transaction |
| `transaction_to` | String | Transaction destination address |
| `transaction_value` | UInt256 | Native ETH value sent with the transaction, in wei |
| `transaction_gas` | UInt64 | Gas limit declared by the transaction |
| `transaction_nonce` | UInt64 | Sender nonce used by the transaction |
| `max_fee_per_gas` | UInt256 | Maximum EIP-1559 fee per gas in wei |
| `max_priority_fee_per_gas` | UInt256 | Maximum EIP-1559 priority fee per gas in wei |
| `inserted_at` | DateTime | UTC timestamp when the record was inserted into ClickHouse |

## tokens

ERC-20 identities on Robinhood Chain - name, symbol, decimals, and the creation context. This is what turns an address into something readable, and the source of the `decimals` you need to scale every amount.

**Rows:** 64,440 · **Size:** 31.4 MB · **Columns:** 28  
**History:** 2026-07-08 → 2026-09-01

| Column | Type | Description |
|---|---|---|
| `token_address` | String | ERC-20 token contract address |
| `name` | String | Token name from contract metadata |
| `symbol` | String | Token ticker symbol from contract metadata |
| `decimals` | UInt8 | Number of decimal places used by the token |
| `description` | String | Human-readable token description when available |
| `website` | String | Project website URL when available |
| `image` | String | Token image URL when available |
| `extra_data` | String | Additional token metadata serialized as text |
| `creator` | String | Address associated with creation of the token |
| `event_id` | String | Unique identifier for the decoded contract event |
| `block_number` | UInt64 | EVM block number containing the event |
| `log_index` | UInt32 | Event log index within the transaction receipt |
| `transaction_index` | UInt32 | Transaction index within the block |
| `contract_address` | String | Address of the contract that emitted the event |
| `block_hash` | String | Hash of the block containing the event |
| `block_timestamp` | DateTime | UTC timestamp of the block containing the event |
| `gas_used` | UInt64 | Gas consumed by the transaction |
| `gas_limit` | UInt64 | Transaction gas limit |
| `base_fee_per_gas` | UInt256 | Block base fee per gas in wei |
| `transaction_hash` | String | Hash of the transaction containing the event |
| `transaction_from` | String | Address that submitted the transaction |
| `transaction_to` | String | Transaction destination address |
| `transaction_value` | UInt256 | Native ETH value sent with the transaction, in wei |
| `transaction_gas` | UInt64 | Gas limit declared by the transaction |
| `transaction_nonce` | UInt64 | Sender nonce used by the transaction |
| `max_fee_per_gas` | UInt256 | Maximum EIP-1559 fee per gas in wei |
| `max_priority_fee_per_gas` | UInt256 | Maximum EIP-1559 priority fee per gas in wei |
| `inserted_at` | DateTime | UTC timestamp when the record was inserted into ClickHouse |

## pons_curve_trades

Bonding-curve buys and sells on Pons, before a token graduates to an AMM pool.

**Rows:** 5,155,554 · **Size:** 1.41 GB · **Columns:** 28  
**Partition key:** `toYYYYMMDD(block_timestamp)`  
**History:** 2026-07-21 → 2026-09-01

| Column | Type | Description |
|---|---|---|
| `curve` | String | Address of the bonding-curve contract for the token |
| `token` | String | Address of the launchpad token |
| `is_buy` | UInt8 | Whether the trade was a buy (1) or a sell (0) |
| `sender` | String | Address recorded as the swap sender |
| `recipient` | String | Address that received the swap output |
| `quote_amount` | UInt256 | Quote-token amount for the trade, in raw quote-token units |
| `token_amount` | UInt256 | Amount of the token deposited, in raw token units |
| `fee` | UInt256 | Pool swap fee in hundredths of a basis point |
| `tax` | UInt256 | Transfer tax configured for the token, in basis points |
| `event_id` | String | Unique identifier for the decoded contract event |
| `block_number` | UInt64 | EVM block number containing the event |
| `log_index` | UInt32 | Event log index within the transaction receipt |
| `transaction_index` | UInt32 | Transaction index within the block |
| `contract_address` | String | Address of the contract that emitted the event |
| `block_hash` | String | Hash of the block containing the event |
| `block_timestamp` | DateTime | UTC timestamp of the block containing the event |
| `gas_used` | UInt64 | Gas consumed by the transaction |
| `gas_limit` | UInt64 | Transaction gas limit |
| `base_fee_per_gas` | UInt256 | Block base fee per gas in wei |
| `transaction_hash` | String | Hash of the transaction containing the event |
| `transaction_from` | String | Address that submitted the transaction |
| `transaction_to` | String | Transaction destination address |
| `transaction_value` | UInt256 | Native ETH value sent with the transaction, in wei |
| `transaction_gas` | UInt64 | Gas limit declared by the transaction |
| `transaction_nonce` | UInt64 | Sender nonce used by the transaction |
| `max_fee_per_gas` | UInt256 | Maximum EIP-1559 fee per gas in wei |
| `max_priority_fee_per_gas` | UInt256 | Maximum EIP-1559 priority fee per gas in wei |
| `inserted_at` | DateTime | UTC timestamp when the record was inserted into ClickHouse |

## pons_creations

Token launches on Pons: the asset, its metadata, and the pool it opens against.

**Rows:** 143,892 · **Size:** 56.9 MB · **Columns:** 28  
**History:** 2026-08-03 → 2026-09-01

| Column | Type | Description |
|---|---|---|
| `token` | String | Address of the launchpad token |
| `curve` | String | Address of the bonding-curve contract for the token |
| `deployer` | String | Address that deployed the token |
| `pair_token` | String | Address of the token paired with the launchpad token |
| `launch_config_id` | UInt256 | Identifier of the launch configuration used |
| `graduation_threshold` | UInt256 | Bonding-curve graduation threshold, in raw quote-token units |
| `name` | String | Token name from contract metadata |
| `symbol` | String | Token ticker symbol from contract metadata |
| `decimals` | UInt8 | Number of decimal places used by the token |
| `event_id` | String | Unique identifier for the decoded contract event |
| `block_number` | UInt64 | EVM block number containing the event |
| `log_index` | UInt32 | Event log index within the transaction receipt |
| `transaction_index` | UInt32 | Transaction index within the block |
| `contract_address` | String | Address of the contract that emitted the event |
| `block_hash` | String | Hash of the block containing the event |
| `block_timestamp` | DateTime | UTC timestamp of the block containing the event |
| `gas_used` | UInt64 | Gas consumed by the transaction |
| `gas_limit` | UInt64 | Transaction gas limit |
| `base_fee_per_gas` | UInt256 | Block base fee per gas in wei |
| `transaction_hash` | String | Hash of the transaction containing the event |
| `transaction_from` | String | Address that submitted the transaction |
| `transaction_to` | String | Transaction destination address |
| `transaction_value` | UInt256 | Native ETH value sent with the transaction, in wei |
| `transaction_gas` | UInt64 | Gas limit declared by the transaction |
| `transaction_nonce` | UInt64 | Sender nonce used by the transaction |
| `max_fee_per_gas` | UInt256 | Maximum EIP-1559 fee per gas in wei |
| `max_priority_fee_per_gas` | UInt256 | Maximum EIP-1559 priority fee per gas in wei |
| `inserted_at` | DateTime | UTC timestamp when the record was inserted into ClickHouse |

## pons_migrations

Tokens that graduated off the Pons bonding curve onto a public pool.

**Rows:** 1,758 · **Size:** 747.2 KB · **Columns:** 26  
**History:** 2026-08-04 → 2026-09-01

| Column | Type | Description |
|---|---|---|
| `token` | String | Address of the token being migrated |
| `pool_id` | String | Identifier of the destination pool created by the migration |
| `quote_token` | String | Address of the quote token paired with the migrated token |
| `creator` | String | Address that created the migrated token |
| `position_id` | UInt256 | Liquidity position identifier minted by the migration |
| `token_amount` | UInt256 | Amount of the migrated token deposited, in raw token units |
| `pair_token_amount` | UInt256 | Amount of the paired quote token deposited, in raw token units |
| `event_id` | String | Unique identifier for the decoded contract event |
| `block_number` | UInt64 | EVM block number containing the event |
| `log_index` | UInt32 | Event log index within the transaction receipt |
| `transaction_index` | UInt32 | Transaction index within the block |
| `contract_address` | String | Address of the contract that emitted the event |
| `block_hash` | String | Hash of the block containing the event |
| `block_timestamp` | DateTime | UTC timestamp of the block containing the event |
| `gas_used` | UInt64 | Gas consumed by the transaction |
| `gas_limit` | UInt64 | Transaction gas limit |
| `base_fee_per_gas` | UInt256 | Block base fee per gas in wei |
| `transaction_hash` | String | Hash of the transaction containing the event |
| `transaction_from` | String | Address that submitted the transaction |
| `transaction_to` | String | Transaction destination address |
| `transaction_value` | UInt256 | Native ETH value sent with the transaction, in wei |
| `transaction_gas` | UInt64 | Gas limit declared by the transaction |
| `transaction_nonce` | UInt64 | Sender nonce used by the transaction |
| `max_fee_per_gas` | UInt256 | Maximum EIP-1559 fee per gas in wei |
| `max_priority_fee_per_gas` | UInt256 | Maximum EIP-1559 priority fee per gas in wei |
| `inserted_at` | DateTime | UTC timestamp when the record was inserted into ClickHouse |

## pons_trading

Post-graduation swap stream for Pons tokens, computed from the pool events.

**Kind:** view, computed at query time · **Columns:** 28

| Column | Type | Description |
|---|---|---|
| `pool_id` | String | Pons pool identifier |
| `sender` | String | Address recorded as the swap sender |
| `amount0` | Int128 | Signed change in the pool's token0 balance, in raw token units |
| `amount1` | Int128 | Signed change in the pool's token1 balance, in raw token units |
| `sqrt_price_x96` | UInt256 | Pool square-root price after the swap as a Q64.96 integer |
| `liquidity` | UInt128 | In-range pool liquidity after the swap |
| `tick` | Int32 | Pool tick after the swap |
| `fee` | UInt32 | Swap fee applied to this event in hundredths of a basis point |
| `event_id` | String | Unique identifier for the decoded contract event |
| `block_number` | UInt64 | EVM block number containing the event |
| `log_index` | UInt32 | Event log index within the transaction receipt |
| `transaction_index` | UInt32 | Transaction index within the block |
| `contract_address` | String | Address of the contract that emitted the event |
| `block_hash` | String | Hash of the block containing the event |
| `block_timestamp` | DateTime | UTC timestamp of the block containing the event |
| `gas_used` | UInt64 | Gas consumed by the transaction |
| `gas_limit` | UInt64 | Transaction gas limit |
| `base_fee_per_gas` | UInt256 | Block base fee per gas in wei |
| `transaction_hash` | String | Hash of the transaction containing the event |
| `transaction_from` | String | Address that submitted the transaction |
| `transaction_to` | String | Transaction destination address |
| `transaction_value` | UInt256 | Native ETH value sent with the transaction, in wei |
| `transaction_gas` | UInt64 | Gas limit declared by the transaction |
| `transaction_nonce` | UInt64 | Sender nonce used by the transaction |
| `max_fee_per_gas` | UInt256 | Maximum EIP-1559 fee per gas in wei |
| `max_priority_fee_per_gas` | UInt256 | Maximum EIP-1559 priority fee per gas in wei |
| `inserted_at` | DateTime | UTC timestamp when the record was inserted into ClickHouse |
| `launchpad_token` | String | Address of the launchpad token traded in this pool |

## flap_curve_trades

Bonding-curve buys and sells on Flap, before a token graduates to an AMM pool.

**Rows:** 1,295,777 · **Size:** 352.8 MB · **Columns:** 27  
**Partition key:** `toYYYYMMDD(block_timestamp)`  
**History:** 2026-07-08 → 2026-09-01

| Column | Type | Description |
|---|---|---|
| `token` | String | Address of the launchpad token |
| `trader` | String | Address that executed the bonding-curve trade |
| `is_buy` | UInt8 | Whether the trade was a buy (1) or a sell (0) |
| `seq` | UInt256 | Sequence number of the trade within the bonding curve |
| `amount0` | UInt256 | Raw amount field 0 from the bonding-curve trade event |
| `amount1` | UInt256 | Raw amount field 1 from the bonding-curve trade event |
| `amount2` | UInt256 | Raw amount field 2 from the bonding-curve trade event |
| `amount3` | UInt256 | Raw amount field 3 from the bonding-curve trade event |
| `event_id` | String | Unique identifier for the decoded contract event |
| `block_number` | UInt64 | EVM block number containing the event |
| `log_index` | UInt32 | Event log index within the transaction receipt |
| `transaction_index` | UInt32 | Transaction index within the block |
| `contract_address` | String | Address of the contract that emitted the event |
| `block_hash` | String | Hash of the block containing the event |
| `block_timestamp` | DateTime | UTC timestamp of the block containing the event |
| `gas_used` | UInt64 | Gas consumed by the transaction |
| `gas_limit` | UInt64 | Transaction gas limit |
| `base_fee_per_gas` | UInt256 | Block base fee per gas in wei |
| `transaction_hash` | String | Hash of the transaction containing the event |
| `transaction_from` | String | Address that submitted the transaction |
| `transaction_to` | String | Transaction destination address |
| `transaction_value` | UInt256 | Native ETH value sent with the transaction, in wei |
| `transaction_gas` | UInt64 | Gas limit declared by the transaction |
| `transaction_nonce` | UInt64 | Sender nonce used by the transaction |
| `max_fee_per_gas` | UInt256 | Maximum EIP-1559 fee per gas in wei |
| `max_priority_fee_per_gas` | UInt256 | Maximum EIP-1559 priority fee per gas in wei |
| `inserted_at` | DateTime | UTC timestamp when the record was inserted into ClickHouse |

## flap_creations

Token launches on Flap: the asset, its metadata, and the pool it opens against.

**Rows:** 295,316 · **Size:** 118.4 MB · **Columns:** 26  
**History:** 2026-07-08 → 2026-09-01

| Column | Type | Description |
|---|---|---|
| `token` | String | Address of the launchpad token |
| `creator` | String | Address that created the token |
| `nonce` | UInt256 | Creation nonce for the token |
| `ts` | UInt256 | Creation timestamp (unix seconds) |
| `name` | String | Token name from contract metadata |
| `symbol` | String | Token ticker symbol from contract metadata |
| `meta` | String | Additional token metadata serialized as text |
| `event_id` | String | Unique identifier for the decoded contract event |
| `block_number` | UInt64 | EVM block number containing the event |
| `log_index` | UInt32 | Event log index within the transaction receipt |
| `transaction_index` | UInt32 | Transaction index within the block |
| `contract_address` | String | Address of the contract that emitted the event |
| `block_hash` | String | Hash of the block containing the event |
| `block_timestamp` | DateTime | UTC timestamp of the block containing the event |
| `gas_used` | UInt64 | Gas consumed by the transaction |
| `gas_limit` | UInt64 | Transaction gas limit |
| `base_fee_per_gas` | UInt256 | Block base fee per gas in wei |
| `transaction_hash` | String | Hash of the transaction containing the event |
| `transaction_from` | String | Address that submitted the transaction |
| `transaction_to` | String | Transaction destination address |
| `transaction_value` | UInt256 | Native ETH value sent with the transaction, in wei |
| `transaction_gas` | UInt64 | Gas limit declared by the transaction |
| `transaction_nonce` | UInt64 | Sender nonce used by the transaction |
| `max_fee_per_gas` | UInt256 | Maximum EIP-1559 fee per gas in wei |
| `max_priority_fee_per_gas` | UInt256 | Maximum EIP-1559 priority fee per gas in wei |
| `inserted_at` | DateTime | UTC timestamp when the record was inserted into ClickHouse |

## flap_migrations

Tokens that graduated off the Flap bonding curve onto a public pool.

**Kind:** view, computed at query time · **Columns:** 8

| Column | Type | Description |
|---|---|---|
| `pool` | String | Address of the liquidity pool created for the token |
| `token` | String | Address of the launchpad token |
| `token0` | String | Address of token0 in the pool |
| `token1` | String | Address of token1 in the pool |
| `fee` | UInt32 | Pool swap fee in hundredths of a basis point |
| `block_number` | UInt64 | EVM block number containing the event |
| `block_timestamp` | DateTime | UTC timestamp of the block containing the event |
| `transaction_hash` | String | Hash of the transaction containing the event |

## flap_trading

Post-graduation swap stream for Flap tokens, computed from the pool events.

**Kind:** view, computed at query time · **Columns:** 28

| Column | Type | Description |
|---|---|---|
| `pool_address` | String | Address of the pool contract |
| `sender` | String | Address recorded as the swap sender |
| `recipient` | String | Address that received the swap output |
| `amount0` | Int256 | Signed change in the pool's token0 balance, in raw token units |
| `amount1` | Int256 | Signed change in the pool's token1 balance, in raw token units |
| `sqrt_price_x96` | UInt256 | Pool square-root price after the swap as a Q64.96 integer |
| `liquidity` | UInt128 | In-range pool liquidity after the swap |
| `tick` | Int32 | Pool tick after the swap |
| `event_id` | String | Unique identifier for the decoded contract event |
| `block_number` | UInt64 | EVM block number containing the event |
| `log_index` | UInt32 | Event log index within the transaction receipt |
| `transaction_index` | UInt32 | Transaction index within the block |
| `contract_address` | String | Address of the contract that emitted the event |
| `block_hash` | String | Hash of the block containing the event |
| `block_timestamp` | DateTime | UTC timestamp of the block containing the event |
| `gas_used` | UInt64 | Gas consumed by the transaction |
| `gas_limit` | UInt64 | Transaction gas limit |
| `base_fee_per_gas` | UInt256 | Block base fee per gas in wei |
| `transaction_hash` | String | Hash of the transaction containing the event |
| `transaction_from` | String | Address that submitted the transaction |
| `transaction_to` | String | Transaction destination address |
| `transaction_value` | UInt256 | Native ETH value sent with the transaction, in wei |
| `transaction_gas` | UInt64 | Gas limit declared by the transaction |
| `transaction_nonce` | UInt64 | Sender nonce used by the transaction |
| `max_fee_per_gas` | UInt256 | Maximum EIP-1559 fee per gas in wei |
| `max_priority_fee_per_gas` | UInt256 | Maximum EIP-1559 priority fee per gas in wei |
| `inserted_at` | DateTime | UTC timestamp when the record was inserted into ClickHouse |
| `flap_token` | String | Address of the Flap launchpad token traded in this pool |

## doppler_creations

Token launches on Doppler, each carrying the Uniswap v4 pool and hooks contract it opens against.

**Rows:** 288,585 · **Size:** 127.0 MB · **Columns:** 32  
**History:** 2026-07-01 → 2026-09-01

| Column | Type | Description |
|---|---|---|
| `asset` | String | Address of the launchpad asset (token) for the launch |
| `numeraire` | String | Address of the numeraire (quote) token for the pool |
| `initializer` | String | Address of the contract that initialized the pool |
| `pool_or_hook` | String | Address of the pool or its hooks contract |
| `pool_id` | String | Pool identifier |
| `hook` | String | Address of the Uniswap v4 hooks contract for the pool |
| `currency0` | String | Address of currency0, or the native-currency sentinel |
| `currency1` | String | Address of currency1, or the native-currency sentinel |
| `fee` | UInt32 | Pool swap fee in hundredths of a basis point |
| `tick_spacing` | Int32 | Permitted spacing between initialized ticks |
| `name` | String | Token name from contract metadata |
| `symbol` | String | Token ticker symbol from contract metadata |
| `decimals` | UInt8 | Number of decimal places used by the token |
| `event_id` | String | Unique identifier for the decoded contract event |
| `block_number` | UInt64 | EVM block number containing the event |
| `log_index` | UInt32 | Event log index within the transaction receipt |
| `transaction_index` | UInt32 | Transaction index within the block |
| `contract_address` | String | Address of the contract that emitted the event |
| `block_hash` | String | Hash of the block containing the event |
| `block_timestamp` | DateTime | UTC timestamp of the block containing the event |
| `gas_used` | UInt64 | Gas consumed by the transaction |
| `gas_limit` | UInt64 | Transaction gas limit |
| `base_fee_per_gas` | UInt256 | Block base fee per gas in wei |
| `transaction_hash` | String | Hash of the transaction containing the event |
| `transaction_from` | String | Address that submitted the transaction |
| `transaction_to` | String | Transaction destination address |
| `transaction_value` | UInt256 | Native ETH value sent with the transaction, in wei |
| `transaction_gas` | UInt64 | Gas limit declared by the transaction |
| `transaction_nonce` | UInt64 | Sender nonce used by the transaction |
| `max_fee_per_gas` | UInt256 | Maximum EIP-1559 fee per gas in wei |
| `max_priority_fee_per_gas` | UInt256 | Maximum EIP-1559 priority fee per gas in wei |
| `inserted_at` | DateTime | UTC timestamp when the record was inserted into ClickHouse |

## doppler_trading

Swap stream for Doppler pools, computed from the pool events.

**Kind:** view, computed at query time · **Columns:** 28

| Column | Type | Description |
|---|---|---|
| `pool_id` | String | Pool identifier |
| `sender` | String | Address recorded as the swap sender |
| `amount0` | Int128 | Signed change in the pool's token0 balance, in raw token units |
| `amount1` | Int128 | Signed change in the pool's token1 balance, in raw token units |
| `sqrt_price_x96` | UInt256 | Pool square-root price after the swap as a Q64.96 integer |
| `liquidity` | UInt128 | In-range pool liquidity after the swap |
| `tick` | Int32 | Pool tick after the swap |
| `fee` | UInt32 | Pool swap fee in hundredths of a basis point |
| `event_id` | String | Unique identifier for the decoded contract event |
| `block_number` | UInt64 | EVM block number containing the event |
| `log_index` | UInt32 | Event log index within the transaction receipt |
| `transaction_index` | UInt32 | Transaction index within the block |
| `contract_address` | String | Address of the contract that emitted the event |
| `block_hash` | String | Hash of the block containing the event |
| `block_timestamp` | DateTime | UTC timestamp of the block containing the event |
| `gas_used` | UInt64 | Gas consumed by the transaction |
| `gas_limit` | UInt64 | Transaction gas limit |
| `base_fee_per_gas` | UInt256 | Block base fee per gas in wei |
| `transaction_hash` | String | Hash of the transaction containing the event |
| `transaction_from` | String | Address that submitted the transaction |
| `transaction_to` | String | Transaction destination address |
| `transaction_value` | UInt256 | Native ETH value sent with the transaction, in wei |
| `transaction_gas` | UInt64 | Gas limit declared by the transaction |
| `transaction_nonce` | UInt64 | Sender nonce used by the transaction |
| `max_fee_per_gas` | UInt256 | Maximum EIP-1559 fee per gas in wei |
| `max_priority_fee_per_gas` | UInt256 | Maximum EIP-1559 priority fee per gas in wei |
| `inserted_at` | DateTime | UTC timestamp when the record was inserted into ClickHouse |
| `launchpad_asset` | String | Address of the launchpad asset (token) traded in this pool |

## noxa_creations

Token launches on Noxa. Last record is 11 July 2026 - the launchpad has been quiet since.

**Rows:** 60,143 · **Size:** 24.9 MB · **Columns:** 32  
**History:** 2026-06-16 → 2026-07-11

| Column | Type | Description |
|---|---|---|
| `token` | String | Address of the launchpad token |
| `deployer` | String | Address that deployed the token |
| `dex_factory` | String | Address of the DEX factory that created the pool |
| `pair_token` | String | Address of the token paired with the launchpad token |
| `pool` | String | Address of the liquidity pool created for the token |
| `dex_id` | UInt256 | Identifier of the DEX/venue used for the launch |
| `launch_config_id` | UInt256 | Identifier of the launch configuration used |
| `position_id` | UInt256 | Liquidity position identifier |
| `restrictions_end_block` | UInt256 | Block number at which post-launch trading restrictions end |
| `initial_buy_amount` | UInt256 | Amount spent on the creator's initial buy, in raw quote-token units |
| `name` | String | Token name from contract metadata |
| `symbol` | String | Token ticker symbol from contract metadata |
| `decimals` | UInt8 | Number of decimal places used by the token |
| `event_id` | String | Unique identifier for the decoded contract event |
| `block_number` | UInt64 | EVM block number containing the event |
| `log_index` | UInt32 | Event log index within the transaction receipt |
| `transaction_index` | UInt32 | Transaction index within the block |
| `contract_address` | String | Address of the contract that emitted the event |
| `block_hash` | String | Hash of the block containing the event |
| `block_timestamp` | DateTime | UTC timestamp of the block containing the event |
| `gas_used` | UInt64 | Gas consumed by the transaction |
| `gas_limit` | UInt64 | Transaction gas limit |
| `base_fee_per_gas` | UInt256 | Block base fee per gas in wei |
| `transaction_hash` | String | Hash of the transaction containing the event |
| `transaction_from` | String | Address that submitted the transaction |
| `transaction_to` | String | Transaction destination address |
| `transaction_value` | UInt256 | Native ETH value sent with the transaction, in wei |
| `transaction_gas` | UInt64 | Gas limit declared by the transaction |
| `transaction_nonce` | UInt64 | Sender nonce used by the transaction |
| `max_fee_per_gas` | UInt256 | Maximum EIP-1559 fee per gas in wei |
| `max_priority_fee_per_gas` | UInt256 | Maximum EIP-1559 priority fee per gas in wei |
| `inserted_at` | DateTime | UTC timestamp when the record was inserted into ClickHouse |

## noxa_trading

Swap stream for Noxa pools, computed from the pool events.

**Kind:** view, computed at query time · **Columns:** 28

| Column | Type | Description |
|---|---|---|
| `pool_address` | String | Address of the pool contract |
| `sender` | String | Address recorded as the swap sender |
| `recipient` | String | Address that received the swap output |
| `amount0` | Int256 | Signed change in the pool's token0 balance, in raw token units |
| `amount1` | Int256 | Signed change in the pool's token1 balance, in raw token units |
| `sqrt_price_x96` | UInt256 | Pool square-root price after the swap as a Q64.96 integer |
| `liquidity` | UInt128 | In-range pool liquidity after the swap |
| `tick` | Int32 | Pool tick after the swap |
| `event_id` | String | Unique identifier for the decoded contract event |
| `block_number` | UInt64 | EVM block number containing the event |
| `log_index` | UInt32 | Event log index within the transaction receipt |
| `transaction_index` | UInt32 | Transaction index within the block |
| `contract_address` | String | Address of the contract that emitted the event |
| `block_hash` | String | Hash of the block containing the event |
| `block_timestamp` | DateTime | UTC timestamp of the block containing the event |
| `gas_used` | UInt64 | Gas consumed by the transaction |
| `gas_limit` | UInt64 | Transaction gas limit |
| `base_fee_per_gas` | UInt256 | Block base fee per gas in wei |
| `transaction_hash` | String | Hash of the transaction containing the event |
| `transaction_from` | String | Address that submitted the transaction |
| `transaction_to` | String | Transaction destination address |
| `transaction_value` | UInt256 | Native ETH value sent with the transaction, in wei |
| `transaction_gas` | UInt64 | Gas limit declared by the transaction |
| `transaction_nonce` | UInt64 | Sender nonce used by the transaction |
| `max_fee_per_gas` | UInt256 | Maximum EIP-1559 fee per gas in wei |
| `max_priority_fee_per_gas` | UInt256 | Maximum EIP-1559 priority fee per gas in wei |
| `inserted_at` | DateTime | UTC timestamp when the record was inserted into ClickHouse |
| `launchpad_token` | String | Address of the launchpad token traded in this pool |

## nox_creations

Token launches on Nox, the smallest launchpad in the set. Last record is 30 August 2026.

**Rows:** 1,086 · **Size:** 411.4 KB · **Columns:** 27  
**History:** 2026-07-22 → 2026-08-30

| Column | Type | Description |
|---|---|---|
| `token` | String | Address of the launchpad token |
| `creator` | String | Address that created the token |
| `pool` | String | Address of the liquidity pool created for the token |
| `position_id` | UInt256 | Liquidity position identifier |
| `initial_buy` | UInt256 | Amount spent on the creator's initial buy, in raw quote-token units |
| `name` | String | Token name from contract metadata |
| `symbol` | String | Token ticker symbol from contract metadata |
| `decimals` | UInt8 | Number of decimal places used by the token |
| `event_id` | String | Unique identifier for the decoded contract event |
| `block_number` | UInt64 | EVM block number containing the event |
| `log_index` | UInt32 | Event log index within the transaction receipt |
| `transaction_index` | UInt32 | Transaction index within the block |
| `contract_address` | String | Address of the contract that emitted the event |
| `block_hash` | String | Hash of the block containing the event |
| `block_timestamp` | DateTime | UTC timestamp of the block containing the event |
| `gas_used` | UInt64 | Gas consumed by the transaction |
| `gas_limit` | UInt64 | Transaction gas limit |
| `base_fee_per_gas` | UInt256 | Block base fee per gas in wei |
| `transaction_hash` | String | Hash of the transaction containing the event |
| `transaction_from` | String | Address that submitted the transaction |
| `transaction_to` | String | Transaction destination address |
| `transaction_value` | UInt256 | Native ETH value sent with the transaction, in wei |
| `transaction_gas` | UInt64 | Gas limit declared by the transaction |
| `transaction_nonce` | UInt64 | Sender nonce used by the transaction |
| `max_fee_per_gas` | UInt256 | Maximum EIP-1559 fee per gas in wei |
| `max_priority_fee_per_gas` | UInt256 | Maximum EIP-1559 priority fee per gas in wei |
| `inserted_at` | DateTime | UTC timestamp when the record was inserted into ClickHouse |

## nox_trading

Swap stream for Nox pools, computed from the pool events.

**Kind:** view, computed at query time · **Columns:** 28

| Column | Type | Description |
|---|---|---|
| `pool_address` | String | Address of the pool contract |
| `sender` | String | Address recorded as the swap sender |
| `recipient` | String | Address that received the swap output |
| `amount0` | Int256 | Signed change in the pool's token0 balance, in raw token units |
| `amount1` | Int256 | Signed change in the pool's token1 balance, in raw token units |
| `sqrt_price_x96` | UInt256 | Pool square-root price after the swap as a Q64.96 integer |
| `liquidity` | UInt128 | In-range pool liquidity after the swap |
| `tick` | Int32 | Pool tick after the swap |
| `event_id` | String | Unique identifier for the decoded contract event |
| `block_number` | UInt64 | EVM block number containing the event |
| `log_index` | UInt32 | Event log index within the transaction receipt |
| `transaction_index` | UInt32 | Transaction index within the block |
| `contract_address` | String | Address of the contract that emitted the event |
| `block_hash` | String | Hash of the block containing the event |
| `block_timestamp` | DateTime | UTC timestamp of the block containing the event |
| `gas_used` | UInt64 | Gas consumed by the transaction |
| `gas_limit` | UInt64 | Transaction gas limit |
| `base_fee_per_gas` | UInt256 | Block base fee per gas in wei |
| `transaction_hash` | String | Hash of the transaction containing the event |
| `transaction_from` | String | Address that submitted the transaction |
| `transaction_to` | String | Transaction destination address |
| `transaction_value` | UInt256 | Native ETH value sent with the transaction, in wei |
| `transaction_gas` | UInt64 | Gas limit declared by the transaction |
| `transaction_nonce` | UInt64 | Sender nonce used by the transaction |
| `max_fee_per_gas` | UInt256 | Maximum EIP-1559 fee per gas in wei |
| `max_priority_fee_per_gas` | UInt256 | Maximum EIP-1559 priority fee per gas in wei |
| `inserted_at` | DateTime | UTC timestamp when the record was inserted into ClickHouse |
| `launchpad_token` | String | Address of the launchpad token traded in this pool |

## letscash_creations

Token launches on Letscash.

**Rows:** 9,867 · **Size:** 4.5 MB · **Columns:** 30  
**History:** 2026-07-10 → 2026-09-01

| Column | Type | Description |
|---|---|---|
| `token` | String | Address of the launchpad token |
| `creator` | String | Address that created the token |
| `pool_id` | String | Pool identifier |
| `hook` | String | Address of the Uniswap v4 hooks contract for the pool |
| `fee_recipient` | String | Address that receives trading fees for the token |
| `tax` | UInt256 | Transfer tax configured for the token, in basis points |
| `initial_buy` | UInt256 | Amount spent on the creator's initial buy, in raw quote-token units |
| `initial_buy_tokens` | UInt256 | Tokens received from the creator's initial buy, in raw token units |
| `name` | String | Token name from contract metadata |
| `symbol` | String | Token ticker symbol from contract metadata |
| `decimals` | UInt8 | Number of decimal places used by the token |
| `event_id` | String | Unique identifier for the decoded contract event |
| `block_number` | UInt64 | EVM block number containing the event |
| `log_index` | UInt32 | Event log index within the transaction receipt |
| `transaction_index` | UInt32 | Transaction index within the block |
| `contract_address` | String | Address of the contract that emitted the event |
| `block_hash` | String | Hash of the block containing the event |
| `block_timestamp` | DateTime | UTC timestamp of the block containing the event |
| `gas_used` | UInt64 | Gas consumed by the transaction |
| `gas_limit` | UInt64 | Transaction gas limit |
| `base_fee_per_gas` | UInt256 | Block base fee per gas in wei |
| `transaction_hash` | String | Hash of the transaction containing the event |
| `transaction_from` | String | Address that submitted the transaction |
| `transaction_to` | String | Transaction destination address |
| `transaction_value` | UInt256 | Native ETH value sent with the transaction, in wei |
| `transaction_gas` | UInt64 | Gas limit declared by the transaction |
| `transaction_nonce` | UInt64 | Sender nonce used by the transaction |
| `max_fee_per_gas` | UInt256 | Maximum EIP-1559 fee per gas in wei |
| `max_priority_fee_per_gas` | UInt256 | Maximum EIP-1559 priority fee per gas in wei |
| `inserted_at` | DateTime | UTC timestamp when the record was inserted into ClickHouse |

## letscash_trading

Swap stream for Letscash pools, computed from the pool events.

**Kind:** view, computed at query time · **Columns:** 28

| Column | Type | Description |
|---|---|---|
| `pool_id` | String | Pool identifier |
| `sender` | String | Address recorded as the swap sender |
| `amount0` | Int128 | Signed change in the pool's token0 balance, in raw token units |
| `amount1` | Int128 | Signed change in the pool's token1 balance, in raw token units |
| `sqrt_price_x96` | UInt256 | Pool square-root price after the swap as a Q64.96 integer |
| `liquidity` | UInt128 | In-range pool liquidity after the swap |
| `tick` | Int32 | Pool tick after the swap |
| `fee` | UInt32 | Pool swap fee in hundredths of a basis point |
| `event_id` | String | Unique identifier for the decoded contract event |
| `block_number` | UInt64 | EVM block number containing the event |
| `log_index` | UInt32 | Event log index within the transaction receipt |
| `transaction_index` | UInt32 | Transaction index within the block |
| `contract_address` | String | Address of the contract that emitted the event |
| `block_hash` | String | Hash of the block containing the event |
| `block_timestamp` | DateTime | UTC timestamp of the block containing the event |
| `gas_used` | UInt64 | Gas consumed by the transaction |
| `gas_limit` | UInt64 | Transaction gas limit |
| `base_fee_per_gas` | UInt256 | Block base fee per gas in wei |
| `transaction_hash` | String | Hash of the transaction containing the event |
| `transaction_from` | String | Address that submitted the transaction |
| `transaction_to` | String | Transaction destination address |
| `transaction_value` | UInt256 | Native ETH value sent with the transaction, in wei |
| `transaction_gas` | UInt64 | Gas limit declared by the transaction |
| `transaction_nonce` | UInt64 | Sender nonce used by the transaction |
| `max_fee_per_gas` | UInt256 | Maximum EIP-1559 fee per gas in wei |
| `max_priority_fee_per_gas` | UInt256 | Maximum EIP-1559 priority fee per gas in wei |
| `inserted_at` | DateTime | UTC timestamp when the record was inserted into ClickHouse |
| `launchpad_token` | String | Address of the launchpad token traded in this pool |

## varo_creations

Token launches on Varo. The widest creation table of the set at 38 columns.

**Rows:** 8,912 · **Size:** 4.7 MB · **Columns:** 38  
**History:** 2026-07-26 → 2026-09-01

| Column | Type | Description |
|---|---|---|
| `launch_id` | UInt256 | Varo launch identifier |
| `token` | String | Address of the newly created token |
| `creator` | String | Address that created the token |
| `pool` | String | Address of the liquidity pool created for the token |
| `numeraire` | String | Address of the numeraire (quote) token for the pool |
| `aux_contract` | String | Address of the auxiliary contract associated with the launch |
| `total_supply` | UInt256 | Total token supply minted at creation, in raw token units |
| `fee` | UInt32 | Pool swap fee in hundredths of a basis point |
| `sqrt_price_x96` | UInt256 | Initial pool square-root price as a Q64.96 integer |
| `tick_lower` | Int32 | Lower tick of the initial liquidity position |
| `tick_upper` | Int32 | Upper tick of the initial liquidity position |
| `start_tick` | Int32 | Pool tick at launch |
| `liquidity` | UInt256 | Initial liquidity provided at launch |
| `position_id` | UInt256 | Liquidity position identifier minted at launch |
| `aux_param` | UInt256 | Auxiliary launch parameter (protocol-specific) |
| `name` | String | Token name from contract metadata |
| `symbol` | String | Token ticker symbol from contract metadata |
| `image_uri` | String | URI of the token image |
| `metadata_uri` | String | URI of the token metadata document |
| `event_id` | String | Unique identifier for the decoded contract event |
| `block_number` | UInt64 | EVM block number containing the event |
| `log_index` | UInt32 | Event log index within the transaction receipt |
| `transaction_index` | UInt32 | Transaction index within the block |
| `contract_address` | String | Address of the contract that emitted the event |
| `block_hash` | String | Hash of the block containing the event |
| `block_timestamp` | DateTime | UTC timestamp of the block containing the event |
| `gas_used` | UInt64 | Gas consumed by the transaction |
| `gas_limit` | UInt64 | Transaction gas limit |
| `base_fee_per_gas` | UInt256 | Block base fee per gas in wei |
| `transaction_hash` | String | Hash of the transaction containing the event |
| `transaction_from` | String | Address that submitted the transaction |
| `transaction_to` | String | Transaction destination address |
| `transaction_value` | UInt256 | Native ETH value sent with the transaction, in wei |
| `transaction_gas` | UInt64 | Gas limit declared by the transaction |
| `transaction_nonce` | UInt64 | Sender nonce used by the transaction |
| `max_fee_per_gas` | UInt256 | Maximum EIP-1559 fee per gas in wei |
| `max_priority_fee_per_gas` | UInt256 | Maximum EIP-1559 priority fee per gas in wei |
| `inserted_at` | DateTime | UTC timestamp when the record was inserted into ClickHouse |

## varo_trading

Swap stream for Varo pools, computed from the pool events.

**Kind:** view, computed at query time · **Columns:** 28

| Column | Type | Description |
|---|---|---|
| `pool_address` | String | Address of the Varo pool contract |
| `sender` | String | Address that initiated the swap callback |
| `recipient` | String | Address that received the swap output |
| `amount0` | Int256 | Signed change in the pool's token0 balance, in raw token units |
| `amount1` | Int256 | Signed change in the pool's token1 balance, in raw token units |
| `sqrt_price_x96` | UInt256 | Pool square-root price after the swap as a Q64.96 integer |
| `liquidity` | UInt128 | In-range pool liquidity after the swap |
| `tick` | Int32 | Pool tick after the swap |
| `event_id` | String | Unique identifier for the decoded contract event |
| `block_number` | UInt64 | EVM block number containing the event |
| `log_index` | UInt32 | Event log index within the transaction receipt |
| `transaction_index` | UInt32 | Transaction index within the block |
| `contract_address` | String | Address of the contract that emitted the event |
| `block_hash` | String | Hash of the block containing the event |
| `block_timestamp` | DateTime | UTC timestamp of the block containing the event |
| `gas_used` | UInt64 | Gas consumed by the transaction |
| `gas_limit` | UInt64 | Transaction gas limit |
| `base_fee_per_gas` | UInt256 | Block base fee per gas in wei |
| `transaction_hash` | String | Hash of the transaction containing the event |
| `transaction_from` | String | Address that submitted the transaction |
| `transaction_to` | String | Transaction destination address |
| `transaction_value` | UInt256 | Native ETH value sent with the transaction, in wei |
| `transaction_gas` | UInt64 | Gas limit declared by the transaction |
| `transaction_nonce` | UInt64 | Sender nonce used by the transaction |
| `max_fee_per_gas` | UInt256 | Maximum EIP-1559 fee per gas in wei |
| `max_priority_fee_per_gas` | UInt256 | Maximum EIP-1559 priority fee per gas in wei |
| `inserted_at` | DateTime | UTC timestamp when the record was inserted into ClickHouse |
| `launchpad_token` | String | Address of the launchpad token traded in this pool |

## long_creations

Token launches on Long. Unlike the other launchpads this one is a view, computed at query time.

**Kind:** view, computed at query time · **Columns:** 32

| Column | Type | Description |
|---|---|---|
| `asset` | String | Address of the launchpad asset (token) for the launch |
| `numeraire` | String | Address of the numeraire (quote) token for the pool |
| `initializer` | String | Address of the contract that initialized the pool |
| `pool_or_hook` | String | Address of the pool or its hooks contract |
| `pool_id` | String | Pool identifier |
| `hook` | String | Address of the Uniswap v4 hooks contract for the pool |
| `currency0` | String | Address of currency0, or the native-currency sentinel |
| `currency1` | String | Address of currency1, or the native-currency sentinel |
| `fee` | UInt32 | Pool swap fee in hundredths of a basis point |
| `tick_spacing` | Int32 | Permitted spacing between initialized ticks |
| `name` | String | Token name from contract metadata |
| `symbol` | String | Token ticker symbol from contract metadata |
| `decimals` | UInt8 | Number of decimal places used by the token |
| `event_id` | String | Unique identifier for the decoded contract event |
| `block_number` | UInt64 | EVM block number containing the event |
| `log_index` | UInt32 | Event log index within the transaction receipt |
| `transaction_index` | UInt32 | Transaction index within the block |
| `contract_address` | String | Address of the contract that emitted the event |
| `block_hash` | String | Hash of the block containing the event |
| `block_timestamp` | DateTime | UTC timestamp of the block containing the event |
| `gas_used` | UInt64 | Gas consumed by the transaction |
| `gas_limit` | UInt64 | Transaction gas limit |
| `base_fee_per_gas` | UInt256 | Block base fee per gas in wei |
| `transaction_hash` | String | Hash of the transaction containing the event |
| `transaction_from` | String | Address that submitted the transaction |
| `transaction_to` | String | Transaction destination address |
| `transaction_value` | UInt256 | Native ETH value sent with the transaction, in wei |
| `transaction_gas` | UInt64 | Gas limit declared by the transaction |
| `transaction_nonce` | UInt64 | Sender nonce used by the transaction |
| `max_fee_per_gas` | UInt256 | Maximum EIP-1559 fee per gas in wei |
| `max_priority_fee_per_gas` | UInt256 | Maximum EIP-1559 priority fee per gas in wei |
| `inserted_at` | DateTime | UTC timestamp when the record was inserted into ClickHouse |

## long_trading

Swap stream for Long pools, computed from the pool events.

**Kind:** view, computed at query time · **Columns:** 28

| Column | Type | Description |
|---|---|---|
| `pool_id` | String | Pool identifier |
| `sender` | String | Address recorded as the swap sender |
| `amount0` | Int128 | Signed change in the pool's token0 balance, in raw token units |
| `amount1` | Int128 | Signed change in the pool's token1 balance, in raw token units |
| `sqrt_price_x96` | UInt256 | Pool square-root price after the swap as a Q64.96 integer |
| `liquidity` | UInt128 | In-range pool liquidity after the swap |
| `tick` | Int32 | Pool tick after the swap |
| `fee` | UInt32 | Pool swap fee in hundredths of a basis point |
| `event_id` | String | Unique identifier for the decoded contract event |
| `block_number` | UInt64 | EVM block number containing the event |
| `log_index` | UInt32 | Event log index within the transaction receipt |
| `transaction_index` | UInt32 | Transaction index within the block |
| `contract_address` | String | Address of the contract that emitted the event |
| `block_hash` | String | Hash of the block containing the event |
| `block_timestamp` | DateTime | UTC timestamp of the block containing the event |
| `gas_used` | UInt64 | Gas consumed by the transaction |
| `gas_limit` | UInt64 | Transaction gas limit |
| `base_fee_per_gas` | UInt256 | Block base fee per gas in wei |
| `transaction_hash` | String | Hash of the transaction containing the event |
| `transaction_from` | String | Address that submitted the transaction |
| `transaction_to` | String | Transaction destination address |
| `transaction_value` | UInt256 | Native ETH value sent with the transaction, in wei |
| `transaction_gas` | UInt64 | Gas limit declared by the transaction |
| `transaction_nonce` | UInt64 | Sender nonce used by the transaction |
| `max_fee_per_gas` | UInt256 | Maximum EIP-1559 fee per gas in wei |
| `max_priority_fee_per_gas` | UInt256 | Maximum EIP-1559 priority fee per gas in wei |
| `inserted_at` | DateTime | UTC timestamp when the record was inserted into ClickHouse |
| `launchpad_asset` | String | Address of the launchpad asset (token) traded in this pool |