date_trunc('hour', block_timestamp) as hour,

sum(amount_in_usd) as volume_usd

from ethereum.core.ez_dex_swaps

where block_timestamp >= current_date() - interval '{} HOURS'

group by hour

order by hour asc