pancakeswap_v2_ethereum

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
0x1097053fd2ea711dad45caccc45eff7548fcb362	0x15d2fdd9366cbe9b3530cfabb65ccd7c538a42c9	false	202	0x136210a5c79d2435432e443f7155d9d83600ac70	0xdac17f958d2ee523a2206206994597c13d831ec7	282	16141887	2022-12-08T18:49:47.000Z	0x47ea5f2093bc01826ceea7c20eadcc598e12fbd07278773856839e7c2e6216e8
0x1097053fd2ea711dad45caccc45eff7548fcb362	0xc46fb4d887d857cce1c6f1b1f219f3dd5bd4a155	false	201	0x7cc02e47d6b38e1e42a5c6824e58b0fd66638ff2	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	366	16141468	2022-12-08T17:25:23.000Z	0x719c975481ab621d53f4031667d45594d5ee2189a2a236383ca41d5e9a4c8a11
0x1097053fd2ea711dad45caccc45eff7548fcb362	0x045f347a3661b976f5871552e365b5852076d499	false	198	0xaf08589912134225d26f01185ca5920fe00c19da	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	75	16137545	2022-12-08T04:16:11.000Z	0xe20da7f973df36b3af94dffb586e1349f894b608821003a790dd67eeead10595

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pancakeswap_v2_ethereum.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
0xeff92a263d31888d860bd50809a8d171709b7b1c	0x17c1ae82d99379240059940093762c5e4539aba5	false	0xeff92a263d31888d860bd50809a8d171709b7b1c	164	144146853154813924	239490948	16645829	2023-02-17T03:41:23.000Z	0x413a98fc34bd443b96cb21f8721e23d7dbbfa922c67419b43543083aaf64b41a
0xeff92a263d31888d860bd50809a8d171709b7b1c	0x2e8135be71230c6b1b4045696d41c09db0414226	false	0xeff92a263d31888d860bd50809a8d171709b7b1c	319	495308008	298830946497925225	16646918	2023-02-17T07:21:11.000Z	0x711c20bedeff11496fec035ab7849c49a57378c1a4c7d0f5e5a30a9d36938d6d
0x5d6905438419fd6c3f8a6a2a23cc46494a6819de	0x481e2f30940949cf6a3e0f4617e3d0b16bbb03d1	false	0xeff92a263d31888d860bd50809a8d171709b7b1c	255	668487469251473059985159925	226293670522964786	17964237	2023-08-21T16:17:59.000Z	0xe4e1c311eaffd5aee5e3d4b752cc4e0727cad7e648e125ec0533038699e8799f

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pancakeswap_v2_ethereum.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
0x18b02dbebd40750a83c42ff2f92f04189be55a24	false	0xeff92a263d31888d860bd50809a8d171709b7b1c	238	38044064084644468456054	53999999999999999	17760782	2023-07-24T05:08:47.000Z	0x6ff43210b4223b8350bb839870e907dcd0330ec652c46f4facab582c109dbbe7
0x17c1ae82d99379240059940093762c5e4539aba5	false	0xeff92a263d31888d860bd50809a8d171709b7b1c	236	19019696267528309	23940677	15967991	2022-11-14T11:31:35.000Z	0x5c902e5a4d7258dab199cd20e4e33276f358defaaa39689a4dab8f4993ab3e90
0x17c1ae82d99379240059940093762c5e4539aba5	false	0xeff92a263d31888d860bd50809a8d171709b7b1c	257	395090232298408705	497000000	15967902	2022-11-14T11:13:47.000Z	0xb944ba277e63fe73324cb0a8d85ea48d0016e0d99ef4f8031c628fa5f4e3d75c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pancakeswap_v2_ethereum.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_amount0In	in_amount1Out	block_timestamp	transaction_hash
0x17c1ae82d99379240059940093762c5e4539aba5	0x4ab6702b3ed3877e9b1f203f90cbef13d663b0e8	false	0xeff92a263d31888d860bd50809a8d171709b7b1c	72	16079600	13182	1740118447976839	2022-11-30T01:44:11.000Z	0xc0d2015c14d5f468d9db95f939962d4c10fc545d20a1cb3b5b1b9db424986d8c
0x17c1ae82d99379240059940093762c5e4539aba5	0x4ab6702b3ed3877e9b1f203f90cbef13d663b0e8	false	0xeff92a263d31888d860bd50809a8d171709b7b1c	180	16080039	76683	10198358996382554	2022-11-30T03:12:11.000Z	0x258ea51d0d564469fe7d2d1f2d7b83cf0856b75334c54c3676c8d8053f352f10
0x17c1ae82d99379240059940093762c5e4539aba5	0x4ab6702b3ed3877e9b1f203f90cbef13d663b0e8	false	0xeff92a263d31888d860bd50809a8d171709b7b1c	521	16084872	559675	73698229192939194	2022-11-30T19:24:47.000Z	0x40135a36bff0a112e5fd876ee57ad6e35834684b36dd93d33b6e9ce601531a01

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pancakeswap_v2_ethereum.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
0x130ad3a076269f8c3935b13c9fd202ddcb64c88d	false	88	268510401	45624973670199947280504	16380086	2023-01-11T00:48:35.000Z	0xc587e4a99fae2d9d201bf412bdcd08970c57db8654cd95c174336d431c6434e8
0x17c1ae82d99379240059940093762c5e4539aba5	false	19	1035899397621767524804	1353562805148	16379889	2023-01-11T00:08:59.000Z	0xb6ae05a72cfb476fa2930d5df5877a9a192a5e5391ea9c5978c22def04cc9dc7
0x17c1ae82d99379240059940093762c5e4539aba5	false	363	1028261024077514145081	1363707593319	16384116	2023-01-11T14:18:11.000Z	0x575305b237f9760de31fe85505d212425687bc3a6658c8cfb64580581c6e6e9f

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pancakeswap_v2_ethereum.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
0xd721d05024ce2875a57a6115b12f09c4095c577e	0x17c1ae82d99379240059940093762c5e4539aba5	0x2e71b2688019ebdfdde5a45e6921aaebb15b25fb	false	230444946848	313	16134042	2022-12-07T16:33:23.000Z	0x04981e43000977cc576ea9887c64ee0ebdc88906ad4add4adb41ce14f19f926a
0x99b13581f55db933eb9397b3936803b2c5c726a1	0x17c1ae82d99379240059940093762c5e4539aba5	0x0000000000000000000000000000000000000000	false	93737466072948	261	16131317	2022-12-07T07:18:59.000Z	0x555bac952072298cee983dd196aef6f9b62397de798d1b51d827451e2c60cca3
0x7ff8a32ebb4adf398b0e45c5baf8ccb06cee196f	0x17c1ae82d99379240059940093762c5e4539aba5	0x0000000000000000000000000000000000000000	false	577604088237	260	16131317	2022-12-07T07:18:59.000Z	0x555bac952072298cee983dd196aef6f9b62397de798d1b51d827451e2c60cca3

Example Query

Query with partition filter

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