MLDZMNLAL.5
    Updated 2023-05-26
    with tb3 as (select
    dayname(to_date(block_timestamp::date)) as week_day,
    sum(price) as volume,
    count(*) as sales_count

    from flow.core.ez_nft_sales s left join flow.core.dim_contract_labels b on s.NFT_COLLECTION=b.EVENT_CONTRACT
    where TX_SUCCEEDED='TRUE' and CURRENCY='A.ead892083b3e2c6c.DapperUtilityCoin'
    and CONTRACT_NAME = 'Golazos'
    group by 1)


    select avg(volume) as avg_volume, avg(sales_count), week_day,
    case when week_day in ('Sat', 'Sun') then 'WeekEnds'
    else 'WeekDays' END as date_type
    from tb3
    group by week_day
    Run a query to Download Data