boomer77thorchain pool sizes
Updated 2021-11-01
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
with tvl as (select date_trunc('day', block_timestamp) as dt, pool_name, avg(rune_e8/1e8) as tvl_rune, avg(asset_e8/1e8) as tvl_asset
from thorchain.block_pool_depths
group by 1,2
order by 1 desc),
price as (select date_trunc('day', block_timestamp) as dt, avg(rune_usd) as rune_price
from thorchain.prices
group by 1)
select a.dt, a.pool_name, a.tvl_rune, b.rune_price, (a.tvl_rune * b.rune_price) as TVL_usd
from tvl a
join price b on a.dt = b.dt
Run a query to Download Data