oxkimiaGetting Started
Updated 2025-03-04
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select
BLOCK_TIMESTAMP :: date as date,
count(tx_hash) as tx_count,
count (distinct from_address) as active_user,
sum(tx_count) over(order by date asc) as Total_tx_count
from
monad.testnet.fact_transactions
where
BLOCK_TIMESTAMP :: date >= '2025-02-19'
group by
BLOCK_TIMESTAMP :: date
QueryRunArchived: QueryRun has been archived