block_timestamp::date as days,

count(*) as number_of_transactions

from algorand.transactions

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

and block_timestamp::date < '2022-05-08'

group by days

order by days