sushiswap_v2_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	0xc0ae17ac218aca26f5dd92633eb070530b10dadd	false	4892	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	0xec927beb49baa12a45bbebd600a13eeb43fe6c5b	208	24107383	2022-01-24T13:50:56.000Z	0x890bfd127884d011854dc1308c73dba0519041cc40792937aae06277a786f0bf
0xc35dadb65012ec5796536bd9864ed8773abc74c4	0xdfe9fa84330de7bbd239da9af6eba24a69d2c833	false	4891	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	0x8a311c8cd682e42755f46ab37bf807966d0c3007	188	24086471	2022-01-24T01:21:49.000Z	0x404ceaf1c64ecd74fc92efc7c00c8935690b6e34f7d25ac004c97878550e5e23
0xc35dadb65012ec5796536bd9864ed8773abc74c4	0x866e77160c760faa285c8830a1f7b58bdcbe5829	false	4893	0x03943c3ef00d92e130185cebc0bcc435def2cc94	0xc3cffdaf8f3fdf07da6d5e3a89b8723d5e385ff8	165	24119952	2022-01-24T21:14:12.000Z	0x287980ca2ad8aa5cdb392534604abf9171e862673466dc153031d49d0929c28d

Example Query

Query with partition filter

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

MiniChef_Harvest_event

