Nige7777Price of DeadHeads
    Updated 2022-11-28




    select distinct
    avg(price_usd) over (partition by date_trunc('day',block_timestamp ) order by date_trunc('day',block_timestamp )) as AVG_PRICE,
    min(price_usd) over (partition by date_trunc('day',block_timestamp ) order by date_trunc('day',block_timestamp )) as MIN_PRICE,
    MAX(price_usd) over (partition by date_trunc('day',block_timestamp ) order by date_trunc('day',block_timestamp )) as MAX_PRICE,
    COUNT( price_usd) over (partition by date_trunc('day',block_timestamp ) order by date_trunc('day',block_timestamp )) as Sale_count,
    date_trunc('day',block_timestamp ) day
    from ethereum.nft_events
    where contract_address = lower('0x6fc355d4e0ee44b292e50878f49798ff755a5bbc')
    and event_type = 'sale'
    and date_trunc('day',block_timestamp ) > '2021-06-25T09:55:55Z'
    order by day--price_usd desc
    Run a query to Download Data