Skip to main content
The stablecoins_tron.balances table contains daily stablecoin balances per wallet on Tron. One row represents one wallet-token balance snapshot for a specific day. Coverage is TRC20 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.
 It includes both 0x-format and base58-format address fields.

​
Table schema

ColumnTypeDescription
blockchainVARCHARChain name (tron)
dayDATEBalance date
addressVARBINARYHolder address (0x)
address_varcharVARCHARHolder address (base58)
token_symbolVARCHARToken symbol
token_addressVARCHARToken contract address (base58)
contract_addressVARBINARYToken contract address (0x)
token_standardVARCHARToken standard (trc20)
token_idVARCHARToken id (typically NULL)
balance_rawUINT256Raw balance
balanceDOUBLEDecimals-adjusted balance
balance_usdDOUBLEUSD value
currencyVARCHARISO 4217 currency code
last_updatedTIMESTAMPLast balance update time

​
Sample Queries

SELECT
    b.day
    , b.token_symbol
    , SUM(b.balance_usd) AS total_supply_usd
FROM stablecoins_tron.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

​
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.