hyperliquid.stablecoins.supply_distribution_daily table provides daily total, non-circulating, and circulating supply for Hyperliquid stablecoins. One row per (date, chain, token_address).
Table Details
| Property | Value |
|---|---|
| Table Name | hyperliquid.stablecoins.supply_distribution_daily |
| Table Status | Production-Ready |
| Unique Key | date, chain, token_address |
Table Columns
Identifiers
| Column Name | Data Type | Description |
|---|---|---|
| date | TIMESTAMP_NTZ(9) | The UTC date this supply snapshot covers |
| product_id | VARCHAR(16777216) | Allium stablecoin product identifier (e.g. usdc, usdt) |
| chain | VARCHAR(16777216) | The blockchain the stablecoin resides on |
| token_address | VARCHAR(16777216) | Contract address of the stablecoin token |
| token_name | VARCHAR(16777216) | Name of the stablecoin |
| token_symbol | VARCHAR(16777216) | Symbol of the stablecoin |
| token_decimals | NUMBER(38,0) | Decimal precision of the stablecoin |
| total_supply_source | VARCHAR(16777216) | Source of the total-supply figure (snapshot). |
| total_supply_raw | VARCHAR(16777216) | Total supply as VARCHAR. |
| total_supply | FLOAT | Total supply in decimal units. |
| total_supply_usd | FLOAT | USD value of the reconciled total supply |
| circulating_supply | FLOAT | Circulating supply at the issuer-basis layer. |
| circulating_supply_usd | FLOAT | USD value of the circulating supply |
| adjusted_circulating_supply | FLOAT | Circulating supply across all configured supply layers. |
| adjusted_circulating_supply_usd | FLOAT | USD value of the adjusted circulating supply |
| price_usd | FLOAT | USD price of one unit of the asset for this record |
| total_supply_details | VARIANT | Structured breakdown of how the reconciled total supply was computed |
| circulating_supply_details | VARIANT | Structured breakdown of how the circulating supply was computed |
| unique_id | VARCHAR(16777216) | Deterministic unique identifier per row. |
| _created_at | TIMESTAMP_NTZ(9) | Row creation timestamp. |
| _updated_at | TIMESTAMP_NTZ(9) | Row last update timestamp. |
| _changed_since_full_refresh | BOOLEAN | Indicates if the record has changed since the last full data refresh. |
Supply
| Column Name | Description | |
|---|---|---|
| total_supply_source | Source of the total-supply figure (snapshot). | Method used to derive total_supply for this row: state (onchain totalSupply() call), computed (accumulated mint/burn Transfer events), state_reconstructed (reconstructed from state where no direct totalSupply() call is available), or snapshot (aggregated spot balances, used on Hyperliquid). |
| total_supply_raw | Total supply as VARCHAR. | Total supply as string (same value as total_supply for Hyperliquid). |
| total_supply | Total supply in decimal units. | Total token supply outstanding (minted minus burned). In token base units unless otherwise specified. |
| non_circulating_supply | Non-circulating supply at the issuer-basis layer (premint reserves, issuer holdings). | |
| non_circulating_supply_raw | Issuer-basis NCS as raw VARCHAR. | |
| non_circulating_supply_details | JSON breakdown of NCS addresses by type (issuer_basis layer). | |
| adjusted_non_circulating_supply | Non-circulating supply across all configured supply layers. | |
| adjusted_non_circulating_supply_raw | Adjusted NCS as raw VARCHAR. | |
| adjusted_non_circulating_supply_details | JSON breakdown of NCS addresses across all layers. | |
| circulating_supply | Circulating supply at the issuer-basis layer. | Circulating supply of the token: total_supply minus non_circulating_supply (issuer_basis layer). Represents tokens held outside issuer/treasury/bridge-escrow wallets, i.e. in public circulation. Derived from supply distribution (balances of non-circulating wallets), not from the mint/burn supply_change series, which tracks total supply. |
| adjusted_circulating_supply | Circulating supply across all configured supply layers. | total_supply minus adjusted_non_circulating_supply (all layers). |
Lineage
| Column Name | Description | |
|---|---|---|
| unique_id | Deterministic unique identifier per row. | Allium’s deterministic unique identifier for this row. Generated from the fields that uniquely identify the record (e.g. transaction hash + log index). Stable across full refreshes. |
| _created_at | Row creation timestamp. | Timestamp (UTC) when this row was first written to the Allium platform. Set once on insert and never changed. |
| _updated_at | Row last update timestamp. | Timestamp (UTC) of the most recent update to this row in the Allium platform. Advances when the row is reprocessed or enriched (e.g. USD price hydration). |
Sample Query
SELECT
date,
token_symbol,
total_supply,
non_circulating_supply,
circulating_supply
FROM hyperliquid.stablecoins.supply_distribution_daily
WHERE date >= CURRENT_DATE - 30
ORDER BY date DESC, token_symbol