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

# overnight_v1_bsc

> Tables in tt-contracts.overnight_v1_bsc

## Tables

### ETS\_PayoutEvent\_event

Payout events from Overnight Finance's Exchange Token Sale (ETS) vault strategy on BNB Smart Chain, recording profit distributions, performance fees, and occasional losses. Used for analyzing vault performance, fee collection patterns, and return attribution across different strategy 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_tvlFee`          | `STRING`    | Fee amount calculated based on total value locked (TVL). String-encoded integer representing token amounts in the smallest denomination.                                                                                     |
  | `in_profitFee`       | `STRING`    | Fee amount deducted from profit. String-encoded integer representing token amounts in the smallest denomination.                                                                                                             |
  | `in_profit`          | `STRING`    | Profit amount generated by the protocol operation or position. String-encoded integer representing token amounts in the smallest denomination.                                                                               |
  | `in_loss`            | `STRING`    | Loss amount incurred by the protocol operation or position. String-encoded integer representing token amounts in the smallest denomination.                                                                                  |
  | `in_bufferBalance`   | `STRING`    | Amount held in the contract's buffer balance at the time of payout, denominated in the smallest token unit (wei-equivalent). Consistently zero in sample data, suggesting buffer is typically depleted during payout events. |
  | `in_collectorAmount` | `STRING`    | Amount of tokens allocated to the protocol fee collector from the payout event. Denominated in the smallest unit of the token (e.g., wei), typically representing 25% of the profit fee based on sample values.              |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | in\_loss | removed | in\_profit             | in\_tvlFee | log\_index | block\_number | in\_profitFee         | block\_timestamp         | in\_bufferBalance | transaction\_hash                                                  | in\_collectorAmount   |
  | ------------------------------------------ | -------- | ------- | ---------------------- | ---------- | ---------- | ------------- | --------------------- | ------------------------ | ----------------- | ------------------------------------------------------------------ | --------------------- |
  | 0x65afd05fbc4413948ffaad8bcb13f71b6f79332d | 0        | false   | 1824607942052598795418 | 0          | 159        | 25995241      | 456151985513149698854 | 2023-02-26T07:01:33.000Z | 0                 | 0x583becd7e9410865430b5ef505da07be0fec095a77763b835ad8bdccf983d02f | 456151985513149698854 |
  | 0x65afd05fbc4413948ffaad8bcb13f71b6f79332d | 0        | false   | 445028310126980464470  | 0          | 178        | 24915051      | 111257077531745116117 | 2023-01-19T07:01:40.000Z | 0                 | 0xc4136ca3c5e8a629eb179bbdc055972b4a01cb1d6ecc1755ff088310423ec546 | 111257077531745116117 |
  | 0x65afd05fbc4413948ffaad8bcb13f71b6f79332d | 0        | false   | 474892034710074605418  | 0          | 234        | 25227681      | 118723008677518651354 | 2023-01-30T07:01:52.000Z | 0                 | 0xd2467f619acdd1e19bab494ffcdafedbbcd040d23e994d95558a9d994790f39c | 118723008677518651354 |
</Accordion>

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

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

***

### ETS\_RoleGranted\_event

