TOTAL_USER | TOTAL_PROGRAM | TOTAL_TRANSACTION | TOTAL_TRANSITION | |
|---|---|---|---|---|
1 | 2595602 | 135 | 17908500 | 25399908 |
commanderjoseph-761gwXALEO Total
Updated 4 days ago
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
25
›
⌄
WITH
total
AS
(
SELECT
block_timestamp,
transition_id,
program_id,
tx_id,
value:value::string AS address
FROM
aleo.core.fact_transitions,
LATERAL FLATTEN(input => inputs)
WHERE
address LIKE 'aleo%'
AND
succeeded = 'TRUE'
)
SELECT
COUNT(DISTINCT address) AS total_user,
COUNT(DISTINCT program_id) AS total_program,
COUNT(DISTINCT tx_id) AS total_transaction,
COUNT(DISTINCT transition_id) AS total_transition
FROM
total
Last run: 4 days ago
1
33B
19s