staking_ethereum.flows table combines deposits and withdrawals into a unified view for analyzing net staking flows over time.
Table Schema
| Column | Type | Description |
|---|---|---|
block_time | TIMESTAMP | Block time |
block_number | BIGINT | Block number |
amount_staked | DOUBLE | Amount of ETH staked (deposits) |
depositor_address | VARBINARY | Address of the depositor |
entity | VARCHAR | Name of entity if identified |
entity_unique_name | VARCHAR | Unique name of identified entity |
entity_category | VARCHAR | Category of entity |
sub_entity | VARCHAR | Sub-entity name |
sub_entity_unique_name | VARCHAR | Unique name of sub-entity |
sub_entity_category | VARCHAR | Category of sub-entity |
tx_from | VARBINARY | Address that executed the transaction |
deposit_index | BIGINT | Deposit index |
withdrawal_index | BIGINT | Withdrawal index |
validator_index | BIGINT | Validator index |
pubkey | VARBINARY | Validator public key |
signature | VARBINARY | Signature |
withdrawal_address | VARBINARY | Withdrawal address |
withdrawal_credentials_type | VARBINARY | Withdrawal credentials type |
withdrawal_credentials | VARBINARY | Withdrawal credentials |
amount_full_withdrawn | DOUBLE | Amount from full validator withdrawal |
amount_partial_withdrawn | DOUBLE | Amount from partial (rewards) withdrawal |
tx_hash | VARBINARY | Transaction hash |
evt_index | INTEGER | Event index |