SELECT
token_out,
DATE_TRUNC('hour', BLOCK_TIMESTAMP + INTERVAL '1 hours') AS interval_start,
SUM(amount_in) AS volume
FROM
ethereum.defi.ez_dex_swaps
where
interval_start between '2023-10-10' and '2023-10-16'
GROUP BY
token_out, interval_start
ORDER BY
interval_start DESC, volume DESC;