sushiswap_v2_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
0xc35dadb65012ec5796536bd9864ed8773abc74c4	0x393fdeb9eb0c190372969e5f10a8b86e70609959	false	111	0x03943c3ef00d92e130185cebc0bcc435def2cc94	0xc7198437980c041c805a1edcba50c1ce5db95118	30	8666313	2021-12-24T19:12:35.000Z	0x7c09954ff6834c7487b65fea6be5d7a4fa4173d0232b165c43fb6b83d4c9383e
0xc35dadb65012ec5796536bd9864ed8773abc74c4	0x37bb7fe11a2620cbf30f2a534a763605920e16fe	false	109	0x130966628846bfd36ff31a822705796e8cb8c18d	0xce1bffbd5374dac86a2893119683f4911a2f7814	129	8645384	2021-12-24T07:23:46.000Z	0xb248e5436aa661352bace10b36e0f7aab0b5762590e86c9a8984c528c1d53c68
0xc35dadb65012ec5796536bd9864ed8773abc74c4	0x5ecfca21f29366ab9e8e1f2c7de56cdb96037c21	false	110	0xa7d7079b0fead91f3e65f86e8915cb59c1a4c664	0xdef1fac7bf08f173d286bbbdcbeeade695129840	77	8647486	2021-12-24T08:35:13.000Z	0x1744dd173f6b5bff95b637a03b6d2a508e397bb9e0e280b26356560069be2b69

Example Query

Query with partition filter

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

MiniChef_Harvest_event

