boomer77average lp thorchain
Updated 2022-04-12
9
1
2
3
4
5
6
7
8
›
⌄
with raw as (select date(block_timestamp) as dt, pool_name, (rune_amount_usd+asset_amount_usd) as vol_usd
from thorchain.liquidity_actions
where lp_action = 'add_liquidity' and pool_name not in ('ETH.WBTC-0X2260FAC5E5542A773AA44FBCFEDF7C193BC2C599'))
select pool_name, sum(vol_usd) as total_vol_usd, avg(vol_usd) as average_lp, 1000 as "$1000"
from raw
group by 1
Run a query to Download Data