apeswap_v1_polygon

Tables

ApeFactory_PairCreated_event

Decentralized exchange (DEX) factory events emitted when new liquidity pool pairs are deployed. Records token pair addresses, deployed pool contract address, and sequential pair counter for tracking pool creation 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_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
0xcf083be4164828f00cae704ec15a36d711491284	0x770a9204fdacae411f111964673a57a0fd1d6293	false	1088	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	0x8bed0e679df86f14415fd9474c440b263df9506c	130	36908682	2022-12-16T17:38:56.000Z	0xd6b16817a386927c0b498bd9dcde2e039867d9b24afb5322c9acb8cbadf997b6
0xcf083be4164828f00cae704ec15a36d711491284	0x4b47fe781f0642283303f04941a45700d6c83522	false	1089	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	0x2ab0e9e4ee70fff1fb9d67031e44f6410170d00e	413	36915968	2022-12-16T22:15:23.000Z	0x7968328898484c55e78cdf4d799597c8116e0be2839b9724515ddb7f1abd1200
0xcf083be4164828f00cae704ec15a36d711491284	0x65c37f48781a555e2ad5542e4306ebab1ae93cd7	false	69	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	0xc68e83a305b0fad69e264a1769a0a070f190d2d6	245	16098199	2021-06-24T15:10:19.000Z	0x47fc99d29d2ec90506178693ef32afca1c38f430637f59d7dd2195f814631a08

Example Query

Query with partition filter

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

ApePair_Burn_event

Liquidity removal events from ApeSwap decentralized exchange (DEX) pair contracts, recording amounts of both tokens withdrawn when liquidity providers burn their LP tokens. Used for tracking liquidity exits and pool balance changes across ApeSwap deployments.

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
0xe5267881f38c74b253b3474b2801d150b7a05c8f	0x034293f21f1cce5908bc605ce5850df2b1059ac0	false	0xc0788a3ad43d79aa53b09c2eacc313a787d1d607	304	5536979397125904250529	5028143777363369455136	16888025	2021-07-15T13:09:40.000Z	0x8e407973a223dd752e775edc7b2196fa865ec819387023b077b9a9f91094e82b
0xacb9af7d66c69e8533b2cd39694a7ddf03bbd714	0x034293f21f1cce5908bc605ce5850df2b1059ac0	false	0xc0788a3ad43d79aa53b09c2eacc313a787d1d607	50	11318178879288133096	10765347125502414664	16889399	2021-07-15T14:03:16.000Z	0xaeda0b0ee82635e60d034bed3ca737e79f33dafbba65a903f7fe826756314518
0x87279a012d49f44ed3a347c50dcc7cd0d7dec61e	0x034293f21f1cce5908bc605ce5850df2b1059ac0	false	0xc0788a3ad43d79aa53b09c2eacc313a787d1d607	149	302711858559252079140	265345574180030734139	16876675	2021-07-15T06:10:55.000Z	0xe0a3b10db47393636c8c5bde812d16b0c634dc152e4402234b1fe30bbff6896a

Example Query

Query with partition filter

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

ApePair_Mint_event

Liquidity provision events emitted when tokens are deposited into ApeSwap DEX (Decentralized Exchange) trading pairs. Records sender address and amounts of both tokens added to liquidity 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.

Sample Data

address	removed	in_sender	log_index	in_amount0	in_amount1	block_number	block_timestamp	transaction_hash
0xb8e54c9ea1616beebe11505a419dd8df1000e02a	false	0x89d2adba00fa9b1b7068a8ff784046055c218099	209	271077618698826109	25859365469538912808	33169988	2022-09-16T07:50:55.000Z	0x827bb728fc2b52c583e9e1602cb0661375c6d6a23aa658267fa6836cdaf82e04
0x034293f21f1cce5908bc605ce5850df2b1059ac0	false	0xc0788a3ad43d79aa53b09c2eacc313a787d1d607	268	432847893745336505	3814005220363322248	33158776	2022-09-16T01:23:09.000Z	0x8385e3da1af533aab517af0465cb684f4d089b3cec7bb11f106f7efc45a07c4e
0x034293f21f1cce5908bc605ce5850df2b1059ac0	false	0xc0788a3ad43d79aa53b09c2eacc313a787d1d607	205	519268523672354709	4548449898541079171	33163387	2022-09-16T04:01:41.000Z	0x0c84680b29601155b8733aef3d41e0bfb1d473d74b953a391677e1406faa2c31

Example Query

Query with partition filter

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

ApePair_Swap_event

Token swap events from ApeSwap DEX (Decentralized Exchange) liquidity pools recording bidirectional token exchanges with sender and recipient addresses. Contains input and output amounts for both token0 and token1 in each swap transaction.

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
0x0000084397b6d03d925d3deeddea90edb4f073b4	0x65d43b64e3b31965cd5ea367d4c2b94c03084797	false	0xc0788a3ad43d79aa53b09c2eacc313a787d1d607	76	49910819	5576221000000000000	4986709	2023-11-13T22:57:30.000Z	0x3dc553213d5db0119494d255e7b35356372fddd128e3ad080aacad6ebc3a53b4
0x00933357b10e24a8723c8863ca74166654e7e404	0x65d43b64e3b31965cd5ea367d4c2b94c03084797	false	0xc0788a3ad43d79aa53b09c2eacc313a787d1d607	172	49894503	16438536000000000000	14247467	2023-11-13T13:07:00.000Z	0x27364eb1c2867482e2d7590cc0e6beaf0e1aa41d64a445a6b0e1d46dd569a724
0x00ca0dd51dcd486cde843c7b2b734fec203dd289	0x65d43b64e3b31965cd5ea367d4c2b94c03084797	false	0x66a2995547ee992c0d7bed1a01ec0383ee8fb044	181	49905806	2534657135918964561	2348945	2023-11-13T19:59:33.000Z	0x36e3c5284bd14d9aada68250a0d7c2da6e7de0ff2dfbca6ccad449b6632112bd

