quickswap_v3_polygon

Tables

AlgebraFactory_Pool_event

Pool creation events emitted by Algebra DEX (Decentralized Exchange) factory contracts, recording the deployment of new liquidity pools with their token pair addresses. Used for tracking pool deployments and identifying tradable pairs across Algebra-based DEX implementations.

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_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_pool	removed	in_token0	in_token1	log_index	block_number	block_timestamp	transaction_hash
0x411b0facc3489691f28ad58c47006af5e3ab3a28	0xf25f1109096f5da72334f1e08be125e6c5cf07da	false	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	0x9b945fa7a18c90f00c9c647df11af71b33179e6a	254	69907029	2025-04-05T00:51:05.000Z	0x50e640fd31cae1f26f876e6a5dc76d7ece60f7675a40debd58ac9b2c5ac4bb58
0x411b0facc3489691f28ad58c47006af5e3ab3a28	0x359af1dc77e2b4aaf8ed48657689aa5f4b16ed4c	false	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	0xaa93c8282927c384e5c40c8c0fe11a4b860b6074	88	69940558	2025-04-05T20:47:30.000Z	0xaecf0c285852b489115f2ba876677c49bcc689d462c567fc1ea8a0852eb1f920
0x411b0facc3489691f28ad58c47006af5e3ab3a28	0xe0ba5663d72c91dda29743c4a119816a67283da9	false	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	0x1e8463f6ad0aceaa3e6af3956343cd69b4838b46	320	36706523	2022-12-11T16:40:22.000Z	0x0928d541a5a53a6640abd1b397e8a73593844bc9012ae05b3001786623640383

Example Query

Query with partition filter

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

AlgebraFactory_VaultAddress_event

VaultAddress configuration change events from QuickSwap V3’s AlgebraFactory contract on Polygon, recording when new vault addresses are set in the protocol. Used for tracking vault address updates and protocol governance 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_newVaultAddress`	`STRING`	Hex-encoded contract address of the newly configured vault for the QuickSwap V3 Algebra factory on Polygon. This address receives protocol fees and is updated through factory governance events.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_newVaultAddress
0x411b0facc3489691f28ad58c47006af5e3ab3a28	false	1	34300909	2022-10-13T17:25:19.000Z	0xf1a4671e28edc45572f5b7c2d9b1c1df1cd36a8811137afacf1af1f53a5f9459	0xb771380f912e4b5f6beddf81314c383c13f16ab5
0x411b0facc3489691f28ad58c47006af5e3ab3a28	false	199	34611573	2022-10-21T08:44:14.000Z	0x3966054e0f7b899859dac5c601c28da2838d317cc9c20814b6af26b7e4a275dd	0x36e6fb1846c66898d28800497a2620d374ba5c80

Example Query

Query with partition filter

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

EternalFarming_FarmEnded_event

Liquidity farming incentive completion events from QuickSwap V3 on Polygon, recording reward distributions when NFT positions exit eternal (ongoing) farming programs. Tracks earned rewards, bonus rewards, and incentive identifiers for analyzing liquidity mining participation and yield farming outcomes.

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_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`in_incentiveId`	`STRING`	Unique identifier (hash) for the specific QuickSwap V3 farming incentive program. Each incentive represents a distinct reward campaign with its own parameters and eligible liquidity positions.
`in_rewardAddress`	`STRING`	Contract address of the primary reward token distributed for this farming position on Polygon. Hex-encoded, 0x-prefixed 40-character string representing the ERC-20 token paid to liquidity providers.
`in_bonusRewardToken`	`STRING`	Contract address of the bonus reward token distributed to the liquidity provider upon farming completion. Hex-encoded Polygon address, often zero-valued when no bonus rewards apply.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_reward`	`STRING`	Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.
`in_bonusReward`	`STRING`	Bonus reward amount earned from the liquidity farming program, denominated in the smallest unit of the bonus reward token. Typically zero when no additional bonus rewards are active beyond the primary reward.

Sample Data

