select BLOCK_TIMESTAMP::date as date,sum(FROM_AMOUNT)/1e6 as swap_from_akt,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

and TX_STATUS='SUCCEEDED'

group by 1),

tab2 as (

select BLOCK_TIMESTAMP::date as date,sum(TO_AMOUNT)/1e6 as swap_to_akt,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

and TX_STATUS='SUCCEEDED'

group by 1)

select tab2.date,swap_from_akt,swap_count_from_akt,unique_swappers_from_akt

,swap_to_akt,swap_count_to_akt,unique_swappers_to_akt

from tab1

full outer join tab2

on tab1.date=tab2.date