sushiswap_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
0xc35dadb65012ec5796536bd9864ed8773abc74c4	0x2fcd51bc211ed43d1cbe28b845905dcfbec8be7e	false	11821	0x01d57499ecad9c77dca34337783d940a8e01ec04	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	7	68818493	2023-03-11T10:29:36.000Z	0x4422135b034fa9104ebd4f50518d10e8d2da96fd084195a77c01e07132e62255
0xc35dadb65012ec5796536bd9864ed8773abc74c4	0x883d85407b9d6fd1c8b7c491aaed7c02f8968195	false	11836	0x08647925b13f5a6f4ff908728c7400b7b9c13454	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	0	68862640	2023-03-11T13:54:57.000Z	0x1498136c19865b919b386f717b5befa29264b6ff5c8a661ce27e6f94675d92b4
0xc35dadb65012ec5796536bd9864ed8773abc74c4	0x16ac0d985abcf5efc4a9cda8ff9e3ef9a19fb131	false	11848	0x0b8bea46e50bce4715d075b103d94c144c077183	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	1	68891870	2023-03-11T16:13:24.000Z	0xcc62cbac552aff928d2858146477a01a47da87ba4c9f5eda03776ef47cebc48b

Example Query

Query with partition filter

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

MiniChef_Harvest_event

