Skip to main content
The stablecoins_solana_balances_enriched table extends Solana stablecoin balances with address classification and whale flags.

Premium dataset access

This dataset is part of a premium offering and requires additional access. Contact the Dune enterprise team to request access.

​
Why these enriched tables matter

Stablecoin analysis comes down to two fundamental questions:
  1. Where are stablecoins right now? (balances)
  2. How did they get there? (activity)
This balances-enriched table answers the first question by going beyond raw balances and adding attribution for where capital sits: CEX, lending, treasury, yield, bridge, whale concentration, and more. Balances alone are not insight. Balances plus attribution are insight.

​
What this dataset is designed to do

  • Track where stablecoins are at a daily level.
  • Classify addresses by economic function with transparent logic.
  • Provide a defensible foundation for stock/composition analysis.
The goal is to turn stablecoin balance data from noise into structured economic insight.

​
Table schema

ColumnTypeDescription
blockchainVARCHARChain name (solana)
dayDATEBalance date (partition column)
addressVARCHARWallet address
token_symbolVARCHARToken symbol
token_addressVARCHARToken mint address
token_standardVARCHARToken standard (spl_token or token2022)
token_idVARCHARAlways NULL
balance_rawUINT256Raw balance
balanceDOUBLEDecimals-adjusted balance
balance_usdDOUBLEUSD value
currencyVARCHARISO 4217 code
address_categoryVARCHARAddress category
address_subcategoryVARCHARAddress subcategory (nullable)
address_projectVARCHARProject/entity name (nullable)
address_versionVARCHARProject version (nullable)
address_labelVARCHARLabel value (nullable)
is_whaleBOOLEANAddress has >= $10M on that day
last_updatedTIMESTAMPLast balance update time

​
Value possibilities

The address-label columns are standardized so balance composition analyses can be segmented consistently across protocols and time.
address_categoryAllowed address_subcategory values
bridgebridge_liquidity
dexdex_liquidity, dex_execution
lendinglending_liquidity, lending_execution
yieldyield_liquidity, yield_execution
issuerissuer_operations, issuer_treasury
treasury_or_governancetreasury, treasury_collector, governance
cexcex
burnburn
unidentified_whaleunidentified_whale
unidentifiedunidentified
This mapping enables stable balance-composition segmentation and comparable category reporting across tokens, chains, and time windows. As label coverage expands, new values may be added in backward-compatible fashion.

​
Methodology

This model enriches daily balance snapshots with functional address labeling.
  1. Start from daily rows in stablecoins_solana.balances.
  2. Join curated Solana address labels to assign category, subcategory, and project metadata where available.
  3. Compute daily concentration flags (is_whale) and preserve unlabeled coverage using fallback categories.
  4. Retain all balances in the output, including bridge and protocol-held balances, so analysts can apply custom filters.

​
Important interpretation details

  • Categories represent address function, not beneficial ownership.
  • Labels improve over time as protocol coverage expands and should be treated as a curated classification layer.
  • Bridge balances are intentionally retained and can be isolated with address_category = 'bridge'.

​
Sample query

SELECT
    b.address_category
    , b.token_symbol
    , SUM(b.balance_usd) AS total_usd
FROM stablecoins_solana_balances_enriched AS b
WHERE b.day = CURRENT_DATE
    AND b.balance > 0
GROUP BY b.address_category, b.token_symbol
ORDER BY total_usd DESC

​
Notes

  • is_whale is calculated per day.
  • For performance, filter by blockchain and day.

Interpreting balances vs circulating supply

  • This table represents onchain balances, which is different from circulating supply.
  • Bridge-locked funds are intentionally included in balances. For example, more than $4B USDT can appear in the Tether USDT0Adapter contract on Ethereum while representing circulating USDT0 on other chains.
  • We are not subtracting bridge balances at this stage because exclusions are not objective across bridge designs, and some bridge-held balances represent liquidity for chains not covered elsewhere.
  • Bridge exposure is directly analyzable with address_category = 'bridge'.
  • We will continue to work toward a more reliable total supply measure.