KaskoazulMetaplex Bot Free Time distribution
    Updated 2022-05-07
    select date_trunc ('hour', block_timestamp) as hora,
    count(tx_id) as hourly_bot_txs,
    sum(hourly_bot_txs) over (order by hora) as total_bot_txs,
    total_bot_txs * 0.01 as tax_paid
    -- signers[0] as bot
    from solana.fact_transactions
    where hora >= '2022-04-26'
    and CAST(log_messages as string) ILIKE '%Botting is taxed%'
    group by 1
    order by 1 DESC

    Run a query to Download Data