Reward claims from MiniChef staking contracts emitted when users harvest accumulated incentive tokens. Contains pool identifier, user address, and harvested token amount for tracking yield farming rewards across liquidity mining programs.

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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_pid`	`STRING`	Pool identifier referencing a specific staking or liquidity pool within the protocol. Numeric string representation of the pool ID.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	in_user	removed	log_index	block_number	block_timestamp	transaction_hash
0xf4d73326c13a4fc5fd7a064217e12780e9bd62c3	0xf1a95a47ef82fa7ce37995d91494a47cb6abc55d	false	1	162921975	2023-12-23T12:05:05.000Z	0x563cf70893b073ac2b8889abd0264a1a666e870ba3d58fe13b91992a4fc0de16
0xf4d73326c13a4fc5fd7a064217e12780e9bd62c3	0x7a783045e6296bc6c6307490af17d22a2a6a15c8	false	1	162987142	2023-12-23T16:38:57.000Z	0x648757665677a6afb489f17c8e25fa8f14a3628f54e375d7a7a7ae3796bcc9bd
0xf4d73326c13a4fc5fd7a064217e12780e9bd62c3	0x88c907770735b1fc9d9ccb1a8f73dc17e75c0699	false	1	162930326	2023-12-23T12:40:02.000Z	0xfc84bd051cf4ea9b333d62edf5a76479ad6f786f36e55cf819afdcf4ba73316c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v2_arbitrum.MiniChef_Harvest_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
0x1b02da8cb0d097eb8d57a175b88c7d8b47997506	0x5dcf474814515b58ca0ca5e80bbb00d18c5b5cf8	false	0x1b02da8cb0d097eb8d57a175b88c7d8b47997506	5	4326883915894803314	6003791322790075027	53539592	2023-01-16T19:40:00.000Z	0x6f6ec44a5dbd177089f9ded158ced91fbd8d05d9a03ff0815f7fe159c8bf7133
0x1b02da8cb0d097eb8d57a175b88c7d8b47997506	0xb7e50106a5bd3cf21af210a755f9c8740890a8c9	false	0x1b02da8cb0d097eb8d57a175b88c7d8b47997506	5	12425353494721871523	5881247689933091	53407710	2023-01-16T06:45:14.000Z	0x452a2cb7f331487a1f5fe10a1598db8ba354630640bfdcd7994cc2462055aa93
0xbe0a3270d7d5ac7a94179ca1375f350407d2dfe8	0xd7b7f3431084f75a32e4bf05b44ba40e9ead202d	false	0x1b02da8cb0d097eb8d57a175b88c7d8b47997506	5	154183758004389899881245	144399749613924186671478	53367504	2023-01-16T01:48:06.000Z	0xaed0ff81bad484c9a72b72c3d0265a411782c196035f42b04e8238c2db63faf1

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v2_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
0x69601dda3b22d99f92ad3af2aa9b3323634b28bf	false	0x1b02da8cb0d097eb8d57a175b88c7d8b47997506	7	14855902487303096999257	35961215	7182694	2022-03-01T15:58:26.000Z	0xf9849474aef8e196163de966ef99c30ece99357fe51b74c4c29a0ccc4003ffaa
0xe235e8dfa8ea3b7ffff1c922fa4928bfb7ad964a	false	0x1b02da8cb0d097eb8d57a175b88c7d8b47997506	7	997017710899165	1447020032762496955	7135775	2022-03-01T00:35:47.000Z	0xba95add17f1a1bc2f8be5ce4b00d741c7b4f4db6286dc46e8ed4aa6a34ad67b0
0x6478931004cd7b995957a4e1a5d06f9a8db0fa04	false	0x1b02da8cb0d097eb8d57a175b88c7d8b47997506	7	14855902505300922459846	51537129	7182373	2022-03-01T15:51:59.000Z	0xa635a7092032577ee184a537afd911dc2add7bcc779335936b929ca280736a48

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v2_arbitrum.Pair_Mint_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
0xd3f4d3461e9280b73f984e053c72f649ef7b0f1f	0x01de11cfd3a7261a954db411f02c86d8b826e5d2	false	0x1b02da8cb0d097eb8d57a175b88c7d8b47997506	4	9197626	220948459316531839948	257505676	2022-04-02T19:14:25.000Z	0xaa97a2a854dbd8ef19183070b1080566caaeac77b01aca76f02be56020127c50
0x9ef3826b317406491335ddaa3b2b53b3070c1ade	0x01de11cfd3a7261a954db411f02c86d8b826e5d2	false	0x1b02da8cb0d097eb8d57a175b88c7d8b47997506	4	9197481	456523505967983135108	532281169	2022-04-02T19:10:33.000Z	0xbfb37b263fc1612308a3499eee32dec3c9aa142c6086468cad2ec099fd875a6c
0x1111111254fb6c44bac0bed2854e76f90643097d	0x01de11cfd3a7261a954db411f02c86d8b826e5d2	false	0x26271dfddbd250014f87f0f302c099d5a798bab1	4	9090101	6592749282740111915648	7695966566	2022-04-02T02:59:50.000Z	0xc24ff3dee4f081894896bc4df96c8a7d83a6f910926ef3501a6fd1ac58beda94

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_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
0x05c6f695ad50c16299bedca3fe9059b56550082f	false	2	1953234117236456573	121881871341386136560	4871397	2022-01-21T21:33:08.000Z	0xa353e280875e5e2eb1a91b716e661482a733cf5c4c9a5c6ef42af82edc7f89f1
0x05c6f695ad50c16299bedca3fe9059b56550082f	false	2	1886207430809711253	126177362303010945671	4850597	2022-01-21T06:54:29.000Z	0xfb3faf7f81c33e2d716b18910a655298c49304997f61d5a14b30b32e1e92541f
0x05c6f695ad50c16299bedca3fe9059b56550082f	false	2	1893248785408341354	125755173109419020552	4874059	2022-01-21T22:18:10.000Z	0x6fa8b69a9c53f1bbd45269f5f572ca2c11dd75a4f3dbc76aec30a1fbc3239e0c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v2_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
0x0000000000000000000000000000000000000000	0x01de11cfd3a7261a954db411f02c86d8b826e5d2	0x01de11cfd3a7261a954db411f02c86d8b826e5d2	false	56172404434	3	28794373	2022-10-07T02:51:33.000Z	0x3cb394c5d65dd1045dab74a9222cb11731ba1e924865a3ef10e25a018423f6c5
0x01de11cfd3a7261a954db411f02c86d8b826e5d2	0x01de11cfd3a7261a954db411f02c86d8b826e5d2	0xd3f4129336be7e26180c7c0093602fae3b9c88ca	false	56172404434	1	28794373	2022-10-07T02:51:33.000Z	0x3cb394c5d65dd1045dab74a9222cb11731ba1e924865a3ef10e25a018423f6c5
0xa19b3b22f29e23e4c04678c94cfc3e8f202137d8	0x01de11cfd3a7261a954db411f02c86d8b826e5d2	0x0000000000000000000000000000000000000000	false	13914321256346	2	28794373	2022-10-07T02:51:33.000Z	0x3cb394c5d65dd1045dab74a9222cb11731ba1e924865a3ef10e25a018423f6c5

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Factory_PairCreated_event

MiniChef_Harvest_event

Pair_Burn_event

Pair_Mint_event

Pair_Swap_event

Pair_Sync_event

Pair_Transfer_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Factory_PairCreated_event

​MiniChef_Harvest_event

​Pair_Burn_event

​Pair_Mint_event

​Pair_Swap_event

​Pair_Sync_event

​Pair_Transfer_event

Tables

Factory_PairCreated_event

MiniChef_Harvest_event

Pair_Burn_event

Pair_Mint_event

Pair_Swap_event

Pair_Sync_event

Pair_Transfer_event