Example Query

Query with partition filter

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

ApePair_Sync_event

Liquidity pool reserve synchronization events emitted by ApeSwap V1 pair contracts. Contains updated reserve balances for both tokens in the pool after swaps, liquidity additions, or withdrawals.

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
0x019011032a7ac3a87ee885b6c08467ac46ad11cd	false	297	666508989427336767574	148440011	77001372	2025-09-28T10:03:47.000Z	0x186ab7319986348d18c5f1eed0fc7a020cf4a78d8305f3e4df50ed62c26617ec
0x019011032a7ac3a87ee885b6c08467ac46ad11cd	false	764	662315434606707600205	149377072	76996979	2025-09-28T07:28:13.000Z	0x70c0341c3b28709e4d52de417ac1ea723b326751d7601b5454503f5603f7c866
0x019011032a7ac3a87ee885b6c08467ac46ad11cd	false	232	667410560060575626666	148249533	77007063	2025-09-28T13:25:21.000Z	0x7ac787a00791844a16962aa15f6c54b74b401d40f36ce33add7309bc1dbfb1f5

Example Query

Query with partition filter

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

ApePair_Transfer_event

ERC-20 Transfer events emitted by ApeSwap liquidity pair contracts, recording minting, burning, and transfers of LP (liquidity provider) tokens. Tracks liquidity changes and LP position movements across ApeSwap DEX 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_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
0x36d32dc87d861a7d8c6dc7a6161c0ffcc9c26ca0	0x019011032a7ac3a87ee885b6c08467ac46ad11cd	0x0000000000000000000000000000000000000000	false	27833896636311	392	17285479	2021-07-26T09:53:34.000Z	0x037acf928eb2f0117ee05b558e91eac264fc4429faa0be2cdcf71125311ef9b0
0x94bfe225859347f2b2dd7eb8cbf35b84b4e8df69	0x019011032a7ac3a87ee885b6c08467ac46ad11cd	0x0000000000000000000000000000000000000000	false	221809363659	391	17285479	2021-07-26T09:53:34.000Z	0x037acf928eb2f0117ee05b558e91eac264fc4429faa0be2cdcf71125311ef9b0
0x0000000000000000000000000000000000000000	0x019011032a7ac3a87ee885b6c08467ac46ad11cd	0x019011032a7ac3a87ee885b6c08467ac46ad11cd	false	4731359246790	579	17294417	2021-07-26T15:57:59.000Z	0x13826c8f5f039a6734520a0f8da8c0cd5fccdb1a81d9dc1b1e9747ca3640e4a0

Example Query

Query with partition filter

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

MiniApeV2_Harvest_event

Harvest events from ApeSwap’s MiniApeV2 staking pools on Polygon, recording user reward claims with pool ID, harvested token amounts, and user addresses. Used for tracking yield farming reward distributions and user staking activity across different liquidity 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_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
0x54aff400858dcac39797a81894d9920f16972d1d	0x0a8557b9f8cd68d46e3c0a33007623e4637f9a49	false	2168046829357628860	278	33889648	2022-10-03T18:59:53.000Z	0xad327638d36ffa36ea23efe8c5233227b256be0b98f27c6bfcd4b2f8d98ad559
0x54aff400858dcac39797a81894d9920f16972d1d	0x1a9bca1327871530c60cfe65eeebfab4e2a20c38	false	32088830608690045303	995	33892373	2022-10-03T20:34:36.000Z	0x6f6a0ff05a9a7773f63a2779af4683e424c127e2e1f0cc58defc3de0c9b7b2f8
0x54aff400858dcac39797a81894d9920f16972d1d	0x1e557c24fc7ac9989c78c017b91bf0b0ad63334d	false	13696908844952882881	168	33869033	2022-10-03T07:05:59.000Z	0xc69a45ff22acc3638bf616fcc6b4bccfa131a8c01b21e09ef0963f5d7a0dbca6

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

ApeFactory_PairCreated_event

ApePair_Burn_event

ApePair_Mint_event

ApePair_Swap_event

ApePair_Sync_event

ApePair_Transfer_event

MiniApeV2_Harvest_event

​Tables

​ApeFactory_PairCreated_event

​ApePair_Burn_event

​ApePair_Mint_event

​ApePair_Swap_event

​ApePair_Sync_event

​ApePair_Transfer_event

​MiniApeV2_Harvest_event

Tables

ApeFactory_PairCreated_event

ApePair_Burn_event

ApePair_Mint_event

ApePair_Swap_event

ApePair_Sync_event

ApePair_Transfer_event

MiniApeV2_Harvest_event