Query editor
WITH usdc_volume AS (SELECTDATE_TRUNC('day', block_time) AS date, /* */SUM(amount_display) AS total_volume_sol /* */FROM tokens_solana.transfersWHEREsymbol = 'USDC' /* */ AND block_time >= TRY_CAST('2024-07-01' /* */ AS TIMESTAMP)GROUP BY1)SELECT*FROM usdc_volumeORDER BYdate,total_volume_sol DESC