> ## Documentation Index
> Fetch the complete documentation index at: https://tokenterminal.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# bsc_v1_bsc

> Tables in tt-contracts.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.

<Accordion title="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.       |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | in\_owner | in\_value | log\_index | in\_spender | 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 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.bsc_v1_bsc.ERC20_Approval_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### 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.

<Accordion title="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. |
</Accordion>

<Accordion title="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 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.bsc_v1_bsc.StakeHub_StakeCreditInitialized_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### 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.

<Accordion title="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.                                               |
</Accordion>

<Accordion title="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 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.bsc_v1_bsc.StakeHub_ValidatorCreated_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### 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.

<Accordion title="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.                      |
</Accordion>

<Accordion title="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 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.bsc_v1_bsc.ValidatorSet_feeBurned_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### 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.

<Accordion title="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.                                         |
</Accordion>

<Accordion title="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 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.bsc_v1_bsc.ValidatorSet_validatorSetUpdated_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***