zyberswap_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
0xac2ee06a14c52570ef3b9812ed240bce359772e7	0xcbb0acada736fede88bb18ae3dc201393af80e2c	false	18	0x3b475f6f2f41853706afc9fa6a6b8c5df1a2724c	0xda10009cbd5d07dd0cecc66161fc93d7c9000da1	10	60699094	2023-02-14T00:40:36.000Z	0xc42009cf5dd737cb7938d6df873312c5d9b95d34cc08bd02f1688bd8d152c1da
0xac2ee06a14c52570ef3b9812ed240bce359772e7	0xe9db019c1fa90abdadeabb8f73d356a4be7598de	false	23	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	0x9842989969687f7d249d01cae1d2ff6b7b6b6d35	2	60917921	2023-02-14T17:29:00.000Z	0x1ae5427a791aeffa87634e93557f992eb9130af437bbe33b9ff9d7dfaca5ad72
0xac2ee06a14c52570ef3b9812ed240bce359772e7	0x2846212b717cfc0862b5ba9f9c07ebf5aa24a4d8	false	20	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	0xa39c0fe390ae78676b26351d0911cc6e5a71529d	0	60830336	2023-02-14T11:06:00.000Z	0xfb0b5b4e351175373e3ed94c4d66da0d5864978dfaabbda4f79cb084b8417525

Example Query

Query with partition filter

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

Pair_Burn_event