Access control role assignment events from Overnight Finance protocol on BSC, tracking when addresses are granted specific permissions. Used for analyzing protocol governance, administrative actions, and permission changes across 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_role`          | `STRING`    | Role identifier for access control. 66-character keccak256 hash including 0x prefix.                                                                 |
  | `in_account`       | `STRING`    | Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.                                             |
  | `in_sender`        | `STRING`    | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.                                                  |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | in\_role                                                           | removed | in\_sender                                 | log\_index | in\_account                                | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x071a288c4b0c786c2e59854436445c66b92e86f2 | 0xa49807205ce4d355092ef5a8a18f56e8913cf4a201fbe287825b095693c21775 | false   | 0x510c7ff863bd6c86d8741306646a19dad18af65a | 651        | 0x3a575da987d1dca7370a8bbf8cb7d08fb06c7fdc | 15909258      | 2022-03-09T13:02:45.000Z | 0x79bfd8e250521ca131c7b42de4792be080a339c1236f8bb955efa6a3eb11b21b |
  | 0x0bb28fe76cecbbd36145a2684074e5a46beea061 | 0x0000000000000000000000000000000000000000000000000000000000000000 | false   | 0x4ac30ce621fba04c178cfda9140deca1533de5f8 | 510        | 0x4ac30ce621fba04c178cfda9140deca1533de5f8 | 15920130      | 2022-03-09T22:11:03.000Z | 0x44dc10e23ab0c234921e19878997e5a0faf7dde135e7b50fdf38e36f24d48498 |
  | 0x13d35100a150f5ec616ac667b68eac3273a1dd8d | 0x0000000000000000000000000000000000000000000000000000000000000000 | false   | 0x9ac03268909bc9586d6b72de309dfbcf6468469c | 342        | 0x72a6eed86fefba17edb9ffde97e61ec63d9f63f5 | 15906069      | 2022-03-09T10:22:00.000Z | 0x05c14c81e306bf6995b1487346d98b910ab6ce288c6c9584ba723a486fab702e |
</Accordion>

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

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

***

### OldETS\_PayoutEvent\_event

Payout events from a deprecated Overnight Finance ETS (Exchange Traded Strategy) contract on BNB Chain, recording profit distributions, total value locked (TVL) fees, and loss amounts. Used for analyzing historical yield payouts and fee structures before the protocol upgrade.

<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_tvlFee`        | `STRING`    | Fee amount calculated based on total value locked (TVL). String-encoded integer representing token amounts in the smallest denomination.             |
  | `in_profitFee`     | `STRING`    | Fee amount deducted from profit. String-encoded integer representing token amounts in the smallest denomination.                                     |
  | `in_profit`        | `STRING`    | Profit amount generated by the protocol operation or position. String-encoded integer representing token amounts in the smallest denomination.       |
  | `in_loss`          | `STRING`    | Loss amount incurred by the protocol operation or position. String-encoded integer representing token amounts in the smallest denomination.          |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | in\_loss | removed | in\_profit | in\_tvlFee | log\_index | block\_number | in\_profitFee | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | -------- | ------- | ---------- | ---------- | ---------- | ------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0xc6eca7a3b863d720393dfc62494b6eab22567d37 | 0        | false   | 13579863   | 684698     | 454        | 22872938      | 2396446       | 2022-11-08T07:43:32.000Z | 0x1a994ec740a15e2935f9f10e934f5d21e4e16e477720e00bfddc4ad765c7ceac |
  | 0xbaac6ed05b2feb47ef04b63018a27d80cbea10d1 | 0        | false   | 199048109  | 10663291   | 313        | 21262183      | 49762027      | 2022-09-12T07:45:46.000Z | 0x7aefa9744fc6a116d029497c5a3186e0b8db6aef50b4965f4975fa26ae561da3 |
  | 0xc6eca7a3b863d720393dfc62494b6eab22567d37 | 0        | false   | 50695384   | 2556069    | 363        | 21262191      | 8946244       | 2022-09-12T07:46:10.000Z | 0x468ad105bd7b90ebfcf45821fafc6f68de3d513ec1ff5a87a117c0f835cc68df |
</Accordion>

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

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

***

### OldSkims\_RewardWalletSend\_event

Reward distribution events from Overnight Protocol's deprecated (OldSkims) contract on BNB Smart Chain, recording token amounts sent to reward wallets. Used for tracking historical reward payouts and protocol revenue distribution patterns.

