select BLOCK_TIMESTAMP::date as date,count(distinct TX_ID) as "SWAP COUNT FROM AKT"

,count(distinct TRADER)as "UNIQUE SWAPPERS FROM AKT"

from osmosis.core.fact_swaps

where FROM_CURRENCY='ibc/1480B8FD20AD5FCAE81EA87584D269547DD4D436843C1D20F15E00EB64743EF4'

and date>=current_date-7

group by 1),

tab2 as (

select BLOCK_TIMESTAMP::date as date,count(distinct TX_ID) as "SWAP COUNT TO AKT"

,count(distinct TRADER)as "UNIQUE SWAPPERS TO AKT"

from osmosis.core.fact_swaps

where TO_CURRENCY='ibc/1480B8FD20AD5FCAE81EA87584D269547DD4D436843C1D20F15E00EB64743EF4'

and date>=current_date-7

group by 1)

select tab2.date,"SWAP COUNT FROM AKT","UNIQUE SWAPPERS FROM AKT","SWAP COUNT TO AKT","UNIQUE SWAPPERS TO AKT"

,avg("SWAP COUNT FROM AKT") as "AVG SWAP COUNT FROM AKT"

from tab1

full outer join tab2

on tab1.date=tab2.date