block_timestamp::date as day,

STATUS,

count(distinct tx_hash)

from gnosis.core.fact_transactions

WHERE tx_hash is not null

and block_timestamp>=CURRENT_DATE-30

group by 1,2