<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                                                  |
  | ------------------------------------------ | ------- | ---------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0xd9fcdffed5ca34ef21661ec6fe3aeb742db6331e | false   | 51         | 361        | 26536573      | 2023-03-17T07:00:53.000Z | 0xb86f49e9adbceadd765e4504d529d1d8b9f88b965518ab2221b234373b237ba3 |
  | 0xd9fcdffed5ca34ef21661ec6fe3aeb742db6331e | false   | 91         | 512        | 26479814      | 2023-03-15T07:00:34.000Z | 0x47c945fd8e337faf147436ca4e9d6cd8433dcba5ccefe9245e79f09b6ca60e9c |
  | 0xd9fcdffed5ca34ef21661ec6fe3aeb742db6331e | false   | 91         | 424        | 26821603      | 2023-03-27T07:01:06.000Z | 0x8a1bbc62133981400a96a860e85c0aff5d1d1e6ea25dbf2af3b15c11d59375b9 |
</Accordion>

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

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

***

### OldSkims\_ThenaSkimReward\_event

Reward skim events from Overnight's integration with Thena DEX liquidity pools on BNB Smart Chain. Tracks bribe reward collections from specific pools with amounts and associated bribe contract addresses for analyzing yield optimization strategies.

<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_pool`          | `STRING`    | Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.                                           |
  | `in_bribe`         | `STRING`    | Contract address of the bribe contract associated with the gauge or pool. Hex-encoded, 0x-prefixed, 42-character string.                             |
  | `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                                    | in\_pool                                   | removed | in\_bribe                                  | in\_amount | log\_index | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0xd9fcdffed5ca34ef21661ec6fe3aeb742db6331e | 0x1f3ca66c98d682fa1bec31264692dad4f17340bc | false   | 0x8fbf01a6d3fef2847f2c35d9a05476eb859d6b2e | 96397926   | 487        | 25484577      | 2023-02-08T08:51:03.000Z | 0x653a5dae3c69bc30fdbaec1050dc93c5e347dad522939f94864191a791593388 |
  | 0xd9fcdffed5ca34ef21661ec6fe3aeb742db6331e | 0x92573046bd4aba37d875eb45a0a1182ac63d5580 | false   | 0x90ab86ddd5fdae0207367c2d09e10ef1fb3cb651 | 455634369  | 480        | 25484577      | 2023-02-08T08:51:03.000Z | 0x653a5dae3c69bc30fdbaec1050dc93c5e347dad522939f94864191a791593388 |
  | 0xd9fcdffed5ca34ef21661ec6fe3aeb742db6331e | 0x150990b9630ffe2322999e86905536e2e7e8d93f | false   | 0x8828bd1b7abc5296d3fcfeb15f58c23088410449 | 63903129   | 494        | 25484577      | 2023-02-08T08:51:03.000Z | 0x653a5dae3c69bc30fdbaec1050dc93c5e347dad522939f94864191a791593388 |
</Accordion>

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

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

***

### OldSkims\_TotalSkimReward\_event

TotalSkimReward events from Overnight Finance's deprecated skim contract on BNB Smart Chain, recording reward distributions with amounts and contract addresses. Used to track historical reward payouts before protocol upgrades.

<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                                                  |
  | ------------------------------------------ | ------- | ---------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0xd9fcdffed5ca34ef21661ec6fe3aeb742db6331e | false   | 0          | 496        | 25741193      | 2023-02-17T08:51:18.000Z | 0xe7b3f4a40fe3af90729edb3efb6688cadd38b7e2bb3dbe23ecce90eea03d7ac7 |
  | 0xd9fcdffed5ca34ef21661ec6fe3aeb742db6331e | false   | 0          | 253        | 26166161      | 2023-03-04T07:01:22.000Z | 0x80855a3cfd612664d0b52770fcfbbbe05dd9408de51c5f1caf154b27cf2645e5 |
  | 0xd9fcdffed5ca34ef21661ec6fe3aeb742db6331e | false   | 0          | 361        | 26023819      | 2023-02-27T07:02:35.000Z | 0x360ad3a19f618468caf089fff42d7d80aa8da9fc033f669dbfc2f8373b4de15e |
</Accordion>

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

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

***

### OldUSDCExchange\_PayoutEvent\_event

Profit distribution events from Overnight Finance's deprecated USDC exchange contract on BNB Smart Chain, tracking yield payouts with profit amounts and liquidity index updates. Used for analyzing historical yield generation patterns and excess profit distributions in the protocol's earlier version.