Liquidity removal events from DEX (Decentralized Exchange) trading pairs recording amounts of both tokens withdrawn when liquidity providers burn LP tokens. Used for tracking liquidity provision activity and calculating total value locked (TVL) changes in 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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`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	in_amount0	in_amount1	block_number	block_timestamp	transaction_hash
0x16e71b13fe6079b4312063f7e81f76d165ad32ad	0xf69223b75d9cf7c454bb44e30a3772202bee72cf	false	0x16e71b13fe6079b4312063f7e81f76d165ad32ad	25	8701070355939834176	1219582350503433	98557172	2023-06-07T01:34:18.000Z	0x04ccd0e74f3d43fa042c305277a5afefb6a8e855da3d5c1211d643d369fce182
0x16e71b13fe6079b4312063f7e81f76d165ad32ad	0xf69223b75d9cf7c454bb44e30a3772202bee72cf	false	0x16e71b13fe6079b4312063f7e81f76d165ad32ad	12	160171542853115737838	22755949080287214	98658877	2023-06-07T08:47:45.000Z	0xc3b3ab44f4765d0b1ad69f4ef3bbf4394310642f4192651b12bd57e0b1a5ac60
0x78b8a76bea31733777556033e2a116df66c4c41c	0x3ec0eddcd1e25025077327886a78133589082fb2	false	0x16e71b13fe6079b4312063f7e81f76d165ad32ad	7	14463620360237621308	3723251	98856247	2023-06-07T22:44:49.000Z	0xcdfcdc4782fa79b53fa0ee20768345ff78f9ae8f35c9b3e05adbef9b20604c8d

Example Query

Query with partition filter

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

Pair_Mint_event

Liquidity provision events emitted when users add tokens to a DEX pair contract. Records sender address and token amounts deposited for liquidity pool operations.

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_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_sender	log_index	in_amount0	in_amount1	block_number	block_timestamp	transaction_hash
0x3ec0eddcd1e25025077327886a78133589082fb2	false	0x16e71b13fe6079b4312063f7e81f76d165ad32ad	6	214000000000000000000	819724280	73988195	2023-03-26T20:37:04.000Z	0x18f19eb1900c495c38a2204d647ea9572be0bce4906a3c0966f094742ddb1c59
0x7db09b248f026f1a77d58b56ab92943666672968	false	0x16e71b13fe6079b4312063f7e81f76d165ad32ad	6	14420086810481184016	19490300000000000000000	73918871	2023-03-26T15:48:12.000Z	0x3d7dfcce65dd719ebf203deb6dad4271f090e481cb91dcd3b6fd6fdddfe4dcb3
0x7db09b248f026f1a77d58b56ab92943666672968	false	0x16e71b13fe6079b4312063f7e81f76d165ad32ad	7	11452410377270700	15737131985663241292	73828906	2023-03-26T09:37:28.000Z	0x0594061b5083b65f4bc54bd160833d8e95f47d4ddae6cb21cb0ecbf66492a8cf

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.zyberswap_v1_arbitrum.Pair_Mint_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
0x252cd7185db7c3689a571096d5b57d45681aa080	false	16	18438037625964809210	17360796	120936331	2023-08-13T08:59:44.000Z	0x2bdaa5167608e767a11f6211a6281478ac26a39b26bace50d3fc346c5a6528a9
0x252cd7185db7c3689a571096d5b57d45681aa080	false	25	22033471117479551206	14520751	120936330	2023-08-13T08:59:43.000Z	0x4d873b6ada9a3e83a94d47c19e9e2f33b5e445cf067f49bf17320d68f056583e
0x3ec0eddcd1e25025077327886a78133589082fb2	false	3	92165713697216360632280	5698406440	120888000	2023-08-13T05:31:50.000Z	0x8c6cdf6d3e1d602405ac7194ea6a62586a2160190b01e37666dad2f4f01417e9

Example Query

Query with partition filter

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

Pair_Transfer_event

ERC20 Transfer events emitted by liquidity pair contracts in automated market maker (AMM) decentralized exchanges (DEXs). Records minting, burning, and transfer of LP (liquidity provider) tokens representing ownership shares in trading pairs.

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_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.

Sample Data

in_to	address	in_from	removed	in_value	log_index	block_number	block_timestamp	transaction_hash
0x0ccfa1c3441f3febdcee067bd1cbe3af7bbb614b	0xf69223b75d9cf7c454bb44e30a3772202bee72cf	0x9ba666165867e916ee7ed3a3ae6c19415c2fbddd	false	901469403645138026	6	157670019	2023-12-07T06:49:42.000Z	0xde8ea0af7a6b9fad6699bf428c2a29bccc35aa26b4fe59254155b5141534ad92
0xf69223b75d9cf7c454bb44e30a3772202bee72cf	0xf69223b75d9cf7c454bb44e30a3772202bee72cf	0x0ccfa1c3441f3febdcee067bd1cbe3af7bbb614b	false	901469403645138026	1	157670145	2023-12-07T06:50:26.000Z	0x0352dc77a6950c96cbd4b1c2e48efe6c9c826900208f2f99d4a0e674e17a5a52
0x5539b54370b92de97bf6e2153d69635b977d8d88	0xf69223b75d9cf7c454bb44e30a3772202bee72cf	0x0000000000000000000000000000000000000000	false	216292736273501497	2	157670145	2023-12-07T06:50:26.000Z	0x0352dc77a6950c96cbd4b1c2e48efe6c9c826900208f2f99d4a0e674e17a5a52

Example Query

Query with partition filter

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

SwapDeployer_NewSwapPool_event

Liquidity pool deployment events from ZyberSwap V1 on Arbitrum, recording the creation of new swap pools with their constituent tokens and contract addresses. Used for tracking pool launches and analyzing protocol growth and token 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`	Contract address of the newly deployed swap pool on Arbitrum. Hex-encoded, 0x-prefixed 40-character string representing the pool’s location on-chain.
`in_pooledTokens`	`ARRAY<STRING>`	Array of token contract addresses included in the newly deployed liquidity pool. Each address is a hex-encoded, 0x-prefixed string representing an ERC-20 token available for swapping in 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_v1_arbitrum.SwapDeployer_NewSwapPool_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Metrics

Primitives

Contracts

Blockchain

Tables

Factory_PairCreated_event

Pair_Burn_event

Pair_Mint_event

Pair_Sync_event

Pair_Transfer_event

SwapDeployer_NewSwapPool_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Factory_PairCreated_event

​Pair_Burn_event

​Pair_Mint_event

​Pair_Sync_event

​Pair_Transfer_event

​SwapDeployer_NewSwapPool_event

Tables

Factory_PairCreated_event

Pair_Burn_event

Pair_Mint_event

Pair_Sync_event

Pair_Transfer_event

SwapDeployer_NewSwapPool_event