sushiswap_v2_ethereum

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
0xc0aee478e3658e2610c5f7a4a2e1777ce9e4f2ac	0x680a025da7b1be2c204d7745e809919bce074026	false	1	0x6b3595068778dd592e39a122f4f5a5cf09c90fe2	0xdac17f958d2ee523a2206206994597c13d831ec7	81	10794352	2020-09-04T10:41:28.000Z	0x64318dfffc6544cb4782715ad914e335039cda02f5e8d3e47f0dac47f53565d2
0xc0aee478e3658e2610c5f7a4a2e1777ce9e4f2ac	0x6c765d6b957dacac398d0996cc3e32bd599c8f79	false	1378	0x383518188c0c6d7730d91b2c03a03c837814a899	0x853d955acef822db058eb8505911ed77f175b99e	175	12671937	2021-06-20T15:20:16.000Z	0x2d817deb3afbb114e19ee2f345a56da091df26d061fbc6838d540e10b5cec05f
0xc0aee478e3658e2610c5f7a4a2e1777ce9e4f2ac	0x45679d087f7e01e517204b78825faf0f68c19cbc	false	1381	0x0000000000085d4780b73119b644ae5ecd22b376	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	218	12674201	2021-06-20T23:31:12.000Z	0xc15e2c3fd358fd2b9c72ea3de9ef75d9ed766cf728c4c3ef434a9576a1b4a7b9

Example Query

Query with partition filter

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

MasterChefV2_Harvest_event