Reward claims from MiniChef staking contracts emitted when users harvest accumulated incentive tokens. Contains pool identifier, user address, and harvested token amount for tracking yield farming rewards across liquidity mining programs.

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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_pid`	`STRING`	Pool identifier referencing a specific staking or liquidity pool within the protocol. Numeric string representation of the pool ID.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	in_user	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash
0xe11252176cedd4a493aec9767192c06a04a6b04f	0x30ce132bb163b1189a8eaa07a3891ea78b91c677	false	0	7	36510765	2023-10-16T05:59:59.000Z	0x1ed727b6a070a1163f291179d4655d207bdfb7af158a1610a7143b5c6444ed80
0xe11252176cedd4a493aec9767192c06a04a6b04f	0x30ce132bb163b1189a8eaa07a3891ea78b91c677	false	0	4	36510729	2023-10-16T05:58:46.000Z	0xa226d2462b89c57696c92ff7f5d98a36ecaabf8a015dfa6158a52acbdc5a723c
0xe11252176cedd4a493aec9767192c06a04a6b04f	0x311169d5a8164230426ac11e655c4c4e793edcf4	false	23643233277677631065	12	34177569	2023-08-20T23:57:39.000Z	0x5fe5ee91676c8d1f087dca374ac1498e033d23868d43fd2262ce9947a60ad636

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v2_avalanche.MiniChef_Harvest_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
0x1b02da8cb0d097eb8d57a175b88c7d8b47997506	0x09657b445df5bf0141e3ef0f5276a329fc01de01	false	0x1b02da8cb0d097eb8d57a175b88c7d8b47997506	33	5192407456285066800	483460162	9497897	2022-01-13T03:31:54.000Z	0x4f35c0a7ba3314b0f5f0d8d85ffb48d28de6dd6246fdf8744fffe954da4ee102
0xef65f6cc8acd21cf16812dcbbfcbcbb3566b1b9e	0x24f01f3dcdee246567029bce8830a866c9cd2b1e	false	0x1b02da8cb0d097eb8d57a175b88c7d8b47997506	46	260518973963712456527	2134920024898624654958	9515376	2022-01-13T13:13:32.000Z	0x8d92168b02139411aaac20f2af674608c01e93b2f0c308a2b9c9075b5415a051
0x1b02da8cb0d097eb8d57a175b88c7d8b47997506	0x3e105e5acb4dab409fb365ba72d7793210ae6e59	false	0x1b02da8cb0d097eb8d57a175b88c7d8b47997506	58	343969800065386	364298976836094716	9505842	2022-01-13T07:55:52.000Z	0x43c61bbd8807be5aff38e0e4621b9109127eea8b5d272888508c8916f98ba13b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v2_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
0xd74ac622819f10a04958f58af16f1c62b1f50a99	false	0x1b02da8cb0d097eb8d57a175b88c7d8b47997506	9	9138436156530520513556	18819272	24835041	2023-01-12T07:14:48.000Z	0xf92125072dcf43a747f17b86348207f4a6858c9cda5a56818491da9754d5c9bd
0x09657b445df5bf0141e3ef0f5276a329fc01de01	false	0x1b02da8cb0d097eb8d57a175b88c7d8b47997506	36	38551843237853639	1254011	14825002	2022-05-17T18:42:07.000Z	0x9c7b4e2a977a33956caa9c20e40e9edc5d074985839cf9ba956404aca7bcce0a
0x29488375275ebb2dfb09c1e5d6119d677606da7b	false	0x1b02da8cb0d097eb8d57a175b88c7d8b47997506	15	17131288031187001242	313373686415912450	14821163	2022-05-17T16:34:47.000Z	0x53082ef530d30d394edccac521c79d5a6f2f190f2cbc64b3dd4489b1418c9a15

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v2_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
0x033c3fc1fc13f803a233d262e24d1ec3fd4efb48	0xe5cddbfd3a807691967e528f1d6b7f00b1919e6f	false	0x457479a045eaf015ea074c8812d0e03bf50aa964	7	28233900	6218925443484218585011	5558993320703043209315	2023-04-02T19:39:18.000Z	0xf52325fcb64424a53fc6d489b4a660f19b5b62005c39141abae9d1fb3ace66ad
0x033c3fc1fc13f803a233d262e24d1ec3fd4efb48	0xe5cddbfd3a807691967e528f1d6b7f00b1919e6f	false	0x457479a045eaf015ea074c8812d0e03bf50aa964	6	28230176	5750057743436402934271	6009950647995092166134	2023-04-02T17:33:31.000Z	0x4c4ee3c5004f2202be355e4e430b58226012ee6828e99c45c1ffe6e9cdd9e26e
0x033c3fc1fc13f803a233d262e24d1ec3fd4efb48	0xe5cddbfd3a807691967e528f1d6b7f00b1919e6f	false	0x457479a045eaf015ea074c8812d0e03bf50aa964	6	28230327	13310115540309011391187	12418383661413205299345	2023-04-02T17:38:36.000Z	0x176f373924241f3fc709b48b3944a8ae610b95624d27171a4a0537d11b56b6cb

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v2_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
0x204ae948fae55288b39c24fb3132ef69c5ec26f2	false	2	481728713193738148	4243237	5471817	2021-10-10T20:34:51.000Z	0x9c6c804042671693174011ddad555ae5f4ec438d359af8f0fa9a325337c13539
0x2fde1c280a623950b10b6483b9a0c23549c9b515	false	2	58912358703530671	3543414645537819508	5442160	2021-10-10T03:47:32.000Z	0x90f7054cd866149934dccab5e0299ed27bff3cc536507bef1070db32a6c8059a
0x09657b445df5bf0141e3ef0f5276a329fc01de01	false	3	8744783177401753932	518678332	5459796	2021-10-10T13:45:11.000Z	0x60c337d70547f0932ac46e002f9acc29242de771f2d82b93dac934b0dcb69747

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v2_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	in_value	log_index	block_number	block_timestamp	transaction_hash
0xb9a4266432781ce018fc2ee68d25d9b1563ddfef	0x0fe8cc7d92cc882a59f86235cc99be6bea9a740d	0x0000000000000000000000000000000000000000	false	31622775601	6	8239204	2021-12-14T19:04:13.000Z	0x50633dd9744e5705b3cdebec61f4890a9fbf2b555ad0f038336828786ba76ed8
0x0000000000000000000000000000000000000000	0x0fe8cc7d92cc882a59f86235cc99be6bea9a740d	0x0000000000000000000000000000000000000000	false	1000	5	8239204	2021-12-14T19:04:13.000Z	0x50633dd9744e5705b3cdebec61f4890a9fbf2b555ad0f038336828786ba76ed8
0xd05a0582d44e094a35e91701f45392940006013c	0x2fde1c280a623950b10b6483b9a0c23549c9b515	0x0000000000000000000000000000000000000000	false	14247915971754648	24	8245034	2021-12-14T22:16:42.000Z	0x2227894b683d468473cb053f1c948a66a1164ce7558e48d7b4542056728ebb63

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Factory_PairCreated_event

MiniChef_Harvest_event

Pair_Burn_event

Pair_Mint_event

Pair_Swap_event

Pair_Sync_event

Pair_Transfer_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Factory_PairCreated_event

​MiniChef_Harvest_event

​Pair_Burn_event

​Pair_Mint_event

​Pair_Swap_event

​Pair_Sync_event

​Pair_Transfer_event

Tables

Factory_PairCreated_event

MiniChef_Harvest_event

Pair_Burn_event

Pair_Mint_event

Pair_Swap_event

Pair_Sync_event

Pair_Transfer_event