Skip to main content
The stablecoins_tron.transfers table contains curated stablecoin transfer records on Tron. One row represents one TRC20 transfer event at event-log granularity. It includes both VARBINARY (0x) and VARCHAR (base58) address/hash representations.

​
Table schema

ColumnTypeDescription
blockchainVARCHARChain name (tron)
block_monthDATEFirst day of month (partition column)
block_dateDATETransaction date
block_timeTIMESTAMPTransaction timestamp
block_numberBIGINTBlock number
tx_hashVARBINARYTransaction hash (0x)
evt_indexBIGINTEvent index
trace_addressVARCHARTrace address (nullable)
token_standardVARCHARToken standard (trc20)
token_addressVARCHARToken contract address (base58)
token_symbolVARCHARToken symbol
currencyVARCHARISO 4217 currency code
amount_rawUINT256Raw transfer amount
amountDOUBLEDecimals-adjusted amount
price_usdDOUBLEUSD price used for valuation
amount_usdDOUBLEUSD amount
fromVARBINARYSender address (0x)
toVARBINARYRecipient address (0x)
unique_keyVARCHARUnique transfer identifier
tx_fromVARBINARYTransaction sender (0x)
tx_toVARBINARYTransaction receiver (0x)
tx_indexBIGINTTransaction index
contract_addressVARBINARYToken contract (0x)
tx_hash_varcharVARCHARTransaction hash (base58)
contract_address_varcharVARCHARToken contract (base58)
from_varcharVARCHARSender address (base58)
to_varcharVARCHARRecipient address (base58)
tx_from_varcharVARCHARTransaction sender (base58)
tx_to_varcharVARCHARTransaction receiver (base58)

​
Sample Queries

SELECT
    t.block_date
    , SUM(t.amount_usd) AS volume_usd
    , COUNT(*) AS transfers
FROM stablecoins_tron.transfers AS t
WHERE t.token_symbol = 'USDT'
    AND t.block_date >= CURRENT_DATE - INTERVAL '30' DAY
GROUP BY t.block_date
ORDER BY t.block_date DESC

​
Notes

  • For partition pruning, filter by block_month.