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