FIRST_BLOCK_DATE | LAST_BLOCK_DATE | TOTAL_TRANSACTIONS | TOTAL_BLOCKS | AVG_TRANSACTIONS_PER_BLOCK | TOTAL_LABELED_ADDRESSES | TOTAL_USER_ADDRESSES | TOTAL_CONTRACT_ADDRESSES | TOTAL_PROJECTS | AVG_DAILY_TRANSACTIONS | USER_ADDRESS_PERCENTAGE | TRANSACTIONS_PER_ADDRESS | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 2024-09-04 15:00:00.000 | 2025-03-08 00:35:33.000 | 14154988 | 5366627 | 2.64 | 25 | 0 | 0 | 13 | 76513.45 | 0.00% | 566199.52 |
K41R0NAleo Users
Updated 2025-01-09
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
26
27
28
29
30
31
32
›
⌄
WITH all_time_transactions AS (
SELECT
MIN(block_timestamp) AS first_block_date,
MAX(block_timestamp) AS last_block_date,
SUM(tx_count) AS total_transactions,
COUNT(DISTINCT block_id) AS total_blocks,
AVG(tx_count) AS avg_transactions_per_block
FROM aleo.core.fact_blocks
),
labeled_addresses AS (
SELECT
COUNT(DISTINCT address) AS total_labeled_addresses,
COUNT(DISTINCT CASE WHEN label_type = 'user' THEN address END) AS total_user_addresses,
COUNT(DISTINCT CASE WHEN label_type = 'contract' THEN address END) AS total_contract_addresses,
COUNT(DISTINCT project_name) AS total_projects
FROM aleo.core.dim_labels
)
SELECT
att.first_block_date,
att.last_block_date,
att.total_transactions,
att.total_blocks,
ROUND(att.avg_transactions_per_block, 2) AS avg_transactions_per_block,
la.total_labeled_addresses,
la.total_user_addresses,
la.total_contract_addresses,
la.total_projects,
ROUND(att.total_transactions / NULLIF(DATEDIFF(day, att.first_block_date, att.last_block_date), 0), 2) AS avg_daily_transactions,
ROUND(la.total_user_addresses * 100.0 / NULLIF(la.total_labeled_addresses, 0), 2) || '%' AS user_address_percentage,
ROUND(att.total_transactions * 1.0 / NULLIF(la.total_labeled_addresses, 0), 2) AS transactions_per_address
FROM all_time_transactions att
CROSS JOIN labeled_addresses la;
Last run: about 1 month ago
1
114B
1s