sushiswap_v2_gnosis

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	0xf0e11508276a55aea911e5a1044eeae65fe797fb	false	483	0x9c58bacc331c9aa871afd802db6379a98e80cedb	0xa899e4476ff5da39dcd9ddec7a6e2c651d8614bf	0	24714326	2022-10-24T02:50:30.000Z	0x7b9589ec2d4600abb45a78ecb355db322cbca81f3f8d6f4198a979f202790523
0xc35dadb65012ec5796536bd9864ed8773abc74c4	0x3b1950933c0ec4c1564844c218edf832d7a6260b	false	721	0x6a023ccd1ff6f2045c3309768ead9e68f978f6e1	0xe0dcec3737602737dc4b81519f6977de6cca462c	0	27915602	2023-05-13T02:32:25.000Z	0xe86efeb8ce8428a3e001b5d62aba280f6e0ec2aad1dd7b992ed92d6bd73b392a
0xc35dadb65012ec5796536bd9864ed8773abc74c4	0xf54e71ea87e0262588a87abae33a8310ff6dd754	false	733	0xc630c14dafdaab9bda33073929d0711d4ff1219e	0xe91d153e0b41518a2ce8dd3d7944fa863463a97d	2	28553911	2023-06-20T19:26:40.000Z	0x82ca95c215fb69c5e4fde253db4cd7b85155db8775364da702f9d2e4f875ff3f

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v2_gnosis.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	in_amount	log_index	block_number	block_timestamp	transaction_hash
0xddcbf776df3de60163066a5dddf2277cb445e0f3	0xb4633912c7374cd94d8917a167449e23b46d0ad1	false	806157036339784	53	18879756	2021-11-03T09:37:45.000Z	0x99987b97028e1f863a3bda16a1c37cffd2bc6c0697a66742e3934f1bdd79bb65
0xddcbf776df3de60163066a5dddf2277cb445e0f3	0xea763c36c687a14d68498f4835539fd8e6d351c4	false	3305107175744732873	14	18877404	2021-11-03T05:54:37.000Z	0xeb327c145bf906b8d4d0da63397e35579e6dd603a289b628872518a0e2b67df9
0xddcbf776df3de60163066a5dddf2277cb445e0f3	0xfe3142024baae2a07e257d67bf25492ef414f351	false	10157137603816517258	27	18880646	2021-11-03T11:00:50.000Z	0x0fd910fa67b06e88654fdd1c7c902ab4057e13a9e182490272d3a3165076b77d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v2_gnosis.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	0xbaca1296539733285f5734b2e09a734571b57e91	false	0x1b02da8cb0d097eb8d57a175b88c7d8b47997506	80	299999999999999999769	316189867199733242	14972346	2021-03-12T11:44:30.000Z	0xf974373d7000586c5478e8c70f7f33c04d87a34b27d606b246c5a2527160e5c1
0x1b02da8cb0d097eb8d57a175b88c7d8b47997506	0x8c0c36c85192204c8d782f763ff5a30f5ba0192f	false	0x1b02da8cb0d097eb8d57a175b88c7d8b47997506	16	552629468714662945	986118935930972232468	14976927	2021-03-12T18:18:30.000Z	0x741411f9ef4e582f268056b3d027b14977f06cb77f70bf9de6927bf6189136c3
0xe2b52fc1ad49b93f85c45315ecbad740f17b0e8e	0xc704050a17af0caed763431b80e38e8d8ff15591	false	0x1b02da8cb0d097eb8d57a175b88c7d8b47997506	10	50066939251572072206	487257826693368294978	21076584	2022-03-12T21:31:50.000Z	0x2c5004ee14158c68f50f6e94df9891d7ad71a31fd3d06b3389c18d014cfb9dd2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v2_gnosis.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
0x8c0c36c85192204c8d782f763ff5a30f5ba0192f	false	0x1b02da8cb0d097eb8d57a175b88c7d8b47997506	28	160113473072600509	547333208641004320578	16117535	2021-05-18T16:17:25.000Z	0xbcf4f2eebe7a6c6cf1ff41206c518bbee819661fbc45fba93980e964d17c16cd
0xf17022e4fb51e6381714a52926786ab7385ef743	false	0x1b02da8cb0d097eb8d57a175b88c7d8b47997506	35	1960000000000000000	2000000000000000000000000	16119322	2021-05-18T18:46:55.000Z	0x5012a938f28de11cb01a11693f54326a4fd4a6015f326b70de8297288a92150f
0xa227c72a4055a9dc949cae24f54535fe890d3663	false	0x1b02da8cb0d097eb8d57a175b88c7d8b47997506	35	11987806	11999999799545709669	16113538	2021-05-18T09:55:30.000Z	0x19d72447ccb9abb2c7059f6a63250d8db9978c9b529f9f29383d4cb9b36189f1

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v2_gnosis.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_amount1In	in_amount0Out	block_timestamp	transaction_hash
0x008cb160a21f5653e173a72e38067c981f693aac	0xc704050a17af0caed763431b80e38e8d8ff15591	false	0x9a1eb049f2da6ec476d0fb31c3e772c31a640bb2	10	17245133	2075810500842386259	345630462120978763	2021-07-25T10:01:45.000Z	0x772e66da9cfe34b987e4bfe19822f6bfebf7a4bea61387b86f0c1f90a29c5886
0x036f1868a304fe7470e266c1cec5bf42d801da50	0xc704050a17af0caed763431b80e38e8d8ff15591	false	0x036f1868a304fe7470e266c1cec5bf42d801da50	4	17241503	29187877802218438656	4915308020564723363	2021-07-25T04:59:10.000Z	0x9630583faf3137408f31fe7e9eebe2ff84762847e574ca9b595c7de1c4644fbb
0x036f1868a304fe7470e266c1cec5bf42d801da50	0x8c0c36c85192204c8d782f763ff5a30f5ba0192f	false	0x036f1868a304fe7470e266c1cec5bf42d801da50	4	17255089	47982079065971621888	22467025923545741	2021-07-25T23:51:50.000Z	0x30fda067574299d06c53fe34cc6198e64c0e8f70e07319ea62dc9c3b888d4864

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v2_gnosis.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
0xc704050a17af0caed763431b80e38e8d8ff15591	false	9	4995275323172366642174	2509172395366190123765	26327553	2023-02-05T17:54:45.000Z	0x8823afe8e4668253f848269537b83e27340e3a92877f734b4eb9e9d83cbbba9b
0x527f95182aaabb4fe7ee16ff2a5579b77c9d4b06	false	3	513855285679922830808	31877718599498173761	26331651	2023-02-05T23:48:35.000Z	0x44344e09c1e88321110bdbd917a6d276ee065cb22da6a3253e9f1dc8991f6b87
0x3c5a6e760b09b534a58edafa0de0653951bddc77	false	48	260662834492807756	26395363611	26319623	2023-02-05T06:30:20.000Z	0x17e5d1f92c507cd7804808810e0ae5263dcd97b90d14b35d30fc2fe4bab8ab1c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v2_gnosis.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
0x5420cfd7449ed4245936a71a761adf77bd7d0071	0x0f9d54d9ee044220a3925f9b97509811924fd269	0xddcbf776df3de60163066a5dddf2277cb445e0f3	false	105547868392186798123	5	25820285	2023-01-06T01:34:50.000Z	0x7799be72b03b38541d48bbeb3740177da92d6bd964c99fefa6b629b4e390e8c7
0x0000000000000000000000000000000000000000	0x0f9d54d9ee044220a3925f9b97509811924fd269	0x0f9d54d9ee044220a3925f9b97509811924fd269	false	105547868392186798123	7	25820321	2023-01-06T01:38:00.000Z	0xb2e7ddb6c706d68ef35b2c2a5198860172db5e2ba3e8365daec5eda383bdaace
0x0f9d54d9ee044220a3925f9b97509811924fd269	0x0f9d54d9ee044220a3925f9b97509811924fd269	0x5420cfd7449ed4245936a71a761adf77bd7d0071	false	105547868392186798123	5	25820321	2023-01-06T01:38:00.000Z	0xb2e7ddb6c706d68ef35b2c2a5198860172db5e2ba3e8365daec5eda383bdaace

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v2_gnosis.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