Table Details
| Property | Value |
|---|---|
| Table Name | core.stablecoins.supply_distribution_daily |
| Table Status | Production-Ready |
| Unique Key | date, chain, token_address |
Table Columns
| 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) | Indicates whether total_supply came from contract state or computed events |
| total_supply_raw | VARCHAR(16777216) | Reconciled total supply, unnormalized |
| total_supply | FLOAT | Reconciled total supply, normalized |
| total_supply_usd | FLOAT | USD value of the total supply. |
| circulating_supply | FLOAT | total_supply minus non_circulating_supply |
| circulating_supply_usd | FLOAT | USD value of the circulating supply. |
| adjusted_circulating_supply | FLOAT | total_supply minus adjusted_non_circulating_supply |
| adjusted_circulating_supply_usd | FLOAT | USD value of circulating supply after adjustments to avoid double-counting. |
| price_usd | FLOAT | USD price of one unit of the asset for this record. |
| total_supply_details | VARIANT | Structured breakdown of how total supply was computed. |
| circulating_supply_details | VARIANT | Structured breakdown of how circulating supply was computed. |
| unique_id | VARCHAR(16777216) | Unique identifier for the (date, chain, token) row |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |
| _changed_since_full_refresh | BOOLEAN | Indicates if the record has changed since the last full data refresh. |