articoloquintoSolana daily botters
Updated 2022-07-10
9
1
2
3
4
5
6
7
8
›
⌄
select "date", count(distinct "daily botter") as "daily botters", avg("daily botters") over (order by "date" asc) as "moving average" from(
select date_trunc('day', BLOCK_TIMESTAMP) as "date", SIGNERS as "daily botter", count(SUCCEEDED) as "failed transactions"
from solana.core.fact_transactions
where BLOCK_TIMESTAMP >= '2022-01-01' and BLOCK_TIMESTAMP < '2022-07-09' and SUCCEEDED = 'FALSE'
group by 1, 2)
where "failed transactions" > 20
group by 1
order by 1 asc
Run a query to Download Data