Skip to main content

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_token0STRINGContract address of the first token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
in_token1STRINGContract address of the second token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
in_feeSTRINGFee 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_tickSpacingINT64Minimum price movement increment between adjacent ticks in a concentrated liquidity pool.
in_poolSTRINGContract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
in_feeaddressin_poolremovedin_token0in_token1log_indexblock_numberin_tickSpacingblock_timestamptransaction_hash
100000x179d9a5592bc77050796f7be28058c51ca575df40x0b366cf232a9480d2e1d26a6f8a66aac41a575ccfalse0x3ea30c06f4ba6f696d3ba4b660c39da96ed8f6860xe30fedd158a2e3b13e9badaeabafc5516e95e8c741221095792002024-12-22T22:50:57.000Z0xb7cbbe45144473c9e04e71c9eedc0d34d0f9f66f0166f3d1f8dbe5076c606d75
30000x179d9a5592bc77050796f7be28058c51ca575df40x9e8cba8138ec2975bbfad17d018cebae06290a36false0xc141153c69f28be65469c98e318872911587ebec0xe30fedd158a2e3b13e9badaeabafc5516e95e8c75158502418602025-07-21T14:11:54.000Z0x4014def95746b78b1f49734b7c824b9aad2c43233d50658b166fffef2c3bd96e
1000x179d9a5592bc77050796f7be28058c51ca575df40x281a0696494445b4bc056b28cf6971a9d2c2acd8false0x2b01a6f212c20bd3616e4462a155f0d45bd14e570xe554b9769906cd741732828b8af515db4c896d471315841626112025-07-21T02:43:59.000Z0x8e1e994336eda958df90d34ecc36ecb1c90a5fb2193169b2f6f4dd7125f62140
Query with partition filter
SELECT *
FROM `tt-contracts.dragonswap_v3_seievm.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_ownerSTRINGAddress that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
in_tickLowerINT64Lower 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_tickUpperINT64Upper 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_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_amount0STRINGAmount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
in_amount1STRINGAmount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
addressremovedin_ownerin_amountlog_indexin_amount0in_amount1block_numberin_tickLowerin_tickUpperblock_timestamptransaction_hash
0x47595f7f86f72a4a7c2b33858b2d1a448f663234false0xa7fdcbe645d6b2b98639ebacbc347e2b575f6f70245891065850662730122274278890113780511-109-1082024-11-09T00:40:56.000Z0xcde63d0fcde4ddff1aab291a0684b6759db333192415ee6d55a0f3e6bcfbe11f
0x47595f7f86f72a4a7c2b33858b2d1a448f663234false0xa7fdcbe645d6b2b98639ebacbc347e2b575f6f701401120378068600069999999999113901818-20-102024-11-09T15:04:08.000Z0x73ef2a844f37d90f91ff65ded2a14baef8a9efad994dcd8c08531a71f9192537
0x47595f7f86f72a4a7c2b33858b2d1a448f663234false0xa7fdcbe645d6b2b98639ebacbc347e2b575f6f70243935344689417703095714768390974751441113873575-10-92024-11-09T11:50:16.000Z0x97f462c9430de4717c30bec6f86f5eacd992c64b0d9819b9e0de8294646ed6c1
Query with partition filter
SELECT *
FROM `tt-contracts.dragonswap_v3_seievm.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_ownerSTRINGAddress that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
in_recipientSTRINGAddress designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_tickLowerINT64Lower 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_tickUpperINT64Upper 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_amount0STRINGAmount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
in_amount1STRINGAmount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
addressremovedin_ownerlog_indexin_amount0in_amount1block_numberin_recipientin_tickLowerin_tickUpperblock_timestamptransaction_hash
0x69e2edd60bbcd42fd5ed549599de249a9a34b98bfalse0x9eccbc0c95c7f1d26dfcffe0879c085b6388d437413783679129921328238040310721364409140x9eccbc0c95c7f1d26dfcffe0879c085b6388d437-202260-2008202025-03-14T02:05:54.000Z0xb5aa0dfcb73fffb648be8315985a9efac93b48bbc568732ce3bd8c96e477036a
0x69e2edd60bbcd42fd5ed549599de249a9a34b98bfalse0xa7fdcbe645d6b2b98639ebacbc347e2b575f6f705192098482400510842176601867381365925100x0e545f33038c3457cc2efe1edcfdf8f76ab4af32-202080-2000402025-03-14T23:17:22.000Z0x43722c488e04ca3a38de99049e0d470507f5abbb4be88e8991b186d15c50bd54
0x69e2edd60bbcd42fd5ed549599de249a9a34b98bfalse0xa7fdcbe645d6b2b98639ebacbc347e2b575f6f704138227304183358771009501365708790x0e545f33038c3457cc2efe1edcfdf8f76ab4af32-202080-2000402025-03-14T20:16:16.000Z0x3abfc66bbffa2e620f9e928e9e0ba76f060c946fcc939bc2c8755cf09340df92
Query with partition filter
SELECT *
FROM `tt-contracts.dragonswap_v3_seievm.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_senderSTRINGAddress that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_recipientSTRINGAddress designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amount0STRINGAmount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
in_amount1STRINGAmount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
in_paid0STRINGAmount of token0 paid as flash loan fee. Numeric string representation of token quantity in smallest denomination.
in_paid1STRINGAmount of token1 paid as flash loan fee. Numeric string representation of token quantity in smallest denomination.
addressremovedin_paid0in_paid1in_senderlog_indexin_amount0in_amount1block_numberin_recipientblock_timestamptransaction_hash
0x71be732f1455397dddf00a8bd3d146c6aef5ef2efalse05800000000000000x19eef93efe28ef239a4e31d4e86ff0b09dedf4788011600000000000000001432058370xf2a3555584c6e20b288094b137f670472ec1bb9c2025-04-21T10:07:27.000Z0xe4c2c11c0f920152c3144d0447ea8867dc3db2d2c5023210588a6017ee9e4998
0x2394c3f6c9a9dc00a36a80d493331e3c3f19c052false034800000000000000x19eef93efe28ef239a4e31d4e86ff0b09dedf4788011600000000000000001432058530xf2a3555584c6e20b288094b137f670472ec1bb9c2025-04-21T10:07:35.000Z0xb4c3187f32dedb52b2925204943030dad1976a786fcd8ca13e9aa44e8874d451
0xb243320bcf9c95db7f74108b6773b8f4dc3adaf5false034800000000000000x19eef93efe28ef239a4e31d4e86ff0b09dedf4788011600000000000000001432058800xf2a3555584c6e20b288094b137f670472ec1bb9c2025-04-21T10:07:48.000Z0x9e770717b9ba9db6760c78d0cb219ce8a9d6ee1efff708d68311b034a1fb0695
Query with partition filter
SELECT *
FROM `tt-contracts.dragonswap_v3_seievm.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_senderSTRINGAddress that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_ownerSTRINGAddress that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
in_tickLowerINT64Lower 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_tickUpperINT64Upper 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_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_amount0STRINGAmount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
in_amount1STRINGAmount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
addressremovedin_ownerin_amountin_senderlog_indexin_amount0in_amount1block_numberin_tickLowerin_tickUpperblock_timestamptransaction_hash
0x69e2edd60bbcd42fd5ed549599de249a9a34b98bfalse0xa7fdcbe645d6b2b98639ebacbc347e2b575f6f706013212388207110680xa7fdcbe645d6b2b98639ebacbc347e2b575f6f702375187384680753139790398871975126883807-195540-1954802025-01-18T10:41:49.000Z0xccfb78e982ad64a59e3fb665f0562be52b875774b75d81c801866325b09691c8
0x69e2edd60bbcd42fd5ed549599de249a9a34b98bfalse0xa7fdcbe645d6b2b98639ebacbc347e2b575f6f70355031807966214140xa7fdcbe645d6b2b98639ebacbc347e2b575f6f70112215179622967533015337326022126883832-195540-1954802025-01-18T10:42:02.000Z0x83532a7f27b15454eb3dea2f2f747ededaa2bed37983bde3cc9ebef1143130db
0x69e2edd60bbcd42fd5ed549599de249a9a34b98bfalse0xa7fdcbe645d6b2b98639ebacbc347e2b575f6f706368271256612780170xa7fdcbe645d6b2b98639ebacbc347e2b575f6f702407880898518418243695395124933126884432-195540-1954802025-01-18T10:47:16.000Z0x2c82db3c403b47df4f5146526392afa4ba2e5df8aa2f4410d706136c588d6000
Query with partition filter
SELECT *
FROM `tt-contracts.dragonswap_v3_seievm.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_senderSTRINGAddress that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_recipientSTRINGAddress designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amount0STRINGAmount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
in_amount1STRINGAmount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
in_sqrtPriceX96STRINGSquare 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_liquiditySTRINGTotal liquidity available in the pool at the time of the event. Numeric string representation of liquidity in smallest denomination.
in_tickINT64Current 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.
addressin_tickremovedin_senderlog_indexin_amount0in_amount1block_numberin_liquidityin_recipientblock_timestampin_sqrtPriceX96transaction_hash
0xc1461365c3fcfebb12247b40ceca5bdb97e87c56-7false0x0000000000035bd5849b8cb31eaa5b39630e6b7211909294-9086191493127051346591054536890x0000000000035bd5849b8cb31eaa5b39630e6b722025-05-27T14:32:46.000Z792027542743204473054367002750xaacd2e60e5b6454d9745724749f7706bea270c13a8339f3e093ea7e812321994
0xc1461365c3fcfebb12247b40ceca5bdb97e87c56-8false0x0000000000035bd5849b8cb31eaa5b39630e6b7215-6157369236153216011492604951346591054536890x0000000000035bd5849b8cb31eaa5b39630e6b722025-05-27T06:24:58.000Z791976585801207584635426921160x69683eab9e05f0792e2199b5299722f09f1ef07b8c0d02441494ebab850f2576
0xe0f20947365d2fcf5fabd14ad4415ab18191bd3a93574false0x0000000000035bd5849b8cb31eaa5b39630e6b72165105234995624537-58942976524505275030149239681139444400151374401556230x0000000000035bd5849b8cb31eaa5b39630e6b722025-05-27T03:03:33.000Z85257312358943768221891096936610x453ad01cea7f41ed1a4fb5ea69566e011a82e5f4bf503f6638017c27d67d6c02
Query with partition filter
SELECT *
FROM `tt-contracts.dragonswap_v3_seievm.Pool_Swap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

