flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Average Price for July 22, 2024
gigiokoba
Average Price for July 22, 2024
Updated 2024-08-04
Copy Reference
Fork
9
1
2
3
4
5
6
7
8
›
⌄
SELECT
DATE_TRUNC
(
'day'
,
hour
)
AS
recorded_day
,
AVG
(
price
)
AS
avg_Boden_Price
FROM
solana
.
price
.
ez_prices_hourly
WHERE
TOKEN_ADDRESS
=
'3psH1Mj1f7yUfaD5gh6Zj7epE8hhrMkMETgv5TshQA4o'
AND
DATE
(
hour
)
=
'2024-07-22'
GROUP
BY
recorded_day
;
Results
QueryRunArchived: QueryRun has been archived