apeswap_v1_arbitrum

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	0x488a565e7d2335239692671c1d58738473ebd1ed	false	88	0xb1084db8d3c05cebd5fa9335df95ee4b8a0edc30	0xe80772eaf6e2e18b651f160bc9158b2a5cafca65	0	266938731	2024-10-23T20:56:00.000Z	0xd433354b4a82362de3894987445c9b45bed3621a171f6c0c13ffcc955c29fb56
0xcf083be4164828f00cae704ec15a36d711491284	0xdb2a78e81a52b282752e34b31565bf22ea56fc0e	false	71	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	0xa991db13d5898f179988746db52a684945574641	1	82926346	2023-04-21T23:00:59.000Z	0x934ca9ffceb50b2e166ff979e2691500fde5b6a09170487771685b165f4fe576
0xcf083be4164828f00cae704ec15a36d711491284	0xc7c85d00ff61d17152e4207139cd505f91e55d12	false	42	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	0x9084ac1bd7d480700c78cb2bc6d84a84f124d962	0	72357927	2023-03-22T04:59:17.000Z	0x981e9a23b6b68c9372ed213f577ac8401f5002969fe050f7e3c687df6cfa7155

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.apeswap_v1_arbitrum.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
0x2f0316de92e26487fef5fd210abc70439cd02b20	0xb8fcc49ecc9206dabb48b28ecbcfd31d5c6346d1	false	0x7d13268144adcdbebdf94f654085cc15502849ff	5	116748831878987590	767386622369597141222	89747666	2023-05-11T23:13:55.000Z	0x6927002beb13c4d104a98f90e38fccceb6bdd3275b964ec307dcb964eee291c4
0xd842a1f6b5f0b89c72eda2601e26b21be690a966	0xb8fcc49ecc9206dabb48b28ecbcfd31d5c6346d1	false	0x7d13268144adcdbebdf94f654085cc15502849ff	6	317022536822698479	2083779767489023213470	89718795	2023-05-11T21:12:57.000Z	0xb4bb8c9946bc6e2d4cbf93576b53c7f3126ad0278a17cc14e6a65102619cea44
0x840c284c4c4531ac7ba11c147b995ad70269e01d	0xb8fcc49ecc9206dabb48b28ecbcfd31d5c6346d1	false	0x7d13268144adcdbebdf94f654085cc15502849ff	6	67125814496535380	438593078101021211512	89685137	2023-05-11T18:52:56.000Z	0xce8bc6ee0d8cb434ac5861771b6934c4aeff7b7b0e86fbd62f6ef31f289a8619

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.apeswap_v1_arbitrum.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
0x29a53c0df64c63d06b1bd8696e66654fdd48bc2a	false	0x7d13268144adcdbebdf94f654085cc15502849ff	6	266542341129664318420	143015440073850374	77660678	2023-04-06T14:16:00.000Z	0x199a5f5e9d18bc3403575d024b1b94e6140f80fe1a9079948d37e7bd39de50b5
0x63c9282f2d72aeb221c4a5f2db10dfb900a4cba9	false	0x7d13268144adcdbebdf94f654085cc15502849ff	6	171248104635949501657	205566898	77765948	2023-04-06T21:38:44.000Z	0x6b053ae7d87baf517b7e87b7b533806358b44d6e5dbedf68e327ec70969fc611
0xf643500a0115ae0151f58ee58aa8c271f8f535d6	false	0x7d13268144adcdbebdf94f654085cc15502849ff	7	7200000000000000000	9904314	77486673	2023-04-06T02:12:45.000Z	0x072e0f686e4e65b27707cac8e13dcd6a5bc774a48b3da333ddc19a287bc739b3

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.apeswap_v1_arbitrum.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_amount1In	in_amount0Out	in_amount1Out	block_timestamp	transaction_hash
0x00000000049c95d6b6002a72c222809bfbfe2ed8	0xc09c5b1420f33ba6557789f15ce6e1eb9af1d31a	false	0x00000000049c95d6b6002a72c222809bfbfe2ed8	13	156949805	12770559716995086299337	0	0	20815541455974166	2023-12-05T00:12:03.000Z	0x4957d32eff9a63aceb92c003fa5de5cb5f0ac93a7951361e9826b2e136db5e41
0x00000000049c95d6b6002a72c222809bfbfe2ed8	0xbeb125e43b46f757ece0428cde20cce336af962e	false	0x00000000049c95d6b6002a72c222809bfbfe2ed8	19	156949805	20179886660386815	0	0	45829376	2023-12-05T00:12:03.000Z	0x4957d32eff9a63aceb92c003fa5de5cb5f0ac93a7951361e9826b2e136db5e41
0x00000000049c95d6b6002a72c222809bfbfe2ed8	0x957a8b5762a9c7da273c3b42b70459383753a70e	false	0x00000000049c95d6b6002a72c222809bfbfe2ed8	16	156949805	0	45829375	12770559716995086299338	0	2023-12-05T00:12:03.000Z	0x4957d32eff9a63aceb92c003fa5de5cb5f0ac93a7951361e9826b2e136db5e41

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.apeswap_v1_arbitrum.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
0x1713f5d04a741a2dd2d026ce7cab5614a499e1c0	false	26	898308251579903106	1560468166963000733287	186280112	2024-03-02T07:48:48.000Z	0x39d37a4b4b703094f069eb079730a2663b550cd8484522e01e7aec5985bcd539
0x1713f5d04a741a2dd2d026ce7cab5614a499e1c0	false	17	903631861048603960	1551320387538425973273	186442189	2024-03-02T19:22:47.000Z	0x35a3f2c34e2fa3f65a7b37fd3490d17348c93e164f1478971b14904663226aac
0x1713f5d04a741a2dd2d026ce7cab5614a499e1c0	false	6	901488227871843374	1555001867589081987180	186427889	2024-03-02T18:19:22.000Z	0x6e654119451466d04bf160cc584bb58926a4b32dcac6ce4bea4895996b367489

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.apeswap_v1_arbitrum.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
0x5ed78bbd113c42647ec1449542c8c2eb497a8c54	0xe2f6d9d96d1c046aa8e9e9604c7fe5a41c32e48f	0xf9c83ff6cf1a9bf2584aa2d00a7297ca8f845cce	false	12200000	1	138323752	2023-10-07T06:28:52.000Z	0x13eb1f11c214c4459e7561b803752fc56a99c62b0cd3d9e536ae0aee75bc00b9
0xb8fcc49ecc9206dabb48b28ecbcfd31d5c6346d1	0xb8fcc49ecc9206dabb48b28ecbcfd31d5c6346d1	0xfb9ada6f22429b2501b5f5b87a5d7ed7181edf1d	false	6704025053137799906	0	91133313	2023-05-16T02:22:10.000Z	0x3242df3c2ed765798942beabdf67ed3b59229e5f3eabb0b0ae7b5d1743158576
0x0000000000000000000000000000000000000000	0xb8fcc49ecc9206dabb48b28ecbcfd31d5c6346d1	0xb8fcc49ecc9206dabb48b28ecbcfd31d5c6346d1	false	6704025053137799906	2	91133313	2023-05-16T02:22:10.000Z	0x3242df3c2ed765798942beabdf67ed3b59229e5f3eabb0b0ae7b5d1743158576

Example Query

Query with partition filter

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