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.

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