with tab1 as (

select BLOCK_TIMESTAMP::date as date,max(FROM_AMOUNT)/1e6 as MAX_SWAP_FROM,min(FROM_AMOUNT)/1e6as MIN_SWAP_FROM

,median(FROM_AMOUNT)/1e6as MEDIAN_SWAP_FROM

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,max(TO_AMOUNT)/1e6 as MAX_SWAP_TO,min(TO_AMOUNT)/1e6as MIN_SWAP_TO

,median(TO_AMOUNT)/1e6as MEDIAN_SWAP_TO

from osmosis.core.fact_swaps

where TO_CURRENCY='ibc/1480B8FD20AD5FCAE81EA87584D269547DD4D436843C1D20F15E00EB64743EF4'

and date>=current_date-7

group by 1)

select tab2.date,MAX_SWAP_FROM,MIN_SWAP_FROM ,MEDIAN_SWAP_FROM

,MAX_SWAP_TO,MIN_SWAP_TO ,MEDIAN_SWAP_TO

from tab1

full outer join tab2

on tab1.date=tab2.date