kasadeghThe average ALGO holding
    Updated 2022-06-16
    with new_wallet_in_may as (
    select count(distinct a.ADDRESS) as "number_of_new_wallet_in_may" from flipside_prod_db.algorand.account as a
    join flipside_prod_db.algorand.block as b
    on b.BLOCK_ID=a.CREATED_AT
    where date(b.BLOCK_TIMESTAMP)>='2022-05-01' and date(b.BLOCK_TIMESTAMP)<='2022-05-30' and a.ACCOUNT_CLOSED=0
    ),
    new_wallet_in_may_with_more_than_1 as (
    select a.ADDRESS,a.BALANCE from flipside_prod_db.algorand.account as a
    join flipside_prod_db.algorand.block as b
    on b.BLOCK_ID=a.CREATED_AT
    where date(b.BLOCK_TIMESTAMP)>='2022-05-01' and date(b.BLOCK_TIMESTAMP)<='2022-05-30' and a.ACCOUNT_CLOSED=0 and a.BALANCE>1
    order by a.BALANCE desc
    )

    select avg(BALANCE) as "The average ALGO holding" from new_wallet_in_may_with_more_than_1


    Run a query to Download Data