0xaimanVolume of Pool by TVL
Updated 2021-11-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with addvalue as (select pool_name, sum(rune_amount) as r1,sum(rune_amount_usd) as rusd1, sum(asset_amount) as a1, sum(asset_amount_usd) as ausd1
from thorchain.liquidity_actions
where lp_action='add_liquidity'
group by pool_name
),
removevalue as (select pool_name, sum(rune_amount) as r2,sum(rune_amount_usd) as rusd2, sum(asset_amount) as a2, sum(asset_amount_usd) as ausd2
from thorchain.liquidity_actions
where lp_action='remove_liquidity'
group by pool_name
)
select addvalue.pool_name, r1-r2 as Rune_amount,rusd1-rusd2 as rune_amount_usd,a1-a2 as asset_amount ,ausd1-ausd2 as asset_amount_usd
from addvalue
inner join removevalue on addvalue.pool_name=removevalue.pool_name
Run a query to Download Data