统计代币每日转账量

SELECT
    CAST(block_timestamp AS DATE) AS day,
    COUNT(*) AS transfer_count
FROM token.token_transfer.eth
WHERE token_id = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'
  AND block_timestamp >= TIMESTAMP '2026-09-01 00:00:00'
  AND block_timestamp < TIMESTAMP '2026-09-08 00:00:00'
GROUP BY 1
ORDER BY 1