flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
average price of RUNE and others assets on each pool
elsina
average price of RUNE and others assets on each pool
Updated 2022-04-23
Copy Reference
Fork
9
1
2
3
4
›
⌄
select
pool_name
as
name
,
avg
(
asset_amount_usd
/
asset_amount
)
as
asset_price
,
avg
(
rune_amount_usd
/
rune_amount
)
as
rune_price
from
thorchain
.
pool_block_balances
where
asset_amount
!=
0
and
rune_amount
!=
0
group
by
1
Results
Run a query to Download Data