SELECT
date_trunc('day', block_timestamp) as date,
COUNT(DISTINCT tx_hash) as number_of_transaction,
COUNT(DISTINCT from_address) as numbr_of_wallet,
sum(tx_fee) as total_fee
FROM polygon.core.fact_transactions
WHERE BLOCK_TIMESTAMP>= '2022-07-01'
GROUP by 1
order by 1