bsc_v1_bsc

Tables

ERC20_Approval_event

ERC-20 (Ethereum Request for Comments-20) token approval events on BNB Smart Chain (BSC), recording when token holders authorize spenders to transfer tokens on their behalf. Used for tracking token allowances granted to decentralized exchanges, protocols, and other smart contracts.

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_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_spender`	`STRING`	Address authorized to spend tokens on behalf of the owner. 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

address	removed	log_index	block_number	block_timestamp	transaction_hash
0xc7e48bc06d2ed7a96c33b3ad0e2e66d565fe7e5b	false	163	24650240	2023-01-10T00:02:09.000Z	0xd3a9d155b64ab7dadbd3c6cdcfd971896a24cb9e6cd3d7e643cc681075209c52
0x77e8ace40b478d1e405e450cd42afd5b94746a28	false	83	24651520	2023-01-10T01:06:20.000Z	0xe0c05f888a8dd81c9fb0d204a0a6a797af76277a34204753b37b25437e892db6
0xdfe8f54b894793bfbd2591033e7a307ed28a8d40	false	118	24651776	2023-01-10T01:19:22.000Z	0x164d106940194557ac38e8a65d6082f6fb051366f2d6b108feb82c70c1d35762

Example Query

Query with partition filter

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

StakeHub_StakeCreditInitialized_event

StakeHub contract initialization events on BNB Smart Chain (BSC) recording when new stake credit contracts are created for validator operators. Used for tracking validator onboarding and stake credit deployment across BSC’s proof-of-stake consensus system.

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_operatorAddress`	`STRING`	Contract address of the validator operator whose stake credit was initialized. This address represents the entity operating the validator node on BSC’s BNB staking system.
`in_creditContract`	`STRING`	Contract address of the stake credit token contract initialized for the validator operator. Hex-encoded, 0x-prefixed 40-character string representing the ERC-20-like token that tracks staking credits on BSC.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_creditContract	in_operatorAddress
0x0000000000000000000000000000000000002002	false	170	39044394	2024-05-25T23:40:27.000Z	0xf1f92df317c20c18c961f16376db0aa395789d408df47b646ac94ffc24cfaf76	0xd38ae55b29ec84d9633d166bae977fa4618bf621	0x0813d0d092b97c157a8e68a65ccdf41b956883ae
0x0000000000000000000000000000000000002002	false	33	39041109	2024-05-25T20:55:28.000Z	0x9a9a252fd75ba1f729451a508f5c72e04af3c7fbd325669f0db9f0460c44c250	0x0fab00071be18caad4c9984ec68e860e84c68dad	0x8683dcb7a775df4587eefad7c08ee647d1da32c1
0x0000000000000000000000000000000000002002	false	103	39042795	2024-05-25T22:20:06.000Z	0xa39dd2c90213a97b2bd0aa531f2025e7f0ffbe315c8f8a4bd69fb42661281a9d	0x19a96b6de86fad8c6603d3c35692cf32e4e55ac2	0x31738238b6a4fcb00ba4de9ee923986b6df55ae6

Example Query

Query with partition filter

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

StakeHub_ValidatorCreated_event

