Date | User Type | Number of Users | |
---|---|---|---|
1 | 2024-11-05 00:00:00.000 | New Users | 13 |
2 | 2025-05-04 00:00:00.000 | Daily Users | 114 |
3 | 2024-08-06 00:00:00.000 | Daily Users | 121 |
4 | 2024-10-20 00:00:00.000 | Daily Users | 87 |
5 | 2025-01-10 00:00:00.000 | Daily Users | 141 |
6 | 2025-03-11 00:00:00.000 | Daily Users | 118 |
7 | 2024-06-23 00:00:00.000 | Daily Users | 34 |
8 | 2024-08-12 00:00:00.000 | Daily Users | 91 |
9 | 2024-11-17 00:00:00.000 | Daily Users | 133 |
10 | 2025-06-11 00:00:00.000 | Daily Users | 119 |
11 | 2024-12-05 00:00:00.000 | Daily Users | 142 |
12 | 2025-04-03 00:00:00.000 | Daily Users | 86 |
13 | 2025-01-12 00:00:00.000 | Daily Users | 101 |
14 | 2024-09-11 00:00:00.000 | Daily Users | 136 |
15 | 2024-09-17 00:00:00.000 | New Users | 54 |
16 | 2025-03-18 00:00:00.000 | Daily Users | 117 |
17 | 2024-11-09 00:00:00.000 | Daily Users | 122 |
18 | 2025-05-11 00:00:00.000 | Daily Users | 106 |
19 | 2025-06-02 00:00:00.000 | Daily Users | 146 |
20 | 2024-09-03 00:00:00.000 | New Users | 105 |
Zanyar_98Daily Users and New Users
Updated 4 hours agoCopy Reference Fork
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
›
⌄
------------------------------------------------------------------------------ Core Market ------------------------------------------------------------------------------
--------------------------------------- Initialized Pools ---------------------------------------
WITH COLEND_CORE_MARKETS_INITIALIZED_POOL_ON_COLEND AS (
SELECT
CONTRACT_ADDRESS AS POOL_ADDRESS,
(DECODED_LOG:underlyingAsset)::STRING AS ASSET_ADDRESS
FROM
core.core.ez_decoded_event_logs
WHERE
TOPIC_0 = '0xb19e051f8af41150ccccb3fc2c2d8d15f4a4cf434f32a559ba75fe73d6eea20b'
AND EVENT_NAME = 'Initialized'
AND DECODED_LOG:pool = '0x0cea9f0f49f30d376390e480ba32f903b43b19c5'
AND DECODED_LOG:underlyingAsset != '0x0000000000000000000000000000000000000000'
AND TX_SUCCEEDED = TRUE
),
COLEND_CORE_MARKETS_INITIALIZED_DEPT_POOL_ON_COLEND AS (
SELECT
CONTRACT_ADDRESS AS POOL_ADDRESS,
(DECODED_LOG:underlyingAsset)::STRING AS ASSET_ADDRESS
FROM
core.core.ez_decoded_event_logs
WHERE
EVENT_NAME = 'Initialized'
AND DECODED_LOG:pool = '0x0cea9f0f49f30d376390e480ba32f903b43b19c5'
AND DECODED_LOG:underlyingAsset != '0x0000000000000000000000000000000000000000'
AND TX_SUCCEEDED = TRUE
AND CONTRACT_NAME ILIKE '%Debt%'
),
--------------------------------------- Deposit ---------------------------------------
COLEND_CORE_MARKETS_DEPOSIT_ASSETS AS (
SELECT
Last run: about 4 hours agoAuto-refreshes every 24 hours
887
38KB
94s