Query editor
--Bots definition by @ilemiwith trader_summary as (SElectsigner,count(*) as txs,sum(case when success = false then 1 else 0 end) as failsfrom solana.transactionswhere signer in (SELECTdistinct trader_idFROm dex_solana.trades)group by 1),bots as (SELECTsignerFROM trader_summaryWHERE txs > 5000AND cast(fails as double)/cast(txs as double) > 0.2)selectblock_date,case when tx_signer in (select signer from bots) then 'Bots'else 'Organic'end as user_type,count(distinct tx_id) as txnsfrom solana.instruction_callswhere block_date >= date('2024-03-10')and tx_success = falsegroup by 1,2