zakkisyed#2 THORchain Arbitration Bots
Updated 2022-07-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
with bots as
(
SELECT
from_address,
COUNT(DISTINCT tx_id) as swaps
FROM flipside_prod_db.thorchain.swaps
where block_timestamp >= '2022-01-01'
--and from_address = '0x%'
GROUP BY 1
HAVING swaps > 5000
)
SELECT
count(DISTINCT from_address) as swappers,
count(DISTINCT tx_id) as swaps,
sum(TO_AMOUNT_USD) as volume_usd
FROM flipside_prod_db.thorchain.swaps
WHERE from_address in (
SELECT from_address
from bots
)
Run a query to Download Data