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.Columns
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. |
trace_address | STRING | Hierarchical 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. |
status | BOOL | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution. |
from_address | STRING | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
to_address | STRING | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
value | NUMERIC | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC). |
gas_used | INT64 | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used. |
gas | INT64 | Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed. |
signature | STRING | Function selector identifying which contract function was called. 10-character hex string including 0x prefix. |
Sample Data
Sample Data
| gas | value | status | gas_used | signature | to_address | block_number | from_address | trace_address | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|---|
| 128020 | 11400000000000 | false | 117774 | 0xe10cb889 | 0xc7be520a13dc023a1b34c03f4abdab8a43653f7b | 16640651 | 0x3ec08a466df2916ae00d3abd03edb7d30421b680 | 2023-02-16T10:19:23.000Z | 0x124cef02338bface1a4ef538de08a067aafe1b4d6fc560aa78e17b673951bb6b | |
| 128020 | 118000000000000 | false | 117774 | 0xe10cb889 | 0xc7be520a13dc023a1b34c03f4abdab8a43653f7b | 16640667 | 0x7fc1d29fec11a9d0ec7fd8d816204390abef4c18 | 2023-02-16T10:22:35.000Z | 0x514050d1cfdf68989d9b9b6fdc3afdd74e8dc64ab680ed56731e8b031ca8dd47 | |
| 145392 | 109000000000000 | false | 134875 | 0xe10cb889 | 0xc7be520a13dc023a1b34c03f4abdab8a43653f7b | 16640647 | 0xb477189ece82f877ff701a0603f439f6a05c0e55 | 2023-02-16T10:18:35.000Z | 0xfe2652980a3f003b6b2bba8f75390b2332a5c3772a958d9271f6a85e3b1fd1d7 |
Example Query
Example Query
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