TX_NUMBER | ACTIVE_USERS | SUCCESS_RATE | DATE | Total_tx_number | |
|---|---|---|---|---|---|
1 | 189966 | 63071 | 0.9917353632 | 2025-03-31 00:00:00.000 | 79809560 |
2 | 243078 | 83565 | 0.9912003554 | 2025-03-24 00:00:00.000 | 79619594 |
3 | 221153 | 82914 | 0.9856569886 | 2025-03-17 00:00:00.000 | 79376516 |
4 | 209879 | 67823 | 0.9828901415 | 2025-03-10 00:00:00.000 | 79155363 |
5 | 241096 | 78883 | 0.9919160832 | 2025-03-03 00:00:00.000 | 78945484 |
6 | 267867 | 106776 | 0.9923282823 | 2025-02-24 00:00:00.000 | 78704388 |
7 | 211214 | 71802 | 0.9916293428 | 2025-02-17 00:00:00.000 | 78436521 |
8 | 206210 | 70045 | 0.9857038941 | 2025-02-10 00:00:00.000 | 78225307 |
9 | 243491 | 75155 | 0.9942461939 | 2025-02-03 00:00:00.000 | 78019097 |
10 | 238304 | 73015 | 0.9782756479 | 2025-01-27 00:00:00.000 | 77775606 |
11 | 279304 | 92055 | 0.9940136912 | 2025-01-20 00:00:00.000 | 77537302 |
12 | 326427 | 102711 | 0.9916275308 | 2025-01-13 00:00:00.000 | 77257998 |
13 | 269754 | 85016 | 0.9920853815 | 2025-01-06 00:00:00.000 | 76931571 |
14 | 249557 | 89866 | 0.992033884 | 2024-12-30 00:00:00.000 | 76661817 |
15 | 241971 | 84337 | 0.9894202198 | 2024-12-23 00:00:00.000 | 76412260 |
16 | 384558 | 127512 | 0.9877183676 | 2024-12-16 00:00:00.000 | 76170289 |
17 | 322153 | 110165 | 0.9871613798 | 2024-12-09 00:00:00.000 | 75785731 |
18 | 527665 | 183370 | 0.9912842428 | 2024-12-02 00:00:00.000 | 75463578 |
19 | 488435 | 158205 | 0.988176523 | 2024-11-25 00:00:00.000 | 74935913 |
20 | 654744 | 189105 | 0.9323185856 | 2024-11-18 00:00:00.000 | 74447478 |
IBC_insiderCosmos stats over time
Updated 5 days ago
99
1
2
3
4
5
6
7
8
9
10
›
⌄
SELECT
COUNT(*) AS TX_number,
COUNT(DISTINCT TX_FROM) AS Active_users ,
CAST(COUNT(CASE WHEN TX_SUCCEEDED = 1 THEN 1 ELSE NULL END) AS DOUBLE) /CAST(COUNT(*) AS DOUBLE) AS Success_rate ,
DATE_TRUNC('WEEK', BLOCK_TIMESTAMP) AS Date,
SUM(TX_number) OVER (ORDER BY DATE) AS "Total_tx_number"
FROM
cosmos.core.fact_transactions
GROUP BY DATE
ORDER BY DATE DESC
Last run: 5 days ago
...
280
16KB
22s