lagandispenserTop Active LPer Over Time
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
›
⌄
WITH
all_liquidity_actions as (
SELECT
date_trunc ('week',block_timestamp) as week,
from_address,
COUNT(from_address) as number_of_liquidity_actions
FROM thorchain.liquidity_actions
GROUP BY 1,2
ORDER BY number_of_liquidity_actions DESC
),
targeted_addresses as (
SELECT
*
FROM all_liquidity_actions
ORDER BY number_of_liquidity_actions DESC
--WHERE tx_count > 100 AND tx_count < 10000
LIMIT 20
),
top_human as (
SELECT
*,
date_trunc ('week',block_timestamp) as week
FROM thorchain.liquidity_actions
WHERE from_address in (SELECT from_address FROM targeted_addresses)
)
SELECT
*
FROM targeted_addresses
Run a query to Download Data