> ## 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 BSC liquid staking

The `bsc.liquid_staking.withdrawals` table captures when users initiate withdrawals from Binance liquid staking on BSC.

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 (binance)                         |
| action\_type                | VARCHAR           | Type of action (always 'user\_withdrawal' for this table)             |
| contract\_type              | VARCHAR           | Type of staking token being withdrawn (wBETH)                         |
| withdrawer                  | VARCHAR           | Address of the user initiating the withdrawal                         |
| native\_token\_address      | VARCHAR           | Address representing the asset to be received (ETH)                   |
| 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 ETH to be withdrawn (raw wei amount)                        |
| native\_token\_amount       | FLOAT             | Amount of ETH to be withdrawn (normalized)                            |
| native\_token\_amount\_usd  | FLOAT             | USD value of 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 (wBETH)     |
| staking\_token\_name        | VARCHAR           | Name of the liquid staking token                                      |
| staking\_token\_symbol      | VARCHAR           | Symbol of the liquid staking token (wBETH)                            |
| staking\_token\_decimals    | INTEGER           | Number of decimals for the staking token                              |
| staking\_token\_amount\_raw | VARCHAR           | Amount of liquid staking tokens being burned (raw wei amount)         |
| staking\_token\_amount      | FLOAT             | Amount of liquid staking tokens being burned (normalized)             |
| staking\_token\_amount\_usd | FLOAT             | USD value of staking tokens being burned (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 bsc.liquid_staking.withdrawals
WHERE block_timestamp >= CURRENT_DATE - INTERVAL '7 days'
ORDER BY block_timestamp DESC
```
