select

date_trunc('month',block_timestamp) as month,

sum(AMOUNT_OUT) as stNear_from_wNEAR_vol

from near.core.ez_dex_swaps

where TOKEN_OUT = 'STNEAR'

and TOKEN_IN = 'wNEAR'

group by 1

),

withdrawn as(

SELECT

date_trunc('month',block_timestamp) as month,

sum(AMOUNT_IN) as wNEAR_from_stNEAR_vol

from near.core.ez_dex_swaps

where TOKEN_IN = 'STNEAR'

and TOKEN_OUT = 'wNEAR'

group by 1

)

select

a.month,

a.stNear_from_wNEAR_vol,

b.wNEAR_from_stNEAR_vol

from dep a inner join withdrawn b

where a.month=b.month