honeypop_v1_scroll

Tables

Factory_PoolCreated_event

Factory contract event emitted when a new liquidity pool is created, recording token pairs and pool configuration parameters. Used for tracking DEX pool deployments and liquidity market initialization.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_token0`	`STRING`	Contract address of the first token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_token1`	`STRING`	Contract address of the second token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.
`in_tickSpacing`	`INT64`	Minimum price movement increment between adjacent ticks in a concentrated liquidity pool.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_fee	address	in_pool	removed	in_token0	in_token1	log_index	block_number	in_tickSpacing	block_timestamp	transaction_hash
500	0x1d25af2b0992bf227b350860ea80bad47382caf6	0xf8df1399b91dd48f0b7dcabdbed08473c285af7e	false	0x01f0a31698c4d065659b9bdc21b3610292a1c506	0x5300000000000000000000000000000000000004	4	14752523	10	2025-04-15T11:12:56.000Z	0xddf62f4edfcf8bbce5f80323af2abcffa0183c62028ddb49fba8f229684ccd7f
500	0x1d25af2b0992bf227b350860ea80bad47382caf6	0x04566bf83399e4f750728d1ef57008aedda00e71	false	0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4	0x5300000000000000000000000000000000000004	1	14752429	10	2025-04-15T11:08:14.000Z	0x3b14ec55b12e97de16b02083bd1aedb524cb87edf75dc7a02bcd4c65e9035e46
500	0x1d25af2b0992bf227b350860ea80bad47382caf6	0x21dcf6bd4d2cbbd66906e53c240c97c8074fcaaf	false	0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4	0xf55bec9cafdbe8730f096aa55dad6d22d44099df	5	14750284	10	2025-04-15T09:20:59.000Z	0x6eee138d226f5deabd58c803fbfda457f69fb2a02dad6800aba757c6e23e7e98

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.honeypop_v1_scroll.Factory_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pool_Burn_event

