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

# Balances Daily

Sample query:

Fetch the daily balance of a wallet over time.

```sql theme={null}
select * from bitcoin.assets.balances_daily
where address = '34xp4vRoCGJym3xR7yCVPFHoCNxv4Twseo'
order by date desc
```

Table Columns

Unique Key: `date`, `address`

| Unique Key                         | Description                                                                                                |
| ---------------------------------- | ---------------------------------------------------------------------------------------------------------- |
| date                               | Date of the balance.                                                                                       |
| address                            | Address of the account.                                                                                    |
| raw\_balance\_str                  | String of balance of tokens                                                                                |
| raw\_balance                       | Balance of tokens (unnormalized)                                                                           |
| balance\_str                       | Balance of this token, normalized by the decimal points defined in the token contract.                     |
| balance                            | Balance of the token, normalized by the decimal points defined by BTC protocol in sats. One sat = 1e-8 btc |
| usd\_balance                       | The amount of tokens, in \$USD at the current time.                                                        |
| usd\_exchange\_rate                | The exchange rate used to calculate the usd\_value at current time.                                        |
| last\_activity\_block\_timestamp   | Timestamp of the last activity block.                                                                      |
| last\_activity\_block\_number      | Number of the last activity block.                                                                         |
| last\_activity\_block\_hash        | Hash of the last activity block.                                                                           |
| last\_activity\_transaction\_hash  | Hash of the last activity transaction.                                                                     |
| last\_activity\_transaction\_index | Index of the last activity transaction.                                                                    |
| \_created\_at                      | Timestamp of the balance entry creation.                                                                   |
| \_updated\_at                      | Timestamp of the balance entry update.                                                                     |