sushiswap_v1_arbitrum

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	0xb09b325c99b6f620d4f5cf8e1c9b0eeeef341266	false	27638	0x5fdbdc19bca1609ab52778176705fa64f13169ac	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	0	176834782	2024-02-02T21:31:31.000Z	0xe3e09892ae332be5b222eaee3902e1868506a091f5965f8d30df3fada0192325
0xc35dadb65012ec5796536bd9864ed8773abc74c4	0xda2299a91283748681b63ab63d04139a4a67b027	false	27639	0x1ad78177065c37d78bf4529bbb6f7869afecb7e7	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	0	176836732	2024-02-02T21:40:41.000Z	0x8aa6e1363790f91d0faef226aa1418b172f3caf372c366577c7d38aa183c0ddf
0xc35dadb65012ec5796536bd9864ed8773abc74c4	0x829c5d12fd5dcb2ccff40b8d82b8a476a7332dcc	false	27637	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	0x8ca8285e0f557133c3dbaeba39f5d9672748b3cd	1	176822128	2024-02-02T20:31:52.000Z	0x7a6c0269bbd3650e8fc79868d12d3fcac23c6c6855fabf73a62308d31ed88d24

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v1_arbitrum.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
0x515e252b2b5c22b4b2b6df66c2ebeea871aa4d69	false	39	3002845980	525405593940634172582	15977786	2022-06-26T23:59:03.000Z	0x23f16b5f0517c4e2d81f53202f729402902e881359746c6d56363d0ff7e3f542
0x515e252b2b5c22b4b2b6df66c2ebeea871aa4d69	false	24	3004927657	525040522201992404512	15976658	2022-06-26T23:42:36.000Z	0x80b5cbc0f8852b09d8aaf5d766e53cb4660c0e9aa73710c3fb47a6768036161b
0x515e252b2b5c22b4b2b6df66c2ebeea871aa4d69	false	40	3007176114	524580675766715536499	15950893	2022-06-26T18:54:11.000Z	0xaa1aadfc2f30fc566062dcd4196af383c09cfe62386d64349410b993aaf6c2b5

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

Factory_PairCreated_event

Pair_Sync_event

​Tables

​Factory_PairCreated_event

​Pair_Sync_event

Tables

Factory_PairCreated_event

Pair_Sync_event