sunswap_v2_tron

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_anon3`	`STRING`	Sequential counter tracking the total number of pairs created by the factory contract.

Sample Data

address	in_pair	removed	in_anon3	in_token0	in_token1	log_index	block_number	block_timestamp	transaction_hash
TKWJdrQkqHisa1X8HUdHEfREvTzw4pMAaY	TYkCuKKD14hDW94yjcK9LGRVMnRX5qUL3G	false	937	TDcep6TUw5b1CYnccQqadEb7iXf49PqJ49	TXRunbazkVWfwtEyqe6jQkbxTVp4KCERxQ	4	40684232	2022-05-15T09:10:21.000Z	0x7eef88ae159e76e2eb25f12c6bb4bd727ebadaee512fea53069cc831503b849f
TKWJdrQkqHisa1X8HUdHEfREvTzw4pMAaY	TKto9ZzFHkWM8YMVJP9yNKXZkoHETfnKcx	false	938	TJEf9hmq3Nzb4SHzp1hdqyf6umcQHtezYd	TR7NHqjeKQxGTCi8q8ZY4pL8otSzgjLj6t	5	40693006	2022-05-15T16:29:42.000Z	0xb8017dd2b07f38f8220c9089f19733a99abafc81f04569dce37dba833ac47e44
TKWJdrQkqHisa1X8HUdHEfREvTzw4pMAaY	TJE4fBkyn4JMPuFz5DK3UV8Ht3dwXqTwix	false	296	TG2DUXPsSgYDvwhv9ePYqAaJxhrieX2d7W	TGcjhDQ9d5d8DqkHgcdyUF6KsTSikYLUsE	4	37099501	2022-01-10T16:59:09.000Z	0x492419f2d6dee91949b6a498fc33e6f1013da09ed85e337606f564d867024e68

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sunswap_v2_tron.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
TAeTAbt8NrB1zKeAjqWS3m49ABK5fxAP8Q	TBcDQHSyvChBqJNPYXxvxc3t2WPQLX5Nai	false	TKzxdSv2FZKQrEqkKVgp5DcwEXBEKMg2Ax	6	16249267832483661	58475035	38038350	2022-02-12T10:04:54.000Z	0x12dc00f181222eff45450fe17663d2c8faa40c24576333302a77f588bcf02989
TBKR3efrVzMBbmgDmGeU621zqq4AiAXrnX	TXFpue4nqvVptJEv4o8JXko5W6yCWpZZaR	false	TKzxdSv2FZKQrEqkKVgp5DcwEXBEKMg2Ax	59	37837421471360	79382643	38046235	2022-02-12T16:39:15.000Z	0x8ce8dd1ef9d1496f48d9e38adf2e41bae429d072aa33c78f66f211c35c393c38
TBpiQ8ko5FFdCj3qiGTqvZFfxBRXV2RPdq	TC1GhhC5iGFLuuUthriuUu183P8YWPmQsK	false	TKzxdSv2FZKQrEqkKVgp5DcwEXBEKMg2Ax	35	369882952260	119259543	38054759	2022-02-12T23:45:42.000Z	0x0f9ada07f3b61c0292089fa67d0257f7cb7ca4aeece5a2a443789dc48d959f85

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sunswap_v2_tron.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
TC1GhhC5iGFLuuUthriuUu183P8YWPmQsK	false	TKzxdSv2FZKQrEqkKVgp5DcwEXBEKMg2Ax	70	250000000000	17646900	56004090	2023-10-30T05:35:24.000Z	0xf9c22d98fffb3b2cf1f03094712c201f6d27c53dc6fe961307654efd3eeae115
TC1GhhC5iGFLuuUthriuUu183P8YWPmQsK	false	TKzxdSv2FZKQrEqkKVgp5DcwEXBEKMg2Ax	15	1920580580306	136026210	55999064	2023-10-30T01:23:45.000Z	0xc0a004cb211423c50ee2fffce1a1195f230282e4696337029f092301f7477c5b
TFGDbUyP8xez44C76fin3bn3Ss6jugoUwJ	false	TKzxdSv2FZKQrEqkKVgp5DcwEXBEKMg2Ax	30	694790837573	66008551574	55998060	2023-10-30T00:33:33.000Z	0x0e3925d88ecccab85129e15d181cb65a65a770092c877972011b7674114d4b89

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sunswap_v2_tron.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_amount1In	in_amount0Out	block_timestamp	transaction_hash
TSAhTHzE1xKn7DJwQ6eiWYpGkTjcoFftAp	TA2PXALQsnCZ9KGAFaZrbPrWeG54Jp15yw	false	TKzxdSv2FZKQrEqkKVgp5DcwEXBEKMg2Ax	15	38732762	72209581	2000000000000000000	2022-03-08T14:02:39.000Z	0x654714c9109427d71eb8290070c9252f34d3a612a347305db4d656217b391a61
TGgBGgET7KSYqYqmeaVAV4N7xF8Z6UaBWX	TA2PXALQsnCZ9KGAFaZrbPrWeG54Jp15yw	false	TKzxdSv2FZKQrEqkKVgp5DcwEXBEKMg2Ax	37	38727430	52423275	1450000000000000000	2022-03-08T09:35:54.000Z	0x34d7d92acf721440234b63f8011fbf123643397c2a056024b49d0db06c946644
TRPj2QKQM4zqQfUcYyuoW6gvYQ8FvDkLbV	TA2PXALQsnCZ9KGAFaZrbPrWeG54Jp15yw	false	TKzxdSv2FZKQrEqkKVgp5DcwEXBEKMg2Ax	8	38730742	46882516	1300000000000000000	2022-03-08T12:21:36.000Z	0x872bc8e23b0b70141d41a72d679a44c0c084babdb8f9aaf3849892b23a86d662

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sunswap_v2_tron.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
T9zMDQW61oKA8iSBYUbF3EExC5EdhzJnPd	false	10	9996452675742	1451580446591303780757	43308590	2022-08-14T18:59:30.000Z	0x8448b90b50fad79ec289a748a433560a05c7c81618208e03080f1c627d98a103
T9zMDQW61oKA8iSBYUbF3EExC5EdhzJnPd	false	79	9890510594149	1467082386788400015415	43299346	2022-08-14T11:17:00.000Z	0x09a5b05c4c5bd03ee1349dd9c255ba4e80a3f3e4fa9b5724faaddd3bc09486ce
TAQCLN5kbhRUrNDQ3AVmaiXJfchc7cEBVW	false	7	1016717453695	1014843634487	43314004	2022-08-14T23:30:15.000Z	0x1366d2f09d424f6bd968bcb935503de6bbb1f0bb0caedb124fb94708e64d3f6a

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

​Tables

​Factory_PairCreated_event

​Pair_Burn_event

​Pair_Mint_event

​Pair_Swap_event

​Pair_Sync_event

Tables

Factory_PairCreated_event

Pair_Burn_event

Pair_Mint_event

Pair_Swap_event

Pair_Sync_event