date_trunc('day', block_timestamp) as date,

count(distinct from_address) as users,

count(distinct tx_hash) as transactions

from gnosis.core.fact_transactions

where block_timestamp >= current_date-30

group by date order by date asc