pancakeswap_v2_arbitrum

Tables

Factory_PairCreated_event

Decentralized exchange (DEX) liquidity pool creation events emitted by Automated Market Maker (AMM) factory contracts. Records new trading pair deployments with token addresses, deployed pair contract address, and creation sequence number for tracking pool instantiation across DEX protocols.

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
0x02a84c1b3bbd7401a5f7fa98a384ebc70bb5749e	0x9601cef4487c96453cd7037a71b300855a36d6a5	false	263	0x75c5f6d32d8ef3a4f0f43f7792aa08e8678972f9	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	27	204216544	2024-04-24T04:01:44.000Z	0x793b0d5139b1faa1d7d8fd63add532ea973807734ea4162442afefbe4c471542
0x02a84c1b3bbd7401a5f7fa98a384ebc70bb5749e	0x9fa100f757a36a49280cb22cc41deb9274ec04cf	false	262	0x526bcb36e138c7bbc8c5c2cf20fe3a4398b6ebf1	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	15	204206932	2024-04-24T03:20:46.000Z	0x00806593a4d5b0ef581d3156b4efb4463152863389ffee8a05ff7db5f718aada
0x02a84c1b3bbd7401a5f7fa98a384ebc70bb5749e	0xe72f68f34e544581a0b427aaea8df6bc33b49b92	false	163	0x63edd0ba5dcbad53a0ef95e90396f9ab53f56121	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	2	175207612	2024-01-29T00:14:29.000Z	0xe97fe3974d9d9eca7b14159ecaf436a26a4759533396c6e0cb1f971d158a721c

Example Query

Query with partition filter

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

Pair_Burn_event

