SELECT
-- DATE_TRUNC(day, block_timestamp) AS timespan,
SUM(amount) AS volume,
SUM(amount_usd) AS volume_usd
FROM arbitrum.core.ez_token_transfers
WHERE to_address = LOWER('0x85b34Aa54fdf8242e4656eA50b711F45340925bC') -- Contract address
AND symbol = 'USDC'
AND block_timestamp::date BETWEEN '2024-06-26' AND '2024-07-26'
-- GROUP BY 1
-- ORDER BY 1