zakkisyedTHORchain 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
›
⌄
SELECT
date_trunc('day', block_timestamp) as block_time,
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 (
SELECT
from_address,
COUNT(DISTINCT tx_id) as swaps
FROM flipside_prod_db.thorchain.swaps
GROUP BY 1
HAVING swaps > 5000
)
)
and block_timestamp >= '2022-01-01'
GROUP BY 1
order by 1 desc
Run a query to Download Data