MLDZMNNFT 3
    Updated 2024-04-19
    -- 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