sushiswap_v2_bsc

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	0xe29a2c652e463e5fa38fe9c846909114a622629b	false	1800	0x9b578d423d22e8a21820b97897ba9bf744e809e5	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	25	23515425	2022-11-30T23:22:16.000Z	0xaa9280aea219ad19dbf9216c02c9eaa173b2aab77652ab3042fc3f62d0dd315c
0xc35dadb65012ec5796536bd9864ed8773abc74c4	0x7f893ce3ebe943863dd66bacc39a503811a749ba	false	1799	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	0xe8ea9b8cf96c2531c4bf6fb03220ba473fb0dbfb	12	23515289	2022-11-30T23:15:28.000Z	0xc2d7409c63ecc6eb0db10975a7bdc07a6f00d27f3e5051596c5c3be4372d2bd8
0xc35dadb65012ec5796536bd9864ed8773abc74c4	0x852421d0297ea820467abcc5fae48ccab2301d10	false	1578	0x23396cf899ca06c4472205fc903bdb4de249d6fc	0x3d4350cd54aef9f9b2c29435e0fa809957b3f30a	96	19569026	2022-07-15T09:53:11.000Z	0x44d53e82215190b229290ed2090a3db6c2cd851518b16bd6fe5f61ba0b046278

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v2_bsc.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
0x5219c5e32b9fff87f29d5a833832c29134464aaa	0xf467217b9339debd8b48b6eb892931f2077887e9	false	3482719184729651897	63	28251974	2023-05-16T05:16:35.000Z	0xf9f424cf85dbbdcd26a47a17d33c4b31045d8f8dc07b3c2ac11667cd27a9c74a
0x5219c5e32b9fff87f29d5a833832c29134464aaa	0xf467217b9339debd8b48b6eb892931f2077887e9	false	0	67	28251974	2023-05-16T05:16:35.000Z	0x3b62e5f2d6fdd139ba4613c2697f1f01961a1b19c0ca7cbc74f6f47c0a023353
0x5219c5e32b9fff87f29d5a833832c29134464aaa	0xf467217b9339debd8b48b6eb892931f2077887e9	false	112746220538246945879	160	28249791	2023-05-16T03:27:21.000Z	0xe9d740889c3627108b8f098f63bffc815b6ab98f3a7dce2b33cfad57654ff59c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v2_bsc.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
0x16eb1deae4c4c32805da237db93771b4cb12416a	0x8cc8605f2b54852b54a77b7e9711bb1156581ee9	false	0x1b02da8cb0d097eb8d57a175b88c7d8b47997506	21	45685481441	379372446528014532	22575838	2022-10-28T20:20:51.000Z	0xf92e5303536f65c3328a58bbec6c1c3078febc755edac3c6b0908c956d21c5eb
0xaec2ac8a9df82ae0f5fc6ef2b779a71589622f90	0x8cc8605f2b54852b54a77b7e9711bb1156581ee9	false	0x1b02da8cb0d097eb8d57a175b88c7d8b47997506	290	209529967926	1751226274790088907	22572449	2022-10-28T17:29:45.000Z	0x003d1ddc5118024ccd3dc2a62efe52851ff8f828e7d1b4de5d211b69df2bc255
0xab8785a1058b62016ffdbab5a8f195e61aea5be1	0x2905817b020fd35d9d09672946362b62766f0d69	false	0xab8785a1058b62016ffdbab5a8f195e61aea5be1	213	499252640658487845	1581837188181938	26879010	2023-03-29T07:17:55.000Z	0xf76ebd2753f03f9eac067ae14e59e8f00ca768d90249b5fe2352be85697f27bd

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v2_bsc.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
0x51f914a192a97408d991fdddafb8f8537c5ffb0a	false	0x1b02da8cb0d097eb8d57a175b88c7d8b47997506	110	2714113805901589553	330893383263617403812	6939392	2021-04-27T20:34:31.000Z	0x6f6e79b38daccfd0b618ea6ecb37d03ee5cac149e38bd80b96ea59ecafb4574a
0x51f914a192a97408d991fdddafb8f8537c5ffb0a	false	0x1b02da8cb0d097eb8d57a175b88c7d8b47997506	944	419999999999999999	49947913569326847157	6932455	2021-04-27T14:40:54.000Z	0xad89c303a2be65147d006a4e2275cdc547ccd8b571e98f1ad10b860359217ba7
0x51f914a192a97408d991fdddafb8f8537c5ffb0a	false	0x1b02da8cb0d097eb8d57a175b88c7d8b47997506	622	1299999999999999999	155942169686082528095	6937113	2021-04-27T18:38:21.000Z	0x341936491ca4ce7ca920e6db65dfb589a8b1709de66e33beb4a80e596297426a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v2_bsc.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
0x00000000000061ab74e8283239e8c4e9d2dfed3e	0x3cdb884f5940ce4d4c7255438aea77cfb6072dda	false	0x00000000000061ab74e8283239e8c4e9d2dfed3e	69	30486687	1337840497581956418727227	9686390335796539254	2023-08-02T00:22:20.000Z	0xb4369191ee0aefe9d3a737d70f2d4b9706b8dde7e30388637bc8b395d2701af7
0x0000000000007cf14b1600832c7a2f4fbe143033	0x373345c3efa3fd836ad1d54afbd3c5eb86e12120	false	0x0000000000007cf14b1600832c7a2f4fbe143033	77	30493096	71715693799915385398	10043683115325377256330	2023-08-02T05:43:22.000Z	0x686e26c091bf5eca1b82fc88e577fd0005d2578d89acc20185b0cebdfceca1b9
0x0000000000016a723d0d576df7dc79ec149ac760	0x373345c3efa3fd836ad1d54afbd3c5eb86e12120	false	0x0000000000016a723d0d576df7dc79ec149ac760	59	30511706	9601908464247046138	1604443667129194058102	2023-08-02T21:17:22.000Z	0x6a1b3bbccc260429a1732abddc31f9898c89360192287880857615531c4b0c8a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v2_bsc.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
0x0390c792056ea02aa09b94fb05e703ebd46f3ec3	false	545	3103331219835645274	835539953476683077434939370	13784573	2021-12-25T13:33:55.000Z	0xfe40abc6ac7682c575cc6a14d294dd688f1aaa9f83ff47d31cd9173bcebe66a1
0x0390c792056ea02aa09b94fb05e703ebd46f3ec3	false	220	2940578696508819819	882018995171536844147996206	13786148	2021-12-25T14:52:49.000Z	0x699078e0249a9890183710b0a75981e18f39e845fb7d3b9e55d01e839483c3a5
0x0390c792056ea02aa09b94fb05e703ebd46f3ec3	false	471	2886344992636930408	898542193764981322482921870	13785718	2021-12-25T14:31:19.000Z	0x6cd9c2b8dade966d159a6a8b8644988679f8b2ecb0e1c936141a02a4ecb3ccae

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v2_bsc.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
0x9af6ca1ddd2057cf57d14cfe3e0ae14c21f7064f	0x9af6ca1ddd2057cf57d14cfe3e0ae14c21f7064f	0x8f6b4c1a7c86cd848721f91c4a8c89dabe433d7d	false	174442560786042699	693	15334400	2022-02-17T12:03:56.000Z	0xf5347287d0554c4fe49b6c361e4d073abf1642769773c35e76709d1c70256758
0xc6fd91ad4919fd91e2c84077ba648092cb499638	0x9af6ca1ddd2057cf57d14cfe3e0ae14c21f7064f	0x0000000000000000000000000000000000000000	false	20218138228736034	694	15334400	2022-02-17T12:03:56.000Z	0xf5347287d0554c4fe49b6c361e4d073abf1642769773c35e76709d1c70256758
0x0000000000000000000000000000000000000000	0x9af6ca1ddd2057cf57d14cfe3e0ae14c21f7064f	0x9af6ca1ddd2057cf57d14cfe3e0ae14c21f7064f	false	174442560786042699	695	15334400	2022-02-17T12:03:56.000Z	0xf5347287d0554c4fe49b6c361e4d073abf1642769773c35e76709d1c70256758

Example Query

Query with partition filter

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