PoolFactory_PoolCreated_event

Pool creation events emitted by factory contracts when new liquidity pools are deployed. Records the pool address, token pair or configuration parameters, and fee structure for tracking pool deployments across decentralized exchange protocols.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_token0STRINGContract address of the first token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
in_token1STRINGContract address of the second token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
in_feeSTRINGFee 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_tickSpacingINT64Minimum price movement increment between adjacent ticks in a concentrated liquidity pool.
in_poolSTRINGContract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
in_feeaddressin_poolremovedin_token0in_token1log_indexblock_numberin_tickSpacingblock_timestamptransaction_hash
30000x179d9a5592bc77050796f7be28058c51ca575df40xf7ef9bc39addf3742b25b3b509122b1d0f0a02d2false0x5cf6826140c1c56ff49c808a1a75407cd1df94230xb75d0b03c06a926e488e2659df1a861f860bd3d12127318152602025-01-20T23:51:22.000Z0x2fff8ecf535bca562f271d608a99a96bd4d2f5425b4db24033a023559fb6b0ef
30000x179d9a5592bc77050796f7be28058c51ca575df40x69e2edd60bbcd42fd5ed549599de249a9a34b98bfalse0x160345fc359604fc6e70e3c5facbde5f7a9342d80x3894085ef7ff0f0aedf52e2a2704928d1ec074f10117379496602024-11-27T10:35:02.000Z0x55e69354db73844f2b09449099eee9932cf696ebc30961938a318460bcd3beb6
30000x179d9a5592bc77050796f7be28058c51ca575df40x40aac17a7aa8504fe0d14276e7be46b81f83d386false0xe30fedd158a2e3b13e9badaeabafc5516e95e8c70xfc99af95cd9512b6acb5598d8d4da006759fc9180103448370602024-09-21T02:53:15.000Z0xe37e89bbe69c3f06d20e9a53618e530820dbfa7ae90b11fb2f6c32af11e78545
Query with partition filter
SELECT *
FROM `tt-contracts.dragonswap_v3_seievm.PoolFactory_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100