Skip to main content
The stablecoins_evm_balances_enriched table extends EVM stablecoin balances with address classification, entity tags, 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
dayDATEBalance date (partition column)
addressVARBINARYHolder address
token_symbolVARCHARToken symbol
token_addressVARBINARYToken contract address
token_standardVARCHARToken standard (erc20)
token_idVARCHARAlways NULL
balance_rawUINT256Raw balance
balanceDOUBLEDecimals-adjusted balance
balance_usdDOUBLEUSD value
currencyVARCHARISO 4217 code
address_categoryVARCHARAddress category
address_subcategoryVARCHARAddress subcategory
address_projectVARCHARProject/entity name (nullable)
address_versionVARCHARProject version (nullable)
address_labelVARCHARLabel value (nullable)
is_smart_contractBOOLEANContract flag
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
erc20_contracterc20_contract
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_smart_contractunidentified_smart_contract
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_evm.balances.
  2. Join curated address labels to assign address_category, subcategory, and project metadata where a label exists.
  3. Derive structural flags (is_smart_contract) and concentration flags (is_whale) for each day.
  4. Apply fallback categories for unlabeled addresses (for example unidentified_smart_contract, unidentified_whale, unidentified) to maintain complete coverage.

​
Important interpretation details

  • Labels represent the best-known economic function of an address and can evolve as coverage improves.
  • Category totals should be interpreted as “where balances sit” rather than ownership or liability accounting.
  • 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_evm_balances_enriched AS b
WHERE b.blockchain = 'ethereum'
    AND 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 and per chain.
  • 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.