MLDZMNNFT 3
Updated 2024-04-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
-- What is the daily median sale price of NFTs on OpenSea marketplace in 2024?
select
date_trunc('day', Block_timestamp) as day,
round(avg(price_usd), 3) as "Avg price USD",
round(Median(price_usd), 3) as "Median price USD"
from
ethereum.nft.ez_nft_sales
where
PLATFORM_NAME = 'opensea'
and Block_timestamp >= '2024-01-01'
group by
day
order by
day desc
QueryRunArchived: QueryRun has been archived