SUSHI token reward claim events from SushiSwap’s MasterChef V2 staking contract on Ethereum. Tracks harvested reward amounts by user and pool ID (pid) for analyzing yield farming behavior and reward distribution patterns.

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	in_amount	log_index	block_number	block_timestamp	transaction_hash
0xef0881ec094552b2e128cf945ef17a6752b4ec5d	0x0f7981ae60708d4d64040999e463f106b13f07c5	false	2995662916974844124	283	12590102	2021-06-07T22:27:28.000Z	0x6ad9e7438ce90a4b89733a74f44ddcdfe9acc15d83e3423eb118481cf15544a3
0xef0881ec094552b2e128cf945ef17a6752b4ec5d	0x8aac227fbb0dcaf9d73b5ab6bd22777b0b669dc4	false	51277890613193130	357	12590120	2021-06-07T22:31:23.000Z	0x36905e526345a8a2c597f13f15f615905f1fb2aa8e1c52280e03ca207dad7292
0xef0881ec094552b2e128cf945ef17a6752b4ec5d	0x8aac227fbb0dcaf9d73b5ab6bd22777b0b669dc4	false	236333243061061	316	12590122	2021-06-07T22:31:54.000Z	0xbf0cecce0e974003b533a4be8991d797f0fe6a32c23c4b478d65c161eec33f99

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v2_ethereum.MasterChefV2_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
0x00000000cc0b822819f03424dacf9077fdaa58a3	0xb84c45174bfc6b8f3eaecbae11dee63114f5c1b2	false	0xd9e1ce17f2641f24ae83637ab66a2cca9c378b9f	232	196482776438394582548890545	90160870398584808	14572318	2022-04-12T18:17:59.000Z	0x5576206a1b91a701c6f8b8d77552ab936ba3748a0121ec88f84cf07bc137b69c
0x00000000cc0b822819f03424dacf9077fdaa58a3	0xb84c45174bfc6b8f3eaecbae11dee63114f5c1b2	false	0xd9e1ce17f2641f24ae83637ab66a2cca9c378b9f	376	4912869846247056890528156	2144844896321401	14571520	2022-04-12T15:22:00.000Z	0x1c8f22aabe53c9f47bc01b089959f9cdced74a82bb98b94ba73c531d2c5ed260
0x0898512055826732026ac02242e7d7b66fccc2b0	0x5fa4370164a2fabeef159b893299d59ff5dc1e6d	false	0xd9e1ce17f2641f24ae83637ab66a2cca9c378b9f	210	2009746587765089175671	4960388437690846457179	14569884	2022-04-12T09:17:14.000Z	0x10d42c89eb70a03ebbd987ba65c0a49fa9d9c112080a1403c1c5399acf0f0f2a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v2_ethereum.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
0x06da0fd433c1a5d7a4faa01111c044910a184553	false	0xd9e1ce17f2641f24ae83637ab66a2cca9c378b9f	108	658033218514020	1000000	16605084	2023-02-11T11:00:59.000Z	0x9f6366f8c502164a29bf7f1750ce5b99adec9cf146fbdafb6fb0ed521c645262
0x06da0fd433c1a5d7a4faa01111c044910a184553	false	0xd9e1ce17f2641f24ae83637ab66a2cca9c378b9f	97	4249747230000000000	6447197055	16602803	2023-02-11T03:21:35.000Z	0x0c59bd4d1f3900c68dcffd469c37c998c2fdc3a64f8e3f99ccaf6af554ef04c5
0x06da0fd433c1a5d7a4faa01111c044910a184553	false	0xd9e1ce17f2641f24ae83637ab66a2cca9c378b9f	251	65878620235019	100000	16605476	2023-02-11T12:20:11.000Z	0x500b91793dab42f01ec6ae87930409b3fe20d86448e6bdd737999a16103d8df4

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v2_ethereum.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
0x000000000000006f6502b7f2bbac8c30a3f67e9a	0xf1f85b2c54a2bd284b1cf4141d64fd171bd85539	false	0x000000000000006f6502b7f2bbac8c30a3f67e9a	172	12598401	12251688172317050351566	5010531896267283095	2021-06-09T05:15:04.000Z	0x99942f3d8a34ecf701c3c14161ec3597671166b590da1bcde4c3237085082b09
0x000000000000006f6502b7f2bbac8c30a3f67e9a	0xa73df646512c82550c2b3c0324c4eedee53b400c	false	0x000000000000006f6502b7f2bbac8c30a3f67e9a	340	12600430	181894169228515484539	2006563877970413597	2021-06-09T12:53:15.000Z	0xb66f87785da51920b9a7b2e8f356ec70d15c0dbd0d841946e1a42bc3fe3376db
0x0000000000000eb4ec62758aae93400b3e5f7f18	0x4fb3cae84a1264b8bb1911e8915f56660ec8178e	false	0x0000000000000eb4ec62758aae93400b3e5f7f18	287	12597002	9638329649459737780315	218709760948397215	2021-06-09T00:01:32.000Z	0xda8017b886d2a12377053ebf89ad5e31ded1e54ba06d70f78d3928495fbb902e

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v2_ethereum.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
0xf169cea51eb51774cf107c88309717dda20be167	false	322	27342401214988103980491	1077480986439253887209	12294602	2021-04-23T05:32:48.000Z	0x49b85df9f726309bf09d1d400a9639c4924288a949ea2c6ab5088d39bed60313
0xc40d16476380e4037e6b1a2594caf6a6cc8da967	false	133	1896757686773446620699334	27623145395678711115326	12294602	2021-04-23T05:32:48.000Z	0xec0bf44c6aa986d8a750d13a94db3ca2d59f2b0353f704d6506f8cdd84e80060
0x06da0fd433c1a5d7a4faa01111c044910a184553	false	242	62497494716030265223392	138258281487967	12294602	2021-04-23T05:32:48.000Z	0x39d9c727a17fa0433e4e9b9b2346f08405be96de08c54d836948bbda573790d5

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v2_ethereum.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	log_index	block_number	block_timestamp	transaction_hash
0xc2edad668740f1aa35e4d8f227fb8e17dca888cd	0x001b6450083e531a5a7bf310bd2c1af4247e23d4	0x974678f5aff73bf7b5a157883840d752d01f1973	false	317	13234896	2021-09-16T05:34:32.000Z	0x6d06f683676357f7f7449893d25e0a119563a4e088030b6831a8c1dd1c7ff785
0xc2edad668740f1aa35e4d8f227fb8e17dca888cd	0x001b6450083e531a5a7bf310bd2c1af4247e23d4	0x07fe984c446417c1ff4532ce4fd67eeb59a0d682	false	143	13234710	2021-09-16T04:49:45.000Z	0x141c95bde6b21c8019391e8fc2e3549e66172b601efd1010347307982a414b47
0xc2edad668740f1aa35e4d8f227fb8e17dca888cd	0x001b6450083e531a5a7bf310bd2c1af4247e23d4	0xd2a78bb82389d30075144d17e782964918999f7f	false	230	13234919	2021-09-16T05:39:18.000Z	0x39c7ffcd73fa0b8ce46bb89a3ec07377d9e0296882dfa27f6c5f6d2d9076a476

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Factory_PairCreated_event

MasterChefV2_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

​MasterChefV2_Harvest_event

​Pair_Burn_event

​Pair_Mint_event

​Pair_Swap_event

​Pair_Sync_event

​Pair_Transfer_event

Tables

Factory_PairCreated_event

MasterChefV2_Harvest_event

Pair_Burn_event

Pair_Mint_event

Pair_Swap_event

Pair_Sync_event

Pair_Transfer_event