Amp
/

Daily USDC transfer volume on Ethereum for the last week

Here's daily USDC transfer volume on Ethereum, decoded from Transfer events on the USDC contract and summed per UTC day.

SQL
SELECT  date_trunc('day', timestamp) AS day,  count(*) AS transfers,  sum(transfer['value']) / 1e6 AS volume_usdcFROM (  SELECT timestamp, evm_decode_log(topic1, topic2, topic3, data,    'Transfer(address indexed from, address indexed to, uint256 value)') AS transfer  FROM "edgeandnode/ethereum_mainnet@latest".logs  WHERE address = X'a0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'    AND timestamp >= now() - INTERVAL '7 days')GROUP BY 1ORDER BY 1 DESC
daytransfersvolume_usdc
2026-10-12612,4088,904,117,322.18
2026-10-11498,2336,215,880,410.92
2026-10-10655,0919,731,402,118.55
2026-10-09701,87210,288,615,904.07
2026-10-08689,1409,976,233,871.40
ChatEarly access

Ask for any onchain data

Describe what you need in plain language. Amp finds the right datasets, writes the SQL, and shows you the rows.

  • Answers backed by SQL you can inspect
  • Sample rows in seconds, across every dataset
  • Keep refining until it's exactly right