Stablecoin Transfers (Tron)

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

Column	Type	Description
`blockchain`	`VARCHAR`	Chain name (`tron`)
`block_month`	`DATE`	First day of month (partition column)
`block_date`	`DATE`	Transaction date
`block_time`	`TIMESTAMP`	Transaction timestamp
`block_number`	`BIGINT`	Block number
`tx_hash`	`VARBINARY`	Transaction hash (0x)
`evt_index`	`BIGINT`	Event index
`trace_address`	`VARCHAR`	Trace address (nullable)
`token_standard`	`VARCHAR`	Token standard (`trc20`)
`token_address`	`VARCHAR`	Token contract address (base58)
`token_symbol`	`VARCHAR`	Token symbol
`currency`	`VARCHAR`	ISO 4217 currency code
`amount_raw`	`UINT256`	Raw transfer amount
`amount`	`DOUBLE`	Decimals-adjusted amount
`price_usd`	`DOUBLE`	USD price used for valuation
`amount_usd`	`DOUBLE`	USD amount
`from`	`VARBINARY`	Sender address (0x)
`to`	`VARBINARY`	Recipient address (0x)
`unique_key`	`VARCHAR`	Unique transfer identifier
`tx_from`	`VARBINARY`	Transaction sender (0x)
`tx_to`	`VARBINARY`	Transaction receiver (0x)
`tx_index`	`BIGINT`	Transaction index
`contract_address`	`VARBINARY`	Token contract (0x)
`tx_hash_varchar`	`VARCHAR`	Transaction hash (base58)
`contract_address_varchar`	`VARCHAR`	Token contract (base58)
`from_varchar`	`VARCHAR`	Sender address (base58)
`to_varchar`	`VARCHAR`	Recipient address (base58)
`tx_from_varchar`	`VARCHAR`	Transaction sender (base58)
`tx_to_varchar`	`VARCHAR`	Transaction 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.

Curated Data

Solana

Hyperliquid

Non-EVM Networks

Protocols

EVM Networks

Partner Data

Dune Index

Stablecoin Transfers (Tron)

Table schema

Sample Queries

Notes

​Table schema

​Sample Queries

​Notes

Table schema

Sample Queries

Notes