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, at hourly grain.
Unique Key: hour, chain, token_address
Documentation Index
Fetch the complete documentation index at: /llms.txt
Use this file to discover all available pages before exploring further.
Hourly total and circulating supply for stablecoins across chains.
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, at hourly grain.
Unique Key: hour, chain, token_address
| 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. |
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. |
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
Was this page helpful?