Stablecoin Balances (Tron)

Daily stablecoin balances per wallet on Tron

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

Column	Type	Description
blockchain	VARCHAR	Chain name (tron)
day	DATE	Balance date
address	VARBINARY	Holder address (0x)
address_varchar	VARCHAR	Holder address (base58)
token_symbol	VARCHAR	Token symbol
token_address	VARCHAR	Token contract address (base58)
contract_address	VARBINARY	Token contract address (0x)
token_standard	VARCHAR	Token standard (trc20)
token_id	VARCHAR	Token id (typically NULL)
balance_raw	UINT256	Raw balance
balance	DOUBLE	Decimals-adjusted balance
balance_usd	DOUBLE	USD value
currency	VARCHAR	ISO 4217 currency code
last_updated	TIMESTAMP	Last 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.