Skip to main content
The stablecoins_solana.balances table contains daily stablecoin balances per wallet on Solana. One row represents one wallet-token balance snapshot for a specific day. Coverage includes both SPL and SPL2022 stablecoin balances.

Upgrade to the enriched dataset

Skip manual reconstruction. The enriched version packages attribution and methodology so you can move from raw data to insights faster.

​
Table schema

ColumnTypeDescription
blockchainVARCHARChain name (solana)
dayDATEBalance date
addressVARCHARWallet address
token_symbolVARCHARToken symbol
token_addressVARCHARToken mint address
token_standardVARCHARToken standard (spl_token / token2022)
token_idVARCHARToken id (typically NULL)
currencyVARCHARISO 4217 currency code
balance_rawUINT256Raw balance
balanceDOUBLEDecimals-adjusted balance
balance_usdDOUBLEUSD value
last_updatedTIMESTAMPLast balance update time

​
Sample Queries

SELECT
    b.day
    , b.token_symbol
    , SUM(b.balance_usd) AS total_supply_usd
FROM stablecoins_solana.balances AS b
WHERE b.balance > 0
    AND b.day >= CURRENT_DATE - INTERVAL '30' DAY
GROUP BY b.day, b.token_symbol
ORDER BY b.day DESC, total_supply_usd DESC

​
Notes

  • Balances are forward-filled by day.
  • For best performance, filter by day.
  • For multichain aggregate balances, see stablecoins_multichain.balances.

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.
  • We will continue to work toward a more reliable total supply measure.