Yousefi_1994Bot on Solana network in the 3 last month
Updated 2022-07-12
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
›
⌄
with bot_list as (
select
date_trunc('minute', block_timestamp) as minute_interval,
signers[0] as bot,
count(tx_id) as number_of_transaction
from solana.core.fact_transactions
where block_timestamp::date <= current_date - 1
and block_timestamp::date >= '2022-01-01'
group by minute_interval, bot
having number_of_transaction > 20
),
bot_final_list as (
select
bot
from bot_list
where number_of_transaction > 20
group by bot
)
select
block_timestamp::date as days,
count(distinct signers[0]) as "Number of Bot"
from solana.core.fact_transactions
where block_timestamp::date <= current_date - 1
and block_timestamp::date >= '2022-01-01'
and signers[0] in (select bot from bot_final_list)
group by days
order by days
Run a query to Download Data