KaskoazulALGO addresses distribution
    Updated 2022-02-17
    WITH New_wallets AS (
    SELECT
    address,
    balance
    FROM
    algorand.account
    WHERE
    created_at>= 18363444 AND created_at<=18974008 -- 18363444 January first block 18974008 January last block
    )

    SELECT -- Distribution of ALGO held by new wallets
    CASE WHEN balance > 0 AND balance <= 1 THEN 'a. Shrimp 0-1'
    WHEN balance > 1 AND balance <= 10 THEN 'b. Crab 1-10'
    WHEN balance > 10 AND balance <= 100 THEN 'c. Octopus 10-100'
    WHEN balance > 100 AND balance <= 1000 THEN 'd. Fish 100-1k'
    WHEN balance > 1000 AND balance <= 10000 THEN 'e. Dolphin 1k-10k'
    WHEN balance > 10000 AND balance <= 100000 THEN 'f. Shark 10k-100k'
    WHEN balance > 100000 AND balance <= 1000000 THEN 'g. Whale 100k-1M'
    WHEN balance > 1000000 AND balance <= 400000000 THEN 'h. Humpback >1M'
    WHEN balance > 400000000 THEN 'i. Moby Dick > 400M'
    ELSE NULL END AS Tier,
    count(distinct address) as Number_of_addresses,
    sum(balance) as Total_ALGO
    FROM New_wallets
    WHERE balance > 0
    GROUP BY 1
    ORDER BY 1
    Run a query to Download Data