apeswap_v1_bsc

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
0x0841bd0b734e4f5853f0dd8d7ea041c241fb0da6	0xcf27e75351ff29e4fcec821c8388b78ecde383f0	false	4537	0x4413f51a34df3950b9dca18122a8c4674a09b0b3	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	351	31124012	2023-08-24T05:21:27.000Z	0x86fce568ee7fee09e01bd4b1d3ba72f859a396c63e720ab795bf431e48073a8c
0x0841bd0b734e4f5853f0dd8d7ea041c241fb0da6	0xa827a226cd566daeef52a45dd66a76745f02825a	false	2165	0x3b23a0ffbc53198d86fa5927e8ee32f7ef699a14	0x603c7f932ed1fc6575303d8fb018fdcbb0f39a95	1142	12117341	2021-10-26T21:15:49.000Z	0xe60bdb8df5ffc5030b1bc60c57be00bf4c8f4064d00af0d32ab94490f80ddeaf
0x0841bd0b734e4f5853f0dd8d7ea041c241fb0da6	0xbd47f4eeeede391628df7f731a960bc2710cbf9c	false	2163	0xa1217c0cce65a37e77cf43af277c0b29d808652c	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	1006	12113870	2021-10-26T18:19:49.000Z	0x5491704a86097ddf6a9a16089584291cc4f4ad4332f09b0f1819e1dae9fd8367

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.apeswap_v1_bsc.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
0x10ab57c5889a00c497ce6be7ce142bb9a613e362	0x0be55fd1fdc7134ff8412e8baac63cbb691b1d64	false	0x10ab57c5889a00c497ce6be7ce142bb9a613e362	417	18599418188134284724107	272290020615492512	9973746	2021-08-12T19:51:48.000Z	0x098c0ae1d2d2f7d1e4ded8a5f2c53dea5dadae8b1544b51bbd7fb4cf043ff54b
0x10ab57c5889a00c497ce6be7ce142bb9a613e362	0x0f12362c017fe5101c7bba09390f1cb729f5b318	false	0x10ab57c5889a00c497ce6be7ce142bb9a613e362	320	404026740982206637	178480636606704733	9957864	2021-08-12T06:22:47.000Z	0xfbfe591cdd00b76db9aa8301a0678324f126590a3bb162b0c467f3cbd07e3d29
0x10ab57c5889a00c497ce6be7ce142bb9a613e362	0x16f77b8f15ec2c98069e0e34fda78e3d57ca501b	false	0x10ab57c5889a00c497ce6be7ce142bb9a613e362	493	496167288427351265	1447940459727442181926	9963360	2021-08-12T11:03:03.000Z	0x76adfe33595c7c219b1a8c915d6bd825400f38ab55426fcb919a6022427974e7

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.apeswap_v1_bsc.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
0xd82ed8363f0e40a787b386c936720af174b68487	false	0x7e1e330e5f2fa0618f3e5449ae3b3c29b73fa864	314	14391551567469862816192	107006555107471098	21183432	2022-09-09T14:08:09.000Z	0xa128aecec609db1fae76181bf8f2872a805381c771b964fe78cec217a3f7cd80
0x092ada3818db7fbb8e0a2124ff218c5125c1cce6	false	0xc0788a3ad43d79aa53b09c2eacc313a787d1d607	209	49325956029068710	1845860752455604444	21186498	2022-09-09T16:41:27.000Z	0xd6eb9754057b3bfd31a5bfd7ce99ad223b25f1f8e25770d317817f11f1ddfc1b
0x0ab82ec81c80f75b02a117fba9b414c17379ae8c	false	0xc0788a3ad43d79aa53b09c2eacc313a787d1d607	648	14696684576444721831509	42845259958553358	21185016	2022-09-09T15:27:21.000Z	0xfc4da75478c89f89e9575927c94761bdb3d3b7edc3273447baae6b3c4cb8195a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.apeswap_v1_bsc.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
0x00000000000061ab74e8283239e8c4e9d2dfed3e	0xdfc7b9b17ef17da19abb0d3a3aeeb8aeff5b0183	false	0x00000000000061ab74e8283239e8c4e9d2dfed3e	35	30787435	7484610463726	71491584527908387436	2023-08-12T11:52:58.000Z	0x0e003d9f7740b7129fd128cef6b586fb14abb3607ade4922c7c1c66ea1bbcf8d
0x00000000000061ab74e8283239e8c4e9d2dfed3e	0x7bd46f6da97312ac2dbd1749f82e202764c0b914	false	0x00000000000061ab74e8283239e8c4e9d2dfed3e	16	30789772	11274156059012356032266	253540363726981043825	2023-08-12T13:50:01.000Z	0xfc0e634133afba9be34ac313702b4d73c151ba089a8c03c34728143c9baf6684
0x00000000000061ab74e8283239e8c4e9d2dfed3e	0xe0a15a31a78129a3d28138b71724cb2d3a688dd7	false	0x00000000000061ab74e8283239e8c4e9d2dfed3e	135	30780771	7367466292	70291093580288784	2023-08-12T06:19:07.000Z	0x6869e2ec21d124c1191618820bdb3c59304cd0c54b733927fc20108ce1fcbd79

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.apeswap_v1_bsc.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
0x004f72d474ee262701205e3637b4367594efb11d	false	243	432230186905126765642004	3485873479320835101184	25056770	2023-01-24T06:32:08.000Z	0x871664b8a8cd70b1e168db074b0557df5ebf5ceaae2c84b29456dba6da71ab29
0x004f72d474ee262701205e3637b4367594efb11d	false	206	417068173874004146205345	3613086676729047110578	25059602	2023-01-24T08:54:22.000Z	0xfd292aeac02f0cd5decdecdddb9d8269dd5ba85b9a5a304cf28e10cadc7e93c8
0x004f72d474ee262701205e3637b4367594efb11d	false	260	410442899642720924822138	3671291172925167267825	25059363	2023-01-24T08:42:25.000Z	0x75e7a1ce656781c26570b01a5370f776e42cd31b2f507ce482da9675d076a247

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.apeswap_v1_bsc.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
0x781d57eadaa92ca2235bfbc4e7f3751bd3d380c8	0x044f2b275a344d4edfc3d98e1cb7c02b30e6484e	0x5c8d727b265dbafaba67e050f2f739caeeb4a6f9	false	1476971518916067934010	97	5882883	2021-03-21T19:25:40.000Z	0x9dc255b7f956c052b40c7f1765150db05f805196ba1847a9f51717b0184beddb
0x781d57eadaa92ca2235bfbc4e7f3751bd3d380c8	0x044f2b275a344d4edfc3d98e1cb7c02b30e6484e	0x0000000000000000000000000000000000000000	false	541910726962852099840	61	5887255	2021-03-21T23:04:18.000Z	0xd4b085f5d91cf9d620e059873c161f72cf5d2ed560d1f2a915c8b8ab2af11113
0x5c8d727b265dbafaba67e050f2f739caeeb4a6f9	0x044f2b275a344d4edfc3d98e1cb7c02b30e6484e	0x781d57eadaa92ca2235bfbc4e7f3751bd3d380c8	false	541910726962852099840	38	5887262	2021-03-21T23:04:39.000Z	0x855ff64fb7e4a0e2877227d6ca572482c8a63b37635111be885b60ad8704c671

