mrnnptrcParallel Avatars - Sales - Volume
    Updated 2024-10-17
    select
    block_timestamp :: date as sale_date,
    count(*) as quantity,
    sum(price_usd) as amt_usd,
    min(price_usd) as min_price_usd,
    avg(price_usd) as avg_price_usd,
    percentile_cont(0.5) within group (
    order by
    price_usd
    ) as median_price_usd
    from
    ethereum.nft.ez_nft_sales
    where
    nft_address = '0x0fc3dd8c37880a297166bed57759974a157f0e74'
    and sale_date >= dateadd('day', - {{n_days}}, current_date)
    and sale_date < current_date
    and price_usd > 0
    group by
    1
    order by
    1 desc

    QueryRunArchived: QueryRun has been archived