select trader as unique_swappers_from_akt,sum(FROM_AMOUNT)/1e6 as swap_from_akt

from osmosis.core.fact_swaps

where FROM_CURRENCY='ibc/1480B8FD20AD5FCAE81EA87584D269547DD4D436843C1D20F15E00EB64743EF4'

and BLOCK_TIMESTAMP>=current_date-7

and TX_STATUS='SUCCEEDED'

group by 1

order by 2 desc

limit 10