date_trunc('hour', block_timestamp) as hour,

count(*) as swaps,

count(DISTINCT ORIGIN_FROM_ADDRESS) as swappers,

sum(case when not AMOUNT_IN_USD is NULL then AMOUNT_IN_USD else AMOUNT_out_USD end) as swap_volume_usd

FROM ethereum.defi.ez_dex_swaps

where token_in like lower('0x0000000000c5dc95539589fbD24BE07c6C14eCa4')

or token_out like lower('0x0000000000c5dc95539589fbD24BE07c6C14eCa4')

GROUP by 1