Date_trunc('day', block_timestamp)AS Date,

COUNT(DISTINCT TX_HASH) AS Transactions,

COUNT(DISTINCT TX_HASH)/86400 AS TPS

FROM near.core.fact_transactions

WHERE TX_SUCCEEDED = 'True'

AND block_timestamp::date >= '2024-01-01'

GROUP BY 1