select min(block_id) as first_block_of_day from algorand.block

where block_timestamp::date = '2022-05-02'

), max_block as (

select max(block_id) as last_block_of_day from algorand.block

where block_timestamp::date = '2022-05-09'

select block_timestamp::date as day,

count(address) as wallets

from algorand.account

left join algorand.block on block_id = created_at

where block_id >= (select * from min_block)

and block_id <= (select * from max_block)

group by day

order by day desc