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