TYPE | TX_NUMBER | ACTIVE_USERS | TX_CHANGE | ACTIVE_USERS_CHANGE | |
|---|---|---|---|---|---|
1 | 1 Days | 286424 | 1532 | 97.790008 | 97.208122 |
2 | 7 Days | 2232488 | 4336 | 97.270317 | 89.64234 |
3 | 30 Days | 9317326 | 9746 | 88.841025 | 90.999066 |
4 | 90 Days | 31967166 | 19559 | 88.961281 | 66.690535 |
IBC_insiderChangees
Updated 5 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
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH T1 AS
(SELECT
COUNT(CASE WHEN BLOCK_TIMESTAMP > CURRENT_DATE - 1 THEN 1 ELSE NULL END) AS TX_1D,
COUNT(DISTINCT (CASE WHEN BLOCK_TIMESTAMP > CURRENT_DATE - 1 THEN TX_FROM ELSE NULL END)) AS Active_users_1D,
COUNT(CASE WHEN BLOCK_TIMESTAMP > CURRENT_DATE - 7 THEN 1 ELSE NULL END) AS TX_7D,
COUNT(DISTINCT (CASE WHEN BLOCK_TIMESTAMP > CURRENT_DATE - 7 THEN TX_FROM ELSE NULL END)) AS Active_users_7D,
COUNT(CASE WHEN BLOCK_TIMESTAMP > CURRENT_DATE - 30 THEN 1 ELSE NULL END) AS TX_30D,
COUNT(DISTINCT (CASE WHEN BLOCK_TIMESTAMP > CURRENT_DATE - 30 THEN TX_FROM ELSE NULL END)) AS Active_users_30D,
COUNT(CASE WHEN BLOCK_TIMESTAMP > CURRENT_DATE - 90 THEN 1 ELSE NULL END) AS TX_90D,
COUNT(DISTINCT (CASE WHEN BLOCK_TIMESTAMP > CURRENT_DATE - 90 THEN TX_FROM ELSE NULL END)) AS Active_users_90D,
COUNT(CASE WHEN BLOCK_TIMESTAMP BETWEEN CURRENT_DATE - 2 AND CURRENT_DATE - 1 THEN 1 ELSE NULL END) AS TX_1D2,
COUNT(DISTINCT (CASE WHEN BLOCK_TIMESTAMP BETWEEN CURRENT_DATE - 2 AND CURRENT_DATE - 1 THEN TX_FROM ELSE NULL END)) AS Active_users_1D2,
COUNT(CASE WHEN BLOCK_TIMESTAMP BETWEEN CURRENT_DATE - 14 AND CURRENT_DATE - 7 THEN 1 ELSE NULL END) AS TX_7D14,
COUNT(DISTINCT (CASE WHEN BLOCK_TIMESTAMP BETWEEN CURRENT_DATE - 14 AND CURRENT_DATE - 7 THEN TX_FROM ELSE NULL END)) AS Active_users_7D14,
COUNT(CASE WHEN BLOCK_TIMESTAMP BETWEEN CURRENT_DATE - 60 AND CURRENT_DATE - 30 THEN 1 ELSE NULL END) AS TX_30D60,
COUNT(DISTINCT (CASE WHEN BLOCK_TIMESTAMP BETWEEN CURRENT_DATE - 60 AND CURRENT_DATE - 30 THEN TX_FROM ELSE NULL END)) AS Active_users_30D60,
COUNT(CASE WHEN BLOCK_TIMESTAMP BETWEEN CURRENT_DATE - 180 AND CURRENT_DATE - 90 THEN 1 ELSE NULL END) AS TX_90D180,
COUNT(DISTINCT (CASE WHEN BLOCK_TIMESTAMP BETWEEN CURRENT_DATE - 180 AND CURRENT_DATE - 90 THEN TX_FROM ELSE NULL END)) AS Active_users_90D180
FROM
axelar.core.fact_transactions)
(SELECT
'1 Days' AS Type
, TX_1D AS TX_number
, Active_users_1D AS Active_users
, TX_1D * 100 / TX_1D2 AS TX_change
, Active_users_1D * 100 / Active_users_1D2 AS Active_users_change
FROM
Last run: 5 days ago
4
185B
22s