date_trunc('hour',block_timestamp) as hour,

date_trunc('day',block_timestamp) as day,

date_trunc('week',block_timestamp) as week,

date_trunc('month',block_timestamp) as month

from arbitrum.defi.ez_dex_swaps

where block_timestamp::date = '2024-08-08'

limit 1