Robinhood Chain Tables

Tables containing Robinhood Chain token metadata and decoded Uniswap v3/v4, Pons, and Varo pool, swap, and launchpad events.

Last updated: 2026-09-01 12:38 UTC

Tables (25)

Table	Rows	Size
doppler_creations	288,585	127.0 MB
doppler_trading	—	View
flap_creations	295,316	118.4 MB
flap_curve_trades	1,295,777	352.8 MB
flap_migrations	—	View
flap_trading	—	View
letscash_creations	9,867	4.5 MB
letscash_trading	—	View
long_creations	—	View
long_trading	—	View
nox_creations	1,086	411.4 KB
nox_trading	—	View
noxa_creations	60,143	24.9 MB
noxa_trading	—	View
pons_creations	143,892	56.9 MB
pons_curve_trades	5,155,554	1.41 GB
pons_migrations	1,758	747.2 KB
pons_trading	—	View
tokens	64,440	31.4 MB
uniswap_v3_pools	657,565	238.1 MB
uniswap_v3_trades	131,160,440	34.14 GB
uniswap_v4_pools	554,327	215.9 MB
uniswap_v4_trades	69,102,106	16.34 GB
varo_creations	8,912	4.7 MB
varo_trading	—	View

doppler_creations

Statistic	Value
Rows	288,585
Size	127.0 MB
First Record	2026-07-01
Last Record	2026-09-01

Columns:

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

Example Query:

ClickHouse (robinhood)

doppler_trading

Statistic	Value
Type	View (computed at query time)

Columns:

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

Example Query:

ClickHouse (robinhood)

flap_creations

Statistic	Value
Rows	295,316
Size	118.4 MB
First Record	2026-07-08
Last Record	2026-09-01

Columns:

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

Example Query:

ClickHouse (robinhood)

flap_curve_trades

Statistic	Value
Rows	1,295,777
Size	352.8 MB
First Record	2026-07-08
Last Record	2026-09-01
Partition Key	`toYYYYMMDD(block_timestamp)`

Columns:

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

Example Query:

ClickHouse (robinhood)

flap_migrations

Statistic	Value
Type	View (computed at query time)

Columns:

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

Example Query:

ClickHouse (robinhood)

flap_trading

Statistic	Value
Type	View (computed at query time)

Columns:

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

Example Query:

ClickHouse (robinhood)

letscash_creations

Statistic	Value
Rows	9,867
Size	4.5 MB
First Record	2026-07-10
Last Record	2026-09-01

Columns:

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

Example Query:

ClickHouse (robinhood)

letscash_trading

Statistic	Value
Type	View (computed at query time)

Columns:

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

Example Query:

ClickHouse (robinhood)

long_creations

Statistic	Value
Type	View (computed at query time)

Columns:

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

Example Query:

ClickHouse (robinhood)

long_trading

Statistic	Value
Type	View (computed at query time)

Columns:

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

Example Query:

ClickHouse (robinhood)

nox_creations

Statistic	Value
Rows	1,086
Size	411.4 KB
First Record	2026-07-22
Last Record	2026-08-30

Columns:

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

Example Query:

ClickHouse (robinhood)

nox_trading

Statistic	Value
Type	View (computed at query time)

Columns:

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

Example Query:

ClickHouse (robinhood)

noxa_creations

Statistic	Value
Rows	60,143
Size	24.9 MB
First Record	2026-06-16
Last Record	2026-07-11

Columns:

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

Example Query:

ClickHouse (robinhood)

noxa_trading

Statistic	Value
Type	View (computed at query time)

Columns:

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

Example Query:

ClickHouse (robinhood)

pons_creations

Statistic	Value
Rows	143,892
Size	56.9 MB
First Record	2026-08-03
Last Record	2026-09-01

Columns:

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

Example Query:

ClickHouse (robinhood)

pons_curve_trades

Statistic	Value
Rows	5,155,554
Size	1.41 GB
First Record	2026-07-21
Last Record	2026-09-01
Partition Key	`toYYYYMMDD(block_timestamp)`

Columns:

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

Example Query:

ClickHouse (robinhood)

pons_migrations

Statistic	Value
Rows	1,758
Size	747.2 KB
First Record	2026-08-04
Last Record	2026-09-01

Columns:

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

Example Query:

ClickHouse (robinhood)

pons_trading

Statistic	Value
Type	View (computed at query time)

Columns:

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

Example Query:

ClickHouse (robinhood)

tokens

Statistic	Value
Rows	64,440
Size	31.4 MB
First Record	2026-07-08
Last Record	2026-09-01

Columns:

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

Example Query:

ClickHouse (robinhood)

uniswap_v3_pools

Statistic	Value
Rows	657,565
Size	238.1 MB
First Record	2026-06-18
Last Record	2026-09-01

Columns:

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

Example Query:

ClickHouse (robinhood)

uniswap_v3_trades

Statistic	Value
Rows	131,160,440
Size	34.14 GB
First Record	2026-05-22
Last Record	2026-09-01
Partition Key	`toYYYYMMDD(block_timestamp)`

Columns:

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

Example Query:

ClickHouse (robinhood)

uniswap_v4_pools

Statistic	Value
Rows	554,327
Size	215.9 MB
First Record	2026-05-22
Last Record	2026-09-01

Columns:

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

Example Query:

ClickHouse (robinhood)

uniswap_v4_trades

Statistic	Value
Rows	69,102,106
Size	16.34 GB
First Record	2026-05-22
Last Record	2026-09-01
Partition Key	`toYYYYMMDD(block_timestamp)`

Columns:

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

Example Query:

ClickHouse (robinhood)

varo_creations

Statistic	Value
Rows	8,912
Size	4.7 MB
First Record	2026-07-26
Last Record	2026-09-01

Columns:

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

Example Query:

ClickHouse (robinhood)

varo_trading

Statistic	Value
Type	View (computed at query time)

Columns:

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

Example Query:

ClickHouse (robinhood)