with stETH_swaps as (
select
block_timestamp,
platform,
case when direction = 'IN' then amount_in else amount_out end as amount
from flipside_prod_db.ethereum.dex_swaps
where token_address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84'
)
select
date_trunc('day', block_timestamp) as time,
platform,
sum(amount) as volume
from stETH_swaps
group by 1, 2