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.

// updated 2026-09-07

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; for connection details see Indexer overview.

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.

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`	table	131,160,440	34.14 GB	2026-05-22 → 2026-09-01
`uniswap_v4_trades`	table	69,102,106	16.34 GB	2026-05-22 → 2026-09-01
`uniswap_v3_pools`	table	657,565	238.1 MB	2026-06-18 → 2026-09-01
`uniswap_v4_pools`	table	554,327	215.9 MB	2026-05-22 → 2026-09-01
`tokens`	table	64,440	31.4 MB	2026-07-08 → 2026-09-01
`pons_curve_trades`	table	5,155,554	1.41 GB	2026-07-21 → 2026-09-01
`pons_creations`	table	143,892	56.9 MB	2026-08-03 → 2026-09-01
`pons_migrations`	table	1,758	747.2 KB	2026-08-04 → 2026-09-01
`pons_trading`	view	-	-	inherited
`flap_curve_trades`	table	1,295,777	352.8 MB	2026-07-08 → 2026-09-01
`flap_creations`	table	295,316	118.4 MB	2026-07-08 → 2026-09-01
`flap_migrations`	view	-	-	inherited
`flap_trading`	view	-	-	inherited
`doppler_creations`	table	288,585	127.0 MB	2026-07-01 → 2026-09-01
`doppler_trading`	view	-	-	inherited
`noxa_creations`	table	60,143	24.9 MB	2026-06-16 → 2026-07-11
`noxa_trading`	view	-	-	inherited
`nox_creations`	table	1,086	411.4 KB	2026-07-22 → 2026-08-30
`nox_trading`	view	-	-	inherited
`letscash_creations`	table	9,867	4.5 MB	2026-07-10 → 2026-09-01
`letscash_trading`	view	-	-	inherited
`varo_creations`	table	8,912	4.7 MB	2026-07-26 → 2026-09-01
`varo_trading`	view	-	-	inherited
`long_creations`	view	-	-	inherited
`long_trading`	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.

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) before showing a human number. Prices arrive as sqrt_price_x96, a Q64.96 fixed-point integer, not a decimal price.

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.

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