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