date_trunc('day', block_timestamp) as day,

project_name as currency,

count(DISTINCT trader) as users

FROM osmosis.core.fact_swaps

LEFT outer JOIN osmosis.core.dim_labels

ON to_currency = address

GROUP BY 1,2