2844ALGO DISTURBUTION-SWAPPERS
    Updated 2022-07-07


    SELECT
    case
    WHEN 1<=balance and balance <=100 then 'less than 1000'
    WHEN balance > 100 and balance <=1000 then 'between 100 and 1000'
    WHEN balance > 1000 and balance <=10000 then 'between 1000 and 10000'
    WHEN balance > 10000 then 'more than 10000'
    end as holders_ALGO,
    count(1) as distribution_of_ALGO
    from flipside_prod_db.algorand.account
    inner join flipside_prod_db.algorand.swaps S on S.SWAPPER =flipside_prod_db.algorand.account.ADDRESS
    where S.block_timestamp>= '2022-05-01' and S.block_timestamp <'2022-07-01'
    and BALANCE >=1
    group by 1
    Run a query to Download Data