Validator registration events from BSC’s StakeHub contract, capturing consensus, operator, and vote addresses when new validators are created on BNB Smart Chain. Contains validator identity data for tracking network participation and staking infrastructure.

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_consensusAddress`	`STRING`	BLS (Boneh-Lynn-Shacham) consensus address used by the validator to participate in block validation on BSC. Hex-encoded, 0x-prefixed 40-character string representing the validator’s consensus-layer identity.
`in_operatorAddress`	`STRING`	Wallet address authorized to operate and manage the validator on behalf of the validator owner. Hex-encoded, 0x-prefixed 40-character address that controls validator operations but may differ from the consensus or credit contract addresses.
`in_creditContract`	`STRING`	Contract address managing credit and delegation functions for this validator. Typically deployed during validator creation to handle staking credits and rewards distribution.
`in_voteAddress`	`STRING`	BLS public key used by the validator for voting in the consensus protocol. 96-character hex string representing the validator’s cryptographic identity on BSC’s Proof of Staked Authority network.

Sample Data

address	removed	log_index	block_number	in_voteAddress	block_timestamp	transaction_hash	in_creditContract	in_operatorAddress	in_consensusAddress
0x0000000000000000000000000000000000002002	false	212	38189558	0xadc9ae11a5f0da15082a4ded8abaeb73338984c06e2c1af2eb24232e00511e95b24e89291d689f6bedb13d5a398af2ec	2024-04-26T05:49:40.000Z	0x7cdfad4449d977beca50d2b2793c1078e0014e9e752d7e02092ea47a521dee54	0xe48ff82faa5aab796bb7e1f2208cb43008462022	0xaacc290a1a4c89f5d7bc29913122f5982916de48	0x8a239732871adc8829ea2f47e94087c5fbad47b6
0x0000000000000000000000000000000000002002	false	156	38203249	0xb1e211be938b9f77888cbdc7bd3787148a6d1653eb0e17603df69d67db30fa4857e11edec461e01e3e02cea2c7d2c5dd	2024-04-26T17:15:08.000Z	0xd273ac4a0d091601334624bd1fedd9b5d2ab671f288843312636b2f88f526039	0x8e01cf1c95fe6699c06aac0a9f3e33297778d682	0x0e3cf208f4141c41da86d52c5f2076b1ab310e8f	0xccb42a9b8d6c46468900527bc741938e78ab4577
0x0000000000000000000000000000000000002002	false	183	38190547	0x8d68efc0951aa89bf89fd829dd021fac27712f0f046e70d2d33a8a1fc05554a16d26669a9adb33bb41aaff43df7d4da0	2024-04-26T06:39:07.000Z	0xa82c434cd0c42abda694d38eaa0a988f74b79e55d24a2890118acc08e3de19c1	0xb4c7b55664622ed960b3418e626d868a2151c470	0xa31a940ecfb4cb9fe7884eb3c9a959db79cbdc70	0xf8b99643fafc79d9404de68e48c4d49a3936f787

Example Query

Query with partition filter

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

ValidatorSet_feeBurned_event

Fee burn events from BSC’s ValidatorSet system contract tracking BNB amounts destroyed through transaction fees. Used for analyzing BSC’s deflationary tokenomics and validator fee distribution mechanics.

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_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash
0x0000000000000000000000000000000000001000	false	5425005441048427	256	19666975	2022-07-18T19:37:29.000Z	0x38b151e827063655b6bbb44ce867c7af93c6a450b35b94ac1282f4f2dcc9b3cd
0x0000000000000000000000000000000000001000	false	8780917228870932	256	19668699	2022-07-18T21:03:41.000Z	0xb325f0ba6cc4134205c530dfa14c695635701bf9794628e4e4c7ffd575442f32
0x0000000000000000000000000000000000001000	false	6217579950378879	256	19654157	2022-07-18T08:55:32.000Z	0xa684458f11b8e3b5f62a6bce2f5565cb4132bd1e9b623978352a838d74e411e1

Example Query

Query with partition filter

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

ValidatorSet_validatorSetUpdated_event

Validator set change events from BNB Smart Chain’s system contract tracking additions and removals of block validators. Used for analyzing validator rotation patterns and network governance on BSC.

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.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash
0x0000000000000000000000000000000000001000	false	9	31260884	2023-08-29T00:00:37.000Z	0xa67d3bf96f8b58d7300a1ec01c7b05d5a3f4e947f3b388b28b0b1be91c1a4311
0x0000000000000000000000000000000000001000	false	15	32236907	2023-10-02T00:00:18.000Z	0x67c3dd899d67c5878c06736ecaa5067216720376929594160ba736f540bd253b
0x0000000000000000000000000000000000001000	false	37	16808843	2022-04-10T00:01:10.000Z	0x88d40a89863cad334acda5d7ee48a9e5d5639ec104bf55e25cce821f5ea1589b

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

ERC20_Approval_event

StakeHub_StakeCreditInitialized_event

StakeHub_ValidatorCreated_event

ValidatorSet_feeBurned_event

ValidatorSet_validatorSetUpdated_event

​Tables

​ERC20_Approval_event

​StakeHub_StakeCreditInitialized_event

​StakeHub_ValidatorCreated_event

​ValidatorSet_feeBurned_event

​ValidatorSet_validatorSetUpdated_event

Tables

ERC20_Approval_event

StakeHub_StakeCreditInitialized_event

StakeHub_ValidatorCreated_event

ValidatorSet_feeBurned_event

ValidatorSet_validatorSetUpdated_event