ZookUntitled Query
Updated 2022-04-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
--SELECT
--from_address,
--(rune_amount_usd + asset_amount_usd) as balance_change_usd
-- From(
select * from (
Select
from_address,
sum(add_liquidity) as sum_add_liquidity
from (
SELECT
from_address,
(rune_amount_usd + asset_amount_usd) as add_liquidity
from thorchain.liquidity_actions
where from_address is not null
and lp_action = 'add_liquidity')
group by from_address
)
where sum_add_liquidity > 10000 -- note: from_addresses that have provided over 10000 USD in liquidity (ignores withdrawals)
group by from_address,2
Run a query to Download Data