DATE(timestamp) as tx_date,

COUNT(tx_hash)

FROM external.tokenflow_starknet.decoded_transactions

WHERE chain_id = 'mainnet'

GROUP BY 1

ORDER BY 1