select

block_timestamp::date as days,

from_currency as address,

count(*) as number_of_swaps,

sum(to_amount) as swap_volume

from osmosis.core.fact_swaps

where to_currency = 'ibc/0954E1C28EB7AF5B72D24F3BC2B47BBB2FDF91BDDFD57B74B99E133AED40972A'

and block_timestamp::date >= current_date - 90

group by days, address

order by swap_volume desc

select

swap.days as days,

labels.project_name as token_name,

swap.number_of_swaps as number_of_swaps,

swap.swap_volume as swap_volume

from swap_list_to_scrt swap

join osmosis.core.dim_labels labels using(address)