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.

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