apeswap_v1_ethereum

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
0xbae5dc9b19004883d0377419fef3c2c8832d7d7b	0xb9c36e19318408c7d03910f73c6f839b5c6a43d9	false	14	0x9d9d2847baaf00f0583ade2a6f2bfc06668045c6	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	619	17865265	2023-08-07T19:53:59.000Z	0xfe8c4bd8c3e2c0680ce4698ad2a567e9443aeccf0d7e0a7ba9ea080819f4f0c2
0xbae5dc9b19004883d0377419fef3c2c8832d7d7b	0x3d6dda3f6c186f7a31199fe71f9d663608cd8234	false	4	0x3845badade8e6dff049820680d1f14bd3903a5d0	0xdac17f958d2ee523a2206206994597c13d831ec7	201	15539172	2022-09-15T12:43:35.000Z	0xdc62043362da30f02b3b9acf914e62317c704241fc2e7a3a95e7237ff04c18d2
0xbae5dc9b19004883d0377419fef3c2c8832d7d7b	0x6b0cc136f7babd971b5decd21690be65718990e2	false	2	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	369	14747530	2022-05-10T08:25:36.000Z	0x2d446ad5e2715d2aa826dd5b32823fe40b44e899d241020e980da0bfdc634eeb

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.apeswap_v1_ethereum.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
0xab541dad9636abacefbf0cee06663b343ab1f218	0xee576ab4b629f04070b33e51335627d15403d87c	false	0x5f509a3c3f16df2fba7bf84dee1efbce6bb85587	79	936270400460931911038	104999999	15406931	2022-08-25T03:59:39.000Z	0x67a5f209da101cfe5e7b493512451e655be0cebdfd44a3acd1fbf0839fd496d4
0x55986cc9eb57e29875a80a7f70b9abcef063cfaf	0xc77d88d810901e3f49e3a627d2556a0e94425321	false	0x5f509a3c3f16df2fba7bf84dee1efbce6bb85587	310	100862941063308466934	8198442438448902117853211	15606004	2022-09-24T21:48:35.000Z	0x9d0aa29c1c8403eea31ffbc02ad16bfbf64b889f8497164dbb1da07b61798717
0x55986cc9eb57e29875a80a7f70b9abcef063cfaf	0x822f060ccc3039fe206f4603ee1c6b407e85e85b	false	0x5f509a3c3f16df2fba7bf84dee1efbce6bb85587	311	1987436873448350618	18233328475753621427249375	15605997	2022-09-24T21:47:11.000Z	0xe2dbd708c2b3f3cdaa3949645a2ee3e5347f205260a353c35a0a4d53abaf2ae7

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.apeswap_v1_ethereum.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
0x31bd914d44c1a37da653ba6765b716a9bc0ca5f1	false	0x5f509a3c3f16df2fba7bf84dee1efbce6bb85587	208	287445527275104577609	12809237410596654	16509216	2023-01-29T01:32:23.000Z	0x81c8ab2dbf86db8400c2f79367c80a31be38b0eca17d43d265a7a0fba4a0e4ee
0x822f060ccc3039fe206f4603ee1c6b407e85e85b	false	0x5f509a3c3f16df2fba7bf84dee1efbce6bb85587	289	1856536981199398249	20321114067418982585376532	15557806	2022-09-18T03:38:23.000Z	0x9b6979b6e770232e2e36c9a1337087bfbe268c40cc719d71bbaf22731e78887a
0x822f060ccc3039fe206f4603ee1c6b407e85e85b	false	0x5f509a3c3f16df2fba7bf84dee1efbce6bb85587	116	9136	100000000000	15557801	2022-09-18T03:37:23.000Z	0x49bb688288a492f48803be571bb504edf1a737fb53fae38ad43af20e94ba5b1b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.apeswap_v1_ethereum.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_amount1In	in_amount0Out	block_timestamp	transaction_hash
0xe62f2f637fc369d547522dd4dd830c1a0c9401ba	0x6b0cc136f7babd971b5decd21690be65718990e2	false	0x0000000000304a767881fdccb30fceb51f6221e2	72	15878219	10473273456328704	16490269	2022-11-01T22:40:11.000Z	0x4fa1deb329424868920d7617040bd83c6660213cb2849a689c3d26b6c8ce0674
0x1d2e8efae9fab4731028d4a90f0cca27e1a57c9f	0x6b0cc136f7babd971b5decd21690be65718990e2	false	0x0000000000304a767881fdccb30fceb51f6221e2	21	15875613	159598936019959808	252549888	2022-11-01T13:55:59.000Z	0x1b240981de98f2a574d12d0579316a8b49f6f77702ef0a74497da1266e351b09
0x1d2e8efae9fab4731028d4a90f0cca27e1a57c9f	0x6b0cc136f7babd971b5decd21690be65718990e2	false	0x0000000000304a767881fdccb30fceb51f6221e2	33	15874853	128902929309499392	205715968	2022-11-01T11:22:59.000Z	0x6015b378d8471b7087e10ebb38dc7ade37b807f0cb6c6e723bc74ae3b10eb183

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.apeswap_v1_ethereum.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
0x6b0cc136f7babd971b5decd21690be65718990e2	false	95	50460197	15417857285300145	19765446	2024-04-30T03:29:59.000Z	0x65999a7120596d9e9ba4d2c757439e6184b44847e494fbac4348eaa971815e17
0x6b0cc136f7babd971b5decd21690be65718990e2	false	170	50112931	15524912285300145	19768392	2024-04-30T13:22:23.000Z	0xb039bf17192b471e20cb9285dee469c3bb904d32e49de93adea29555f252448a
0x8e4c56e78e8888cebf85e30f13c9a1b3a67889d6	false	265	12869254499798144	2818066979848220051684950	19766116	2024-04-30T05:44:11.000Z	0xbf3c83c9a7053ea2ecf62342d93139a426e16f185b8e8adc9e0897df29af1129

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.apeswap_v1_ethereum.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
0xb38f75e8f7952c60170b7866dd59439e7f3174ac	0x31bd914d44c1a37da653ba6765b716a9bc0ca5f1	0x0000000000000000000000000000000000000000	false	595615086615457716	211	15547985	2022-09-16T18:34:35.000Z	0x8caf68e66cec93a990d6f0335677423b20ee80561117dd12ed324a4d9bfb701e
0x218eb9acdc721e235969a30f5da46fb1224fa7a7	0x31bd914d44c1a37da653ba6765b716a9bc0ca5f1	0x0000000000000000000000000000000000000000	false	3687880058481530	210	15547985	2022-09-16T18:34:35.000Z	0x8caf68e66cec93a990d6f0335677423b20ee80561117dd12ed324a4d9bfb701e
0x873ff13f32eb8dd4f6e142a7ea9ed376184e9855	0x31bd914d44c1a37da653ba6765b716a9bc0ca5f1	0x0000000000000000000000000000000000000000	false	4336507865400210118	134	16227709	2022-12-20T18:30:47.000Z	0x79dc5fda81f458fb3394a75f5d5e2e1c35f350f261cd2da5765f90631e7338ad

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

ApeFactory_PairCreated_event

ApePair_Burn_event

ApePair_Mint_event

ApePair_Swap_event

ApePair_Sync_event

ApePair_Transfer_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​ApeFactory_PairCreated_event

​ApePair_Burn_event

​ApePair_Mint_event

​ApePair_Swap_event

​ApePair_Sync_event

​ApePair_Transfer_event

Tables

ApeFactory_PairCreated_event

ApePair_Burn_event

ApePair_Mint_event

ApePair_Swap_event

ApePair_Sync_event

ApePair_Transfer_event