case when date >= '2022-10-27' and date< '2022-11-07' then 'Before Price Drop'

when date >= '2022-11-08' and date<= '2022-11-09' then 'Price Drop'

when date >= '2022-11-10' and date <= '2022-11-22' then 'After Price Drop' else null end as scheduling ,

case when token_out = '0xae78736cd615f374d3085123a210448e74fc6393' then 'Swap To aETH' else null end as type,

count (distinct tx_hash) as Swaps_Count,

count (distinct origin_from_address) as Swappers_Count,

sum (case when token_in = '0xae78736cd615f374d3085123a210448e74fc6393' then amount_in_usd when token_out = '0xae78736cd615f374d3085123a210448e74fc6393' then amount_out_usd end) as volume

from ethereum.core.ez_dex_swaps

where type is not null

and scheduling is not null

group by 1,2,3 having volume > 0

order by 1