date_trunc('day',block_timestamp) as day,

count(*) as stETH_out

from

ethereum.core.ez_dex_swaps

where token_out = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84' and block_timestamp between '2022-03-01' and '2022-06-14'

group by 1),

ino as (select

date_trunc('day',block_timestamp)dayb,

count(*) as stETH_IN

from

ethereum.core.ez_dex_swaps

where token_in = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84' and block_timestamp between '2022-03-01' and '2022-06-14'

group by 1)

select

day,

stETH_IN,

stETH_OUT * (-1) as stETH_OUT

from ine join ino on ino.dayb = ine.day

group by 1, 2, 3