hyperswap_v3_hyperevm

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	0xb1c0fa0b789320044a6f623cfe5ebda9562602e3	0x7d514196ac8faf6d6ab489bee2d040717fec086f	false	0x5555555555555555555555555555555555555555	0xb0bd04337c70257035529e22ae09f11500751f0c	1	324116	10	2025-02-25T09:53:00.000Z	0x4a94b16b5257b3a38572312372a55b5debb0602c729b7e5982994fb38d679c17
3000	0xb1c0fa0b789320044a6f623cfe5ebda9562602e3	0xcddcef938491f98267c52d623dc571725c9960ac	false	0x5555555555555555555555555555555555555555	0x91fee06d8f5d4bb3e3aea7105cb4dfb8d4a7d06d	1	348327	60	2025-02-25T22:54:00.000Z	0xf88adfbd3bde0a4267fae535363bb587524bd2d6d856f7d76f9baf4c0765b1bf
10000	0xb1c0fa0b789320044a6f623cfe5ebda9562602e3	0xc98b4bbd65bcdd717ef238e2670e936b71a6ee0e	false	0x5555555555555555555555555555555555555555	0x91fee06d8f5d4bb3e3aea7105cb4dfb8d4a7d06d	1	349257	200	2025-02-25T23:24:00.000Z	0x5b829ef3a52395ba72bfef57d200183423e3b180c9ddf4177552f7d0cc7e349a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.hyperswap_v3_hyperevm.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
0xec14884b6245d286d02f988adc7c93e4124c8e45	false	0x6eda206207c09e5428f281761ddc0d300851fbc8	0	10	0	0	11714243	-887272	887272	2025-08-21T10:58:57.000Z	0x28a77312fecd7e27dceb889e8d10130d397ba9762fadfc4d0e5cc2c086378713
0x2effc5cb7ca6a299cc68b79c5e21dd3d4f29c585	false	0x6eda206207c09e5428f281761ddc0d300851fbc8	25262337530252	15	25348814079135166941	25176155	11685907	-887272	887272	2025-08-21T03:14:25.000Z	0x99541e1dbbadc873faffab81258c255613c9a42ce05e48355277c47e15ef798a
0x1aa07e8377d70b033ba139e007d51edf689b2ed3	false	0x6eda206207c09e5428f281761ddc0d300851fbc8	0	12	0	0	11694154	-887272	887272	2025-08-21T05:29:37.000Z	0x9d8165c99740cfcc90ae01ff0c4d809149c064cfb127c5e97312ccd73441bc36

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.hyperswap_v3_hyperevm.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
0x10777e6d87b6c5a7edc491adcf272f8f4f3ab70d	false	0x6eda206207c09e5428f281761ddc0d300851fbc8	5	99412413416768012494	99493578815825964953	1361044	0xa4f7d6a008401a608476199a01dcc5487130987a	-414480	414480	2025-03-20T15:27:06.000Z	0xce1839b3bd497be3085640ddf0366b837c814cc7a07e998b0f8bc327e10f2567
0x142dabf1f10b8d107a9065c9cc890baa77a8200d	false	0x6eda206207c09e5428f281761ddc0d300851fbc8	4	3366727358	1367690378457454033	1335120	0x6eda206207c09e5428f281761ddc0d300851fbc8	-138180	414480	2025-03-20T01:30:52.000Z	0xec0bfa50b18de70367732fbc29587bda1571f385e25d8b47fcdb68052f1724e8
0x142dabf1f10b8d107a9065c9cc890baa77a8200d	false	0x6eda206207c09e5428f281761ddc0d300851fbc8	8	20034740463	8059093436415684581	1367735	0x6eda206207c09e5428f281761ddc0d300851fbc8	-138180	414480	2025-03-20T19:02:58.000Z	0xaf9b8f6befef5dd9b30d2562f4355efa3e5513df61cfe90a64e641aa920126d5

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.hyperswap_v3_hyperevm.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_paid1	in_sender	log_index	in_amount1	block_number	in_recipient	block_timestamp	transaction_hash
0xb0588a09096f1029b25d14f788a480044d8c546b	false	22729	0xac582f0f774b545c31e133cb52153ce3aef90632	16	227282698	13759873	0xac582f0f774b545c31e133cb52153ce3aef90632	2025-09-13T18:09:05.000Z	0x643173663d4d0d860e87b536c93037a2e427dccd54cabfb679865310e9c2e1f3
0xb0588a09096f1029b25d14f788a480044d8c546b	false	7234	0xac582f0f774b545c31e133cb52153ce3aef90632	21	72330875	13731889	0xac582f0f774b545c31e133cb52153ce3aef90632	2025-09-13T10:30:20.000Z	0x0af61388937456b07f22c4e0355c97d63149dc1d7070788a4e0bd46ab84d36c5
0x43e3f61713a6772cb0c5e7855a4e9b5333fa2dc4	false	240000000000000	0xac541896626f68133338d464f6d1847a9062502b	18	80000000000000000	1351587	0xb51a5451629011cfffe3a2abaa9a530050f28b0d	2025-03-20T10:22:02.000Z	0x116493148d3003bc7bc8761d3f5f53bd8669861065915817af948e02fcd07ea9

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.hyperswap_v3_hyperevm.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
0xf0fc398eaa69d12e812c66eb4f351f5eae8ba11a	false	0x6eda206207c09e5428f281761ddc0d300851fbc8	929847004056	0x6eda206207c09e5428f281761ddc0d300851fbc8	4	248547826461531485	1813	15671738	-320400	-319440	2025-10-05T12:33:55.000Z	0x064f2ce7ffa6d41948e9df9eda35e9fa04313e5c7a92f0eaefb647ceb699f89a
0xf0fc398eaa69d12e812c66eb4f351f5eae8ba11a	false	0x6eda206207c09e5428f281761ddc0d300851fbc8	7570156668088	0x6eda206207c09e5428f281761ddc0d300851fbc8	7	15226892750225307396	287000	15662677	-328020	-314700	2025-10-05T10:05:22.000Z	0x94c345dfb64469bc5e9396ae635f20bdafe39d5d5eb2ab9d2dd438e3c536c5aa
0x3a36b04bcc1d5e2e303981ef643d2668e00b43e7	false	0x6eda206207c09e5428f281761ddc0d300851fbc8	61344719115688	0x6eda206207c09e5428f281761ddc0d300851fbc8	12	4328638940108053378	192102	15685826	-308880	-308280	2025-10-05T16:24:52.000Z	0x2bde7839f77e765d558eceedcd4377702c1fbf3c96ac6f63b4b0e2966398ed04

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.hyperswap_v3_hyperevm.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
0x142dabf1f10b8d107a9065c9cc890baa77a8200d	195550	false	0x4e2960a8cd19b467b82d26d83facb0fae26b094d	3	-18300000000	5683180197686939475	348518	100733142488055777	0x86c4c4df233fa4271ab3c135588153d78a602b88	2025-02-25T23:00:10.000Z	1396340957401078405906549176201686	0x52926681b0014ebebd65f5a3710686878e15a7395180306e832d7e194374ad88
0x142dabf1f10b8d107a9065c9cc890baa77a8200d	195489	false	0x4e2960a8cd19b467b82d26d83facb0fae26b094d	3	-32294036	10000000000000000	348533	100733142488055777	0x8c6fdbca2070590d7f2ce5b2c1ed1c305d968e5d	2025-02-25T23:00:40.000Z	1392089707971778825666256661314547	0xa584347abd911e631ccbd384a4b8f3808d44311595ffa0e89d7db79ffee2660f
0xebd422397cfd0b5481c6eee424b9320f9980c710	110359	false	0x4e2960a8cd19b467b82d26d83facb0fae26b094d	3	200000000000000000	-12402723801744674187248	326437	1026331489411512704238	0xbed9c742d2b2054e67beb859124ade7a738c6283	2025-02-25T11:07:54.000Z	19732317180843255464774231912147	0xdc24cbefb20e9283a0576103079ec5fdb91515394e1e999d90804bcf7f954386

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.hyperswap_v3_hyperevm.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