2844the average ALGO holding of new wallets
    Updated 2022-06-13
    SELECT count(address) as holders ,sum(balance) as total_balance, sum(balance) /count(address) as "average ALGO holding"
    from flipside_prod_db.algorand.account
    inner join flipside_prod_db.algorand.block T on t.block_id=flipside_prod_db.algorand.account.CREATED_AT
    where T.block_timestamp>= '2022-05-01' and T.block_timestamp <'2022-06-01'
    and BALANCE >1





    Run a query to Download Data