KaskoazulSmall LP actions
Updated 2022-04-13
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 LARGE_RUNE as (
select pool_name,
'RUNE' as ASSET,
count(rune_amount_usd) as LARGE_RUNE
from thorchain.liquidity_actions
where rune_amount_usd >= 1000
group by 1, 2
order by 1, 2
),
SMALL_RUNE as (
select pool_name,
'RUNE' as ASSET,
count(rune_amount_usd) as SMALL_RUNE
from thorchain.liquidity_actions
where rune_amount_usd < 1000
group by 1, 2
order by 1, 2
),
LARGE_ASSET as (
select pool_name,
'ASSET' as ASSET,
count(asset_amount_usd) as LARGE_ASSET
from thorchain.liquidity_actions
where asset_amount_usd >= 1000
group by 1, 2
order by 1, 2
),
SMALL_ASSET as (
select pool_name,
'ASSET' as ASSET,
count(asset_amount_usd) as SMALL_ASSET
from thorchain.liquidity_actions
where asset_amount_usd < 1000
Run a query to Download Data