select

date_trunc('month',block_timestamp) as month,

sum(AMOUNT_OUT) as in_vol

from near.core.ez_dex_swaps

where TOKEN_OUT = 'STNEAR'

group by 1

),

withdrawn as(

SELECT

date_trunc('month',block_timestamp) as month,

sum(AMOUNT_IN) as out_vol

from near.core.ez_dex_swaps

where TOKEN_IN = 'STNEAR'

group by 1

)

select

a.month,

a.in_vol,

b.out_vol

from dep a inner join withdrawn b

where a.month=b.month