Skip to main content

​
Tables

​
StakingAggregator_depositToLido_function

ETH deposit transactions to Lido liquid staking protocol via StakingAggregator contract on Ethereum. Tracks individual staking deposits with transaction status, gas costs, and ETH amounts for analyzing staking aggregator usage patterns.
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.
trace_addressSTRINGHierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
statusBOOLTransaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
from_addressSTRINGAddress that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
to_addressSTRINGAddress receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
valueNUMERICAmount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
gas_usedINT64Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
gasINT64Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
signatureSTRINGFunction selector identifying which contract function was called. 10-character hex string including 0x prefix.
gasvaluestatusgas_usedsignatureto_addressblock_numberfrom_addresstrace_addressblock_timestamptransaction_hash
12802011400000000000false1177740xe10cb8890xc7be520a13dc023a1b34c03f4abdab8a43653f7b166406510x3ec08a466df2916ae00d3abd03edb7d30421b6802023-02-16T10:19:23.000Z0x124cef02338bface1a4ef538de08a067aafe1b4d6fc560aa78e17b673951bb6b
128020118000000000000false1177740xe10cb8890xc7be520a13dc023a1b34c03f4abdab8a43653f7b166406670x7fc1d29fec11a9d0ec7fd8d816204390abef4c182023-02-16T10:22:35.000Z0x514050d1cfdf68989d9b9b6fdc3afdd74e8dc64ab680ed56731e8b031ca8dd47
145392109000000000000false1348750xe10cb8890xc7be520a13dc023a1b34c03f4abdab8a43653f7b166406470xb477189ece82f877ff701a0603f439f6a05c0e552023-02-16T10:18:35.000Z0xfe2652980a3f003b6b2bba8f75390b2332a5c3772a958d9271f6a85e3b1fd1d7
Query with partition filter
SELECT *
FROM `tt-contracts.test_v1_ethereum.StakingAggregator_depositToLido_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100