date_trunc('day',block_timestamp) as date ,

count(distinct from_address) as unique_address,

count(*) as transaction

from polygon.core.fact_transactions

where block_timestamp >= '2022-07-01'

GROUP BY 1

ORDER BY 1