mariyaBuyers Breakdown based on Volume
    Updated 2022-11-11
    with top_10 as ( select nft_address , sum(price_usd) as volume
    from ethereum.core.ez_nft_sales
    where price_usd is not null and block_timestamp::date >= CURRENT_DATE - 180 group by 1
    order by 2 desc limit 11)
    ,
    final as ( select buyer_address, case when project_name = 'optimistic explorer - get started nft' then 'optimistic explorer'
    else project_name end as collections, count(DISTINCT(tx_hash)) as total_sales, count(DISTINCT(buyer_address)) total_buyer,
    count(DISTINCT(seller_address)) as total_seller, sum(price_usd) as total_volume, avg(price_usd) as avg_price,
    count(DISTINCT(tokenid)) as total_nfts
    from ethereum.core.ez_nft_sales a join ethereum.core.dim_labels b on a.nft_address = b.address where nft_address in ( select nft_address from top_10)
    and block_timestamp::date >= CURRENT_DATE - 180
    group by 1,2)

    select collections , count(DISTINCT(buyer_address)) as buyers,
    case when total_volume > 0 and total_volume <= 1 then 'Up to 1$'
    when total_volume > 1 and total_volume <= 10 then '1-10$' when total_volume > 10 and total_volume <= 100 then '10-100$'
    when total_volume > 100 and total_volume <= 1000 then '100-1000$' when total_volume > 1000 then '+1000$'
    end as type from final
    where collections is not null
    group by 1,3
    Run a query to Download Data