mrnnptrcParallel Alpha - Sales - Volume (exc Assets)
    Updated 2024-10-17
    select
    block_timestamp :: date as sale_date,
    sum(erc1155_value) as quantity,
    sum(price_usd) as amt_usd,
    min(price_usd) as min_price_usd,
    avg(price_usd) as avg_price_usd,
    sum(price_usd) / sum(erc1155_value) as avg_price_usd2,
    percentile_cont(0.5) within group (
    order by
    price_usd
    ) as median_price_usd,
    percentile_cont(0.5) within group (
    order by
    price_usd / erc1155_value
    ) as median_price_usd2
    from
    ethereum.nft.ez_nft_sales
    where
    nft_address = '0x76be3b62873462d2142405439777e971754e8e77'
    and event_type != 'redeem'
    and sale_date >= dateadd('day', - {{n_days}}, current_date)
    and sale_date < current_date
    and price_usd > 0
    and tokenid not in ('87', '10092', '10306', '10464', '10485', '10646', '10782', '10933', '11087', '11099')
    group by
    1
    order by
    1 desc
    QueryRunArchived: QueryRun has been archived