dragonswap_v2_seievm

Tables

Factory_PairCreated_event

Decentralized exchange (DEX) liquidity pool creation events emitted by Automated Market Maker (AMM) factory contracts. Records new trading pair deployments with token addresses, deployed pair contract address, and creation sequence number for tracking pool instantiation across DEX protocols.

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_pair`	`STRING`	Contract address of the liquidity pool pair created for trading between two tokens. Hex-encoded, 0x-prefixed, 42-character string.
`in_length`	`STRING`	Sequential identifier representing the total number of pairs created by the factory at the time of this event. Stored as a string representation of an integer, incrementing with each new pair deployment.

Sample Data

address	in_pair	removed	in_length	in_token0	in_token1	log_index	block_number	block_timestamp	transaction_hash
0x71f6b49ae1558357bbb5a6074f1143c46cbca03d	0x142a77e74a813368bdca05fa2673c5edc8927f4d	false	2448	0x4f3b091e6e70c7df380eaeb05c5878d3dcf02b65	0xe30fedd158a2e3b13e9badaeabafc5516e95e8c7	3	120000803	2024-12-11T14:33:52.000Z	0x585728968d6ed4dbb9ed5b55fa8f63819c197e75b5bf20ca3e9e7c1213916e2f
0x71f6b49ae1558357bbb5a6074f1143c46cbca03d	0x1cd9112962e4a197e492b3370a2d1b888e1b7731	false	2447	0x78815782208907e556c1d9ae63141549fdc5d00d	0xe30fedd158a2e3b13e9badaeabafc5516e95e8c7	4	119957792	2024-12-11T09:12:32.000Z	0xcc2e19674d61aaff479003042a0f88ef97cde98493be7bf8531aea179e73eb24
0x71f6b49ae1558357bbb5a6074f1143c46cbca03d	0x07ee060063b3b8cebaec169875c08a2188d48eb4	false	2446	0x452b5d14497482a3083de9f395f55bd5c4ae2141	0xe30fedd158a2e3b13e9badaeabafc5516e95e8c7	16	119883422	2024-12-11T00:08:37.000Z	0xd8f61e0038387cf08b342d3f625a1dfb33114f4a535cef8cf414e7fc86ed8742

Example Query

Query with partition filter

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

Pair_Burn_event

Liquidity removal events from DEX (Decentralized Exchange) trading pairs recording amounts of both tokens withdrawn when liquidity providers burn LP tokens. Used for tracking liquidity provision activity and calculating total value locked (TVL) changes in automated market maker (AMM) pools.

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_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_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	removed	in_sender	log_index	in_amount0	in_amount1	block_number	block_timestamp	transaction_hash
0x0b9bc785fd2bea7bf9cb81065cfaba2fc5d0286b	0x1164cb64477dc06d533c4d8905d76adeb5adbb94	false	0xa4cf2f53d1195addde9e4d3aca54f556895712f2	5	14039131345	772853093274	97696490	2024-08-24T15:06:35.000Z	0x90a948a8bbb10f7b1a24772f7f41561d6e08bc0c552f54c78c24f662a2b95aae
0xf001749a67728fd0acababa1cf1d4e3ce40f4736	0x1164cb64477dc06d533c4d8905d76adeb5adbb94	false	0xa4cf2f53d1195addde9e4d3aca54f556895712f2	5	305215146	16802070170	97691935	2024-08-24T14:34:55.000Z	0xe05789b419af5dc80353fdf818cba34b28fb730a0b8ccfdcca2e99d8a43649f3
0xe42acd5b87172c5aae877d1e0aee7712e1292529	0x1164cb64477dc06d533c4d8905d76adeb5adbb94	false	0xa4cf2f53d1195addde9e4d3aca54f556895712f2	5	225437586	12648246337	97711504	2024-08-24T16:51:08.000Z	0x98e3539473b348fc081c72db935ca238daa23bd124d0c2818ec93ded851b0067

Example Query

Query with partition filter

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

Pair_Mint_event

Liquidity provision events emitted when users add tokens to a DEX pair contract. Records sender address and token amounts deposited for liquidity pool operations.

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_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_sender	log_index	in_amount0	in_amount1	block_number	block_timestamp	transaction_hash
0xc75c669a62a7ece0c8d37904b747970467432ad3	false	0xa4cf2f53d1195addde9e4d3aca54f556895712f2	7	10000000	18500000000000000000	79364615	2024-05-28T17:46:54.000Z	0x5629e229980093b29632651b6922639ea4307d09d87e78ab5fcaf06c14b3eaa6
0x8d5261cff8d63e71c772574eba63e64e6726ee06	false	0xa4cf2f53d1195addde9e4d3aca54f556895712f2	7	10000000	18500000000000000000	79364597	2024-05-28T17:46:46.000Z	0x4f95f2f10535a75fab6e9d6a28cb702c17fd0245f6aa1512b333544b1e0d8501
0x8d5261cff8d63e71c772574eba63e64e6726ee06	false	0xa4cf2f53d1195addde9e4d3aca54f556895712f2	6	743143	1374962837300646774	79416622	2024-05-28T23:52:41.000Z	0xc6eeb379fe8454c7947df653882dbbded240e598be22ef091a6bb41dc1b29546

Example Query

Query with partition filter

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

Pair_Swap_event

Token swap events from decentralized exchange (DEX) liquidity pairs recording input and output amounts for both tokens. Primary source for tracking DEX trading activity and price discovery.

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_amount0In`	`STRING`	Amount of token0 transferred into the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_amount1In`	`STRING`	Amount of token1 transferred into the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_amount0Out`	`STRING`	Amount of token0 transferred out of the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_amount1Out`	`STRING`	Amount of token1 transferred out of the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	removed	in_sender	log_index	block_number	in_amount0In	in_amount1Out	block_timestamp	transaction_hash
0x0000000000035bd5849b8cb31eaa5b39630e6b72	0xbe3b8eb9ae801395040b013b73aa539f46a9c6a8	false	0x0000000000035bd5849b8cb31eaa5b39630e6b72	6	104733529	83488626180970957133521	28804205917449575627	2024-09-27T02:14:07.000Z	0xcb4918e505d8f4097dafae40dc4a27c0c5fc8fa13d60f688c891f900eefa2698
0x0000000000035bd5849b8cb31eaa5b39630e6b72	0x8ba502d9243fa5e44678044098be9782cebafda5	false	0x0000000000035bd5849b8cb31eaa5b39630e6b72	8	104853564	10391699063	256965216502073359448	2024-09-27T15:40:42.000Z	0xf2fddd4e7e6586b350e32ad493f7683548857352eb8510e6a53b60c62cec67a8
0x0000000000035bd5849b8cb31eaa5b39630e6b72	0xc0112967d4b3940e20508404040bbce8f7adf22b	false	0x0000000000035bd5849b8cb31eaa5b39630e6b72	9	104863936	3631211819542	122707738495335469178	2024-09-27T16:50:19.000Z	0xfdba8c239b0ff89b70a5c5fed87875616b0fbfcadd2f8fcbdda0f0abe25814de

Example Query

Query with partition filter

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

Pair_Sync_event

Liquidity pair reserve synchronization events emitted after each swap, mint, or burn operation. Contains updated reserve balances for both tokens in AMM (Automated Market Maker) pools, enabling real-time price calculation and liquidity tracking.

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_reserve0`	`STRING`	Reserve amount of the first token in a liquidity pool after a state-changing operation. Stored as decimal string representing the smallest unit of the token.
`in_reserve1`	`STRING`	Reserve amount of the second token in a liquidity pool after a state-changing operation. Stored as decimal string representing the smallest unit of the token.