address	removed	in_owner	in_reward	log_index	in_tokenId	block_number	in_incentiveId	block_timestamp	in_rewardAddress	transaction_hash	in_bonusRewardToken
0x8a26436e41d0b5fc4c6ed36c1976fafbe173444e	false	0x5dec906daa498cd33adb872a95d5d409cf4805d6	15913822331706556453	303	45	33122945	0xc59b30d07caa15e38d9ad9b1b01435f210f872330a91b86b155d7518747a5c4c	2022-09-15T04:44:02.000Z	0x958d208cdf087843e9ad98d23823d32e17d723a1	0xeb6cd4a2eac26cd2da01ab54771a57b25cd2dafefa87d4d38f87b2037d34855f	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270
0x8a26436e41d0b5fc4c6ed36c1976fafbe173444e	false	0x74b7e6d4336df8038a44393cac5b7ac53fd75c7a	381023972367936627371	93	111	33145223	0xc59b30d07caa15e38d9ad9b1b01435f210f872330a91b86b155d7518747a5c4c	2022-09-15T17:34:37.000Z	0x958d208cdf087843e9ad98d23823d32e17d723a1	0x7f35b907529e2e87dfd4e22db4d37bc128e413f4b42753daea72c4e80bfed308	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270
0x8a26436e41d0b5fc4c6ed36c1976fafbe173444e	false	0x74b7e6d4336df8038a44393cac5b7ac53fd75c7a	28259353482378876720	136	110	33126619	0xc59b30d07caa15e38d9ad9b1b01435f210f872330a91b86b155d7518747a5c4c	2022-09-15T06:50:18.000Z	0x958d208cdf087843e9ad98d23823d32e17d723a1	0xba8f24602783bcbb6bda72573fc1bfa0084c96e2c7b594a031f3260701e39d4b	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270

Example Query

Query with partition filter

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

EternalFarming_RewardClaimed_event

