Skip to main content
The stablecoins_evm.transfers table contains curated stablecoin transfer records across 37 supported EVM chains. One row represents one ERC20 stablecoin transfer event at log granularity. This table is useful for:
  • stablecoin flow analysis by chain, token, and address
  • transfer volume analysis in native units and USD
  • cross-chain stablecoin transfer comparisons

​
Table schema

ColumnTypeDescription
blockchainVARCHARChain name
block_monthDATEFirst day of month (partition column)
block_dateDATETransaction date
block_timeTIMESTAMPTransaction timestamp
block_numberBIGINTBlock number
tx_hashVARBINARYTransaction hash
evt_indexBIGINTTransfer event index
trace_addressVARCHARTrace address (nullable)
token_standardVARCHARToken standard (erc20)
token_addressVARBINARYToken contract address
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
toVARBINARYRecipient 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_evm.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

  • For partition pruning, filter by blockchain and block_month.