WITH txn_daily AS (
SELECT
DATE_TRUNC('day', block_timestamp) AS day,
COUNT(tx_hash) AS daily_transactions
FROM MONAD.testnet.fact_transactions
WHERE from_address = '{{YOUR_WALLET_ADDRESS}}'
AND block_timestamp >= '2025-02-19 15:00:00.000'
GROUP BY 1
ORDER BY 1 DESC
),
txn_total AS (
SELECT
COUNT(tx_hash) AS total_transactions
FROM MONAD.testnet.fact_transactions
WHERE from_address = '{{YOUR_WALLET_ADDRESS}}'
)
SELECT
(SELECT total_transactions FROM txn_total) AS total_txns,
txn_daily.day,
txn_daily.daily_transactions
FROM txn_daily