nitsThorBefore- 1
Updated 2022-04-26
9
1
2
3
4
5
6
7
›
⌄
SELECT day, pool_name, sum(total_liquidity) as tvl from
(SELECT *, (asset_liquidity*asset_price)+(rune_liquidity* rune_price) as total_liquidity
from thorchain.daily_pool_stats
where abs(timestampdiff(SQL_TSI_DAY, day , '2021-04-11 07:28:47.929')) < 30 )
GROUP by 1,2
-- limit 100
Run a query to Download Data