DATE | TX_NUMBER | ACTIVE_USERS | SUCCESS_RATE | CHAIN | |
|---|---|---|---|---|---|
1 | 2024-07-01 00:00:00.000 | 11568136 | 722539 | 0.943745 | aptos |
2 | 2024-07-01 00:00:00.000 | 22150933 | 2718218 | 0.945057 | base |
3 | 2024-07-01 00:00:00.000 | 16267982 | 1867234 | 0.911785 | arbitrum |
4 | 2024-07-01 00:00:00.000 | 27968664 | 3749920 | 0.918921 | polygon |
5 | 2024-07-01 00:00:00.000 | 3514375 | 456391 | 0.948448 | optimism |
6 | 2024-07-01 00:00:00.000 | 8088071 | 2119886 | 0.979357 | ethereum |
7 | 2024-07-01 00:00:00.000 | 22291544 | 3291999 | 0.943842 | bsc |
8 | 2024-07-01 00:00:00.000 | 4540357 | 313383 | 0.971149 | blast |
9 | 2024-07-01 00:00:00.000 | 1193419 | 227870 | 0.95171 | avalanche |
10 | 2024-07-08 00:00:00.000 | 11889456 | 772491 | 0.978671 | aptos |
11 | 2024-12-02 00:00:00.000 | 29073234 | 3639963 | 0.981857 | aptos |
12 | 2024-12-16 00:00:00.000 | 31923076 | 3928244 | 0.969227 | aptos |
13 | 2024-12-16 00:00:00.000 | 57179683 | 7600774 | 0.829509 | base |
14 | 2024-12-02 00:00:00.000 | 56327408 | 6077362 | 0.794974 | base |
15 | 2024-07-08 00:00:00.000 | 23071063 | 2653735 | 0.956694 | base |
16 | 2024-07-08 00:00:00.000 | 16014667 | 1697042 | 0.918666 | arbitrum |
17 | 2024-12-02 00:00:00.000 | 17364101 | 1341595 | 0.868344 | arbitrum |
18 | 2024-12-16 00:00:00.000 | 19088958 | 1470730 | 0.85374 | arbitrum |
19 | 2024-07-08 00:00:00.000 | 25679368 | 3554373 | 0.924795 | polygon |
20 | 2024-12-02 00:00:00.000 | 23108445 | 2229423 | 0.887144 | polygon |
AzinTotal stats over time
Updated 8 days ago
999
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
33
34
35
36
›
⌄
WITH t1 AS
(
( SELECT
date_trunc('week' , BLOCK_TIMESTAMP) AS Date,
COUNT(*) AS TX_number ,
COUNT(DISTINCT SENDER) AS Active_users,
COUNT(CASE WHEN SUCCESS='TRUE' THEN 1 ELSE NULL END) / COUNT(*) AS Success_rate,
'aptos' AS Chain
FROM
aptos.core.fact_transactions
GROUP BY 1)
UNION ALL
( SELECT
date_trunc('week' , BLOCK_TIMESTAMP) AS Date,
COUNT(*) AS TX_number ,
COUNT(DISTINCT FROM_ADDRESS) AS Active_users,
COUNT(CASE WHEN STATUS='SUCCESS' THEN 1 ELSE NULL END) / COUNT(*) AS Success_rate,
'base' AS Chain
FROM
base.core.fact_transactions
GROUP BY 1)
UNION ALL
(SELECT
date_trunc('week' , BLOCK_TIMESTAMP) AS Date,
COUNT(*) AS TX_number ,
COUNT(DISTINCT FROM_ADDRESS) AS Active_users,
COUNT(CASE WHEN STATUS='SUCCESS' THEN 1 ELSE NULL END) / COUNT(*) AS Success_rate,
'arbitrum' AS Chain
FROM
arbitrum.core.fact_transactions
GROUP BY 1)
Last run: 8 days ago
...
466
28KB
769s