KaskoazulLP Size Distribution Top 10
Updated 2022-05-03
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 add_LP as (
select pool_name,
sum(rune_amount) as total_add_rune,
sum(rune_amount_usd) as total_add_rune_usd,
sum(asset_amount) as total_add_asset,
sum(asset_amount_usd) as total_add_asset_usd
from thorchain.liquidity_actions
where lp_action = 'add_liquidity'
group by 1
),
remove_LP as (
select pool_name,
sum(rune_amount) as total_rem_rune,
sum(rune_amount_usd) as total_rem_rune_usd,
sum(asset_amount) as total_rem_asset,
sum(asset_amount_usd) as total_rem_asset_usd
from thorchain.liquidity_actions
where lp_action = 'remove_liquidity'
group by 1
),
prices as (
select *
from thorchain.prices
where block_id = 5380898 -- '2022-05-02 00:55:01.986'
),
--thorchain.prices!
calculate as (
select split_part (a.pool_name, '-', 1) as pool,
a.total_add_rune,
--a.total_add_rune_usd,
a.total_add_asset,
--a.total_add_asset_usd,
Run a query to Download Data