Reward claim events from QuickSwap V3 eternal farming incentive programs on Polygon, recording when liquidity providers collect farming rewards. Useful for analyzing yield farming participation, reward token distributions, and LP earning patterns across different reward token 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_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_reward`	`STRING`	Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.
`in_rewardAddress`	`STRING`	Contract address of the reward token being claimed from the QuickSwap V3 eternal farming incentive program. Hex-encoded, 0x-prefixed 40-character string on Polygon chain.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	removed	in_owner	in_reward	log_index	block_number	block_timestamp	in_rewardAddress	transaction_hash
0x000001ade50442cb1b4f0178027e77143aa1973f	0x8a26436e41d0b5fc4c6ed36c1976fafbe173444e	false	0x000001ade50442cb1b4f0178027e77143aa1973f	8301126325518848	165	38125758	2023-01-15T21:58:33.000Z	0x958d208cdf087843e9ad98d23823d32e17d723a1	0xb5940b9305020615bb19884cc678fe2a7a1e216d1b29dbf7f2b324c5c9ae691a
0x000001ade50442cb1b4f0178027e77143aa1973f	0x8a26436e41d0b5fc4c6ed36c1976fafbe173444e	false	0x000001ade50442cb1b4f0178027e77143aa1973f	0	93	38125722	2023-01-15T21:57:21.000Z	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	0x7cf458fe3cfb30a982eaba6fc32395ed634357be5812608bf174dd2dbadabea7
0x000001ade50442cb1b4f0178027e77143aa1973f	0x8a26436e41d0b5fc4c6ed36c1976fafbe173444e	false	0x000001ade50442cb1b4f0178027e77143aa1973f	42376843440290274719	91	38125722	2023-01-15T21:57:21.000Z	0x958d208cdf087843e9ad98d23823d32e17d723a1	0x7cf458fe3cfb30a982eaba6fc32395ed634357be5812608bf174dd2dbadabea7

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.quickswap_v3_polygon.EternalFarming_RewardClaimed_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_bottomTick`	`INT64`	Lower bound of the tick range for a concentrated liquidity position. Signed integer value representing the price interval boundary in Uniswap V3-style concentrated liquidity pools.
`in_topTick`	`INT64`	Upper bound of the tick range for a concentrated liquidity position. Signed integer value representing the price interval boundary in Uniswap V3-style concentrated liquidity pools.
`in_liquidityAmount`	`STRING`	Amount of liquidity added to or removed from a concentrated liquidity position. Numeric string representation of liquidity units in the position’s tick range.
`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	log_index	in_amount0	in_amount1	in_topTick	block_number	in_bottomTick	block_timestamp	transaction_hash	in_liquidityAmount
0x9f1a8caf3c8e94e43aa64922d67dff4dc3e88a42	false	0x8ef88e4c7cfbbac1c163f7eddd4b578792201de6	24	3121650188869919771	46374177795836836540	887220	33180152	-887220	2022-09-16T13:44:57.000Z	0x4836e13c750ff6f8926b451df7b180267145974d2c9d2755c52b45f306359eb8	12031789595694453491
0xae81fac689a1b4b1e06e7ef4a2ab4cd8ac0a087d	false	0x8ef88e4c7cfbbac1c163f7eddd4b578792201de6	339	8071975579330549767643	6633648776	887220	33168227	-887220	2022-09-16T06:49:25.000Z	0x374bf8d277df361f0bad960fccdeca6218f020015b3ba5a0b199628493366667	7317557715885548
0xae81fac689a1b4b1e06e7ef4a2ab4cd8ac0a087d	false	0x8ef88e4c7cfbbac1c163f7eddd4b578792201de6	321	0	0	887220	33168208	-887220	2022-09-16T06:48:09.000Z	0x97371dd95ed83d7cbcdf3613c415e0d6b0dbc75ae64ae053df3ad2a8ddab0218	0

Example Query

Query with partition filter

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

Pool_Collect_event

Concentrated liquidity position fee collection events from Uniswap V3 compatible decentralized exchanges. Records position owner, recipient, collected token amounts, and tick range boundaries for tracking earned trading fees and position management activity.

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_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_bottomTick`	`INT64`	Lower bound of the tick range for a concentrated liquidity position. Signed integer value representing the price interval boundary in Uniswap V3-style concentrated liquidity pools.
`in_topTick`	`INT64`	Upper bound of the tick range for a concentrated liquidity position. Signed integer value representing the price interval boundary in Uniswap V3-style concentrated liquidity pools.
`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	log_index	in_amount0	in_amount1	in_topTick	block_number	in_recipient	in_bottomTick	block_timestamp	transaction_hash
0x5b41eedcfc8e0ae47493d4945aa1ae4fe05430ff	false	0x003a30218bbd59c55a34d795523b2efe34430884	442	668692539931058567940	235605567	-281460	61873691	0x003a30218bbd59c55a34d795523b2efe34430884	-289620	2024-09-16T00:01:07.000Z	0x42290864f843309887a2ef52cb9e566912d609670003c0071e61c459a5be710f
0x5b41eedcfc8e0ae47493d4945aa1ae4fe05430ff	false	0x003a30218bbd59c55a34d795523b2efe34430884	436	1239841865374821733787	151743	-284760	61873691	0x003a30218bbd59c55a34d795523b2efe34430884	-285540	2024-09-16T00:01:07.000Z	0x42290864f843309887a2ef52cb9e566912d609670003c0071e61c459a5be710f
0x5b41eedcfc8e0ae47493d4945aa1ae4fe05430ff	false	0x003a30218bbd59c55a34d795523b2efe34430884	181	1306159763055209126247	16677	-284940	61877037	0x003a30218bbd59c55a34d795523b2efe34430884	-285720	2024-09-16T02:01:19.000Z	0x6f866e9b23d74db0e91ee377aa2b1ee0feca48ea9bb0112da72ff63558d4de61

Example Query

Query with partition filter

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

Pool_CommunityFee_event

Community fee rate update events from liquidity pools, recording the new fee percentages allocated to the protocol or community for each token in a trading pair. Used for tracking fee structure changes and protocol revenue distribution configurations.

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_communityFee0New`	`INT64`	Updated community fee rate for token0 in basis points. Integer value representing the fee percentage allocated to the community, where 100 equals 1%.
`in_communityFee1New`	`INT64`	Updated community fee rate for token1 in basis points. Integer value representing the fee percentage allocated to the community, where 100 equals 1%.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_communityFee0New	in_communityFee1New
0xc98c9434dfb18300be98907a6c627468dbd69604	false	358	47570177	2023-09-15T11:43:47.000Z	0x2ecd1276d6928d471d111f596bb9b17faa45bc6054c468d43ec0e88164b752aa	100	100
0x1f97c0260c6a18b26a9c2681f0faa93ac2182dbc	false	655	35430529	2022-11-10T08:43:48.000Z	0x1d6db96162817a501d19d961fb307148c62bf86071f9e410c0477de24a43866b	100	100
0xac4494e30a85369e332bdb5230d6d694d4259dbc	false	26	68992678	2025-03-13T09:19:46.000Z	0x77a808dfb76b59c0552ab421007cc2ee62c5a6cb8dff387ad5d15e0419254758	10	10