Example Query

Query with partition filter

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

GNANAPool_Deposit_event

Deposit event logs from ApeSwap’s GNANA (Golden Banana) staking pool on BNB Smart Chain, capturing user addresses and deposit amounts at block-level granularity. Used for tracking liquidity provider participation and stake timing 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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`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	log_index	block_number	block_timestamp	transaction_hash
0x8f97b2e6559084cfaba140e2ab4da9aaf23fe7f8	0x666ab1d55f026ae287b1fc951bb2cc5d086184b0	false	147	34701154	2023-12-26T20:49:32.000Z	0x6024cb5d9c874a4ebfd112b5c716af3cb83d4ba52ec03d8a9e6120a70f302261
0x8f97b2e6559084cfaba140e2ab4da9aaf23fe7f8	0xe9fad991791a632813293f04dc0457c41ce7ba53	false	190	7804691	2021-05-28T14:34:05.000Z	0x200f30ba5cad36e43636f2b78f6227e0d74a8a19e56675a630318207d270d194
0x8f97b2e6559084cfaba140e2ab4da9aaf23fe7f8	0xe7fa28dfae4c7cd89dffcd25d4ed01a0ae9e1a91	false	235	7810270	2021-05-28T19:13:18.000Z	0x5d833b2794e6d126fe4c85bbb2a1e145d7c609b1196f8b78f10a3ab4bda60def

Example Query

Query with partition filter

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

GNANAPool_Withdraw_event

Withdrawal event logs from ApeSwap’s GNANA (Golden Banana) staking pool on BNB Smart Chain, capturing user addresses and token amounts withdrawn from the pool. Used for tracking staking position changes and liquidity movements in ApeSwap’s governance token pool.

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_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
0x8f97b2e6559084cfaba140e2ab4da9aaf23fe7f8	0xd3911ab26e63b20eab8de8f66bc1d85e8716026c	false	3920723433146009054	513	8797829	2021-07-02T06:35:49.000Z	0x3d26059c455cbe6fa23a8e3848d1e16a9f990664633e1040f7740e519a7b202a
0x8f97b2e6559084cfaba140e2ab4da9aaf23fe7f8	0xfa88a3155dfd24bc7bbd9cfa8feff826ed64c558	false	7127479822833080751	52	8798446	2021-07-02T07:06:52.000Z	0xb5da5ec3f4f22136c39c7b9afae6b61a0f0014dcf565c8ad38ae1ff480f4ab11
0x8f97b2e6559084cfaba140e2ab4da9aaf23fe7f8	0xb209172a7bb656c5ef8d9b6b9ecd7170ba0e816a	false	20000000000000000000	64	8803263	2021-07-02T11:10:06.000Z	0x327b130d615b2f80fe862354fec1ba89bbed9418fe95ee17cd4afab8514beb97

Example Query

Query with partition filter

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

MasterApe_Deposit_event

Liquidity provider (LP) token deposit events from ApeSwap’s MasterApe yield farming contract on BNB Smart Chain (BSC), tracking user stakes into specific pool IDs. Used for analyzing farm participation patterns, harvest timing (zero-amount deposits), and staking behavior across ApeSwap’s incentivized 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

in_pid	address	in_user	removed	log_index	block_number	block_timestamp	transaction_hash
109	0x5c8d727b265dbafaba67e050f2f739caeeb4a6f9	0x0e51a3bfa09baf0509676c8eecb1c64dbdd6005b	false	475	19001530	2022-06-25T16:24:29.000Z	0x50175c6f2edfa61ef7efcdc02836f456fe77fafa8d08f10474dddd211648018a
132	0x5c8d727b265dbafaba67e050f2f739caeeb4a6f9	0x0e51a3bfa09baf0509676c8eecb1c64dbdd6005b	false	420	19001532	2022-06-25T16:24:35.000Z	0x8c1c809d5722e7d390ec521821913b720305ecc7cfc0c650cf1e2d2e55ba66ea
178	0x5c8d727b265dbafaba67e050f2f739caeeb4a6f9	0x0f9edd5b3aea2c9a56f928a6ff7a869b770ebea7	false	330	18999843	2022-06-25T15:00:08.000Z	0xa268347c1f6ead7d601fba3907e454f79bdfe05ccd9d744036a1b1b69156ed50

Example Query

Query with partition filter

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

MasterApe_Withdraw_event

Withdrawal events from ApeSwap’s MasterApe staking contract on BNB Smart Chain, tracking unstaked amounts and pool IDs. Used for analyzing user farming positions and liquidity mining exit patterns.

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
0x5c8d727b265dbafaba67e050f2f739caeeb4a6f9	0x9a668d5482828a444d7322fe5420ab5b44ce3de7	false	137618782087403050457	162	29215668	2023-06-18T18:00:30.000Z	0x7804648bf346164fa30abfe00b84f0dad5a494db3cb29803f25cb298ffc41918
0x5c8d727b265dbafaba67e050f2f739caeeb4a6f9	0x460217cbcd5cbf1432e4d8f1ce9cf6038de574b8	false	899642157408696615293	191	29200387	2023-06-18T05:14:07.000Z	0x62a36a9f6227b563d62e3dea00a8cf9027c4bbaf0a66191010e043814e0c7109
0x5c8d727b265dbafaba67e050f2f739caeeb4a6f9	0x9a668d5482828a444d7322fe5420ab5b44ce3de7	false	532383601118676592818	244	29195884	2023-06-18T01:28:37.000Z	0x7872bc7ae492c42bd558b4f79f4f864bff25da5586428a79f987b80dd75df51d

Example Query

Query with partition filter

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

MasterApeV2_Deposit_event

Deposit events from ApeSwap V1 yield farming MasterChef contract on BNB Smart Chain, tracking user stakes into liquidity mining pools identified by pool ID (pid). Used for analyzing farming participation, stake amounts, and yield farm activity patterns.

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
0x71354ac3c695dfb1d3f595afa5d4364e9e06339b	0x3e501bc73c5417c300e295a826cae40d137054ff	false	132359306902959318904	254	29638622	2023-07-03T11:30:32.000Z	0xd0fa0c1ff9f248d387c64f49a7c8ee8c072daf1c4b3ab4a395d1e2fdb4683077
0x71354ac3c695dfb1d3f595afa5d4364e9e06339b	0x2a5dcdc31af51f8f4b0a02df3ee7d6db347fbda2	false	0	355	29636464	2023-07-03T09:42:32.000Z	0xcb9c2d5f50e74005b7738c4c75be1d051ee362ae06f3ce42eb3f69655fd623b7
0x71354ac3c695dfb1d3f595afa5d4364e9e06339b	0xe0a84e47f26acc5ee0b945b9cb4e3ba30ccfa193	false	0	314	29646536	2023-07-03T18:07:12.000Z	0x221da22f2cc201f9f8b5379ab1c0eb9d4267354fcb56db726cfac3a6192dd15f

Example Query

Query with partition filter

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

MasterApeV2_Withdraw_event

Withdraw event logs from ApeSwap V1’s MasterApe staking contract on BNB Smart Chain, capturing user unstaking transactions with pool IDs and withdrawal amounts. Used for tracking liquidity provider exits and farming position changes across ApeSwap yield farms.

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	log_index	block_number	block_timestamp	transaction_hash
0x71354ac3c695dfb1d3f595afa5d4364e9e06339b	0xae9ed266ea3d7ae83cad8fa3b143d3dc86b640bf	false	170	26412717	2023-03-12T22:31:33.000Z	0x1107ee38eecfc1c9e970def357256e5dfda8b0a2b65335b0a69fd12fb585e0cd
0x71354ac3c695dfb1d3f595afa5d4364e9e06339b	0xae9ed266ea3d7ae83cad8fa3b143d3dc86b640bf	false	308	26394971	2023-03-12T07:33:39.000Z	0x50462fd2b73f058e71a305e0e17746ce7d4e45502ebe81a3b8db83bf635700ef
0x71354ac3c695dfb1d3f595afa5d4364e9e06339b	0xae9ed266ea3d7ae83cad8fa3b143d3dc86b640bf	false	295	26408047	2023-03-12T18:36:14.000Z	0x34b606188c36946bad22fe5a3a22e3753fd04e3dcfa019e7c57672c0dc7e2d31

Example Query

Query with partition filter

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

GNANAPool_Deposit_event

GNANAPool_Withdraw_event

MasterApe_Deposit_event

MasterApe_Withdraw_event

MasterApeV2_Deposit_event

MasterApeV2_Withdraw_event

​Tables

​ApeFactory_PairCreated_event

​ApePair_Burn_event

​ApePair_Mint_event

​ApePair_Swap_event

​ApePair_Sync_event

​ApePair_Transfer_event

​GNANAPool_Deposit_event

​GNANAPool_Withdraw_event

​MasterApe_Deposit_event

​MasterApe_Withdraw_event

​MasterApeV2_Deposit_event

​MasterApeV2_Withdraw_event

Tables

ApeFactory_PairCreated_event

ApePair_Burn_event

ApePair_Mint_event

ApePair_Swap_event

ApePair_Sync_event

ApePair_Transfer_event

GNANAPool_Deposit_event

GNANAPool_Withdraw_event

MasterApe_Deposit_event

MasterApe_Withdraw_event

MasterApeV2_Deposit_event

MasterApeV2_Withdraw_event