DATE | TX_NUMBER | ACTIVE_USERS | SUCCESS_RATE | CHAIN | |
|---|---|---|---|---|---|
1 | 2024-07-22 00:00:00.000 | 14580588 | 1004885 | 0.980107 | aptos |
2 | 2024-07-22 00:00:00.000 | 27838077 | 3310900 | 0.945448 | base |
3 | 2024-07-22 00:00:00.000 | 14436736 | 1538208 | 0.904663 | arbitrum |
4 | 2024-07-22 00:00:00.000 | 24106201 | 3461069 | 0.919239 | polygon |
5 | 2024-07-22 00:00:00.000 | 3461237 | 416918 | 0.95079 | optimism |
6 | 2024-07-22 00:00:00.000 | 7819332 | 1893197 | 0.975589 | ethereum |
7 | 2024-07-22 00:00:00.000 | 23191130 | 3221494 | 0.946868 | bsc |
8 | 2024-07-22 00:00:00.000 | 5077899 | 151987 | 0.984663 | blast |
9 | 2024-07-22 00:00:00.000 | 1138715 | 160484 | 0.955186 | avalanche |
10 | 2024-09-30 00:00:00.000 | 27357067 | 2015498 | 0.980058 | aptos |
11 | 2024-09-30 00:00:00.000 | 35224368 | 6512970 | 0.93895 | base |
12 | 2024-09-30 00:00:00.000 | 14324908 | 1115544 | 0.889572 | arbitrum |
13 | 2024-09-30 00:00:00.000 | 18640821 | 1804788 | 0.899785 | polygon |
14 | 2024-09-30 00:00:00.000 | 5654027 | 332673 | 0.955936 | optimism |
15 | 2024-09-30 00:00:00.000 | 8088581 | 1769696 | 0.980365 | ethereum |
16 | 2024-09-30 00:00:00.000 | 24316294 | 3731895 | 0.960101 | bsc |
17 | 2024-09-30 00:00:00.000 | 4025854 | 73066 | 0.991128 | blast |
18 | 2024-09-30 00:00:00.000 | 1113511 | 116139 | 0.944887 | avalanche |
19 | 2024-11-25 00:00:00.000 | 32339658 | 3934567 | 0.967478 | aptos |
20 | 2024-11-25 00:00:00.000 | 59543842 | 4604225 | 0.645363 | base |
AzinTotal stats over time
Updated 13 hours 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: about 13 hours ago
...
467
28KB
817s