NuveveCryptoArchivedMost Botted Pools
Updated 2022-09-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
with bot_acts as (
select
origin_from_address as sender,
date_trunc('minute', block_timestamp) as minute,
count(tx_hash) as tx_count
from arbitrum.sushi.ez_swaps
group by 1, 2
having tx_count > 2
),
bots as (
select
distinct(sender) as wallets
from bot_acts
)
select
swaps.pool_name as pool_name,
count(swaps.tx_hash) as tx_count
from arbitrum.sushi.ez_swaps as swaps
inner join bots on swaps.origin_from_address = bots.wallets
group by swaps.pool_name
order by 2 desc
Run a query to Download Data