pangolin_v1_avalanche

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
0xefa94de7a4656d787667c749f7e1223d71e9fd88	0x5e5b4008248cd43b9f8277db23647a2763cf48f2	false	2943	0x7b2ac2b1d8d9abfb95570c1389ca3750cf180fc2	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	10	12274621	2022-03-18T18:40:00.000Z	0x2f857b37edebfe18416faa64e7dbe8d4b41f5f9c90d04885ae48825d7bf7c109
0xefa94de7a4656d787667c749f7e1223d71e9fd88	0xa09484eb2e6846bd622b5590138e3c1878cbc620	false	2944	0x6b41673feff1bf0b55ba2c9f4bf213b2be8f474d	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	9	12275898	2022-03-18T19:24:34.000Z	0xa4adf049a43fcaf74a2af6b77a4a346d5270cbc1cf88fae17efb62960972692d
0xefa94de7a4656d787667c749f7e1223d71e9fd88	0x1980901cb3dddfee5f19241996e59c7108625473	false	2942	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	0xe161c2e49b398253275cd918fe620e3ade1b61ea	49	12272860	2022-03-18T17:39:26.000Z	0xebd64577c7954069458d22231737146abe0fc10dd17e18ed40b36fa0a30fbef7

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pangolin_v1_avalanche.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
0xe54ca86531e17ef3616d22ca28b0d458b6c89106	0x17a2e8275792b4616befb02eb9ae699aa0dcb94b	false	0xe54ca86531e17ef3616d22ca28b0d458b6c89106	5	24802113703567806445	733160928794094791503	861236	2021-03-30T21:34:08.000Z	0x66e03bb1c10002b9823d062784ab5bfd9352edc0fea1a37a48e76b2fc1d40440
0xe54ca86531e17ef3616d22ca28b0d458b6c89106	0x17a2e8275792b4616befb02eb9ae699aa0dcb94b	false	0xe54ca86531e17ef3616d22ca28b0d458b6c89106	5	2150086675864512544091	64507830315964445760566	853102	2021-03-30T10:46:34.000Z	0xff151dbfb0c5ed25b934ea4a58eabdf9f5431a28ba8745086168931eb842cfe8
0xe54ca86531e17ef3616d22ca28b0d458b6c89106	0x18c8e1346d26824063706242adb391ddb16c293e	false	0xe54ca86531e17ef3616d22ca28b0d458b6c89106	5	91096984322669	17163363062992129757	848634	2021-03-30T04:24:57.000Z	0x846e8f0ddbf18b8b0825534f50899029cc0f524cf303c7b3756f7da033949e7d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pangolin_v1_avalanche.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
0x1938ce0e14dd71caab96f52df3f49b1d1daf8861	false	0x47c5c66be853cc973b64c9487303d69eb146328f	59	197264994200827900	29923967636956434445	31877315	2023-06-27T16:54:45.000Z	0x3af465459a65a04f3fc0d7bbff37bb9b63564f1307adb7a990ae0d60a1d4f3ce
0x1938ce0e14dd71caab96f52df3f49b1d1daf8861	false	0x47c5c66be853cc973b64c9487303d69eb146328f	24	197262675393812935	30792409877778994641	31855675	2023-06-27T04:38:54.000Z	0x641a3ce04e7fa569a38dd69051dcc6b5cf64f653e61d99dbdd719497b47b64bd
0x381cc7bcba0afd3aeb0eaec3cb05d7796ddfd860	false	0xb34fe8a87dfebd5ab0a03db73f2d49b903e63db6	57	823763995040200967150	562618095595952002	31876768	2023-06-27T16:36:07.000Z	0x185784df588490da2fc7cf55f7be471aae883f8a76b771d97a77df12ccb54eef

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pangolin_v1_avalanche.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
0x8cc553fd466fd2c163bcda9a24d354f63318d20d	0x01453e33819c732bf0f51863ca4b5ba15d565e65	false	0xe54ca86531e17ef3616d22ca28b0d458b6c89106	58	11042212	91948299738602552	8490000000000000000	2022-02-17T15:11:36.000Z	0x63e3393429e62b7ddea68ff7344016fbfb5fc324647e725618ad0844ed53683c
0x05c114d3a67eb94777d00e6cbe309e2a1ede1fb7	0x04d80d453033450703e3dc2d0c1e0c0281c42d81	false	0xe54ca86531e17ef3616d22ca28b0d458b6c89106	133	11028085	1959105712361805231	18405664938089351479296	2022-02-17T07:09:25.000Z	0x1bbc8b250811d92ecf70ceffaaf05f508c3284b2227ef22b2904625fc7186a96
0x05c114d3a67eb94777d00e6cbe309e2a1ede1fb7	0x04d80d453033450703e3dc2d0c1e0c0281c42d81	false	0xe54ca86531e17ef3616d22ca28b0d458b6c89106	93	11047827	2455936876451524874	22655507097292204146688	2022-02-17T18:26:13.000Z	0x7a47f869725df0a5815a8cd4e6aa62ebfab8832c5ced5129987f2127ee4a4a08

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pangolin_v1_avalanche.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
0xe44ef634a6eca909ecb0c73cb371140de85357f9	false	35	235657865648157747061714	584426219414362995569	8323584	2021-12-16T18:06:42.000Z	0x7e551dea71ff6279d7c78dfaa8da91022867ad41480579665011585e5bebc38b
0xe44ef634a6eca909ecb0c73cb371140de85357f9	false	30	238360027898748795905967	577781177662231205540	8323584	2021-12-16T18:06:42.000Z	0xa03e25add72ea7883271d863787f91e50eec9b247ed9eee4132a61cbeab55f31
0x5764b8d8039c6e32f1e5d8de8da05ddf974ef5d3	false	12	12640173575	58425564382471983795422	8323840	2021-12-16T18:15:25.000Z	0x410f3a8088df4d52647641a9475a7f2e44acaa2d8a32761ece498a3d1885ea43

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pangolin_v1_avalanche.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	log_index	block_number	block_timestamp	transaction_hash
0xc9a51fb9057380494262fd291aed74317332c0a2	0x0025cebd8289bbe0a51a5c85464da68cbc2ec0c4	0x47f884e0bfc0e56ecdc581e2774efec12874f7fd	false	323	2427011	2021-06-23T11:24:10.000Z	0xc1983d36e7eb2c38956e9cc67ff00dcbd65b6cd7ab028495ab46551f941cccf1
0xc9a51fb9057380494262fd291aed74317332c0a2	0x0025cebd8289bbe0a51a5c85464da68cbc2ec0c4	0x47f884e0bfc0e56ecdc581e2774efec12874f7fd	false	294	2432757	2021-06-23T21:59:50.000Z	0xfa52bac3be64a84eca3eac2b5dc1ac41e24a2b21fa402593b1f693674d5eb4e2
0xc9a51fb9057380494262fd291aed74317332c0a2	0x0025cebd8289bbe0a51a5c85464da68cbc2ec0c4	0x47f884e0bfc0e56ecdc581e2774efec12874f7fd	false	266	2421763	2021-06-23T00:47:11.000Z	0x33da472a9ff34b375afdbfcf23868d96a3816efa80d22baa7113712c8e8fbf44

Example Query

Query with partition filter

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