Example Query

Query with partition filter

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

Pool_Fee_event

Fee tier configuration events emitted by Automated Market Maker (AMM) pool contracts. Records updates to swap fee parameters measured in basis points for directional trades.

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_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.

Sample Data

in_fee	address	removed	log_index	block_number	block_timestamp	transaction_hash
1765	0x0080c1cb52682de5a1f183923134f8ccd2632c90	false	161	59452601	2024-07-17T02:26:46.000Z	0x998a063aa37ce7b84a1f5df8057df8e8f390352c287bc087dc696d5972c22663
2512	0x00a6177c6455a29b8daa7144b2befc9f2147bb7e	false	157	59488814	2024-07-17T23:55:39.000Z	0x35bb4853e108fd3e2deed756381b85f3f912fa160f82078b435c92d4763ee8f0
2552	0x00a6177c6455a29b8daa7144b2befc9f2147bb7e	false	347	59449031	2024-07-17T00:18:41.000Z	0x0a916952112dd5aa5ee05ec6ca1a49d48fd932ddd42365656a69004c320416fc

Example Query

Query with partition filter

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

Pool_Flash_event

Flash loan events from liquidity pools recording borrowed amounts and repayment fees for both tokens in the pair. Tracks sender, recipient, borrowed quantities, and actual fees paid for arbitrage and liquidation analysis.

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_paid0`	`STRING`	Amount of token0 paid as flash loan fee. Numeric string representation of token quantity in smallest denomination.
`in_paid1`	`STRING`	Amount of token1 paid as flash loan fee. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_paid1	in_sender	log_index	in_amount1	block_number	in_recipient	block_timestamp	transaction_hash
0xae81fac689a1b4b1e06e7ef4a2ab4cd8ac0a087d	false	4824	0x906137145ab63b95af440fcc503e6f6507fa9688	17	5359162	79285419	0x906137145ab63b95af440fcc503e6f6507fa9688	2025-11-20T21:57:49.000Z	0x4fa5771705cf998c9b90193bd971ea1d36e7d94de2e4556b6a2bedb40396b652
0xae81fac689a1b4b1e06e7ef4a2ab4cd8ac0a087d	false	21686	0x906137145ab63b95af440fcc503e6f6507fa9688	17	24095442	79250685	0x906137145ab63b95af440fcc503e6f6507fa9688	2025-11-20T02:40:01.000Z	0xe250a6501ec2e9d6894f18d6c1478ed454decac66c6508da44debe9b43aca100
0xae81fac689a1b4b1e06e7ef4a2ab4cd8ac0a087d	false	2400	0x906137145ab63b95af440fcc503e6f6507fa9688	87	2665835	79279858	0x906137145ab63b95af440fcc503e6f6507fa9688	2025-11-20T18:52:27.000Z	0x9660faea005be0146f54fd77c426a414b6561befe4432fa7f76bba7aa5ce310d

Example Query

Query with partition filter

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

Pool_Incentive_event

Incentive program activation and deactivation events for QuickSwap V3 liquidity pools on Polygon, linking pools to virtual pool addresses that manage farming rewards. Used to track when liquidity mining programs are enabled or disabled for specific 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_virtualPoolAddress`	`STRING`	Contract address of the virtual pool associated with this incentive event on Polygon. Can be the zero address (0x0000000000000000000000000000000000000000) when the incentive is deactivated or removed.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_virtualPoolAddress
0x5b1fd9fa139353c5d9eaf459e4bd2f7a6b4812bb	false	14	40242858	2023-03-12T01:58:58.000Z	0xcfa4f28c09e4e78767e1b289054f2c13758fe38a05141cb30b264e0fe2daffc3	0x3d4cfe4c829c2b77cd62074307a354f123221730
0x5b1fd9fa139353c5d9eaf459e4bd2f7a6b4812bb	false	14	40242881	2023-03-12T02:00:12.000Z	0x059fd1e873dc21d005b2457e825a676851f1067ef06c373da059773711f6fbcd	0x3d4cfe4c829c2b77cd62074307a354f123221730
0x5b1fd9fa139353c5d9eaf459e4bd2f7a6b4812bb	false	23	40242881	2023-03-12T02:00:12.000Z	0x059fd1e873dc21d005b2457e825a676851f1067ef06c373da059773711f6fbcd	0x0000000000000000000000000000000000000000

