sushiswap_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
0xc35dadb65012ec5796536bd9864ed8773abc74c4	0x0ca0ff7eaae72faab1df7e1a1c0afcf7d0a68dfd	false	291	0x49d5c2bdffac6ce2bfdb6640f4f80f226bc10bab	0x63a72806098bd3d9520cc43356dd78afe5d386d9	24	17834329	2022-07-26T16:53:56.000Z	0xaad22d9834ce83ed8c65cdeff42f1268cf0c7e4a2ae7ff38302e9a6feff33933
0xc35dadb65012ec5796536bd9864ed8773abc74c4	0x865e0fdb87175ba6f5e8e8b0a07c75bb193f1d07	false	290	0x63a72806098bd3d9520cc43356dd78afe5d386d9	0xd586e7f844cea2f87f50152665bcbc2c279d8d70	8	17834236	2022-07-26T16:50:43.000Z	0x7044e31ca31bb4c1b6335ba4c7c74a9d6fe153c418b863e5c452aeba73f934f2
0xc35dadb65012ec5796536bd9864ed8773abc74c4	0xb21c04afb2a23585877d7a6bc39bf4433c785f83	false	382	0x912b6d678cc7e7ec78f56f7d7c463450ea9c1f14	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	4	26236895	2023-02-14T07:01:51.000Z	0xaf916cc64bcaf8a01b3c5837b615f60f4f4a1cfdcdd08ede206384c0aa0c3b10

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v1_avalanche.Factory_PairCreated_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
0x459eb852799057912138519eab28c8e0c227c42c	false	4	9260022759	9259842207556357541684	28159708	2023-04-01T02:04:31.000Z	0x25ead4c150fbb306a2d165b4b63c0d81eb62ecc82a771a92438268436aa297a6
0x3730c99811fea9ca1dd977ddd6d3b80f8a0bebea	false	5	646958780099233343742	144572611578318864	28192255	2023-04-01T20:17:54.000Z	0x9eb35977d84720d59330d0cffe9b8ea926ce3cc4b4502d7cb14543722c6ce1a3
0x3730c99811fea9ca1dd977ddd6d3b80f8a0bebea	false	5	649858780099233343742	143929382001748583	28192276	2023-04-01T20:18:36.000Z	0x5352b2acc5c33b260a4a40e2fc500ce747a54391cd26a0ab46b94e3a9ac48b8e

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Factory_PairCreated_event

Pair_Sync_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Factory_PairCreated_event

​Pair_Sync_event

Tables

Factory_PairCreated_event

Pair_Sync_event