TheLaughingManoverview
Updated 2025-02-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
-- forked from hourly @ https://flipsidecrypto.xyz/studio/queries/6c739909-37ff-40b3-8d8f-62fd9e460f46
with base as (
SELECT
--date_trunc('hour', block_timestamp) as dhour
COUNT(DISTINCT from_address) as users
, COUNT(DISTINCT tx_hash) as txns
, MAX(b.blocks) as blocks
from monad.testnet.fact_transactions t
LEFT JOIN (
SELECT
COUNT(1) as blocks
from monad.testnet.fact_blocks
) b on 1=1
WHERE 1=1
)
SELECT * from base
QueryRunArchived: QueryRun has been archived