sushiswap_v2_base

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
0x71524b4f93c58fcbf659783284e38825f0622859	0xe8af476ce9647b7d04ea0ea3a5a91f8a1181dd26	false	82	0x4200000000000000000000000000000000000006	0x46c7fd5b736e8fde32ec3d53a260e1757845833c	12	4774349	2023-10-03T13:00:45.000Z	0x5ff2e09901c09fe12b9461cb34e36404e175641b9750d4f63d0bbf53098e8bd1
0x71524b4f93c58fcbf659783284e38825f0622859	0xf66eaf0956eb233e65fe8766b33ad513aae1ed66	false	288	0x149045e17e8c7212d421e72c96cca331eed718b7	0x4200000000000000000000000000000000000006	13	10277553	2024-02-07T22:20:53.000Z	0xc8d57538a0d8f1a7627755cb5f729ede094d0f5cd9293f052b1215a20ddc88da
0x71524b4f93c58fcbf659783284e38825f0622859	0xf6f7f547e1cb03f6c07e0f2f0946f7240ad8702b	false	284	0x391ca8842a33d99a82b4cb48c39ab6963663924f	0x4200000000000000000000000000000000000006	37	10267693	2024-02-07T16:52:13.000Z	0x7be726ea086b180112a6943f4b79a0378ef96e4edb668c7c777a774d243ed00c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v2_base.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
0x6bded42c6da8fbf0d2ba55b2fa120c5e0c8d7891	0xf32fdb63d0a976cc6cec939f2824fcf7f9819f68	false	0x6bded42c6da8fbf0d2ba55b2fa120c5e0c8d7891	6	341715768550311899	2148154165030966506221	5042903	2023-10-09T18:12:33.000Z	0x3b557f640568e9efd80ea671e0e23bf6ccba305a4b91481a1dbe0fcc1dc34bcc
0x6bded42c6da8fbf0d2ba55b2fa120c5e0c8d7891	0xf32fdb63d0a976cc6cec939f2824fcf7f9819f68	false	0x6bded42c6da8fbf0d2ba55b2fa120c5e0c8d7891	6	390761481634868345	3674062692613669945671	5052501	2023-10-09T23:32:29.000Z	0x6e7a907ebb97ea0bbabab6610482af6259627e93d7ea8ecf372ee3802190e671
0x6bded42c6da8fbf0d2ba55b2fa120c5e0c8d7891	0xf32fdb63d0a976cc6cec939f2824fcf7f9819f68	false	0x6bded42c6da8fbf0d2ba55b2fa120c5e0c8d7891	7	70684349947437851	211201351619187596354	5036533	2023-10-09T14:40:13.000Z	0x49aec9c794c0c1691f58a23be89d97e21922cf4a512533be33e0f7740087b9d0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v2_base.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
0x1e5adbb49c6bb1d33620fb472e7b2e2bf19831f7	false	0x6bded42c6da8fbf0d2ba55b2fa120c5e0c8d7891	60	1198372106	300000	9215014	2024-01-14T08:02:55.000Z	0xdca8fcb7e65bd089f386f1249bf4e362ccc8f67996bc02bd80906e1ca26f7ca4
0x1e5adbb49c6bb1d33620fb472e7b2e2bf19831f7	false	0x6bded42c6da8fbf0d2ba55b2fa120c5e0c8d7891	19	10000000000000	2500000000	9214893	2024-01-14T07:58:53.000Z	0xf74d1c63945c42efe5ec975cb555f6032d49e4970a46f4c9c8cfc253a427ed72
0x2f8818d1b0f3e3e295440c1c0cddf40aaa21fa87	false	0x6bded42c6da8fbf0d2ba55b2fa120c5e0c8d7891	93	4000000000000000	10014367	9239857	2024-01-14T21:51:01.000Z	0xe418174f21eec72e79f418111b91cc11b62c37075ee2c5c25eee900efd80a64c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v2_base.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
0x000000000000e2dab5ec25935bb63c8c14d408bf	0x14d92a7e0b39594a24e1433af564b47d7f1354f0	false	0x000000000000e2dab5ec25935bb63c8c14d408bf	3	8342870	94875371541743632	140238678075232640378407	2023-12-25T03:31:27.000Z	0x6dd3e0642a87b2d6c9440e8f5603311e6a689cd46ccf2633199b423fc78a2380
0x000000000000e2dab5ec25935bb63c8c14d408bf	0x14d92a7e0b39594a24e1433af564b47d7f1354f0	false	0x000000000000e2dab5ec25935bb63c8c14d408bf	3	8356104	126370812067509024	193994959041186515758397	2023-12-25T10:52:35.000Z	0x69ab0ca7d4e9466ce044256a6600e233cb65cc72c976245561ef191066f6f066
0x000000000000e2dab5ec25935bb63c8c14d408bf	0x14d92a7e0b39594a24e1433af564b47d7f1354f0	false	0x000000000000e2dab5ec25935bb63c8c14d408bf	3	8342486	37140627498470584	53866422080365014169454	2023-12-25T03:18:39.000Z	0x3c23399f02d722e80085e894b3335e9be9c779d22bd4f90661f9e8a6d0f37794

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v2_base.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
0x206a3356d7d4d2d2c9ebcd7cf489f1661a488ca1	false	3	2057148945167764114	3730356980	6081596	2023-11-02T19:15:39.000Z	0x2fab495f221a51e4c3cdf7776aa6373ce8f40e2adfd2c4fb3bc5db27d15048c1
0x206a3356d7d4d2d2c9ebcd7cf489f1661a488ca1	false	3	2059651758852683020	3725667903	6077772	2023-11-02T17:08:11.000Z	0xae30212bbdbe093e0f3621c2dc66331fa0f6166ad80d8386e1893b6dbc286942
0x206a3356d7d4d2d2c9ebcd7cf489f1661a488ca1	false	5	2059596758852683020	3725767095	6075018	2023-11-02T15:36:23.000Z	0x5b6d0337abb42820cca7aa1a8892bf2709090ec3ce3f09c7b1d0620b403b23fd

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v2_base.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
0x206a3356d7d4d2d2c9ebcd7cf489f1661a488ca1	0x206a3356d7d4d2d2c9ebcd7cf489f1661a488ca1	0xccdfe740fa503a9f90c7cdcf0e2e78cb59c0acec	false	26024845785	23	4216033	2023-09-20T14:50:13.000Z	0xc7f4c4a8c03d0a8190e71676982f46ffd999b8d25c0ac66a4fb3ba1b2184886c
0x0000000000000000000000000000000000000000	0x206a3356d7d4d2d2c9ebcd7cf489f1661a488ca1	0x206a3356d7d4d2d2c9ebcd7cf489f1661a488ca1	false	26024845785	24	4216033	2023-09-20T14:50:13.000Z	0xc7f4c4a8c03d0a8190e71676982f46ffd999b8d25c0ac66a4fb3ba1b2184886c
0x0000000000000000000000000000000000000000	0x206a3356d7d4d2d2c9ebcd7cf489f1661a488ca1	0x206a3356d7d4d2d2c9ebcd7cf489f1661a488ca1	false	523668841954	2	5286670	2023-10-15T09:38:07.000Z	0x68ca30394582acca04098dc2473c181eb4744009deca97733e536045f2c02103

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v2_base.Pair_Transfer_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_Swap_event

Pair_Sync_event

Pair_Transfer_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Factory_PairCreated_event

​Pair_Burn_event

​Pair_Mint_event

​Pair_Swap_event

​Pair_Sync_event

​Pair_Transfer_event

Tables

Factory_PairCreated_event

Pair_Burn_event

Pair_Mint_event

Pair_Swap_event

Pair_Sync_event

Pair_Transfer_event