nitsBTC.BTC TVL
Updated 2022-04-28
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
SELECT day, sum(amt_net) as tvl,sum(tvl) over (order by day) as cumulative_tvl,
sum(asset_amount) as total_vol,
tvl*40000 as tvl_usd,
cumulative_tvl*40000 as cumulative_tvl_usd,
total_vol*40000 as total_vol_usd
from
(SELECT date(block_timestamp) as day, asset_amount, case when lp_action = 'add_liquidity' then asset_amount else asset_amount*(-1) end as amt_net
from thorchain.liquidity_actions
where pool_name = 'BTC.BTC' )
GROUP by 1
-- limit 100
Run a query to Download Data