Sample Data

address	removed	log_index	in_reserve0	in_reserve1	block_number	block_timestamp	transaction_hash
0x0077ab73fb572a7fdad5cb716c31b9117ba15f45	false	3	1717839207401141762	25136788247650509874514724	121387476	2024-12-18T23:55:26.000Z	0x8c994ed02eda9a52ac167f137c11884649a3f03194e51131cb5acbfa1c452a08
0x0077ab73fb572a7fdad5cb716c31b9117ba15f45	false	3	1714722502876915426	25182340064212795211547241	121385687	2024-12-18T23:41:13.000Z	0xc8ab870b1bdb5d8a9315c0fdee2851fc05d7bcc7141a931c2952ff49fd3f6fd4
0x0077ab73fb572a7fdad5cb716c31b9117ba15f45	false	3	1714928082203019405	25179330352316191997664718	121385857	2024-12-18T23:42:31.000Z	0xcef5f8576ae417f6ea31f3dc3ebebd41cc5e0e389bc775019e1eccfbdb3b5a31

Example Query

Query with partition filter

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

Pair_Transfer_event

ERC20 Transfer events emitted by liquidity pair contracts in automated market maker (AMM) decentralized exchanges (DEXs). Records minting, burning, and transfer of LP (liquidity provider) tokens representing ownership shares in trading pairs.

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_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.