Liquidity removal events from concentrated liquidity pools recording withdrawn token amounts and position tick ranges. Contains owner address, liquidity amount burned, token amounts withdrawn (amount0/amount1), and tick boundaries for tracking position liquidations and TVL changes.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_tickLower`	`INT64`	Lower tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
`in_tickUpper`	`INT64`	Upper tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_owner	in_amount	log_index	in_amount0	in_amount1	block_number	in_tickLower	in_tickUpper	block_timestamp	transaction_hash
0x04566bf83399e4f750728d1ef57008aedda00e71	false	0xb6f8d24e28bf5b8add2e7510f84f3b9ef03b3435	50952560485361215	1	1178772368544	0	17251648	196260	207240	2025-07-16T02:52:10.000Z	0xfd8d8dfed2168b3252bf2ef04b784b9da71deee7821d595d4a4709260a32bb6a
0x7761786afab6e496e6bf3ebe56fc2ea71cd02d7d	false	0xb6f8d24e28bf5b8add2e7510f84f3b9ef03b3435	339840389811026735	0	3849813984778744	29999239184941584207	16051449	-887220	887220	2025-05-28T17:01:02.000Z	0xc5f3f6dcf134310d89d28757eaef80ee90572a5da70abcd5aaf0470cf24cf535
0x7761786afab6e496e6bf3ebe56fc2ea71cd02d7d	false	0xb6f8d24e28bf5b8add2e7510f84f3b9ef03b3435	0	0	0	0	16051442	-887220	887220	2025-05-28T17:00:42.000Z	0xfe3e40282b3170b72a5eed7b8521eef4d03b552763c492fa211c515d9bef7b30

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.honeypop_v1_scroll.Pool_Burn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pool_Collect_event

Concentrated liquidity position fee collection events from Uniswap V3 compatible decentralized exchanges. Records position owner, recipient, collected token amounts, and tick range boundaries for tracking earned trading fees and position management activity.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_tickLower`	`INT64`	Lower tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
`in_tickUpper`	`INT64`	Upper tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
`in_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_owner	log_index	in_amount0	in_amount1	block_number	in_recipient	in_tickLower	in_tickUpper	block_timestamp	transaction_hash
0x7761786afab6e496e6bf3ebe56fc2ea71cd02d7d	false	0xb6f8d24e28bf5b8add2e7510f84f3b9ef03b3435	3	150031556742226	1512657479674695145	19535370	0xb6f8d24e28bf5b8add2e7510f84f3b9ef03b3435	-887220	887220	2025-08-18T19:00:52.000Z	0x4c4a1012dbed1be08d29e4718f1af67bc47db0f803ef50b235f93075a4f56893
0x04566bf83399e4f750728d1ef57008aedda00e71	false	0xb6f8d24e28bf5b8add2e7510f84f3b9ef03b3435	7	163937	55309096830233	19535392	0xb6f8d24e28bf5b8add2e7510f84f3b9ef03b3435	-887270	202690	2025-08-18T19:01:14.000Z	0x6c2a0053dfec6f7e4b43f761767ae972f5ec80d575fb97d3362be8c9c71d1bf4
0x7761786afab6e496e6bf3ebe56fc2ea71cd02d7d	false	0xb6f8d24e28bf5b8add2e7510f84f3b9ef03b3435	4	21283845133166901	133014132378809396087	15307305	0xb6f8d24e28bf5b8add2e7510f84f3b9ef03b3435	-887220	887220	2025-05-09T07:36:07.000Z	0xb802369df31a27d7ddb22a2ab8f50e18486ffa798c467116e18995209ee6d1b1

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.honeypop_v1_scroll.Pool_Collect_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pool_Flash_event

Flash loan events from liquidity pools recording borrowed amounts and repayment fees for both tokens in the pair. Tracks sender, recipient, borrowed quantities, and actual fees paid for arbitrage and liquidation analysis.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_paid0`	`STRING`	Amount of token0 paid as flash loan fee. Numeric string representation of token quantity in smallest denomination.
`in_paid1`	`STRING`	Amount of token1 paid as flash loan fee. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_paid0	in_paid1	in_sender	log_index	in_amount0	in_amount1	block_number	in_recipient	block_timestamp	transaction_hash
0x04566bf83399e4f750728d1ef57008aedda00e71	false	0	500000000000	0x05e6c92d637e1700583adb328db505ad6f4a2221	2	0	1000000000000000	21061500	0x05e6c92d637e1700583adb328db505ad6f4a2221	2025-09-11T23:10:04.000Z	0xc338a50454a54c0f18db99859e4a5704982341f378825fc9e2e15ddf03bf6b6e
0xaab2691a940fa604b3358ed109808e0f8391b96e	false	64	0	0x1c40be10077f686fdfd9e6373c5611d02061ab34	65	127489	0	23215307	0xc650765659df198ffe9afc6a6109378c55e741d0	2025-10-14T16:38:16.000Z	0xbe969489da2d9793a06c36ab13b325f5b82a68ce6292e8bbd20d145c4a499e28
0xaab2691a940fa604b3358ed109808e0f8391b96e	false	40	0	0x1c40be10077f686fdfd9e6373c5611d02061ab34	14	79648	0	25541107	0xc650765659df198ffe9afc6a6109378c55e741d0	2025-11-27T15:31:28.000Z	0x115991d88baad20b74bcd70085dc57173898dde347ed65d1e4eb770170cf4fc4

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.honeypop_v1_scroll.Pool_Flash_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pool_Mint_event

