sushiswap_v1_bsc

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	0x57fd34afad11785148ee1250cb4ece8fd7bc23d8	false	209	0x14357d294fbabbe0fbf59503370c772d563b35b6	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	274	7468410	2021-05-16T20:10:14.000Z	0x83abad8db6bb557889cda8f433e4f9f28b4816e6ef6a5186d1adf1548ae26937
0xc35dadb65012ec5796536bd9864ed8773abc74c4	0xd9b831d49af996da0948da07bc5ad86d6a8f56b5	false	202	0x1d2f0da169ceb9fc7b3144628db156f3f6c60dbe	0xf5b702b819c77019fc987d7f37f047ede59fd111	576	7453111	2021-05-16T07:11:28.000Z	0x193cc826116a4cd107af1cf46dcaa1a269592e5fd8e8ce8d7ecc8838fd9bd70b
0xc35dadb65012ec5796536bd9864ed8773abc74c4	0xa36c84e2f1205065c2e62bf0894b6c5359455b4d	false	210	0x1f546ad641b56b86fd9dceac473d1c7a357276b7	0xe9e7cea3dedca5984780bafc599bd69add087d56	276	7472520	2021-05-16T23:37:05.000Z	0x3b3ea987f2b16b0a3300f94db94ecb69b1a8ca725b2656023cf04e8b0cfeddc1

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v1_bsc.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
0x09a238890ea8a1c48410e04075d8d2695fc78cc0	false	175	14456576000000000000000	14456576	20973688	2022-09-02T06:52:18.000Z	0x32af0db596588274086bdceebdcaf5a8be44d5315e3db4714728e9dcedcb8f21
0x09a238890ea8a1c48410e04075d8d2695fc78cc0	false	364	4628915925972411344979863	8624924	20973733	2022-09-02T06:54:33.000Z	0xb00c17b7b6929c0131a656a55b7bff82db80e704a385e0bd45421751827f9ed5
0x09a238890ea8a1c48410e04075d8d2695fc78cc0	false	117	8922441531148203819470101	16624924	20973763	2022-09-02T06:56:03.000Z	0x4041e356aaa521a2b565126628d46bdb7dd5a8b19f39d9c5722cd7425b45c4fa

Example Query

Query with partition filter

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