overnight_v1_arbitrum

Tables

DAIExchange_EventExchange_event

DAI token mint and redeem events from Overnight Finance’s DAIExchange contract on Arbitrum, capturing exchange operations with amounts, fees, and sender addresses. Used for tracking DAI deposit/withdrawal activity and fee analysis in the Overnight protocol.

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
1571039281291456008	0xc8261dc93428f0d2dc04d675b7852cdcdc19d4fd	false	mint	3926027163947348566217	0x3e5096b58f54a6b963754027ccd0c7b53872acc3	18	83702783	2023-04-24T05:32:26.000Z	0x86fda29be4a14f18fdceddb8f484f1ee9a9d33d983ce2cdf59b9794341e5acfd
720962434009183198	0xc8261dc93428f0d2dc04d675b7852cdcdc19d4fd	false	mint	1801685122588948812335	0x3e5096b58f54a6b963754027ccd0c7b53872acc3	45	83692946	2023-04-24T04:50:35.000Z	0x6d608838931da62aaab4537617bb65f80ca6c691f18e8f9cd370608c541007b2
33505651799025724	0xc8261dc93428f0d2dc04d675b7852cdcdc19d4fd	false	mint	83730623845765286369	0x3e5096b58f54a6b963754027ccd0c7b53872acc3	15	83796032	2023-04-24T12:01:00.000Z	0x1ddce5df06b0d56df8a1b16d24a2a13a86e01d4604095592206cb24eec636506

Example Query

Query with partition filter

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

DAIExchange_PayoutEvent_event

Payout events from Overnight Finance’s DAI exchange contract on Arbitrum, tracking profit distributions, insurance premiums/losses, and liquidity index updates. Used to analyze protocol yield generation, risk management mechanics, and rebase accounting for DAI-based vault products.

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
0xc8261dc93428f0d2dc04d675b7852cdcdc19d4fd	false	19004745943541612	36	67829451	2023-03-08T07:01:37.000Z	0x9f52813cf6d85f9baf30fa603ec38fa44630e3d1939c793d2a9e4ef72e54d2ce	1007064099578989892568804925
0xc8261dc93428f0d2dc04d675b7852cdcdc19d4fd	false	109902608880142668640	56	130274735	2023-09-12T02:12:49.000Z	0xf6f9835717a0b3e328ed90d32e711b92e98a2e7a9d8b4eed49dbeb1c57b64a4c	1044432422998827634919696613
0xc8261dc93428f0d2dc04d675b7852cdcdc19d4fd	false	1391857839010467593146	337	97286727	2023-06-03T07:30:18.000Z	0xe21ac2546c28792ebb525804f5a0868c94ad64fcd03f8c36c5bee8fdf2dd70f9	1027676041446464795571349845

Example Query

Query with partition filter

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

ETS_PayoutEvent_event

Profit and loss distribution events from Overnight Finance’s Exchange Traded Strategy (ETS) vaults on Arbitrum, capturing fee collection, profit sharing, and loss realization. Contains per-vault payout calculations used to track yield performance and fee distribution across different investment 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_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 buffer reserve during the payout event, denominated in the protocol’s base token units. Consistently zero across sample events, suggesting buffer reserves were not utilized during these payouts.
`in_collectorAmount`	`STRING`	Amount allocated to the fee collector from the payout event, representing protocol revenue collected. Denominated in the smallest unit of the underlying token (e.g., wei for ETH), typically 25% of profit fees based on sample values.

Sample Data

address	removed	in_profit	log_index	block_number	in_profitFee	block_timestamp	transaction_hash	in_collectorAmount
0xc2c84ca763572c6af596b703df9232b4313ad4e3	false	446585508	24	78478434	111646376	2023-04-09T00:02:13.000Z	0x857413ad9c867a3638d5b3838bb06260071b94a1920a48ce5b20801962dacfb3	111646376
0x69f7425237d901017ab4c3ee6d94d4d3f6f9b2fc	false	92303129	33	78478445	92303128	2023-04-09T00:02:16.000Z	0x74986770cfce8021c0cac1de4270a1d9376009c1aaa665535d97852947829f1b	92303128
0xe711c1273c1d5a1ca1a7c9e0ec8e14b270621711	false	1467	6	78478458	366	2023-04-09T00:02:19.000Z	0xca1e3c5dddfe8bae5589c2b2093ae5d706ed0a4c46c47fde6a425636ddcc709f	366

Example Query

Query with partition filter

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

ETS_RoleGranted_event

