lagandispenserTop Active LP Liquiduity
Updated 2022-06-28
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
31
32
33
34
35
36
›
⌄
WITH
all_liquidity_actions as (
SELECT
from_address,
COUNT(from_address) as tx_count
FROM thorchain.liquidity_actions
GROUP BY from_address
ORDER BY tx_count DESC
),
targeted_addresses as (
SELECT
*
FROM all_liquidity_actions
ORDER BY tx_count DESC
--WHERE tx_count > 100 AND tx_count < 10000
LIMIT 20
),
top_human as (
SELECT
*,
date(block_timestamp) as dates
FROM thorchain.liquidity_actions
WHERE from_address in (SELECT from_address FROM targeted_addresses)
)
SELECT
from_address,
lp_action,
count(from_address) as number
FROM top_human
GROUP BY from_address, lp_action
order by 3 desc
Run a query to Download Data