SELECT

project_name,

label,

date_trunc('day', block_timestamp) as date,

count (distinct (tx_id )) AS transaction

FROM osmosis.core.fact_swaps a

join osmosis.core.dim_labels b

on a.to_currency =b.address

WHERE block_timestamp >= '2022-05-07'

and label in ('Osmosis','Cosmos','USD Coin','Luna Classic','Juno','Evmos','Sentinel','Lum','TerraClassicUSD','Stargaze')

GROUP BY 1,2,3

ORDER BY 4 DESC