flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
NFT Average ETH Price By Month
cryptocat
NFT Average ETH Price By Month
Updated 2022-12-01
Copy Reference
Fork
9
1
2
3
4
5
›
⌄
SELECT
DATE_TRUNC
(
'month'
,
block_timestamp
::
DATE
)
AS
Month
,
SUM
(
price
)
/
COUNT
(
*
)
FROM
ethereum
.
core
.
ez_nft_sales
WHERE
(
block_timestamp
::
date
>
'2021-06-30'
)
AND
(
currency_symbol
LIKE
'ETH'
OR
currency_symbol
LIKE
'WETH'
)
GROUP
BY
Month
Results
Run a query to Download Data