SELECT
DATE_TRUNC('hour', BLOCK_TIMESTAMP) AS hour,
SUM(AMOUNT_USD) AS total_amount_usd,
FROM
ethereum.core.ez_token_transfers
WHERE
CONTRACT_ADDRESS = '0xc56c2b7e71b54d38aab6d52e94a04cbfa8f604fa'
AND BLOCK_TIMESTAMP > DATEADD(day, -90, CURRENT_TIMESTAMP)
GROUP BY
hour
ORDER BY
hour ASC;