flipside
GROWTH MCP
IDG PLAYBOOK
JOURNEYS
INSIGHTS
About
Log in
GET STARTED
flipside
pool rank thor 1
sarath
pool rank thor 1
Updated 2022-04-13
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