> ## 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.

# Deposits

> Deposit events for Ethereum liquid staking protocols

The `ethereum.liquid_staking.deposits` table captures when users deposit ETH into Lido, Rocketpool, or Binance liquid staking and receive liquid staking tokens (stETH, rETH, wBETH) in return.

Each row represents a single deposit 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\_deposit' for this table)                                                       |
| contract\_type              | VARCHAR           | Type of staking token received (stETH, rETH, wBETH)                                                          |
| depositor                   | VARCHAR           | Address of the user who made the deposit. Note: may be a contract address rather than the transaction signer |
| native\_token\_address      | VARCHAR           | Address of the native token deposited (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 deposited (raw wei amount)                                                              |
| native\_token\_amount       | FLOAT             | Amount of native ETH deposited (normalized)                                                                  |
| native\_token\_amount\_usd  | FLOAT             | USD value of native ETH deposited (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 received                                                        |
| 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 received (raw wei amount)                                                    |
| staking\_token\_amount      | FLOAT             | Amount of liquid staking tokens received (normalized)                                                        |
| staking\_token\_amount\_usd | FLOAT             | USD value of staking tokens received (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 deposit occurred                                                             |
| block\_number               | INTEGER           | Block number when the deposit occurred                                                                       |
| transaction\_hash           | VARCHAR           | Hash of the transaction containing the deposit                                                               |
| log\_index                  | INTEGER           | Index of the log within the transaction                                                                      |
| contract\_address           | VARCHAR           | Address of the contract that processed the deposit                                                           |
| \_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 deposits:

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