Role assignment events from Overnight Finance’s Exchange Token System (ETS) contracts on Arbitrum. Tracks administrative and operational permission grants with role identifiers, granting addresses, and recipient accounts for governance and access control analysis.

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
0x093f166e2eab47419417e34bb761650d5818e32b	0x0000000000000000000000000000000000000000000000000000000000000000	false	0x19ec14906a4d84eccca29cdf6428d08ce9cacdf9	1	0x19ec14906a4d84eccca29cdf6428d08ce9cacdf9	50963854	2023-01-05T06:41:27.000Z	0xe9f2bd16f624a42550c70ccf8ebc00b5c1642fe562f36c441b8b7bc7ac4d7d71
0x093f166e2eab47419417e34bb761650d5818e32b	0x71840dc4906352362b0cdaf79870196c8e42acafade72d5d5a6d59291253ceb1	false	0x19ec14906a4d84eccca29cdf6428d08ce9cacdf9	2	0x19ec14906a4d84eccca29cdf6428d08ce9cacdf9	50963854	2023-01-05T06:41:27.000Z	0xe9f2bd16f624a42550c70ccf8ebc00b5c1642fe562f36c441b8b7bc7ac4d7d71
0x2516152fab0217e2cc8961d8b5762dcf84b82e32	0xb309c40027c81d382c3b58d8de24207a34b27e1db369b1434e4a11311f154b5e	false	0x1ff7e338d5e582138c46044dc238543ce555c963	4	0x7b8bf62b5ae9955df0c09716d32735b9fd82b6c4	51097809	2023-01-05T20:13:21.000Z	0x4c6d35b88e10357a8b2b9ead2f1f9505875a31d987b53e5c0761eb816e40fe93

Example Query

Query with partition filter

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

OldSkims_RewardWalletSend_event

Reward distribution events from Overnight Finance’s deprecated skim contract on Arbitrum, recording token amounts sent to reward wallets. Useful for analyzing 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
0x3a31ec6ea73af1eefcd3ca461859604a04d6d714	false	1257615839	23	69403547	2023-03-13T09:55:54.000Z	0xae81a3664af42b99ee41c3c28478a7e2b9a6d94f1d38604d35c4e3818fc31d52
0x3a31ec6ea73af1eefcd3ca461859604a04d6d714	false	1044726092	135	67829438	2023-03-08T07:01:33.000Z	0xe2f6fc10403833c64b218bd635e514b18d8e011669a124129a9a6445be250cf6
0x3a31ec6ea73af1eefcd3ca461859604a04d6d714	false	58046120	92	69692803	2023-03-14T08:57:35.000Z	0x49f7eedc2b196caf61584cfae4ffbb2b29075293d70319e78d0004d8d2def344

Example Query

Query with partition filter

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

OldSkims_SterlingSkimReward_event