<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_profit`            | `STRING`    | Profit amount generated by the protocol operation or position. String-encoded integer representing token amounts in the smallest denomination.                                       |
  | `in_newLiquidityIndex` | `STRING`    | Updated liquidity index value after the payout event. String-encoded integer with 27-digit precision representing the protocol's cumulative liquidity scaling factor.                |
  | `in_excessProfit`      | `STRING`    | Profit amount exceeding the protocol's retention threshold, distributed to excess profit mechanisms. String-encoded integer representing token amounts in the smallest denomination. |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | in\_profit | log\_index | block\_number | block\_timestamp         | in\_excessProfit | transaction\_hash                                                  | in\_newLiquidityIndex       |
  | ------------------------------------------ | ------- | ---------- | ---------- | ------------- | ------------------------ | ---------------- | ------------------------------------------------------------------ | --------------------------- |
  | 0x5a8eee279096052588dfcc4e8b466180490db821 | false   | 836674031  | 282        | 26166161      | 2023-03-04T07:01:22.000Z | 0                | 0x80855a3cfd612664d0b52770fcfbbbe05dd9408de51c5f1caf154b27cf2645e5 | 165599317333767137064771862 |
  | 0x5a8eee279096052588dfcc4e8b466180490db821 | false   | 714534142  | 518        | 25741193      | 2023-02-17T08:51:18.000Z | 534806889        | 0xe7b3f4a40fe3af90729edb3efb6688cadd38b7e2bb3dbe23ecce90eea03d7ac7 | 164717029839906375298055762 |
  | 0x5a8eee279096052588dfcc4e8b466180490db821 | false   | 11336633   | 345        | 24203393      | 2022-12-25T07:22:00.000Z | 0                | 0x08ba69076ec9371c94c17702da77474a3e58518dd7aa9e61462cc40a6b667fea | 162495957801032450266617708 |
</Accordion>

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

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

***

### Skimmer\_PoolOperation\_event

Pool operation events from Overnight Finance's Skimmer contract on BNB Chain, tracking bribe distributions and skim operations across decentralized exchange liquidity pools. Records token transfers to recipients with pool identifiers, operation types, and DEX metadata for analyzing Overnight's liquidity incentive strategy.

<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_dexName`       | `STRING`    | Name of the decentralized exchange (DEX) where the pool operation occurred. Common values include Thena, Pancake, and Wombat on BSC.                                                                                                                              |
  | `in_operation`     | `STRING`    | Enumerated operation type identifier for the event. Integer code representing the specific operation that triggered the event.                                                                                                                                    |
  | `in_poolName`      | `STRING`    | Human-readable name of the liquidity pool involved in the operation, typically showing the trading pair and pool type (e.g., sAMM, vAMM). Examples include "sAMM-USDT+/USD+" for stablecoin automated market makers and "vAMM-USD+/THE" for volatile asset pairs. |
  | `in_pool`          | `STRING`    | Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.                                                                                                                                                        |
  | `in_token`         | `STRING`    | Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.                                                                                                                                                            |
  | `in_amount`        | `STRING`    | Input amount for the swap, transaction, or 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.                                                                                                                                                   |
</Accordion>

