SELECT BLSELECT
DATE(BLOCK_TIMESTAMP_HOUR) AS transaction_date,
SUM(TRANSACTION_COUNT) AS total_transactions
FROM
solana.stats.ez_core_metrics_hourly;
WHERE
BLOCK_TIMESTAMP_HOUR >= DATEADD(day, -30, CURRENT_TIMESTAMP())
GROUP BY
transaction_date
ORDER BY
transaction_date;