afonsosolana nft sales
    Updated 2023-04-13
    select
    block_timestamp::date as day,
    iff(year(day) = 2022, 'Before Christmas', 'After Christmas') as timespan,
    count(distinct tx_id) as sales_count,
    count(distinct purchaser) as purchasers_count,
    sum(sales_amount) as total_sales_volume,
    avg(sales_amount) as average_sales_amount,
    median(sales_amount) as median_sales_amount,
    sum(purchasers_count) over (order by day asc) as cumulative_purchasers_count,
    sum(sales_count) over (order by day asc) as cumulative_sales_count,
    sum(total_sales_volume) over (order by day asc) as cumulative_sales_volume
    from solana.core.fact_nft_sales
    left outer join solana.core.dim_nft_metadata
    on solana.core.fact_nft_sales.mint = solana.core.dim_nft_metadata.mint
    where day between date('2023-01-01') - interval '2 weeks' and date('2023-01-01') + interval '2 weeks'
    group by day, timespan
    order by day
    Run a query to Download Data