<Accordion title="Sample Data">
  | in\_to                                     | address                                    | in\_pool                                   | removed | in\_token                                  | in\_amount | log\_index | in\_dexName | in\_poolName    | block\_number | in\_operation | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ---------- | ----------- | --------------- | ------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x8077d5a4728f6cdebef8503c8f66c39633af347d | 0xa772b0ba6042b9416a619f6638dcfeac4a8b31ff | 0x150990b9630ffe2322999e86905536e2e7e8d93f | false   | 0xe80772eaf6e2e18b651f160bc9158b2a5cafca65 | 4633       | 526        | Thena       | sAMM-USD+/CUSD  | 32073025      | Bribe         | 2023-09-26T07:00:36.000Z | 0x7287c09c8173ec3f58b81fe5eebfa1126dfc1781c17a5fd0b8a8565f1b6c57f3 |
  | 0x9030d5c596d636eefc8f0ad7b2788ae7e9ef3d46 | 0xa772b0ba6042b9416a619f6638dcfeac4a8b31ff | 0x150990b9630ffe2322999e86905536e2e7e8d93f | false   | 0xe80772eaf6e2e18b651f160bc9158b2a5cafca65 | 1158       | 521        | Thena       | sAMM-USD+/CUSD  | 32073025      | Bribe         | 2023-09-26T07:00:36.000Z | 0x7287c09c8173ec3f58b81fe5eebfa1126dfc1781c17a5fd0b8a8565f1b6c57f3 |
  | 0x9030d5c596d636eefc8f0ad7b2788ae7e9ef3d46 | 0xa772b0ba6042b9416a619f6638dcfeac4a8b31ff | 0x1561d9618db2dcfe954f5d51f4381fa99c8e5689 | false   | 0xe80772eaf6e2e18b651f160bc9158b2a5cafca65 | 2334047    | 557        | Thena       | sAMM-USDT+/USD+ | 32073025      | Bribe         | 2023-09-26T07:00:36.000Z | 0x7287c09c8173ec3f58b81fe5eebfa1126dfc1781c17a5fd0b8a8565f1b6c57f3 |
</Accordion>

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

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

***

### USDCExchange\_EventExchange\_event

Exchange transaction events from Overnight Finance's USDC vault on BSC, tracking buy and redeem operations with amounts, fees, and participant addresses for analyzing vault activity and user behavior.

<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_label`         | `STRING`    | Label describing the type of operation or transaction. Common values include 'mint', 'redeem', and 'buy'.                                                      |
  | `in_amount`        | `STRING`    | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.                                |
  | `in_fee`           | `STRING`    | Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency. |
  | `in_sender`        | `STRING`    | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.                                                            |
</Accordion>

<Accordion title="Sample Data">
  | in\_fee | address                                    | removed | in\_label | in\_amount | in\_sender                                 | log\_index | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------- | ------------------------------------------ | ------- | --------- | ---------- | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 6975    | 0x5a8eee279096052588dfcc4e8b466180490db821 | false   | buy       | 17430763   | 0xbd87fdad3cec221ebb4bf11f4ead250331752e17 | 174        | 20516678      | 2022-08-17T09:29:46.000Z | 0x848e64e35b9cb9c4d8dbbd30a07b5b2c0d0dd48551308f6553fd509896b426ad |
  | 38753   | 0x5a8eee279096052588dfcc4e8b466180490db821 | false   | buy       | 96844199   | 0x478defd9c86977b06bf1ebc14b489d80cf8bb298 | 226        | 20509422      | 2022-08-17T03:26:58.000Z | 0x69adce449f8ce7ba58a4031e7c842cd3a1ffa2ebbd96a173e525616ec2d459ca |
  | 480000  | 0x5a8eee279096052588dfcc4e8b466180490db821 | false   | buy       | 1199520000 | 0x489d55df278224a05f793098d41753d5669d5144 | 285        | 20524399      | 2022-08-17T15:55:57.000Z | 0x9e454a13aa97c7f92416035d5b360bbfd4e8e02080873207fcd1a1302751697c |
</Accordion>

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

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

***

### USDCExchange\_PayoutEvent\_event

Daily yield distribution events from Overnight Protocol's USD+ stablecoin contract on BSC. Records total assets, USD+ supply, amounts paid out, and updated liquidity index for tracking rebasing token yield accrual.

<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_totalUsdPlus`      | `STRING`    | Total supply of USD+ stablecoin tracked by the exchange contract at the time of the payout event. Values represent token amounts in their smallest unit (likely 6 decimals for USDC-based stablecoin).                                                                                        |
  | `in_totalAsset`        | `STRING`    | Total value of assets held in the protocol at the time of the payout event, denominated in the smallest unit of the stablecoin (e.g., 6 decimals for USDC). Values range from thousands to hundreds of billions, representing the protocol's asset under management during each daily payout. |
  | `in_totallyAmountPaid` | `STRING`    | Cumulative amount paid out to users since contract inception, denominated in the smallest unit of the stablecoin (6 decimals for USDC). Values grow over time as daily payouts accumulate, representing total yield distributed by the Overnight protocol's USDCExchange contract.            |
  | `in_newLiquidityIndex` | `STRING`    | Updated liquidity index value after the payout event. String-encoded integer with 27-digit precision representing the protocol's cumulative liquidity scaling factor.                                                                                                                         |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | log\_index | block\_number | in\_totalAsset | block\_timestamp         | in\_totalUsdPlus | transaction\_hash                                                  | in\_newLiquidityIndex        | in\_totallyAmountPaid |
  | ------------------------------------------ | ------- | ---------- | ------------- | -------------- | ------------------------ | ---------------- | ------------------------------------------------------------------ | ---------------------------- | --------------------- |
  | 0x5a8eee279096052588dfcc4e8b466180490db821 | false   | 521        | 19967368      | 22027325       | 2022-07-29T07:00:06.000Z | 21988800         | 0x91f6f2f0d757ef14120c705520e82a2ad4596828a83fe2bb1012c6ded0bde32a | 1001752028305319071527323001 | 38525                 |
  | 0x5a8eee279096052588dfcc4e8b466180490db821 | false   | 253        | 22418108      | 870690112005   | 2022-10-23T07:00:12.000Z | 848738959729     | 0xe4f617c72af4f7aec914004e606f1ebdefc69f0fc1229199ce269316fb02041e | 1025863255155764509031832866 | 21951152276           |
  | 0x5a8eee279096052588dfcc4e8b466180490db821 | false   | 1057       | 21002586      | 708170723217   | 2022-09-03T07:00:22.000Z | 698876549807     | 0xeb171bfce61b27c073905c632d72bc4f2d8e7b559c6a07a38ddf90b019b00db7 | 1013298734108196335077719711 | 9294173410            |
