date_trunc('day', block_timestamp) AS date,

count(tx_id) as total_transactions

from polygon.transactions

WHERE block_timestamp >= '2021-6-01'

group by 1

order by 1