date_trunc('day', block_timestamp) as date,

count(distinct tx_hash) as transactions,

count(distinct from_address) as total_users

from polygon.core.fact_transactions

where date >= '2022-07-01'

and status = 'SUCCESS'

group by 1