</Accordion>

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

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

***

### USDCExchangeUpgraded\_EventExchange\_event

Mint and redemption events from Overnight Finance's USDC+ stablecoin exchange contract on BSC, tracking user deposits and withdrawals with associated fees. Used for analyzing vault inflows, outflows, and fee revenue across user addresses.

<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_label`         | `STRING`    | Label describing the type of operation or transaction. Common values include 'mint', 'redeem', and 'buy'.                                                      |
  | `in_amount`        | `STRING`    | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.                                |
  | `in_fee`           | `STRING`    | Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency. |
  | `in_sender`        | `STRING`    | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.                                                            |
  | `in_referral`      | `STRING`    | Referral code identifier associated with the transaction. Numeric string representation, often '0' when no referral is present.                                |
</Accordion>

<Accordion title="Sample Data">
  | in\_fee             | address                                    | removed | in\_label | in\_amount             | in\_sender                                 | log\_index | in\_referral | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------------------- | ------------------------------------------ | ------- | --------- | ---------------------- | ------------------------------------------ | ---------- | ------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 89198               | 0x5a8eee279096052588dfcc4e8b466180490db821 | false   | mint      | 222907872              | 0x2b9bda587ee04fe51c5431709afbafb295f94bb4 | 80         |              | 31081988      | 2023-08-22T18:14:24.000Z | 0xb6c2d7a5050b9bc1eb90ae9fd597aaa5bc19478e4a06db0de8af5ac3214e9e8f |
  | 2449179612800000000 | 0x5a8eee279096052588dfcc4e8b466180490db821 | false   | redeem    | 6120499852387200000000 | 0x823ab77848bc0002ffd297d76ffe0c8c8a83ad96 | 106        |              | 31077567      | 2023-08-22T14:29:22.000Z | 0xb35f366ef4f439f5cd181a78128503f8299ebafebcc421838a32c8c34d21cced |
  | 3855054800000000    | 0x5a8eee279096052588dfcc4e8b466180490db821 | false   | redeem    | 9633781945200000000    | 0x823ab77848bc0002ffd297d76ffe0c8c8a83ad96 | 47         |              | 31072991      | 2023-08-22T10:39:41.000Z | 0xc427ac87664c6277c5f1bb815e14ae07eb08a6d2b676d79ace599efcb07c30a3 |
</Accordion>

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

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

***

### USDCExchangeUpgraded\_PayoutEvent\_event

Payout events from Overnight Finance's USDC exchange contract on BNC Chain, tracking profit distributions and liquidity index updates. Used to analyze yield generation, insurance fund activity, and return distributions to liquidity providers.

<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_profit`            | `STRING`    | Profit amount generated by the protocol operation or position. String-encoded integer representing token amounts in the smallest denomination.                                       |
  | `in_newLiquidityIndex` | `STRING`    | Updated liquidity index value after the payout event. String-encoded integer with 27-digit precision representing the protocol's cumulative liquidity scaling factor.                |
  | `in_excessProfit`      | `STRING`    | Profit amount exceeding the protocol's retention threshold, distributed to excess profit mechanisms. String-encoded integer representing token amounts in the smallest denomination. |
  | `in_insurancePremium`  | `STRING`    | Premium amount allocated to the protocol's insurance fund from payout operations. String-encoded integer representing token amounts in the smallest denomination.                    |
  | `in_insuranceLoss`     | `STRING`    | Loss amount absorbed by the protocol's insurance mechanism. String-encoded integer representing token amounts in the smallest denomination.                                          |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | in\_profit | log\_index | block\_number | block\_timestamp         | in\_excessProfit | in\_insuranceLoss | transaction\_hash                                                  | in\_insurancePremium | in\_newLiquidityIndex       |
  | ------------------------------------------ | ------- | ---------- | ---------- | ------------- | ------------------------ | ---------------- | ----------------- | ------------------------------------------------------------------ | -------------------- | --------------------------- |
  | 0x5a8eee279096052588dfcc4e8b466180490db821 | false   | 267029693  | 267        | 30091422      | 2023-07-19T06:00:05.000Z | 0                | 0                 | 0x64e3a1455e167ea613261d5d96d2bda344f55cbb647ec1c99bf192bdf14f9d72 | 0                    | 171141204370613987006104465 |
  | 0x5a8eee279096052588dfcc4e8b466180490db821 | false   | 278280917  | 250        | 30404927      | 2023-07-30T04:00:17.000Z | 0                | 0                 | 0x075a1df5dcf087215f870943901f2d9f3a6dcf770f27a56bcc74e493a7fd4356 | 0                    | 171351960621551119487045322 |
  | 0x5a8eee279096052588dfcc4e8b466180490db821 | false   | 14238661   | 446        | 31527393      | 2023-09-07T07:03:57.000Z | 0                | 0                 | 0x07e7b75080365f77a46aa46be01164502c543d186d533e10d5c7798ace6d8366 | 0                    | 172097766819322630286793248 |
