sushiswap_v1_polygon

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
0xc35dadb65012ec5796536bd9864ed8773abc74c4	0x5ccc5461b772f580a8e1bc949bb39ce562b53a26	false	794	0x0074b9a846b5a3a2767afe7e4d9a4e56191a5393	0x3ad3daddcaf1fd8e59250d1e98f6adb01bed2a09	409	15693854	2021-06-14T05:29:13.000Z	0x44bb8ca17d4cbabbf83ca91fad0782c6308100830643460f3344b7c77c852036
0xc35dadb65012ec5796536bd9864ed8773abc74c4	0x68f6186bca1715525ec942a44ec1ab28e126f3fc	false	803	0x075dfb346a51e73615fbfd8dd2f7949bee5dd872	0xec9fc958e2995bbfcd72abb00fbc8e08f96e657f	253	15696438	2021-06-14T07:06:33.000Z	0x949d5a13b33cd965136c2739d31a69cf07a95cc0e40dab2aa37eb91c9b94d6c6
0xc35dadb65012ec5796536bd9864ed8773abc74c4	0x26aa9d0464cb2a02efafbfa99b788ac7ceb7966c	false	801	0x075dfb346a51e73615fbfd8dd2f7949bee5dd872	0x97b14a709d1a1a455df2041b97040cba11a99914	392	15695301	2021-06-14T06:25:23.000Z	0x09e7dc7f4fbb94f1498d5d59b94e4718f8870bedc3c591825c96c7c3d29d25ac

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v1_polygon.Factory_PairCreated_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
0x0102b6ebea22fa1725a8c0678414c279621cff46	false	208	2692599466510236968	10241277608135620855	48111880	2023-09-29T05:48:04.000Z	0x60a557cdc77cde95b2f3990a5fe60447671079f92235576608d57349f83e14e8
0x0102b6ebea22fa1725a8c0678414c279621cff46	false	252	2692773876831853468	10240616272874911594	48112342	2023-09-29T06:06:03.000Z	0xf1cd7f05c7797f828ff9c708d9582a87a589b61a75ac784b21b705de8fea35eb
0x0102b6ebea22fa1725a8c0678414c279621cff46	false	305	2697993370754085750	10220864263193515010	48114285	2023-09-29T07:21:29.000Z	0xdf78204e61f6770dff257a604574c51bdb0dafef10bd741748d89eb404d669c3

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Factory_PairCreated_event

Pair_Sync_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Factory_PairCreated_event

​Pair_Sync_event

Tables

Factory_PairCreated_event

Pair_Sync_event