Skip to main content

​
Tables

​
LoopedOracle_TVLCategoryUpdated_event

TVL (Total Value Locked) category updates from Etherfi’s LoopedOracle contract on Optimism, tracking changes in deposited value across asset categories like liquid-weth. Useful for monitoring protocol growth and asset allocation shifts over time.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_categorySTRINGTotal value locked (TVL) category identifier for the oracle update event. Represents the asset classification being tracked, such as “liquid-weth” for liquid wrapped ETH positions.
in_currentTvlSTRINGCurrent total value locked for the specified TVL category at the time of the update, denominated in wei. Sample values show zero, indicating either new categories or empty value states in the oracle’s tracking system.
addressremovedlog_indexin_categoryblock_numberin_currentTvlblock_timestamptransaction_hash
0xab7590cee3ef1a863e9a5877fbb82d9be11504dafalse0liquid-weth13718247002025-06-15T05:01:57.000Z0x07fb22fb7bdf4aca4b628d1cdddd13884689e9ddd6f042bc1dfbef58eefb0844
0xab7590cee3ef1a863e9a5877fbb82d9be11504dafalse0liquid-weth13718067002025-06-15T04:01:57.000Z0x4f2827f1c0a667f16ad2abc3ff29cbfe9a2130fc9571b8076d5148feac26e002
0xab7590cee3ef1a863e9a5877fbb82d9be11504dafalse0liquid-weth13720227702025-06-15T16:02:11.000Z0xe31a6c17b8564ea5202fce607a5c50c51b44bedcba9651687deba93a0763e59e
Query with partition filter
SELECT *
FROM `tt-contracts.etherfi_v1_optimism.LoopedOracle_TVLCategoryUpdated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

​
Oracle_TVLUpdated_event

Oracle price feed events from Ether.fi’s TVL (Total Value Locked) oracle contract on Optimism, recording periodic updates of protocol total value locked in wei. Emitted approximately every 2 hours for tracking protocol growth and health metrics.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in__currentTvlSTRINGTotal Value Locked (TVL) in the EtherFi oracle contract at the time of the update, denominated in wei. Updates occur approximately every 2 hours based on sample timestamps.
addressremovedlog_indexblock_numberin__currentTvlblock_timestamptransaction_hash
0x6329004e903b7f420245e7af3f355186f2432466false012510626020086245162467227693364882024-09-08T16:01:37.000Z0x565186f15262c1267be7a8eab1f82cf8973469668f75c6e43bbac7f049d83111
0x6329004e903b7f420245e7af3f355186f2432466false012510986020086292514142198146487642024-09-08T18:01:37.000Z0x80986465ae389f985836919997c71e6e4fd744e481e4d8d8a0327a18cd1a2d03
0x6329004e903b7f420245e7af3f355186f2432466false012510266020086185615807339081291552024-09-08T14:01:37.000Z0xb2ebc5525582ec5afa8abc01f1e6cf8a18a9685382800a12ee1a6353a81e43c8
Query with partition filter
SELECT *
FROM `tt-contracts.etherfi_v1_optimism.Oracle_TVLUpdated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100