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.

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.

Sample Data

address	removed	in_profit	log_index	block_number	in_profitFee	block_timestamp	transaction_hash	in_collectorAmount
0x65afd05fbc4413948ffaad8bcb13f71b6f79332d	false	1824607942052598795418	159	25995241	456151985513149698854	2023-02-26T07:01:33.000Z	0x583becd7e9410865430b5ef505da07be0fec095a77763b835ad8bdccf983d02f	456151985513149698854
0x65afd05fbc4413948ffaad8bcb13f71b6f79332d	false	445028310126980464470	178	24915051	111257077531745116117	2023-01-19T07:01:40.000Z	0xc4136ca3c5e8a629eb179bbdc055972b4a01cb1d6ecc1755ff088310423ec546	111257077531745116117
0x65afd05fbc4413948ffaad8bcb13f71b6f79332d	false	474892034710074605418	234	25227681	118723008677518651354	2023-01-30T07:01:52.000Z	0xd2467f619acdd1e19bab494ffcdafedbbcd040d23e994d95558a9d994790f39c	118723008677518651354

Example Query

Query with partition filter

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

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.

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.

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

Example Query

Query with partition filter

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

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.

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.

Sample Data

address	removed	in_profit	in_tvlFee	log_index	block_number	in_profitFee	block_timestamp	transaction_hash
0xc6eca7a3b863d720393dfc62494b6eab22567d37	false	13579863	684698	454	22872938	2396446	2022-11-08T07:43:32.000Z	0x1a994ec740a15e2935f9f10e934f5d21e4e16e477720e00bfddc4ad765c7ceac
0xbaac6ed05b2feb47ef04b63018a27d80cbea10d1	false	199048109	10663291	313	21262183	49762027	2022-09-12T07:45:46.000Z	0x7aefa9744fc6a116d029497c5a3186e0b8db6aef50b4965f4975fa26ae561da3
0xc6eca7a3b863d720393dfc62494b6eab22567d37	false	50695384	2556069	363	21262191	8946244	2022-09-12T07:46:10.000Z	0x468ad105bd7b90ebfcf45821fafc6f68de3d513ec1ff5a87a117c0f835cc68df

Example Query

Query with partition filter

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

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.

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

Example Query

Query with partition filter

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

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.

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.

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

Example Query

Query with partition filter

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

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.

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

Example Query

Query with partition filter

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

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.

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.

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

Example Query

Query with partition filter

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

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.

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.

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

Example Query

Query with partition filter

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

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.

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.

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

Example Query

Query with partition filter

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

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.

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.

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

Example Query

Query with partition filter

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

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.

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.

Sample Data

in_fee	address	removed	in_label	in_amount	in_sender	log_index	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

Example Query

Query with partition filter

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

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.

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.

Sample Data

address	removed	in_profit	log_index	block_number	block_timestamp	transaction_hash	in_newLiquidityIndex
0x5a8eee279096052588dfcc4e8b466180490db821	false	267029693	267	30091422	2023-07-19T06:00:05.000Z	0x64e3a1455e167ea613261d5d96d2bda344f55cbb647ec1c99bf192bdf14f9d72	171141204370613987006104465
0x5a8eee279096052588dfcc4e8b466180490db821	false	278280917	250	30404927	2023-07-30T04:00:17.000Z	0x075a1df5dcf087215f870943901f2d9f3a6dcf770f27a56bcc74e493a7fd4356	171351960621551119487045322
0x5a8eee279096052588dfcc4e8b466180490db821	false	14238661	446	31527393	2023-09-07T07:03:57.000Z	0x07e7b75080365f77a46aa46be01164502c543d186d533e10d5c7798ace6d8366	172097766819322630286793248

Example Query

Query with partition filter

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

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.

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.

Sample Data

in_fee	address	removed	in_label	in_amount	in_sender	log_index	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

Example Query

Query with partition filter

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

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.

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.

Sample Data

address	removed	in_profit	log_index	block_number	block_timestamp	transaction_hash	in_newLiquidityIndex
0xd3f827c0b1d224aebcd69c449602bbcb427cb708	false	325404370345015503992	374	27789317	2023-04-30T03:08:00.000Z	0x31ae5959982df5e22a9883b0965df8c3f8f687716c85aedb60c474b3d4bad566	1011714467351712403033426404
0xd3f827c0b1d224aebcd69c449602bbcb427cb708	false	21413982697125184813	483	31384112	2023-09-02T07:01:02.000Z	0x1897e042acdaf460c27182724e16dbda104e496aae7a0e4175b77a9e36390452	1025722626289573006622773536
0xd3f827c0b1d224aebcd69c449602bbcb427cb708	false	138235215611582148441	139	27959434	2023-05-06T01:05:42.000Z	0x16593c244641e26f4bb58c76fd77c64d7287f69660e545c49ec88d679bc137fc	1012961718451459837215770286

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

ETS_PayoutEvent_event

ETS_RoleGranted_event

OldETS_PayoutEvent_event

OldSkims_RewardWalletSend_event

OldSkims_ThenaSkimReward_event

OldSkims_TotalSkimReward_event

OldUSDCExchange_PayoutEvent_event

Skimmer_PoolOperation_event

USDCExchange_EventExchange_event

USDCExchange_PayoutEvent_event

USDCExchangeUpgraded_EventExchange_event

USDCExchangeUpgraded_PayoutEvent_event

USDTExchange_EventExchange_event

USDTExchange_PayoutEvent_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​ETS_PayoutEvent_event

​ETS_RoleGranted_event

​OldETS_PayoutEvent_event

​OldSkims_RewardWalletSend_event

​OldSkims_ThenaSkimReward_event

​OldSkims_TotalSkimReward_event

​OldUSDCExchange_PayoutEvent_event

​Skimmer_PoolOperation_event

​USDCExchange_EventExchange_event

​USDCExchange_PayoutEvent_event

​USDCExchangeUpgraded_EventExchange_event

​USDCExchangeUpgraded_PayoutEvent_event

​USDTExchange_EventExchange_event

​USDTExchange_PayoutEvent_event

Tables

ETS_PayoutEvent_event

ETS_RoleGranted_event

OldETS_PayoutEvent_event

OldSkims_RewardWalletSend_event

OldSkims_ThenaSkimReward_event

OldSkims_TotalSkimReward_event

OldUSDCExchange_PayoutEvent_event

Skimmer_PoolOperation_event

USDCExchange_EventExchange_event

USDCExchange_PayoutEvent_event

USDCExchangeUpgraded_EventExchange_event

USDCExchangeUpgraded_PayoutEvent_event

USDTExchange_EventExchange_event

USDTExchange_PayoutEvent_event