BLOCK_TIMESTAMP::date as date,

STATUS,

count(STATUS) as transactions_num

from gnosis.core.fact_transactions

where BLOCK_TIMESTAMP::date>='2022-06-01' and BLOCK_TIMESTAMP::date<='2022-07-31'

group by 1,2

order by 1 asc