wbnb_v1_bsc

Tables

WBNB_Approval_event

Token approval events for Wrapped BNB (WBNB) on BNB Smart Chain, recording when token holders authorize spenders to transfer WBNB on their behalf. Captures approval amounts in wei, owner addresses (in_src), spender addresses (in_guy), and transaction details for analyzing protocol interactions and token allowances.

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_src`	`STRING`	Address of the account from which tokens or assets are being withdrawn or transferred. Hex-encoded, 0x-prefixed, 42-character string.
`in_guy`	`STRING`	Address of the spender or recipient approved to transfer tokens. Hex-encoded, 0x-prefixed, 42-character string.
`in_wad`	`STRING`	Token amount denominated in WAD units. String-encoded integer representing value with 18 decimal places of precision.

Sample Data

in_guy	in_src	in_wad	address	removed	log_index	block_number	block_timestamp	transaction_hash
0x0000000000000000000000000000000000000000	0x8d1f338f8abd714fd09ec13c100a0d7df693cd5d	250000000000000000	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	false	539	19656473	2022-07-18T10:51:22.000Z	0xe6226d6fe146165b7a221440eaac0ab90312bb048b08b51b516e5b639ed5c1d4
0x0000000000000000000000000000000000000000	0xb97ebf6ff02d23d141cb1676097cab9921a6226b	0	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	false	278	19650188	2022-07-18T05:36:18.000Z	0x956fecafb2f80debe7d7445c84eaca22dd8df4c1ef41df2aae62ad03de56ffc9
0x0000000000000000000000000000000000000000	0xd7a3b35e93e81a78e61db5175019898e58179376	209504918233963672	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	false	140	19664664	2022-07-18T17:41:32.000Z	0x7f8c9b7afbdfb75177a644d373cecec6e12c142adc925bec978ad185958cc1a2

Example Query

Query with partition filter

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

WBNB_Deposit_event

Wrapped BNB (WBNB) deposit events on BNB Smart Chain, recording conversions of native BNB to the ERC-20 wrapped token with depositor addresses and amounts in wei. Enables tracking of WBNB minting activity and liquidity flows into DeFi 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_dst`	`STRING`	Address of the account receiving tokens or assets in the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_wad`	`STRING`	Token amount denominated in WAD units. String-encoded integer representing value with 18 decimal places of precision.

Sample Data

in_dst	in_wad	address	removed	log_index	block_number	block_timestamp	transaction_hash
0x00000000000e8716b4e2d12400a01474cdfad760	1247068580682835850	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	false	187	32943475	2023-10-26T14:55:54.000Z	0x40ee941dbff41c84131e763b6f2bec4b97509a3a37f67a7e0bd5bc8ce761cf75
0x0000000000be6d8381e3a01c19e3b3c2b6d9c7cd	234377000000000000000	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	false	23	32932616	2023-10-26T05:50:58.000Z	0x295de3b4ecc02dc2ae3f56c6a1af1305f5364d6a6204cbcfd19f570e060cd764
0x0000000000be6d8381e3a01c19e3b3c2b6d9c7cd	219082899999999983616	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	false	17	32936741	2023-10-26T09:18:22.000Z	0xe0bfde293b2af094c490a1b284e9f528321c5e3a18de2f20565f4c5c41390dbb

Example Query

Query with partition filter

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

WBNB_Transfer_event

Wrapped BNB (WBNB) token transfer events on BNB Smart Chain, showing sender, recipient, and transfer amounts in wei. Tracks all WBNB movement between addresses for analyzing liquidity flows and trading patterns across DEXs like PancakeSwap.

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_src`	`STRING`	Address of the account from which tokens or assets are being withdrawn or transferred. Hex-encoded, 0x-prefixed, 42-character string.
`in_dst`	`STRING`	Address of the account receiving tokens or assets in the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_wad`	`STRING`	Token amount denominated in WAD units. String-encoded integer representing value with 18 decimal places of precision.

Sample Data

in_dst	in_src	in_wad	address	removed	log_index	block_number	block_timestamp	transaction_hash
0x10ed43c718714eb63d5aa57b78b54704e256024e	0x58f876857a02d6762e0101bb5c46a8c1ed44dc16	267050966867497	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	false	335	17245898	2022-04-25T06:13:20.000Z	0xd191dedbe3476561d637e6328b19613b8653cb098b0b63abf9590f6e06af441a
0x34758094b63e81c2636ee1eac6719d12ee3f808f	0x10ed43c718714eb63d5aa57b78b54704e256024e	7000000000000000	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	false	397	17245898	2022-04-25T06:13:20.000Z	0xf77a2aebe7fab42d557caccbc7f1bdb6f690d808412c6f1acc3440bd332ee118
0x3a6d8ca21d1cf76f653a67577fa0d27453350dd8	0x46492b26639df0cda9b2769429845cb991591e0a	162418742598158282	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	false	250	17245898	2022-04-25T06:13:20.000Z	0xbad60592c258e78c32d9751e62057cceff5c1a03ff71dc9f9a04d7733cb058c9

Example Query

Query with partition filter

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

WBNB_Withdrawal_event

Wrapped BNB (WBNB) unwrapping events on BNB Smart Chain, recording conversions from WBNB back to native BNB. Tracks withdrawal amounts and source addresses for analyzing WBNB liquidity flows and exchange activity.

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_src`	`STRING`	Address of the account from which tokens or assets are being withdrawn or transferred. Hex-encoded, 0x-prefixed, 42-character string.
`in_wad`	`STRING`	Token amount denominated in WAD units. String-encoded integer representing value with 18 decimal places of precision.

Sample Data

in_src	in_wad	address	removed	log_index	block_number	block_timestamp	transaction_hash
0x10ed43c718714eb63d5aa57b78b54704e256024e	71045444826862278	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	false	297	29638167	2023-07-03T11:07:44.000Z	0x9c59630cebe909d212ac060a96181c4e48b1c4859e8c9d00bfd908a34d5f2318
0x13f4ea83d0bd40e75c8222255bc855a974568dd4	6360956106979299	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	false	358	29638847	2023-07-03T11:41:52.000Z	0x8712f59b58095efa95fe22d218c04908fbc775c0c245a7dc7d19b0f12149d6de
0x13f4ea83d0bd40e75c8222255bc855a974568dd4	174741812066607189	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	false	271	29638847	2023-07-03T11:41:52.000Z	0x84a2384f577dae70f713294496e1d7415a7cbea6dac14dd92af6bc9c2e1760fb

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

WBNB_Approval_event

WBNB_Deposit_event

WBNB_Transfer_event

WBNB_Withdrawal_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​WBNB_Approval_event

​WBNB_Deposit_event

​WBNB_Transfer_event

​WBNB_Withdrawal_event

Tables

WBNB_Approval_event

WBNB_Deposit_event

WBNB_Transfer_event

WBNB_Withdrawal_event