quickswap_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
0x5757371414417b8c6caad45baef941abc7d3ab32	0x5e088b7e6e304829b9b0a7cb7ba8297e9de09b25	false	563	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	0x2c8e58aa0a2be89bd022bda28079f3f67121623c	4	12602752	2021-03-29T07:13:48.000Z	0x1e8874d189cd77d7433c1f0e08f7be626b2ab38cc022da4cbb3f69af7bdb5f18
0x5757371414417b8c6caad45baef941abc7d3ab32	0xd80d9b5f4c0ab268da819ca0aa5509c37a984eaf	false	568	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	0x72d6066f486bd0052eefb9114b66ae40e0a6031a	1	12630928	2021-03-29T23:50:43.000Z	0xdc80671e48040e29f789729db219d9dc2f84418639a100a95d510f297b524c27
0x5757371414417b8c6caad45baef941abc7d3ab32	0x5df6b50532ba076151b282c2b344ab2770977268	false	566	0x7c28f627ea3aec8b882b51eb1935f66e5b875714	0x7fbc10850cae055b27039af31bd258430e714c62	0	12623334	2021-03-29T19:18:06.000Z	0x7dabdda035140dbdb44e1c15dac1042bafa6cd073f95655a516b392ea605bb48

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.quickswap_v2_polygon.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
0x0ba8ea826b78de6288d6ffc8cf9f7a3d1931d1a1	0x1c0ccd758c1da634d17ab8c590ebfb9409ce2c56	false	0xa5e0829caced8ffdd4de3c43696c57f7d7a678ff	226	163810701241670961868	1622703952141148929541	37111247	2022-12-21T20:24:17.000Z	0xf790adcfc2cb2b3d37642072f6bdb35f1c5c31905d4482ef5c0e4abe11e59e62
0x0d15764e7f13e780ca0ae83a15a8d819db05ef2b	0xc765eca0ad3fd27779d36d18e32552bd7e26fd7b	false	0xa5e0829caced8ffdd4de3c43696c57f7d7a678ff	125	18397239275148983738	2559325395308053160770	37113199	2022-12-21T21:35:37.000Z	0xb8a9bb776ae6b97e78643f6f8d735f75ed6e5a886d1688be8b7268cf52ae1f72
0x0d15764e7f13e780ca0ae83a15a8d819db05ef2b	0xbfad162775ebfb9988db3f24ef28ca6bc2fb92f0	false	0xa5e0829caced8ffdd4de3c43696c57f7d7a678ff	73	25380270453739165714	1515003831913549371658	37113174	2022-12-21T21:34:47.000Z	0xe1631eee2ba7a3881cbf06a5443eb5566710ab833fc22f471ef302ab6da1f016

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.quickswap_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
0x6e7a5fafcec6bb1e78bae2a1f0b612012bf14827	false	0x5ff960b7e6d6a7c7cb9e47a455f01aface69bf45	219	280591987506577581	170697	64924981	2024-11-30T19:34:45.000Z	0x860e1d750407077009f17fa4af47be23aadeb4f9eb699d535b53778020884e8b
0xf04adbf75cdfc5ed26eea4bbbb991db002036bdd	false	0x5ff960b7e6d6a7c7cb9e47a455f01aface69bf45	1125	419915	417544833090173039	64923850	2024-11-30T18:54:41.000Z	0x3da6686270f185f901313cd604d7e79b9e234f02781673691bb383be11b514a3
0x0513e39ac9eb04a3845b02726162f3877c77d87d	false	0xa5e0829caced8ffdd4de3c43696c57f7d7a678ff	315	77725137224531542865011	31261464308726474416665	64922646	2024-11-30T18:12:00.000Z	0x27d05081f72672729737c477d908806f749536a55db5465b012ef6b1e4db4505

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.quickswap_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_amount1In	in_amount0Out	block_timestamp	transaction_hash
0x00000000009726632680fb29d3f7a9734e3010e2	0x59153f27eefe07e5ece4f9304ebba1da6f53ca88	false	0x111111125421ca6dc452d289314280a0f8842a65	101	56117440	9885	9886917468710262	2024-04-22T08:49:46.000Z	0xbe277407e943ffd68c9d1925c3d313806b13aa3fccb20c6e5bcdd15848c5cd25
0x00000000063e0e1e06a0fe61e16be8bdec1bea31	0x6d9e8dbb2779853db00418d4dcf96f3987cfc9d2	false	0x1111111254eeb25477b68fb85ed929f73a960582	2838	56133882	1241442	1679251060546902111	2024-04-22T18:45:25.000Z	0x6de424adad835e81908faf0ce16fb58eb922404539e5e6bd15655020eab7a869
0x00000000063e0e1e06a0fe61e16be8bdec1bea31	0x604229c960e5cacf2aaeac8be68ac07ba9df81c3	false	0x1111111254eeb25477b68fb85ed929f73a960582	324	56109382	8493086	11599481992818423715	2024-04-22T04:02:04.000Z	0x3b06cf7945b54c5bc21d639adc9a14919b91596a2cff4335b37b6a4eb4c30962

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.quickswap_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
0x4b4c614b9219397c02296f6f4e2351259840b3c7	false	5	5439847595015263999085	7938080211027152334640	6839493	2020-11-10T00:00:57.000Z	0xc848b17a0d5198d976561c0590fd84cdc7b66416b5e3dbfe5fda8848d37eac10
0x1f1e4c845183ef6d50e9609f16f6f9cae43bc9cb	false	4	22278378970	5672618814398683275349	6839973	2020-11-10T00:17:25.000Z	0xf8e3504c272f577217a093936667da4976e4dd27cfba17a49ceb516a1dfcf379
0x1f1e4c845183ef6d50e9609f16f6f9cae43bc9cb	false	5	21841702020	5561430209007217928443	6839998	2020-11-10T00:18:15.000Z	0xd4a248774a5b561897619ca97ccaad0590d58641695c02586553d78f3f30938b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.quickswap_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
0xca1fb28a5e6a3cd987c290cb155653f27ab9b636	0x000767b8aa5b12d239ae1b146a578631b2092e8b	0x0000000000000000000000000000000000000000	false	99999999999999000	696	30856763	2022-07-18T10:07:27.000Z	0x2e8a74a69901a2387778d75902517b1cabf0c52d090380b4a9d18770ce6bda21
0x0000000000000000000000000000000000000000	0x000767b8aa5b12d239ae1b146a578631b2092e8b	0x0000000000000000000000000000000000000000	false	1000	695	30856763	2022-07-18T10:07:27.000Z	0x2e8a74a69901a2387778d75902517b1cabf0c52d090380b4a9d18770ce6bda21
0xca1fb28a5e6a3cd987c290cb155653f27ab9b636	0x000767b8aa5b12d239ae1b146a578631b2092e8b	0x0000000000000000000000000000000000000000	false	100000000000000000	326	30856854	2022-07-18T10:10:53.000Z	0xeca921175acb2e4b946280974100b12dd0947bd4a682c99aa7f6ea1a2e031c8f

Example Query

Query with partition filter

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

Pair_Burn_event

Pair_Mint_event

Pair_Swap_event

Pair_Sync_event

Pair_Transfer_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Factory_PairCreated_event

​Pair_Burn_event

​Pair_Mint_event

​Pair_Swap_event

​Pair_Sync_event

​Pair_Transfer_event

Tables

Factory_PairCreated_event

Pair_Burn_event

Pair_Mint_event

Pair_Swap_event

Pair_Sync_event

Pair_Transfer_event