TheLaughingManhourly - txns/users no labels
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
21
22
›
⌄
-- forked from hourly - txns/users copy @ https://flipsidecrypto.xyz/studio/queries/56761435-c1cc-4d18-9ed8-3c235036c159
-- forked from hourly - txns/users @ 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
, txns/(60*60) as tps
from monad.testnet.fact_transactions
WHERE 1=1
AND block_timestamp>='2025-02-19'
GROUP by 1
)
SELECT * from base
ORDER by 1 ASC
QueryRunArchived: QueryRun has been archived