DrsimonNUMBER OF DEGODS BUYERS AND SELLERS-DAILY
Updated 2022-09-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with degods as
( SELECT *
from solana.core.dim_labels
where ADDRESS_NAME ilike 'DeGods'
)
SELECT
date(BLOCK_TIMESTAMP) as date,
COUNT(DISTINCT PURCHASER) as buyers,
case when buyers <= 10 then 'buyers <= 10'
when buyers <= 100 then 'buyers <= 100'
when buyers <= 1000 then 'buyers <= 1k'
else 'buyers > 1k' end as t_buyers,
sum(buyers) over (order by date) as cum_buyers,
case when cum_buyers <= 1000 then 'cum buyers <= 1000'
when cum_buyers <= 4000 then 'cum buyers <= 4000'
when cum_buyers <= 10000 then 'cum buyers <= 10k'
else 'cum_buyers > 10k' end as t_cum_buyers,
COUNT(DISTINCT SELLER) as sellers,
case when sellers <= 10 then 'sellers <= 10'
when sellers <= 100 then 'sellers <= 100'
when sellers <= 1000 then 'sellers <= 1k'
else 'sellers > 1k' end as t_sellers,
sum(sellers) over (order by date) as cum_sellers,
case when cum_sellers <= 4000 then 'cum_sellers <= 4000'
when cum_sellers <= 4000 then 'cum_sellers <= 4000'
when cum_sellers <= 10000 then 'cum_sellers <= 10k'
else 'cum_sellers > 10k' end as t_cum_sellers,
sum(SALES_AMOUNT) as TOTAL_SALES_AMOUNT,
case when TOTAL_SALES_AMOUNT <= 1000 then 'TOTAL_SALES_AMOUNT <= 1000'
when TOTAL_SALES_AMOUNT <= 10000 then 'TOTAL_SALES_AMOUNT <= 10000'
when TOTAL_SALES_AMOUNT <= 100000 then 'TOTAL_SALES_AMOUNT <= 100k'
else 'SALES_AMOUNT > 100k' end as t_SALES_AMOUNT,
sum(TOTAL_SALES_AMOUNT) over (order by date) as CUM_SALES_AMOUNT,
case when CUM_SALES_AMOUNT <= 1000 then 'CUM_SALES_AMOUNT <= 1000'
when CUM_SALES_AMOUNT <= 10000 then 'CUM_SALES_AMOUNT <= 10000'
when CUM_SALES_AMOUNT <= 100000 then 'CUM_SALES_AMOUNT <= 100k'
Run a query to Download Data