Elprognerd0 - all time
Updated 2023-06-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
with txs AS (
SELECT
x.BLOCK_TIMESTAMP as BLOCK_TIMESTAMP,
x.TX_ID as tx,
x.PROPOSER as user,
y.EVENT_TYPE as type,
y.EVENT_CONTRACT
FROM flow.core.fact_transactions x JOIN flow.core.fact_events y ON x.TX_ID = y.TX_ID
WHERE x.TX_SUCCEEDED = 'true'
)
SELECT
count( DISTINCT tx) as "Number of total txns",
count(DISTINCT user) as "Number of total users"
from txs
Run a query to Download Data