Reward distribution events from Overnight Finance’s legacy Sterling skim contract on Arbitrum, recording amounts transferred from pools to recipient wallets. Used to track historical yield distribution and protocol fee skimming patterns before contract migration.

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_wallet`	`STRING`	Wallet address associated with the event. 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_amount	in_wallet	log_index	block_number	block_timestamp	transaction_hash
0x3a31ec6ea73af1eefcd3ca461859604a04d6d714	0xac4eed9ca04b219935d5c4201167aa9257896443	false	59235756	0x9030d5c596d636eefc8f0ad7b2788ae7e9ef3d46	150	68134543	2023-03-09T07:02:32.000Z	0x8a9972ec7fd7f22aff3934f7b580eece13a125696912e9ca78671b06be4970bb
0x3a31ec6ea73af1eefcd3ca461859604a04d6d714	0xd36a246c848714e52ed810c3f9ae60ccabfccd6b	false	3357964	0x9030d5c596d636eefc8f0ad7b2788ae7e9ef3d46	146	68134543	2023-03-09T07:02:32.000Z	0x8a9972ec7fd7f22aff3934f7b580eece13a125696912e9ca78671b06be4970bb
0x3a31ec6ea73af1eefcd3ca461859604a04d6d714	0xd36a246c848714e52ed810c3f9ae60ccabfccd6b	false	2702488	0x9030d5c596d636eefc8f0ad7b2788ae7e9ef3d46	148	68478831	2023-03-10T08:51:16.000Z	0x614eca22f3d4158ff945d5c6f5275170879d810961bab9dd248f47aa6e8021e9

Example Query

Query with partition filter

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

Skimmer_PoolOperation_event

Overnight Finance Skimmer contract pool operation events on Arbitrum, tracking skim and bribe operations across DEX liquidity pools with token amounts and recipient addresses. Used for analyzing protocol revenue collection and incentive distribution across multiple decentralized exchanges.

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. Identifies the specific DeFi protocol handling the liquidity pool transaction.
`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 where the operation occurred, typically formatted as token pair notation (e.g., USD+/DAI+). This identifier helps analysts quickly understand the trading pair involved in the skim or bribe operation.
`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
0x185f984cb79a9f2a9d907dfcd72967233aedb997	0x3ca375b8107cb2c7f520ca87b2def8dc5040aeb4	0x84b8497556acd53ff2c5885e5e714afe1cef4ab6	false	0xe80772eaf6e2e18b651f160bc9158b2a5cafca65	1546	144	Auragi	USD+/MAI	134369407	Bribe	2023-09-25T06:01:27.000Z	0x2ba3024a1f18d45eda27a197299619ea1ec3392282258d64c159dd7879ce58b9
0x71081021ff37d38dec956386ea5e467e58714951	0x3ca375b8107cb2c7f520ca87b2def8dc5040aeb4	0x51e073d92b0c226f7b0065909440b18a85769606	false	0xeb8e93a0c7504bffd8a8ffa56cd754c63aaebfe8	1894540257896160	34	Wombat	LP-DAI+	134369428	Skim	2023-09-25T06:01:32.000Z	0xa8952e5c3d6fcc087f668e0199934d18528f6a990d135258cecb5c305946af28
0x9030d5c596d636eefc8f0ad7b2788ae7e9ef3d46	0x3ca375b8107cb2c7f520ca87b2def8dc5040aeb4	0xe8c060d40d7bc96fcd5b758bd1437c8653400b0e	false	0xeb8e93a0c7504bffd8a8ffa56cd754c63aaebfe8	206308497583465614	21	Arbidex	USD+/DAI+	134369428	Skim	2023-09-25T06:01:32.000Z	0xa8952e5c3d6fcc087f668e0199934d18528f6a990d135258cecb5c305946af28

Example Query

Query with partition filter

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

USDExchange_EventExchange_event

USD stablecoin mint and redeem events from Overnight Finance’s USD+ protocol on Arbitrum. Tracks exchange operations with amounts, fees, and user addresses for analyzing protocol usage and fee generation.

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
3120000	0x73cb180bf0521828d8849bc8cf2b920918e23032	false	mint	7796880000	0x03098d021e9f45e594f1588a30078e95410df80e	12	77162435	2023-04-05T03:29:56.000Z	0x8e715327f11a3ccb7f7c075db441152fd84991b428246fbf537218da02cb571c
12000000	0x73cb180bf0521828d8849bc8cf2b920918e23032	false	mint	29988000000	0x5796f85dde9abfc2bbb28d086dee994d970a4561	12	77381440	2023-04-05T18:39:49.000Z	0xad71ac0534751d3f39dbb3573000dbaae1392494a348f0a7c753f1baf20d8f81
1525	0x73cb180bf0521828d8849bc8cf2b920918e23032	false	mint	3811693	0x26ef1d3eeaaa8cc1a759bae824086b6301be04b3	12	77285205	2023-04-05T12:00:02.000Z	0xd08f0db95739824ac6bef821bf286c6cc759f883f462e6c6c21247038dcc28ae

Example Query

Query with partition filter

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

USDExchange_PayoutEvent_event

Payout events from Overnight Finance’s USD+ stablecoin vault on Arbitrum, recording daily profit distributions, liquidity index updates, and insurance pool adjustments. Used for tracking yield generation, vault performance, and insurance fund health over time.

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
0x73cb180bf0521828d8849bc8cf2b920918e23032	false	2849370987	274	82014371	2023-04-19T07:25:25.000Z	0x5e470128317da54016cf5e83aa81494cf6088b79ffec50ed2f4c850f09fbb694	1027806418949340590360025291
0x73cb180bf0521828d8849bc8cf2b920918e23032	false	128650780	184	127264118	2023-09-02T07:01:53.000Z	0xc438dcd883dd0605eeddc9fa2a55c1241c21c92ccd26806483c314166cf1bd8a	1049054820702275866257543749
0x73cb180bf0521828d8849bc8cf2b920918e23032	false	2773645497	336	98637014	2023-06-07T07:16:56.000Z	0xc60f233c75dab553c01de79776a0ea9eb7691c0ceb407e28e0ced4a46258164f	1038635614514199838419368609

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

DAIExchange_EventExchange_event

DAIExchange_PayoutEvent_event

ETS_PayoutEvent_event

ETS_RoleGranted_event

OldSkims_RewardWalletSend_event

OldSkims_SterlingSkimReward_event

Skimmer_PoolOperation_event

USDExchange_EventExchange_event

USDExchange_PayoutEvent_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​DAIExchange_EventExchange_event

​DAIExchange_PayoutEvent_event

​ETS_PayoutEvent_event

​ETS_RoleGranted_event

​OldSkims_RewardWalletSend_event

​OldSkims_SterlingSkimReward_event

​Skimmer_PoolOperation_event

​USDExchange_EventExchange_event

​USDExchange_PayoutEvent_event

Tables

DAIExchange_EventExchange_event

DAIExchange_PayoutEvent_event

ETS_PayoutEvent_event

ETS_RoleGranted_event

OldSkims_RewardWalletSend_event

OldSkims_SterlingSkimReward_event

Skimmer_PoolOperation_event

USDExchange_EventExchange_event

USDExchange_PayoutEvent_event