> ## Documentation Index
> Fetch the complete documentation index at: https://docs.allium.so/llms.txt
> Use this file to discover all available pages before exploring further.

# Withdrawals

> Withdrawal events for Ethereum liquid staking protocols

The `ethereum.liquid_staking.withdrawals` table captures when users initiate withdrawals from Lido, Rocketpool, or Binance liquid staking.

Each row represents a single withdrawal event with token metadata, normalized amounts, and USD prices.

### Table Columns

Unique Key: `transaction_hash, log_index`

| Column Name                 | Data Type         | Description                                                                                   |
| --------------------------- | ----------------- | --------------------------------------------------------------------------------------------- |
| project                     | VARCHAR           | Name of the liquid staking protocol (lido, rocketpool, binance)                               |
| action\_type                | VARCHAR           | Type of action (always 'user\_withdrawal' for this table)                                     |
| contract\_type              | VARCHAR           | Type of staking token being withdrawn (stETH, rETH, wBETH)                                    |
| withdrawer                  | VARCHAR           | Address of the user initiating the withdrawal                                                 |
| native\_token\_address      | VARCHAR           | Address of the native token to be received (ETH - 0x0000000000000000000000000000000000000000) |
| native\_token\_name         | VARCHAR           | Name of the native token (Ether)                                                              |
| native\_token\_symbol       | VARCHAR           | Symbol of the native token (ETH)                                                              |
| native\_token\_decimals     | INTEGER           | Number of decimals for the native token (18)                                                  |
| native\_token\_amount\_raw  | VARCHAR           | Amount of native ETH to be withdrawn (raw wei amount)                                         |
| native\_token\_amount       | FLOAT             | Amount of native ETH to be withdrawn (normalized)                                             |
| native\_token\_amount\_usd  | FLOAT             | USD value of native ETH to be withdrawn (amount × price)                                      |
| native\_token\_price\_usd   | FLOAT             | Price of native token in USD at block timestamp (hourly granularity)                          |
| staking\_token\_address     | VARCHAR           | Contract address of the liquid staking token being burned/redeemed                            |
| staking\_token\_name        | VARCHAR           | Name of the liquid staking token                                                              |
| staking\_token\_symbol      | VARCHAR           | Symbol of the liquid staking token (stETH, rETH, wBETH)                                       |
| staking\_token\_decimals    | INTEGER           | Number of decimals for the staking token                                                      |
| staking\_token\_amount\_raw | VARCHAR           | Amount of liquid staking tokens being burned/redeemed (raw wei amount)                        |
| staking\_token\_amount      | FLOAT             | Amount of liquid staking tokens being burned/redeemed (normalized)                            |
| staking\_token\_amount\_usd | FLOAT             | USD value of staking tokens being burned/redeemed (amount × price)                            |
| staking\_token\_price\_usd  | FLOAT             | Price of staking token in USD at block timestamp (hourly granularity)                         |
| block\_timestamp            | TIMESTAMP\_NTZ(9) | Timestamp of the block when the withdrawal was initiated                                      |
| block\_number               | INTEGER           | Block number when the withdrawal was initiated                                                |
| transaction\_hash           | VARCHAR           | Hash of the transaction containing the withdrawal                                             |
| log\_index                  | INTEGER           | Index of the log within the transaction                                                       |
| contract\_address           | VARCHAR           | Address of the contract that processed the withdrawal                                         |
| \_created\_at               | TIMESTAMP\_NTZ(9) | Timestamp when the record was first created                                                   |
| \_updated\_at               | TIMESTAMP\_NTZ(9) | Timestamp when the record was last updated                                                    |

***

### Sample Query

Last 7 days withdrawals:

```sql theme={null}
SELECT *
FROM ethereum.liquid_staking.withdrawals
WHERE block_timestamp >= CURRENT_DATE - INTERVAL '7 days'
ORDER BY block_timestamp DESC
```