biswap_v1_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
0x858e3312ed3a876947ea49d572a7c42de08af7ee	0x39b4ad7d71891d6c33ed60ee6e29a24b814794e3	false	2670	0x0e808ae7bc669e26a5c7fe0ac8faa0f23a98e65b	0x7ff82cb4e9e570d4ad5672444db0015e25f6b135	123	27710458	2023-04-27T09:19:11.000Z	0xcae90142564e640018bac3227f16b67ad9502f632ff17364065d17db1eea50ad
0x858e3312ed3a876947ea49d572a7c42de08af7ee	0xab0b1b7938c63231b31a2d3e66ebe85ae1478082	false	2671	0x9cbb03effd6fb7d79c9bab1b0ceaf4232e957521	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	7	27727762	2023-04-27T23:46:00.000Z	0xa77805624b52bbb08de1e137e566b86c44df3336ad5aa31e0e0f8a5a1599e5a0
0x858e3312ed3a876947ea49d572a7c42de08af7ee	0xbf17f54b12bb757f13ea2e10c96393ebe4971132	false	2543	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	0xf36c19d5507ecb0f3523dca5d617527e4e8b2f74	113	26239840	2023-03-06T20:59:18.000Z	0x2c9c87db2cbe90734f652616d2a38cb0da93aae11d0549461610b8014dbd0336

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.biswap_v1_bsc.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
0x44fbda36ba74707d9d1700fa8e6635e645bd472f	0x05377f3e23e542cf5ccfb280bd2d9b44bcf9bbfd	false	0x3a6d8ca21d1cf76f653a67577fa0d27453350dd8	802	42858660924962923844	45894526687776476187	14045240	2022-01-03T15:06:33.000Z	0xb0c436b5ca7a469c0977bfa5bf5a1ef0a598adab54ab25bd4e444dec55cb1766
0x262e99a2428ac069dde96c48db52bd3d1d07aa53	0x1483767e665b3591677fd49f724bf7430c18bf83	false	0x3a6d8ca21d1cf76f653a67577fa0d27453350dd8	344	2315876946745112092159	2313325584568406599277	14052654	2022-01-03T21:17:15.000Z	0xa1ecd3ab76d9c0fe3cf539d343547b02b79524b1235e6c95f4ca69c5ccfcc7a2
0x078084155454d2062211ab18f5c46f29cf6dbedb	0x1483767e665b3591677fd49f724bf7430c18bf83	false	0x3a6d8ca21d1cf76f653a67577fa0d27453350dd8	348	2158145577855467589922	2157651728275727237050	14055836	2022-01-03T23:56:21.000Z	0x6165808e0f78298b852df959f215969abfe7c634aeb22f413e104946265854e4

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.biswap_v1_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
0x1483767e665b3591677fd49f724bf7430c18bf83	false	0x3a6d8ca21d1cf76f653a67577fa0d27453350dd8	263	2611945097410613232872	2619854606324647931539	7739301	2021-05-26T07:38:30.000Z	0x4dcd62f831b670a70369760f8b94fd8a7d8a192f2e017ffbec5934035b1be847
0x1483767e665b3591677fd49f724bf7430c18bf83	false	0x3a6d8ca21d1cf76f653a67577fa0d27453350dd8	524	501952239975254717497	500078980169481209172	7737501	2021-05-26T06:08:26.000Z	0x6c824a9663acb3aff3d510cf00239f1d96a49878437c0201c19e27f2d9a361e1
0x1483767e665b3591677fd49f724bf7430c18bf83	false	0x3a6d8ca21d1cf76f653a67577fa0d27453350dd8	538	18324515924505896323213	18400041036676358151074	7743893	2021-05-26T11:30:27.000Z	0x5abd250dc4b20a769180006703d4bd2dc8368a678707134bee6647780bd6b0ba

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.biswap_v1_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
0x0000000000008afdacc486225455281f614843e7	0xa987f0b7098585c735cd943ee07544a84e923d1d	false	0x0000000000008afdacc486225455281f614843e7	306	27855435	6680595896401346	186713120936429081825	2023-05-02T10:17:48.000Z	0x65e3d71a149084f485d8ee9e6940db949c2897ef3d5dc02e27240688818ad3dc
0x000000000000d43e334f64e2ae7a8cf488f9ca91	0x203c426c2cbde770d8730fcbe64d16c8064f68fb	false	0x000000000000d43e334f64e2ae7a8cf488f9ca91	13	27850300	298226399894149949432	11263026369026345849604	2023-05-02T06:00:33.000Z	0x038ac00771c2cad396c07ff3f5080b25080ea144b65a95dff14a0d091d732d98
0x0000000000016a723d0d576df7dc79ec149ac760	0x56f6ba7465e67e8b6bda14cf88c933a7720779fa	false	0x0000000000016a723d0d576df7dc79ec149ac760	8	27847136	1398173175000000000	1640242382046649026137	2023-05-02T03:22:14.000Z	0x01caf9042c038e02128fa8bc084e9d62981e060b24eddeb7e5a28bbef378fbe2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.biswap_v1_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
0x556e865f367632d941585138928c2663c8809844	false	633	421089616924814436858	23350558891638701187593	11608064	2021-10-09T00:11:26.000Z	0x22a3bbb3134b81dc28f5d929b58343c836d60a4be1dd30c93ef90ffb3c5b1b9b
0x8840c6252e2e86e545defb6da98b2a0e26d8c1ba	false	506	9985846991477413212948852	23826809889084586294738	11608064	2021-10-09T00:11:26.000Z	0xe27a604760d14ed92255d580b3ef372fb3bf312cf3c750966d8879bc98b1dd2a
0x8840c6252e2e86e545defb6da98b2a0e26d8c1ba	false	80	9992397505305932098980897	23811725028402949779385	11608320	2021-10-09T00:24:14.000Z	0x0e3be006459f1e78303e33e3510d2f6aef30d81ad7f84f454ce4f45d98d4f2ae

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.biswap_v1_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
0x612e072e433a8a08496ee0714930b357426c12ce	0x06cd679121ec37b0a2fd673d4976b09d81791856	0x0000000000000000000000000000000000000000	false	168638527889712340	575	27858413	2023-05-02T12:46:46.000Z	0xe7d335e530aed392ce391142d96fee5354886bfb514f4b68abb31d740b1f55ff
0xdbc1a13490deef9c3c12b44fe77b503c1b061739	0x06cd679121ec37b0a2fd673d4976b09d81791856	0x96eb2f522b1636caa0f6b776b0bc2088a103768e	false	367380702414382796	580	27858413	2023-05-02T12:46:46.000Z	0xe7d335e530aed392ce391142d96fee5354886bfb514f4b68abb31d740b1f55ff
0x96eb2f522b1636caa0f6b776b0bc2088a103768e	0x06cd679121ec37b0a2fd673d4976b09d81791856	0x0000000000000000000000000000000000000000	false	367380702414382796	576	27858413	2023-05-02T12:46:46.000Z	0xe7d335e530aed392ce391142d96fee5354886bfb514f4b68abb31d740b1f55ff

Example Query

Query with partition filter

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