select FROM_CURRENCY,sum(TO_AMOUNT)/1e6 as swap_to_akt,count(distinct tx_id) as swap_count

from osmosis.core.fact_swaps

where TO_CURRENCY='ibc/1480B8FD20AD5FCAE81EA87584D269547DD4D436843C1D20F15E00EB64743EF4'

and BLOCK_TIMESTAMP>=current_date-7

and TX_STATUS='SUCCEEDED'

group by 1

order by 2 desc ),

tab2 as (

select ADDRESS,PROJECT_NAME

from osmosis.core.dim_labels)

select PROJECT_NAME,swap_to_akt,rank()over (order by swap_to_akt)as rank

from tab1

left join tab2

on tab1.FROM_CURRENCY=tab2.ADDRESS

order by 2 desc

limit 10