Stablecoin Transfers (EVM)

Stablecoin transfer events across 37 supported EVM chains

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

Column	Type	Description
blockchain	VARCHAR	Chain name
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
evt_index	BIGINT	Transfer event index
trace_address	VARCHAR	Trace address (nullable)
token_standard	VARCHAR	Token standard (erc20)
token_address	VARBINARY	Token contract address
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
to	VARBINARY	Recipient address
unique_key	VARCHAR	Unique 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.