KaskoazulMetaplex Bot Free Top 10 bots
    Updated 2022-05-07
    select signers[0] as bot,
    count(tx_id) as bot_txs,
    hourly_bot_txs * 0.01 as tax_paid
    from solana.fact_transactions
    where block_timestamp >= '2022-04-26'
    and CAST(log_messages as string) ILIKE '%Botting is taxed%'
    group by 1
    order by 2 DESC
    limit 10

    Run a query to Download Data