with tab1 as (SELECT tx_from,

min(BLOCK_TIMESTAMP) as min_time

FROM osmosis.core.fact_transactions

GROUP by 1

SELECT date_trunc('month', min_time) as month,

PROJECT_NAME,

count(*)

FROM osmosis.core.fact_swaps

LEFT OUTER JOIN tab1

ON trader = tx_from

AND min_time = BLOCK_TIMESTAMP

LEFT outer JOIN osmosis.core.dim_tokens

ON to_currency = address

WHERE NOT tx_from is NULL

GROUP BY 1,2