Example Query

Query with partition filter

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

Pool_Initialize_event

Concentrated liquidity pool initialization event emitted when a pool contract is first created and seeded with a starting price. Records the initial sqrtPriceX96 (square root price encoded as Q64.96 fixed-point) and tick index that define the pool’s starting exchange rate between token0 and token1.

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_price`	`STRING`	Price of the asset or position in the transaction or event. Numeric string representation in smallest denomination or with extended precision.
`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_price	log_index	block_number	block_timestamp	transaction_hash
0xaf1306da8d63835755e95e308dd8d5d0c4508998	0	false	79228162514264337593543950336	73	32693340	2022-09-04T20:13:33.000Z	0x46a7425e3d2f85b3c0d935453d646e245337319d2064f12f4949c6f0ccf1d747
0xae81fac689a1b4b1e06e7ef4a2ab4cd8ac0a087d	-278556	false	70862311846625194826430	94	32687452	2022-09-04T16:50:01.000Z	0x0285dd43a271ce177cbe71002bb96b26bf0e8848713f982ab1a425391a281e18
0xa8533ce824a2730479a32f819a50fee8a17310c9	-1491	false	73536769774519549149177908080	410	42647216	2023-05-13T08:29:50.000Z	0x236eac7dd727f540ff7f4b5ae2146aa306108e170104d760c250bb0da864bd35

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.quickswap_v3_polygon.Pool_Initialize_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_bottomTick`	`INT64`	Lower bound of the tick range for a concentrated liquidity position. Signed integer value representing the price interval boundary in Uniswap V3-style concentrated liquidity pools.
`in_topTick`	`INT64`	Upper bound of the tick range for a concentrated liquidity position. Signed integer value representing the price interval boundary in Uniswap V3-style concentrated liquidity pools.
`in_liquidityAmount`	`STRING`	Amount of liquidity added to or removed from a concentrated liquidity position. Numeric string representation of liquidity units in the position’s tick range.
`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_sender	log_index	in_amount0	in_amount1	in_topTick	block_number	in_bottomTick	block_timestamp	transaction_hash	in_liquidityAmount
0x5d0acfa39a0fca603147f1c14e53f46be76984bc	false	0x002ba5f8ad6dc69bb056ced3e6b5165ae1e1691b	0x002ba5f8ad6dc69bb056ced3e6b5165ae1e1691b	110	0	187851	-274260	40362807	-276180	2023-03-15T05:41:54.000Z	0x7d3344e8e0d8b30063aa6a01610c1eaf3bd4ce4f32df7759349f9ec71d32b009	1851078436008
0x5d0acfa39a0fca603147f1c14e53f46be76984bc	false	0x002ba5f8ad6dc69bb056ced3e6b5165ae1e1691b	0x002ba5f8ad6dc69bb056ced3e6b5165ae1e1691b	220	266835375761188601	327092	-272820	40374305	-276720	2023-03-15T12:56:21.000Z	0x3ef7fc835c6afc08a464b6748eb5d9fe48a22515f7df37651f325552389911cc	3181171157851
0x5d0acfa39a0fca603147f1c14e53f46be76984bc	false	0x002ba5f8ad6dc69bb056ced3e6b5165ae1e1691b	0x002ba5f8ad6dc69bb056ced3e6b5165ae1e1691b	222	33169224848828519	0	-272820	40374305	-274680	2023-03-15T12:56:21.000Z	0x3ef7fc835c6afc08a464b6748eb5d9fe48a22515f7df37651f325552389911cc	405517018452

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.quickswap_v3_polygon.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_price`	`STRING`	Price of the asset or position in the transaction or event. Numeric string representation in smallest denomination or with extended precision.
`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_price	in_sender	log_index	in_amount0	in_amount1	block_number	in_liquidity	in_recipient	block_timestamp	transaction_hash
0xeecb5db986c20a8c88d8332e7e252a9671565751	0	false	79228562972359744594126550842	0x67f1e92ef101a78aa1229b24bc302d2ddaabd26b	1159	1999831625	-1999874866	52902225	159816311937399	0x000000072ed5718cf91290bcaa1143bc97d1d7ff	2024-01-29T22:58:16.000Z	0xcd67a6a5e517e3e1d891b2e28c07a72ed50ffe0188e12021aaf5e541ebb51853
0x3654e293a599953044ac5f6e1e1a45ee749d0d0f	81096	false	4568517130416160034412116757068	0xf5b509bb0909a69b1c207e495f687a596c168e12	76	-86649315026065223	288003530382381940736	52884624	10003169810248108354563	0x004df5de266316d7aa68a639ad73d795a631e2e6	2024-01-29T12:02:52.000Z	0x5d831727b41a126af6e187d4f4c304afa43d14530c82a8cdfd54d3212964ff35
0x3654e293a599953044ac5f6e1e1a45ee749d0d0f	81082	false	4565282682384677979531865027621	0xf5b509bb0909a69b1c207e495f687a596c168e12	73	179572730298391552	-596762128466080668666	52883668	10003169810248108354563	0x004df5de266316d7aa68a639ad73d795a631e2e6	2024-01-29T11:28:27.000Z	0x51c6682b010699d11c6dfb970222d2056b5e37ad81052026d8d4652388055fb3

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

AlgebraFactory_Pool_event

AlgebraFactory_VaultAddress_event

EternalFarming_FarmEnded_event

EternalFarming_RewardClaimed_event

Pool_Burn_event

Pool_Collect_event

Pool_CommunityFee_event

Pool_Fee_event

Pool_Flash_event

Pool_Incentive_event

Pool_Initialize_event

Pool_Mint_event

Pool_Swap_event

​Tables

​AlgebraFactory_Pool_event

​AlgebraFactory_VaultAddress_event

​EternalFarming_FarmEnded_event

​EternalFarming_RewardClaimed_event

​Pool_Burn_event

​Pool_Collect_event

​Pool_CommunityFee_event

​Pool_Fee_event

​Pool_Flash_event

​Pool_Incentive_event

​Pool_Initialize_event

​Pool_Mint_event

​Pool_Swap_event

Tables

AlgebraFactory_Pool_event

AlgebraFactory_VaultAddress_event

EternalFarming_FarmEnded_event

EternalFarming_RewardClaimed_event

Pool_Burn_event

Pool_Collect_event

Pool_CommunityFee_event

Pool_Fee_event

Pool_Flash_event

Pool_Incentive_event

Pool_Initialize_event

Pool_Mint_event

Pool_Swap_event