DrsimonNUMBER OF DEGODS BUYERS AND SELLERS-DAILY
    Updated 2022-09-08
    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