flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Pool Ranks 1
Crazy_Kid
Pool Ranks 1
Updated 2022-04-12
Copy Reference
Fork
9
1
2
3
4
5
›
⌄
SELECT
date
(
block_timestamp
)
AS
date
,
pool_name
,
avg
(
rune_amount_usd
)
as
tvl_rune
,
avg
(
asset_amount_usd
)
as
tvl_asset
FROM
thorchain
.
pool_block_balances
GROUP
BY
date
,
pool_name
ORDER
BY
date
DESC
LIMIT
1000
Results
Run a query to Download Data