Sample Data

in_to	address	in_from	removed	in_value	log_index	block_number	block_timestamp	transaction_hash
0xc75c669a62a7ece0c8d37904b747970467432ad3	0xc75c669a62a7ece0c8d37904b747970467432ad3	0x31fb849032d5091f5b1d4c22d8a94564ad92f302	false	24109844236271	1	82583430	2024-06-13T00:00:14.000Z	0x52970f6ae9c4ec2b6b90d63ca900e75049c6ee9571a300b42c5cc960e33cafe5
0x8d5261cff8d63e71c772574eba63e64e6726ee06	0x8d5261cff8d63e71c772574eba63e64e6726ee06	0x7ec11290633c56e80e09f67ae8c7dddb2b4832aa	false	20689220993027	73	82583822	2024-06-13T00:02:54.000Z	0x5ee5a605de8ab15bf8edeaa9a62156b37a0bb05f9181e9c0e0237e56622d9a9d
0x8d5261cff8d63e71c772574eba63e64e6726ee06	0x8d5261cff8d63e71c772574eba63e64e6726ee06	0xd1d95aacbe050e301d824e677d327160e35d6091	false	20688606048030	46	82583822	2024-06-13T00:02:54.000Z	0x303761648d46401c35db6a0ccd4735f60498fe47b3220ec1beedd1f515d54a5b

Example Query

Query with partition filter

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

PairFactory_PairCreated_event

Event logs emitted when a new liquidity pool pair is created by a DEX (Decentralized Exchange) factory contract. Records the deployed pair contract address, constituent token addresses, and creation metadata for tracking protocol liquidity expansion.

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_pair`	`STRING`	Contract address of the liquidity pool pair created for trading between two tokens. Hex-encoded, 0x-prefixed, 42-character string.
`in_length`	`STRING`	Total number of trading pairs created in the DragonSwap V2 factory at the time of this pair creation event. Increments sequentially with each new pair deployment.

Sample Data

address	in_pair	removed	in_length	in_token0	in_token1	log_index	block_number	block_timestamp	transaction_hash
0x71f6b49ae1558357bbb5a6074f1143c46cbca03d	0x7192a1087be927e8f1c41ea4d112fb606c388245	false	2615	0xd184ed9df3fe41cbeb62dba50f8b1277c80c548f	0xe30fedd158a2e3b13e9badaeabafc5516e95e8c7	8	170366973	2025-09-27T16:49:25.000Z	0xb57db785d475eed9d0232900c29456390e0a3227bfad668e0c421caf7397ffa6
0x71f6b49ae1558357bbb5a6074f1143c46cbca03d	0x01432b294a2d105d85867d25b8f712b995a8cab0	false	2501	0x7a6e53ea8a9b81ecdb623cdc546026fac5de0133	0x86b1b88b2bbfe49999fa9a415270997ed1bfd803	0	133935089	2025-02-27T06:02:52.000Z	0xfcfdae41256b623df6845bd0980919202c251db1cfbd2af383040e2f816e9c49
0x71f6b49ae1558357bbb5a6074f1143c46cbca03d	0xa37b0ae33dbbd5f5c434da2857869cc55ed8f504	false	2502	0x0555e30da8f98308edb960aa94c0db47230d2b9c	0x541fd749419ca806a8bc7da8ac23d346f2df8b77	3	134003791	2025-02-27T15:19:35.000Z	0x6e8fcd92c637389698ab688f777680d1e2dc571a812ec5ef52d886796fda8946

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Factory_PairCreated_event

Pair_Burn_event

Pair_Mint_event

Pair_Swap_event

Pair_Sync_event

Pair_Transfer_event

PairFactory_PairCreated_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Factory_PairCreated_event

​Pair_Burn_event

​Pair_Mint_event

​Pair_Swap_event

​Pair_Sync_event

​Pair_Transfer_event

​PairFactory_PairCreated_event

Tables

Factory_PairCreated_event

Pair_Burn_event

Pair_Mint_event

Pair_Swap_event

Pair_Sync_event

Pair_Transfer_event

PairFactory_PairCreated_event