Query editor
SELECTDATE(tr.block_time) AS date,COUNT(DISTINCT tr.trader_id) AS daily_unique_walletsFROM dex_solana.trades AS trWHEREtr.token_bought_symbol = 'BONK' OR tr.token_sold_symbol = 'BONK'GROUP BY1ORDER BYdate
Query editor
1SELECT2DATE(tr.block_time) AS date,3COUNT(DISTINCT tr.trader_id) AS daily_unique_wallets4FROM dex_solana.trades AS tr5WHERE6tr.token_bought_symbol = 'BONK' OR tr.token_sold_symbol = 'BONK'7GROUP BY819ORDER BY10date11