from algorand.account AS Acc,

algorand.block AS BLO

where BLO.block_id = Acc.created_at

and CAST(block_timestamp as DATE) BETWEEN '2022-01-01' and '2022-01-31'

and balance >= 1000000

ORDER by balance DESC