No Data to Display
Zanyar_98Daily New Users Changes
Updated 2025-03-26
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: 3 months ago
0
2B
143s