flipside
Products
For Protocols
For Analysts
For Explorers
About
Log in
Become a Partner
flipside
sol stable prices
adriaparcerisas
sol stable prices
Updated 2023-03-22
Copy Reference
Fork
9
1
2
3
4
5
6
7
8
›
⌄
SELECT
recorded_hour
,
symbol
,
avg
(
close
)
as
price
from
solana
.
core
.
fact_token_prices_hourly
where
symbol
in
(
'USDC'
,
'USDT'
,
'USDH'
,
'UXD'
,
'PAI'
)
and
recorded_hour
>=
'2023-03-10'
group
by
1
,
2
order
by
1
asc
Results
Run a query to Download Data