sushiswap_v1_gnosis

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	0x9cee70f0f2f52c6d6dddc5dfced8e8cc96fbd17d	false	358	0x9c58bacc331c9aa871afd802db6379a98e80cedb	0xdf613af6b44a31299e48131e9347f034347e2f00	0	21191551	2022-03-19T13:34:40.000Z	0x43d8a9c72a06744b255b9813f1d89a7c14b927550e80dddcbe607409602cae43
0xc35dadb65012ec5796536bd9864ed8773abc74c4	0x80e7c2345009b675fa9ee12f02ea18d7ab957d0c	false	357	0x1e16aa4df73d29c029d94ceda3e3114ec191e25a	0x2995d1317dcd4f0ab89f4ae60f3f020a4f17c7ce	20	21191503	2022-03-19T13:30:40.000Z	0x14a182a24b072b2a7c8735bc58f65f865997f6a9b95fdeee8ad1662602f99ada
0xc35dadb65012ec5796536bd9864ed8773abc74c4	0xd61f88ba5f9398860564a2d92d9a17f2a49ef5e7	false	45	0x82dfe19164729949fd66da1a37bc70dd6c4746ce	0xbf65bfcb5da067446cee6a706ba3fe2fb1a9fdfd	14	14864870	2021-03-05T22:00:15.000Z	0xd7a762c0c3262a3cec9fd69280f16ee85ab7745ac2cf37d5b9c85a3a36df7fa3

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v1_gnosis.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
0xb065d0d0697415eaf992556872a0d3863d9a39a2	false	65	1417262037553698905153	10324362962239159605	23385601	2022-07-27T13:54:15.000Z	0xb574ae44d46a0747954894e203a4dd650201ba7cefa87cb1f86552494c523f1a
0xa71fc075a5fee31c46e183d768891b2fa7d654d1	false	68	310375714740506595345	1537179507411009	23385601	2022-07-27T13:54:15.000Z	0xb574ae44d46a0747954894e203a4dd650201ba7cefa87cb1f86552494c523f1a
0xaa08d3902ffe54224ae1c16dc87e8bfad17932b6	false	18	6918057973862788	479079832442	23386881	2022-07-27T15:40:55.000Z	0x7683128a6f7ee4101a0845b5f82d4a00fc37303c83625ab238660960900ede20

Example Query

Query with partition filter

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