Liquidity provision events emitted when liquidity providers add tokens to concentrated liquidity pools. Records deposited token amounts, tick ranges, liquidity shares, and position owner for DEX pool analytics.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_tickLower`	`INT64`	Lower tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
`in_tickUpper`	`INT64`	Upper tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_owner	in_amount	in_sender	log_index	in_amount0	in_amount1	block_number	in_tickLower	in_tickUpper	block_timestamp	transaction_hash
0x04566bf83399e4f750728d1ef57008aedda00e71	false	0xb6f8d24e28bf5b8add2e7510f84f3b9ef03b3435	14798228	0xb6f8d24e28bf5b8add2e7510f84f3b9ef03b3435	15	735	99997215490	17551792	184220	230270	2025-07-24T05:57:56.000Z	0xb81f0b79b2dc0f574c2516f6d30caa73d5523bcda6c1c32c4d44fac3fca0b813
0x04566bf83399e4f750728d1ef57008aedda00e71	false	0xb6f8d24e28bf5b8add2e7510f84f3b9ef03b3435	2012156	0xb6f8d24e28bf5b8add2e7510f84f3b9ef03b3435	20	100	13600923726	17551876	184220	230270	2025-07-24T06:00:07.000Z	0x1896ed0b0c701e4c49607cec6ac40928db300e6fb8d565e5395cae8b9f8c525f
0x04566bf83399e4f750728d1ef57008aedda00e71	false	0xb6f8d24e28bf5b8add2e7510f84f3b9ef03b3435	5965197	0xb6f8d24e28bf5b8add2e7510f84f3b9ef03b3435	4	356	99953868268	17551923	-887270	887270	2025-07-24T06:01:16.000Z	0x35279ce24971650faa394ec4d1b5fadee60f699d99d459911697ab685111c70e

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.honeypop_v1_scroll.Pool_Mint_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pool_Swap_event

Decentralized exchange (DEX) swap execution events recording token exchanges within liquidity pools. Contains sender, recipient, token amounts, liquidity depth, price data (sqrtPriceX96 or tick), and transaction metadata for tracking trading activity and price movements.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_sqrtPriceX96`	`STRING`	Square root of the price ratio between token1 and token0 encoded as a Q64.96 fixed-point number. Numeric string representation used in concentrated liquidity automated market makers.
`in_liquidity`	`STRING`	Total liquidity available in the pool at the time of the event. Numeric string representation of liquidity in smallest denomination.
`in_tick`	`INT64`	Current tick index of the concentrated liquidity pool after the swap or operation. Integer value representing the price point on the pool’s tick spacing grid.

Sample Data

address	in_tick	removed	in_sender	log_index	in_amount0	in_amount1	block_number	in_liquidity	in_recipient	block_timestamp	in_sqrtPriceX96	transaction_hash
0x7574bc9bac08f22df6b1542b9a85686e825d58d5	-197763	false	0x04a700f83286821a5de732107d0b47996eb3f54f	4	50000000000000000	-129158286	15470535	1638518082334380	0x04a700f83286821a5de732107d0b47996eb3f54f	2025-05-15T03:46:28.000Z	4024645394235456915816698	0xde3457ea91023da98197d3d2533b5ab6e738bca565467007a0c77dceffc629a1
0x7574bc9bac08f22df6b1542b9a85686e825d58d5	-198133	false	0x04a700f83286821a5de732107d0b47996eb3f54f	24	50000000000000000	-124465354	15498699	1638518082334380	0x04a700f83286821a5de732107d0b47996eb3f54f	2025-05-15T14:42:14.000Z	3950907821458810342603207	0xad62ebb6ec8927c26d5adf5ddafa35e6d42174950961497930d836e795deb5c7
0x7574bc9bac08f22df6b1542b9a85686e825d58d5	-197830	false	0x04a700f83286821a5de732107d0b47996eb3f54f	4	50000000000000000	-128301223	15477598	1638518082334380	0x04a700f83286821a5de732107d0b47996eb3f54f	2025-05-15T07:11:11.000Z	4011280215486962779104770	0xef046988a5eab296b848efbb4acdfd5eb1b096aa9f3bc2f72d396d6867080a16

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.honeypop_v1_scroll.Pool_Swap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Metrics

Primitives

Contracts

Blockchain

Tables

Factory_PoolCreated_event

Pool_Burn_event

Pool_Collect_event

Pool_Flash_event

Pool_Mint_event

Pool_Swap_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Factory_PoolCreated_event

​Pool_Burn_event

​Pool_Collect_event

​Pool_Flash_event

​Pool_Mint_event

​Pool_Swap_event

Tables

Factory_PoolCreated_event

Pool_Burn_event

Pool_Collect_event

Pool_Flash_event

Pool_Mint_event

Pool_Swap_event