Reward claims from MiniChef staking contracts emitted when users harvest accumulated incentive tokens. Contains pool identifier, user address, and harvested token amount for tracking yield farming rewards across liquidity mining programs.

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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_pid`	`STRING`	Pool identifier referencing a specific staking or liquidity pool within the protocol. Numeric string representation of the pool ID.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	in_user	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash
0x0769fd68dfb93167989c6f7254cd0d766fb2841f	0x030fc939527e9fa8a9483e9468e4040cdbd405e2	false	7966114960919713922	287	23573090	2022-01-10T23:13:50.000Z	0xda575da79443b8895b46f3e42fb8134e7a020ac47988dda1f69b77adb559dc39
0x0769fd68dfb93167989c6f7254cd0d766fb2841f	0x07b6ed45da7631fc923b337a417098121ad11f75	false	1630549298057637770	152	23554167	2022-01-10T10:50:59.000Z	0xdd86bc64b56eaaf58bb7990bc88039b9bef96b9d3051cfb8a0ac9f7089ccea5e
0x0769fd68dfb93167989c6f7254cd0d766fb2841f	0x082a5a5d287ed0063100c186f0f09cae7baa677c	false	62432038354129829143	280	23547772	2022-01-10T06:49:28.000Z	0x8a0512e6f92d6749c39f4b293654a10c5031a623927580b3c691d4a0a968f400

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v2_polygon.MiniChef_Harvest_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
0xe90053b8136f18206fcf4f48e0c3b6aed9b1ad71	0x2813d43463c374a680f235c428fb1d7f08de0b69	false	0x1b02da8cb0d097eb8d57a175b88c7d8b47997506	175	15313368833513137	258643315283356881	61989146	2024-09-18T20:48:36.000Z	0x9db97f713fef7c2a9397fc3a6dd44c99b619bf3dc6fc6a5779a6743e5e587005
0xf9b463c92e4fc9255980d629c1e681426fb8d7dd	0xb556fed3b348634a9a010374c406824ae93f0cf8	false	0x1b02da8cb0d097eb8d57a175b88c7d8b47997506	230	266215625498613240	203347976395437888262568	61967417	2024-09-18T07:55:46.000Z	0x5852af9dbbab297a05ffee363c12eaad18d339a5551b9d61de63ba42d6ff9dd4
0x1b02da8cb0d097eb8d57a175b88c7d8b47997506	0xc4e595acdd7d12fec385e5da5d43160e8a0bac0e	false	0x1b02da8cb0d097eb8d57a175b88c7d8b47997506	632	4887865326509679401	800100143631955	61976718	2024-09-18T13:25:37.000Z	0x4f0656b11b345f3c0e0a8bd388e88bdeca18a97307b23eb6d7fdb793e3a7193a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v2_polygon.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
0x0102b6ebea22fa1725a8c0678414c279621cff46	false	0x1b02da8cb0d097eb8d57a175b88c7d8b47997506	1683	38564869003144	135758654485009	49268896	2023-10-28T21:14:49.000Z	0xfcc9a0a34af149e4adbc607d3937c2a2b22ca52631b620423e10992477c33328
0x177e42f6b3da3ffdda3dcbb6010f00a380c3cb05	false	0x1b02da8cb0d097eb8d57a175b88c7d8b47997506	869	1644966989931939258	1000000000000000000	49249065	2023-10-28T09:20:39.000Z	0x4ae927d75e55a281faf362edc9216924e534062973be7984b1564ad98ae12a6b
0x1fc05157e66300377b637e93262b355d405f71c6	false	0x1b02da8cb0d097eb8d57a175b88c7d8b47997506	1246	5277235510868515	10000000000000000	49249857	2023-10-28T09:48:43.000Z	0x843febe617afec9102619bc13a95053113bd9216067fc6334f37610cc3a52446

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v2_polygon.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
0x000000000000000000000000000000000000dead	0xc43eff51abcfc42587f8347e94d476a921495328	false	0x1b02da8cb0d097eb8d57a175b88c7d8b47997506	228	33179594	37421812875522	224757284733601	2022-09-16T13:25:49.000Z	0x5f902f9db0471b14a9ddea8f1c20f100023eef65c16665ab3d4e26286d22f0e5
0x000000000000000000000000000000000000dead	0xc43eff51abcfc42587f8347e94d476a921495328	false	0x1b02da8cb0d097eb8d57a175b88c7d8b47997506	42	33169259	36708910752870	216308179611275	2022-09-16T07:25:49.000Z	0x20ea5a87e9f46693889b7aad15aaee8ceaf416d8af7101820fed8464ef7ef808
0x000000000000000000000000000000000000dead	0xcbf6f78981e63ef813cb71852d72a060b583eecf	false	0x1b02da8cb0d097eb8d57a175b88c7d8b47997506	400	33186526	3239188601602	12683088747424	2022-09-16T17:25:11.000Z	0x1ef89e23b1827c06f6530b1676e6189a7b86518c40e437f8c67d371bbebd4fab

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v2_polygon.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
0x00ca0dd51dcd486cde843c7b2b734fec203dd289	false	8	78448040	291391299	59451492	2024-07-17T01:46:38.000Z	0x8abeade9a949794c07978a262c118e0b664c4f9b81b3acb940c3898ed805aa41
0x00ca0dd51dcd486cde843c7b2b734fec203dd289	false	19	75720396	302015889	59463372	2024-07-17T08:50:40.000Z	0x834ece47a07124a7cdddc9de507cbbf5c24194a49a97a171dc51ae53c4eccbb9
0x00ca0dd51dcd486cde843c7b2b734fec203dd289	false	86	76639557	298404503	59486942	2024-07-17T22:49:20.000Z	0x6a39ad7f400d27fa92fac04b68b51e831834dadadd9d8700aafec7d5a82a80fa

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v2_polygon.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
0x21f0ecf98c6dda7351a25030c187784033a7a6f1	0x01daeb567884f4d7b113207918a939623d83e61a	0x0000000000000000000000000000000000000000	false	96366939880006112939	436	22437353	2021-12-12T13:16:37.000Z	0x0b9546f77ed306d81877892fac784482b58a7784611906425950cccfdd3b5a76
0x0000000000000000000000000000000000000000	0x01daeb567884f4d7b113207918a939623d83e61a	0x0000000000000000000000000000000000000000	false	1000	435	22437353	2021-12-12T13:16:37.000Z	0x0b9546f77ed306d81877892fac784482b58a7784611906425950cccfdd3b5a76
0x0000000000000000000000000000000000000000	0x034fadc7701628227701b52473d43565c7a6cdbb	0x0000000000000000000000000000000000000000	false	1000	428	22439399	2021-12-12T14:29:05.000Z	0xb1b2bb2bbd559a5ce556bf2da51bf2f7388dfdbe5ec77c34708f820bc590c7d9

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Factory_PairCreated_event

MiniChef_Harvest_event

Pair_Burn_event

Pair_Mint_event

Pair_Swap_event

Pair_Sync_event

Pair_Transfer_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Factory_PairCreated_event

​MiniChef_Harvest_event

​Pair_Burn_event

​Pair_Mint_event

​Pair_Swap_event

​Pair_Sync_event

​Pair_Transfer_event

Tables

Factory_PairCreated_event

MiniChef_Harvest_event

Pair_Burn_event

Pair_Mint_event

Pair_Swap_event

Pair_Sync_event

Pair_Transfer_event