flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Untitled Query
boomer77
Untitled Query
Updated 2021-07-28
Copy Reference
Fork
9
1
2
3
4
›
⌄
select
avg
(
token0_balance_adjusted
)
/
avg
(
token0_balance_usd
)
as
ust_uni
,
date_trunc
(
'day'
,
block_timestamp
)
as
days
from
uniswapv3
.
pool_stats
where
token0_symbol
=
'UST'
and
token1_symbol
=
'USDT'
group
by
2
Results
Run a query to Download Data