eslamis-darkatNFT solana vs eth 2
    Updated 2022-09-24
    with eth_sales_volume as (select buyer_address, sum(price_usd) as sales_volume
    from ethereum.core.ez_nft_sales
    where block_timestamp::date >= '2022-01-01'
    group by 1)
    select case
    when sales_volume > 0 and sales_volume < 10 then '1. Shrimp 0-10' -- Not account for withdrawals
    when sales_volume >= 10 and sales_volume < 100 then '2. Crab 10-100'
    when sales_volume >= 100 and sales_volume < 500 then '3. Octopus 100-500'
    when sales_volume >= 500 and sales_volume < 1000 then '4. Fish 500-1k'
    when sales_volume >= 1000 and sales_volume < 10000 then '5. Dolphin 1k-10k'
    when sales_volume >= 10000 and sales_volume < 100000 then '6. Shark 10k-100k'
    when sales_volume >= 100000 then '7. Whale >100k' else null end as tier,
    count(distinct buyer_address) as number_of_buyers
    from eth_sales_volume
    where tier is not null
    group by 1
    Run a query to Download Data