Skip to main content

Table Details

PropertyValue
Table Namestellar.stablecoins.supply_non_circulating_daily
Table StatusProduction-Ready
Unique Keyaddress, token_address, block_date

Table Columns

Column NameData TypeDescription
chainVARCHAR(16777216)Blockchain this record belongs to (always stellar).
addressVARCHAR(16777216)Address of the non-circulating holder on Stellar.
token_addressVARCHAR(16777216)Address of the stablecoin token on Stellar.
token_nameVARCHAR(16777216)Full name of the token.
token_symbolVARCHAR(16777216)Ticker symbol of the token.
token_decimalsNUMBER(38,0)Number of decimal places used to represent the token’s smallest unit.
product_idVARCHAR(16777216)Internal Allium identifier for the stablecoin product.
ncs_address_typeVARCHAR(16777216)Classification of the non-circulating supply address.
ncs_address_labelVARCHAR(16777216)Human-readable label for the non-circulating supply address.
ncs_supply_layerVARCHAR(16777216)Supply layer this non-circulating balance belongs to (e.g. treasury, bridge escrow).
raw_balance_strVARCHAR(16777216)Balance in the token’s smallest unit, as a string.
raw_balanceFLOATBalance in the token’s smallest unit, not decimal-adjusted.
balance_strVARCHAR(16777216)Normalized balance as a string for full precision.
balanceFLOATBalance normalized by the token’s decimal precision.
block_dateTIMESTAMP_NTZ(9)Ledger date (UTC) of this balance snapshot.
block_timestampTIMESTAMP_NTZ(9)Ledger close time (UTC) of this balance snapshot.
block_numberNUMBER(38,0)Ledger sequence number of this balance snapshot.
block_hashVARCHAR(16777216)Ledger hash of this balance snapshot.
_has_errorNUMBER(38,0)Data-quality flag indicating whether an error occurred capturing this row.
_short_addressVARCHAR(4)Truncated form of the address used as a clustering key.
_short_token_addressVARCHAR(4)Truncated form of the token address used as a clustering key.
_ncs_seed_updated_atTIMESTAMP_NTZ(9)Timestamp of the most recent update to the non-circulating seed data.
_balances_created_atTIMESTAMP_NTZ(9)Timestamp when the underlying balance snapshot row was first created.
_ncs_eod_created_atTIMESTAMP_NTZ(9)Timestamp when the source end-of-day non-circulating record was first created.
_created_atTIMESTAMP_NTZ(9)Timestamp of when the entry was created in the database.
_updated_atTIMESTAMP_NTZ(9)Timestamp of when the entry was last updated in the database.
_changed_since_full_refreshBOOLEANIndicates if the record has changed since the last full data refresh.