eslamis-darkatNFT solana vs eth 2
Updated 2022-09-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
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