sushiswap_v1_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
0xc0aee478e3658e2610c5f7a4a2e1777ce9e4f2ac	0xe5dab4f3a526b6199fd7002765ed9aca41a3c47c	false	3251	0x396bd4f97ed0eee711ff237aed3ebf9a893e7fa5	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	249	15710389	2022-10-09T11:58:23.000Z	0x184e8a90b830bedd76e8a2c9ac83ad4aee98a8f2f08ac44fcc38ee03b912cde6
0xc0aee478e3658e2610c5f7a4a2e1777ce9e4f2ac	0x0646583be34b133ce5d247f1d94e7effe32b58d0	false	3253	0x0fd034abd916842c17c89bae7b1ec696e1c104a9	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	353	15713391	2022-10-09T22:02:11.000Z	0xc6429f920351f390b392a64b76d847167a46ccd7b30eb1447ed3da0b8f77e373
0xc0aee478e3658e2610c5f7a4a2e1777ce9e4f2ac	0x1b2273311ab410d11168b8df242b8b79d8bfcdb5	false	3252	0xca83bb94f7ec0e72e8b496ac236146a74a567c2f	0xe0b9bcd54bf8a730ea5d3f1ffce0885e911a502c	340	15710641	2022-10-09T12:48:59.000Z	0x37ac1f9c6dbc68a35217edbab9e0d2c657fe2c9c73e725373a386a1a361fa191

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v1_ethereum.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
0x001b6450083e531a5a7bf310bd2c1af4247e23d4	false	81	354771809627638415873822	4620296900222598786786	11480431	2020-12-19T00:27:20.000Z	0xb439e916622bf756c7f48516d8272f6b913d5c416a9e53d2b1049270a729f849
0x001b6450083e531a5a7bf310bd2c1af4247e23d4	false	35	352331310105486165263842	4652427695617434446276	11480783	2020-12-19T01:43:16.000Z	0x3253d372d13d27d23fc6a9b943ccf53540b50b4d42170d7da61a425005074006
0x001b6450083e531a5a7bf310bd2c1af4247e23d4	false	2	370085607511366729280971	4436084317160775209504	11485493	2020-12-19T19:06:16.000Z	0xe4be7809d031d3aa78fab95239d636fe521947d2ce91de3aa07e7267ff416696

Example Query

Query with partition filter

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