zyberswap_v2_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
0xac2ee06a14c52570ef3b9812ed240bce359772e7	0x9ae38c605cc144e0b85e905d3187b820f8d81b7c	false	178	0x2ccd5e4e0aa82e232af6d617df5ef17e5f94e135	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	16	84438956	2023-04-26T09:15:55.000Z	0xa956afc218f39a0d5e8e349f7d33b9fb35edbe330421db4e6ff0437c591050b1
0xac2ee06a14c52570ef3b9812ed240bce359772e7	0x500abeef758bf3e9051c2d678f3b0de5696577df	false	99	0x1b53c0e3154987b5b15c9152ef17aba01db418d3	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	0	65487486	2023-02-28T17:49:00.000Z	0x519574418495378f7ed3def89bf1b137f6c7eeb9401cc255b9afd82645592d3c
0xac2ee06a14c52570ef3b9812ed240bce359772e7	0x190a9cc1cf4402d7bf0b98cf478d9fc4d2096f60	false	100	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f	0x59a252e4dcd8503005230694a6958b437657e70d	0	65556574	2023-02-28T23:06:35.000Z	0xfce6afecf72dd7060fa6564e43689def6f6d6d37ddfcafc40654170ef73b4b73

Example Query

Query with partition filter

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

Pair_Swap_event

Token swap events from decentralized exchange (DEX) liquidity pairs recording input and output amounts for both tokens. Primary source for tracking DEX trading activity and price discovery.

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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount0In`	`STRING`	Amount of token0 transferred into the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_amount1In`	`STRING`	Amount of token1 transferred into the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_amount0Out`	`STRING`	Amount of token0 transferred out of the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_amount1Out`	`STRING`	Amount of token1 transferred out of the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	removed	in_sender	log_index	block_number	in_amount0In	in_amount1Out	block_timestamp	transaction_hash
0x00000000049c95d6b6002a72c222809bfbfe2ed8	0x3ec0eddcd1e25025077327886a78133589082fb2	false	0x00000000049c95d6b6002a72c222809bfbfe2ed8	21	154584025	331183115328318958572	42478844	2023-11-27T11:58:29.000Z	0xc47567d3577935471452cc568bef11d13194c69550b261b1b9a89a2518c92d5c
0x1f5a3c42f26b72c917b3625c7a964ca33600fa25	0x3ec0eddcd1e25025077327886a78133589082fb2	false	0x1f5a3c42f26b72c917b3625c7a964ca33600fa25	18	154569557	144670469933561914481	18916192	2023-11-27T10:57:05.000Z	0xcb0d80f6992b5f4516efb37a5e41659cd2068dddecb7a0232826e49ac0e07c56
0x1f5a3c42f26b72c917b3625c7a964ca33600fa25	0x3ec0eddcd1e25025077327886a78133589082fb2	false	0x1f5a3c42f26b72c917b3625c7a964ca33600fa25	5	154556525	88905399128905367525	11677099	2023-11-27T10:01:13.000Z	0x3ddfdc618460d9e84f32a9fdb95c2740e93b8ee391f2806dcb69a2b7d92b1f35

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.zyberswap_v2_arbitrum.Pair_Swap_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
0x7db09b248f026f1a77d58b56ab92943666672968	false	3	277079770983693100	328615410573461521237	170878774	2024-01-16T01:54:26.000Z	0xe8d612b854e21ffd1b3a2e6af19633948eb6a7fde46c7680da09c9e0362fad23
0x7db09b248f026f1a77d58b56ab92943666672968	false	3	274258857296524531	332039688026425549147	171091524	2024-01-16T17:32:58.000Z	0x00b903f27b33732db4ef74b09c63878512ede971909a744d9565a96bacdb4864
0x7db09b248f026f1a77d58b56ab92943666672968	false	3	277799032909904346	327776227130741423069	170948311	2024-01-16T07:10:55.000Z	0x9cd60f0641fb4cf63d9cc9cb67f335d838648ae295a63741cb4ab3a04f0c43b7

Example Query

Query with partition filter

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

SwapDeployer_NewSwapPool_event

