SELECT date_trunc('hour',block_timestamp) as hour,

count(distinct tx_hash) as n_swaps,

count(DISTINCT swapper) as n_swappers,

sum(case when token_out = '0xeedba439a4ab8987a995cf5cfefebd713000b3365718a29dfbc36bc214445fb8' then amount_out_unadj else amount_in_unadj end)/pow(10,8) as VIBE_swapped,

sum(case when token_out = '0xeedba439a4ab8987a995cf5cfefebd713000b3365718a29dfbc36bc214445fb8' then amount_in_usd else amount_out_usd end) as VIBE_swapped_in_USD

FROM aptos.defi.ez_dex_swaps

WHERE (token_out = '0xeedba439a4ab8987a995cf5cfefebd713000b3365718a29dfbc36bc214445fb8' or token_in = '0xeedba439a4ab8987a995cf5cfefebd713000b3365718a29dfbc36bc214445fb8')

group by 1