to_currency,

project_name,

count(distinct tx_id) as swap_count

from osmosis.core.fact_swaps s

left join osmosis.core.dim_labels l on s.to_currency = l.address

where block_timestamp >= CURRENT_DATE - 7

and project_name is not null

group by to_currency, project_name

qualify row_number() over (order by swap_count desc) <= 5