Liquidity pool deployment events from ZyberSwap V2 on Arbitrum, capturing the creation of new swap pools with their constituent token addresses and deployer information. Used for tracking protocol expansion and identifying new trading pair availability.

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_deployer`	`STRING`	Address of the account that initiated the deployment or creation action. Hex-encoded, 0x-prefixed, 42-character string.
`in_swapAddress`	`STRING`	Address of the newly deployed swap pool contract created by the deployer. This is the main contract address users interact with for swapping tokens in the pool.
`in_pooledTokens`	`ARRAY<STRING>`	Array of token contract addresses included in the newly deployed liquidity pool. Each address is hex-encoded and 0x-prefixed, representing the tokens that can be swapped within this pool.

Sample Data

address	removed	log_index	in_deployer	block_number	in_swapAddress	block_timestamp	in_pooledTokens	transaction_hash
0xc25e230afb1b67162350cd405add199a002c6abd	false	3	0x17f1395b3705a9c925af7a999f062e41fa72f6fb	59965888	0x969f7699fbb9c79d8b61315630cdeed95977cfb8	2023-02-11T11:19:57.000Z	[“0xff970a61a04b1ca14834a43f5de4533ebddb5cc8”,“0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9”,“0xda10009cbd5d07dd0cecc66161fc93d7c9000da1”]	0x9af02232d13c209c4c8492e07842b0ab6db02d0e8461de8876ca39471ee33a8e

Example Query

Query with partition filter

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

SwapFlashLoan_TokenSwap_event

Token swap events from Saddle Finance and Zyberswap liquidity pools recording buyer address, sold and bought token identifiers, and token quantities exchanged. Used for tracking decentralized exchange (DEX) trading activity and price impact analysis across automated market maker (AMM) pools.

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_buyer`	`STRING`	Address of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokensSold`	`STRING`	Quantity of tokens sold in the swap transaction. Numeric string value representing the raw token amount without decimal adjustment.
`in_tokensBought`	`STRING`	Quantity of tokens acquired in the swap transaction. Numeric string value representing the raw token amount without decimal adjustment.
`in_soldId`	`STRING`	Index identifier for the token being sold in the swap. Numeric string value representing the position of the sold token in the swap pool.
`in_boughtId`	`STRING`	Index identifier for the token being acquired in the swap. Numeric string value representing the position of the purchased token in the swap pool.

Sample Data

address	removed	in_buyer	in_soldId	log_index	in_boughtId	block_number	in_tokensSold	block_timestamp	in_tokensBought	transaction_hash
0x969f7699fbb9c79d8b61315630cdeed95977cfb8	false	0x9b99e9c620b2e2f09e0b9fced8f679eecf2653fe	1	26	2	254011113	2175728	2024-09-16T05:20:25.000Z	2176518315600552736	0x75b170bba8319fc299a8a5ef4f8a040df0d34161008bc8cb1360bd3b8718ab47
0x969f7699fbb9c79d8b61315630cdeed95977cfb8	false	0x9b99e9c620b2e2f09e0b9fced8f679eecf2653fe	1	6	2	254023949	26429043	2024-09-16T06:14:32.000Z	26432852797549326812	0xb63781cab2a529f71fdb1ecdcf60aab1117dec349af8eac368e36ff08ab088dc
0x969f7699fbb9c79d8b61315630cdeed95977cfb8	false	0xc3f3a07ae7d2a125ef81a5950c4d0dd54c740251	2	22	0	283412845	40745350529347204397	2024-12-10T19:11:39.000Z	40710991	0x48b7bd1fae32f22fc5a428da608ce437d2dcf905b7ee09477d056003ce13d6ff

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Factory_PairCreated_event

Pair_Swap_event

Pair_Sync_event

SwapDeployer_NewSwapPool_event

SwapFlashLoan_TokenSwap_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Factory_PairCreated_event

​Pair_Swap_event

​Pair_Sync_event

​SwapDeployer_NewSwapPool_event

​SwapFlashLoan_TokenSwap_event

Tables

Factory_PairCreated_event

Pair_Swap_event

Pair_Sync_event

SwapDeployer_NewSwapPool_event

SwapFlashLoan_TokenSwap_event