Liquidity removal events from DEX (Decentralized Exchange) trading pairs recording amounts of both tokens withdrawn when liquidity providers burn LP tokens. Used for tracking liquidity provision activity and calculating total value locked (TVL) changes in automated market maker (AMM) 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.
`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
0x354152f58c06291f1c689f7ee58294471ed4fa7b	0x29bb566b8aef8b961d6aa90ee28a6889bc94f5d9	false	0x8cfe327cec66d1c090dd72bd0ff11d690c33a2eb	6	68842201862058630456	42549862	289199446	2024-12-27T16:14:46.000Z	0x764026a1507b33d48230b88554338c9a3bbafc339430ddf45275654661a68d51
0x433749a9b501641104ec03b4a7da9b922ccb29b0	0x29bb566b8aef8b961d6aa90ee28a6889bc94f5d9	false	0x8cfe327cec66d1c090dd72bd0ff11d690c33a2eb	8	27826505162199100385	16307432	289263044	2024-12-27T20:41:06.000Z	0xe16b0bb6e7790c4c4eaee4267f5114c9f38a120a0898e784512075e3eef76548
0x5199ae1e5d748ef80a20fe13b2b342d2b34c2464	0x9f0c2ed0b9faffa260cd35d76c4d96bafa406740	false	0x8cfe327cec66d1c090dd72bd0ff11d690c33a2eb	11	5391445570379905095981	49230526775829327908	289186613	2024-12-27T15:21:16.000Z	0xab13fa995ea3e53e0d8f3ed7b7315ef5c672b9817d4ca97932393eab8fa58545

Example Query

Query with partition filter

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

Pair_Mint_event

Liquidity provision events emitted when users add tokens to a DEX pair contract. Records sender address and token amounts deposited for liquidity pool operations.

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
0x6c3f668617915ccd07279b5c6c6878b108b0bd22	false	0x8cfe327cec66d1c090dd72bd0ff11d690c33a2eb	6	1090300717088420900008752	8519126221875000	140849995	2023-10-15T15:46:58.000Z	0x21eb2e727c564d8ecba6d8d8fffda92b00587547e9ee77da46a4089f000b0847
0x6c3f668617915ccd07279b5c6c6878b108b0bd22	false	0x8cfe327cec66d1c090dd72bd0ff11d690c33a2eb	7	726913703349795874493253	5679417481250000	140847354	2023-10-15T15:34:15.000Z	0x71a0659ef25023b3a80e4ebece5f719dccf1d47caf71e804172cc0e87950e519
0x6c3f668617915ccd07279b5c6c6878b108b0bd22	false	0x8cfe327cec66d1c090dd72bd0ff11d690c33a2eb	7	2896487404149152113168062	20000000000000000	140728875	2023-10-15T06:03:47.000Z	0xc87c129bdc9390690f486bdfa45444b51099c7e99e36be3bc30448af85fe846d

Example Query

Query with partition filter

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

Pair_Swap_event

Token swap events from decentralized exchange (DEX) liquidity pairs recording input and output amounts for both tokens. Primary source for tracking DEX trading activity and price discovery.

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
0x0d39d54ce32eb8690c9eb2c76ea092897e478e9b	0x06c409738c1769f9b169488f7d3ca7fe5c14d277	false	0xf2614a233c7c3e7f08b1f887ba133a13f1eb2c55	5	275059949	105662	175746336662513601	2024-11-16T12:03:37.000Z	0x783a88a90504ba079ee789b0fed1201aa2ee0d7151bfb19508dc10f792786792
0x63c9282f2d72aeb221c4a5f2db10dfb900a4cba9	0x06c409738c1769f9b169488f7d3ca7fe5c14d277	false	0xf2614a233c7c3e7f08b1f887ba133a13f1eb2c55	3	275099443	100968	158250340066348966	2024-11-16T14:48:52.000Z	0x7764180718bb77bd94adf613307754312f90ea2bf18e243856832ecec92af38f
0x7db09b248f026f1a77d58b56ab92943666672968	0x06c409738c1769f9b169488f7d3ca7fe5c14d277	false	0x9fa9360de03205130e52f669bf4ca8c80a3b59fb	6	275185397	246870	351792280149403916	2024-11-16T20:48:57.000Z	0xffa5fd09dcd9c6a7ba35f7e5c0b281e5b775e3717caa697598e9cb19dffb3f06

Example Query

Query with partition filter

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

Pair_Sync_event

Liquidity pair reserve synchronization events emitted after each swap, mint, or burn operation. Contains updated reserve balances for both tokens in AMM (Automated Market Maker) pools, enabling real-time price calculation and liquidity tracking.

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
0x0d39d54ce32eb8690c9eb2c76ea092897e478e9b	false	262	40037160497562940	90676043656158547234	198159389	2024-04-06T10:42:30.000Z	0x124e027b77a15fb0f8d3953f44153e9056158b3f2dac07b62d414ed17eaffab7
0x0d39d54ce32eb8690c9eb2c76ea092897e478e9b	false	164	40137017239957163	90451013976346187746	198174779	2024-04-06T11:46:49.000Z	0xcb8a584b20b31cf97d5d407193f02a440978f78287d8adb29d02f27a696023f6
0x0d39d54ce32eb8690c9eb2c76ea092897e478e9b	false	61	40148009523415788	90426310928364070435	198175481	2024-04-06T11:49:45.000Z	0xd667381021ed952d73ab9a01c7655d981736d0ac236c35c5d84fc00d515a03f5

Example Query

Query with partition filter

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

Pair_Transfer_event

ERC20 Transfer events emitted by liquidity pair contracts in automated market maker (AMM) decentralized exchanges (DEXs). Records minting, burning, and transfer of LP (liquidity provider) tokens representing ownership shares in trading 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_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
0x0000000000000000000000000000000000000000	0x0d39d54ce32eb8690c9eb2c76ea092897e478e9b	0x0000000000000000000000000000000000000000	false	1000	5	120045156	2023-08-10T13:28:04.000Z	0xe77e85281781711dede22fa8e33a5e0b8fe8d8e1305ca1f2354fd624d8049f0e
0x2015e3179220262c4b15d48698d9b6d4fbff0d04	0x0d39d54ce32eb8690c9eb2c76ea092897e478e9b	0x0000000000000000000000000000000000000000	false	50277430324151406	6	120045156	2023-08-10T13:28:04.000Z	0xe77e85281781711dede22fa8e33a5e0b8fe8d8e1305ca1f2354fd624d8049f0e
0x6a738c309beac3c68ef8f50f3c5880c97dbc7726	0x513e300932ffb76f12b33d07e2711b8e0c59fc7c	0x0000000000000000000000000000000000000000	false	999999999000	4	120119209	2023-08-10T18:52:14.000Z	0x775971687c71ca24eb5062253e879fb599517e63ac7680d8cb51a505fe896c84

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Factory_PairCreated_event

Pair_Burn_event

Pair_Mint_event

Pair_Swap_event

Pair_Sync_event

Pair_Transfer_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Factory_PairCreated_event

​Pair_Burn_event

​Pair_Mint_event

​Pair_Swap_event

​Pair_Sync_event

​Pair_Transfer_event

Tables

Factory_PairCreated_event

Pair_Burn_event

Pair_Mint_event

Pair_Swap_event

Pair_Sync_event

Pair_Transfer_event