Skip to main content
The stablecoins_multichain.transfers table unions stablecoin transfer records from all supported ecosystems — EVM (37 chains), Solana, and Tron — into a single cross-chain view with normalized address and hash types (VARCHAR). One row represents one stablecoin transfer event. This table is useful for:
  • Cross-ecosystem stablecoin flow analysis
  • Aggregate transfer volume across all supported chains
  • Comparing stablecoin movement patterns across EVM, Solana, and Tron

​
Table Schema

ColumnTypeDescription
blockchainVARCHARChain name
block_monthDATEFirst day of month (partition column)
block_dateDATETransaction date
block_timeTIMESTAMPTransaction timestamp
block_numberBIGINTBlock number (null for Solana)
tx_hashVARCHARTransaction hash
evt_indexBIGINTEvent index within the transaction (null for Solana)
token_standardVARCHARToken standard (e.g. erc20, spl_token)
token_addressVARCHARToken contract/mint address
token_symbolVARCHARToken symbol
currencyVARCHARISO 4217 currency code
amount_rawUINT256Raw transfer amount
amountDOUBLEDecimals-adjusted amount
price_usdDOUBLEUSD price per unit
amount_usdDOUBLEUSD value of transfer
fromVARCHARSender address
toVARCHARRecipient address
unique_keyVARCHARUnique transfer identifier

​
Sample Queries

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

​
Notes

  • Addresses and hashes are cast to VARCHAR for cross-ecosystem compatibility.
  • For partition pruning, filter by blockchain and block_month.