Cipher009-CpUJ5kBots on THOR copy
Updated 2023-06-29
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
28
29
30
›
⌄
-- forked from KowalskiDeFi / Bots on THOR @ https://flipsidecrypto.xyz/KowalskiDeFi/q/3PBxMZBBG3a4/bots-on-thor
with
bot_swappers as (
select
date_trunc('minute', block_timestamp) AS datetime,
from_address as address,
count(*) AS transaction_count
from
flipside_prod_db.thorchain.swaps
WHERE
block_timestamp >= CURRENT_DATE -20
group by
1,
2
having
transaction_count > 10
order by
3 desc
)
SELECT
date_trunc('day', datetime) as datetime,
address,
SUM(transaction_count) total_count
from
bot_swappers
group by
1,
2
order by
3 desc
Run a query to Download Data