bachi26. thor - network load
Updated 2021-12-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
⌄
/*SELECT date_trunc("hour", block_timestamp) as hour, count(DISTINCT(tx_id)) / 60 as tx_done_div_60_min
FROM thorchain.swaps where block_timestamp >= dateadd(year, -1, getdate())
group BY 1 ORDER BY 2 DESC*/
--LIMIT 10000
SELECT
date_trunc("minute", block_timestamp) as time, date_trunc("day", block_timestamp) as date,
count(DISTINCT(tx_id))
FROM thorchain.swaps where block_timestamp >= dateadd(month, -3, getdate())
GROUP BY 1,2
ORDER BY 3
DESC
Run a query to Download Data