Query editor
select date_trunc('day', block_time),count(distinct trader_id) as user_countfrom dex_solana.tradeswhere block_time > date('2023-01-01')group by 1order by 1
Query editor
1select date_trunc('day', block_time),2count(distinct trader_id) as user_count3from dex_solana.trades4where block_time > date('2023-01-01')5group by 16order by 1