Date | User Type | Number of Users | |
|---|---|---|---|
1 | 2024-09-05 00:00:00.000 | Daily Users | 44 |
2 | 2024-08-29 00:00:00.000 | Daily Users | 391 |
3 | 2024-08-08 00:00:00.000 | New Users | 31 |
4 | 2024-10-07 00:00:00.000 | Daily Users | 82 |
5 | 2024-08-05 00:00:00.000 | Daily Users | 166 |
6 | 2024-11-25 00:00:00.000 | New Users | 41 |
7 | 2025-02-26 00:00:00.000 | Daily Users | 116 |
8 | 2024-08-18 00:00:00.000 | Daily Users | 83 |
9 | 2025-02-11 00:00:00.000 | New Users | 37 |
10 | 2024-05-08 00:00:00.000 | New Users | 8 |
11 | 2024-04-24 00:00:00.000 | Daily Users | 15 |
12 | 2024-07-21 00:00:00.000 | New Users | 8 |
13 | 2024-05-19 00:00:00.000 | New Users | 9 |
14 | 2024-09-14 00:00:00.000 | Daily Users | 171 |
15 | 2024-09-29 00:00:00.000 | New Users | 14 |
16 | 2024-12-20 00:00:00.000 | New Users | 87 |
17 | 2024-07-22 00:00:00.000 | Daily Users | 34 |
18 | 2025-02-02 00:00:00.000 | New Users | 8 |
19 | 2024-06-03 00:00:00.000 | Daily Users | 24 |
20 | 2024-05-01 00:00:00.000 | Daily Users | 9 |
Yousefi_1994Daily Users and New Users
Updated 2024-11-17
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 11 hours ago
...
711
31KB
16s