sunswap_v3_tron

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.
`in_poolLength`	`STRING`	Current total count of liquidity pools created by the Sunswap V3 factory contract at the time of this pool’s creation. Increments sequentially with each new pool deployment.

Sample Data

in_fee	address	in_pool	removed	in_token0	in_token1	log_index	block_number	in_poolLength	in_tickSpacing	block_timestamp	transaction_hash
10000	TThJt8zaJzJMhCEScH7zWKnp5buVZqys9x	THcVBYFgBcV7kqXzYzUknAX4PA88Kzr9PN	false	TNUC9Qb1rRpS5CbWLmNMxXBjyFoydXjWFR	TNi4M1p9Q5VP6VkWveswLhuKFLSaMzhytK	16	58668254	50	200	2024-01-30T18:29:42.000Z	0x7cc9f03a7c95bd344e5d85966014efc8ded6d9f757eafb2855ebd7f3852556e0
3000	TThJt8zaJzJMhCEScH7zWKnp5buVZqys9x	TSkAX8y4NrmBaHgfT568b6dZAWiMWomnib	false	TR7NHqjeKQxGTCi8q8ZY4pL8otSzgjLj6t	TSdJ6yX5h9giKGFPH2d8pF7rSjiqTj9WxQ	1	53640213	15	60	2023-08-09T01:05:30.000Z	0xd05a7a04dae6dbaa68cc8ce44d8f28cfa0cce78db6dbb04a588b29532c06d36b
100	TThJt8zaJzJMhCEScH7zWKnp5buVZqys9x	TRZV1dh9mcwMZu5aksq2NSQwZyoLoNLAcg	false	TR7NHqjeKQxGTCi8q8ZY4pL8otSzgjLj6t	TUF3a6J5UXFcnqTK8eEk4wViM7Gn5MQRWp	24	55904877	33	1	2023-10-26T18:52:27.000Z	0x49aac50c77bd91b653b6acc157e8c33c70040ec1487acbd372306942c02af39b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sunswap_v3_tron.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
TPTQhJMAe9hZoeMkhdeQ8CSQKzVqp7oiQH	false	TLSWrv7eC1AZCXkRjpqMZUmvgd99cj7pPF	2220200627334401	11	22733647	22163421065138140503930	57674811	317200	337800	2023-12-27T06:18:42.000Z	0xf1434f59d2a6cf9be9413d98ca9f2ca98341ff53e860e4be39341e61da1b6d4e
TPTQhJMAe9hZoeMkhdeQ8CSQKzVqp7oiQH	false	TLSWrv7eC1AZCXkRjpqMZUmvgd99cj7pPF	2338841099437593770	13	18294213453	12819892012407554991374952	57683916	327400	337600	2023-12-27T13:54:21.000Z	0xa9dfdfcbf0c63af8138d4be68983201e1349c37c4e89e9ab90015767d0e58503
TPTQhJMAe9hZoeMkhdeQ8CSQKzVqp7oiQH	false	TLSWrv7eC1AZCXkRjpqMZUmvgd99cj7pPF	88065735144501680	68	146995345	9822825370117024899	57674804	333800	334400	2023-12-27T06:18:21.000Z	0x2cdff8b251c3973271ca31d7840dd3580206c7a367040922f7de41398ea4cdea

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sunswap_v3_tron.Pool_Burn_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
TY9SHr1oMRqxQDmPkCyHGKuvU5wuHmCUWL	false	TLSWrv7eC1AZCXkRjpqMZUmvgd99cj7pPF	2812666008603728097	TLSWrv7eC1AZCXkRjpqMZUmvgd99cj7pPF	8	299999999999745038565117	675956408046	52591371	-269460	-262440	2023-07-03T14:46:03.000Z	0x4ced3457f0a35cb963308bed8c93bacfa911f35953393302ee9d0cd218e4ec89
TLVDozYEBgeaJXH7oKBsougzEJKNrogFun	false	TLSWrv7eC1AZCXkRjpqMZUmvgd99cj7pPF	92896890343	TLSWrv7eC1AZCXkRjpqMZUmvgd99cj7pPF	92	150506856340	5000000000	52592022	-41000	-27000	2023-07-03T15:18:36.000Z	0x49d4ff6e3d103a5812614ab0c1dd791d14860438a84fb35ec5923082c4078ff7
TC9QmgR8MUwRCYe3kCLwH8MW2WtxiLd6AV	false	TLSWrv7eC1AZCXkRjpqMZUmvgd99cj7pPF	955485084	TLSWrv7eC1AZCXkRjpqMZUmvgd99cj7pPF	22	869999996	89982121	56828495	-29640	-15780	2023-11-27T20:49:27.000Z	0x6ac068280206342356a67f36a877d4a67b582009b43b41b68658bc95549f52ae

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sunswap_v3_tron.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
TTFc7puyspGNvKNxcdeRi1QmYgZEcia4VM	23843	false	TGKLeTRMJyzpHq9ypyukxc3ee4DAyyfbqB	104	24855469	-281306910	55028232	1850955538	TGKLeTRMJyzpHq9ypyukxc3ee4DAyyfbqB	2023-09-26T08:06:30.000Z	260985872852388525542837516214	0x1b3bafb3efafd8533cbf61474b1b215a686d7805adb9651f41374485343c6f81
TTFc7puyspGNvKNxcdeRi1QmYgZEcia4VM	24873	false	TQAvWQpT9H916GckwWDJNhYZvQMkuRL7PN	9	-8420067	100000000	55042520	1850955538	TY6ySgXFr98FGeS9NCCML7rMuhvMt6EE6F	2023-09-26T20:01:09.000Z	274769441981843508275158018687	0x4a9911b7c19e09a05a7322f47128a66e1e7f57c747aee8dc9e756f463d30b941
TTFc7puyspGNvKNxcdeRi1QmYgZEcia4VM	24560	false	TGKLeTRMJyzpHq9ypyukxc3ee4DAyyfbqB	113	-19767125	222985432	55028233	1850955538	TS1TcGJJxLcvhMk73L3vsnUpVzMQceMPkm	2023-09-26T08:06:33.000Z	270501890633091362042850016134	0xc338b5269c660f4d4396b067e2d7ac5371642b956c488fcf026079909b25ba84

Example Query

Query with partition filter

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

Pool_Swap_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Factory_PoolCreated_event

​Pool_Burn_event

​Pool_Mint_event

​Pool_Swap_event

Tables

Factory_PoolCreated_event

Pool_Burn_event

Pool_Mint_event

Pool_Swap_event