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

# Supply Hourly

> Hourly total and circulating supply for stablecoins across chains.

The `stablecoins.core.supply_hourly` table gives an hourly supply snapshot for every tracked stablecoin deployment. It has the same columns as [`stablecoins.core.supply_daily`](https://docs.allium.so/historical-data/stablecoins/supply-daily), at hourly grain.

**Unique Key**: `hour`, `chain`, `token_address`

### Table Columns

| Column Name | Description |
| - | - |
| `is_verified` | True if this deployment is verified. |
| `is_native` | True if this is the issuer's canonical deployment on this chain. |
| `stablecoin_type` | Type of stablecoin (e.g. native, bridged, yield\_bearing). |
| `product_id` | Identifier of the stablecoin product. Join key to `stablecoins.registry.catalog`. |
| `issuer_id` | Identifier of the stablecoin issuer. |
| `currency` | Currency the stablecoin is pegged to (e.g. usd, eur). |
| `peg_mechanism` | How the peg is maintained (e.g. fiat\_backed, crypto\_backed). |
| `hour` | UTC hour of the snapshot. |
| `chain` | Blockchain of the deployment. |
| `token_address` | Contract or mint address of the stablecoin. |
| `token_name` | Name of the token. |
| `token_symbol` | Symbol of the token. |
| `total_supply` | Total supply. |
| `total_supply_usd` | Total supply in USD. |
| `circulating_supply` | Circulating supply. |
| `circulating_supply_usd` | Circulating supply in USD. |
| `adjusted_circulating_supply` | Adjusted circulating supply. See [Supply Daily](https://docs.allium.so/historical-data/stablecoins/supply-daily.md). |
| `adjusted_circulating_supply_usd` | Adjusted circulating supply in USD. |
| `price_usd` | USD price used for the `_usd` columns. |
| `data_as_of` | Time the supply values are current as of. |
| `is_deprecated` | True if the deployment is deprecated. |
| `deprecated_date` | Date the deployment was deprecated. |
| `_metadata` | Source details for the row. |
| `unique_id` | Unique identifier for the row. |
| `_created_at` | Timestamp this row was first created. |
| `_updated_at` | Timestamp this row was last updated. |

### Sample Query

**Hourly USDC supply on Ethereum over the last 24 hours**

```sql theme={null}
select
    hour,
    total_supply,
    circulating_supply
from stablecoins.core.supply_hourly
where chain = 'ethereum'
    and product_id = 'usdc'
    and hour >= dateadd('hour', -24, current_timestamp())
order by hour desc
```
