No Data to Display
monadmetrics-JFe1_Rreluctant-olive
Updated 2025-02-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
›
⌄
WITH txn_daily AS (
SELECT
DATE_TRUNC('day', block_timestamp) AS day,
COUNT(DISTINCT tx_hash) AS daily_transactions
FROM monad.testnet.fact_transactions
WHERE from_address = '{{YOUR_WALLET_ADDRESS}}'
AND block_timestamp >= DATEADD(day, -30, CURRENT_TIMESTAMP()) -- Last 30 days filter
GROUP BY 1
ORDER BY 1 DESC
),
txn_total AS (
SELECT
COUNT(DISTINCT tx_hash) AS total_transactions
FROM monad.testnet.fact_transactions
WHERE from_address = '{{YOUR_WALLET_ADDRESS}}'
AND block_timestamp >= DATEADD(day, -30, CURRENT_TIMESTAMP()) -- Last 30 days filter
)
SELECT
t.total_transactions AS total_txns,
d.day,
d.daily_transactions
FROM txn_daily d
CROSS JOIN txn_total t
ORDER BY d.day DESC;
Last run: about 2 months ago
0
2B
2s