</Accordion>

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

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

***

### USDTExchange\_EventExchange\_event

Mint and redeem events from Overnight Finance's USDT+ stablecoin exchange contract on BNB Smart Chain (BSC). Records deposit and withdrawal transactions with associated fees, amounts, and sender addresses for analyzing USDT+ supply dynamics and user activity.

<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_label`         | `STRING`    | Label describing the type of operation or transaction. Common values include 'mint', 'redeem', and 'buy'.                                                      |
  | `in_amount`        | `STRING`    | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.                                |
  | `in_fee`           | `STRING`    | Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency. |
  | `in_sender`        | `STRING`    | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.                                                            |
  | `in_referral`      | `STRING`    | Referral code identifier associated with the transaction. Numeric string representation, often '0' when no referral is present.                                |
</Accordion>

<Accordion title="Sample Data">
  | in\_fee             | address                                    | removed | in\_label | in\_amount             | in\_sender                                 | log\_index | in\_referral | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------------------- | ------------------------------------------ | ------- | --------- | ---------------------- | ------------------------------------------ | ---------- | ------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 131988088832919485  | 0xd3f827c0b1d224aebcd69c449602bbcb427cb708 | false   | mint      | 329838233993465795182  | 0x9a089ffcce8c28592e4a90eef8bb2cb7dca963f6 | 127        |              | 30360932      | 2023-07-28T15:15:11.000Z | 0xd7563c158ec14cbb4119993539e9a0f815662711aad72487b686c7b43fade901 |
  | 25864028438553266   | 0xd3f827c0b1d224aebcd69c449602bbcb427cb708 | false   | mint      | 64634207067944612296   | 0x2b9bda587ee04fe51c5431709afbafb295f94bb4 | 376        |              | 30365729      | 2023-07-28T19:15:26.000Z | 0x29ef3b443fc852765d7b0e6b62f50ad39725aff06a4b438ce8a02a47b3bc45b9 |
  | 3639970110096454215 | 0xd3f827c0b1d224aebcd69c449602bbcb427cb708 | false   | redeem    | 9096285305131039085240 | 0x15c6209101ea90abf500097e59f2107c5c5fd6f7 | 155        |              | 30359778      | 2023-07-28T14:17:23.000Z | 0xb8f6fa3e58159a785861ec804027753095964fc48c48cd9e0e97527f9e402446 |
</Accordion>

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

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

***

### USDTExchange\_PayoutEvent\_event

Payout distribution events from Overnight Finance's USDT Exchange vault on BNC Smart Chain, tracking profit allocations, insurance premiums and losses, and liquidity index updates. Used to analyze vault performance, yield distribution patterns, and insurance fund dynamics.

<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_profit`            | `STRING`    | Profit amount generated by the protocol operation or position. String-encoded integer representing token amounts in the smallest denomination.                                       |
  | `in_newLiquidityIndex` | `STRING`    | Updated liquidity index value after the payout event. String-encoded integer with 27-digit precision representing the protocol's cumulative liquidity scaling factor.                |
  | `in_excessProfit`      | `STRING`    | Profit amount exceeding the protocol's retention threshold, distributed to excess profit mechanisms. String-encoded integer representing token amounts in the smallest denomination. |
  | `in_insurancePremium`  | `STRING`    | Premium amount allocated to the protocol's insurance fund from payout operations. String-encoded integer representing token amounts in the smallest denomination.                    |
  | `in_insuranceLoss`     | `STRING`    | Loss amount absorbed by the protocol's insurance mechanism. String-encoded integer representing token amounts in the smallest denomination.                                          |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | in\_profit            | log\_index | block\_number | block\_timestamp         | in\_excessProfit | in\_insuranceLoss | transaction\_hash                                                  | in\_insurancePremium | in\_newLiquidityIndex        |
  | ------------------------------------------ | ------- | --------------------- | ---------- | ------------- | ------------------------ | ---------------- | ----------------- | ------------------------------------------------------------------ | -------------------- | ---------------------------- |
  | 0xd3f827c0b1d224aebcd69c449602bbcb427cb708 | false   | 325404370345015503992 | 374        | 27789317      | 2023-04-30T03:08:00.000Z | 0                | 0                 | 0x31ae5959982df5e22a9883b0965df8c3f8f687716c85aedb60c474b3d4bad566 | 0                    | 1011714467351712403033426404 |
  | 0xd3f827c0b1d224aebcd69c449602bbcb427cb708 | false   | 21413982697125184813  | 483        | 31384112      | 2023-09-02T07:01:02.000Z | 0                | 0                 | 0x1897e042acdaf460c27182724e16dbda104e496aae7a0e4175b77a9e36390452 | 0                    | 1025722626289573006622773536 |
  | 0xd3f827c0b1d224aebcd69c449602bbcb427cb708 | false   | 138235215611582148441 | 139        | 27959434      | 2023-05-06T01:05:42.000Z | 0                | 0                 | 0x16593c244641e26f4bb58c76fd77c64d7287f69660e545c49ec88d679bc137fc | 0                    | 1012961718451459837215770286 |
</Accordion>

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

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

***