froms as (

SELECT

distinct trader,

sum(from_amount/pow(10,from_decimal)) as volume,

count(distinct tx_id) as swaps

from osmosis.core.fact_swaps where block_timestamp>='2022-09-26' and from_currency='ibc/EA1D43981D5C9A1C4AAEA9C23BB1D4FA126BA9BC7020A25E0AE4AA841EA25DC5'

and tx_status='SUCCEEDED'

group by 1

) ,

tos as (

SELECT

distinct trader,

sum(to_amount/pow(10,to_decimal)) as volume,

count(distinct tx_id) as swaps

from osmosis.core.fact_swaps where block_timestamp>='2022-09-26' and to_currency='ibc/EA1D43981D5C9A1C4AAEA9C23BB1D4FA126BA9BC7020A25E0AE4AA841EA25DC5'

and tx_status='SUCCEEDED'

group by 1

)

SELECT 'Deposits' as action, avg(volume) as avg_volume_swapped_per_user,avg(swaps) as avg_swaps_per_user from tos

union select 'Withdrawals' as action, avg(volume) as avg_volume_swapped_per_user,avg(swaps) as avg_swaps_per_user from froms