yasminour network 7 new borower new deposssitor
Updated 2025-01-13
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
NewBorrowers AS (
SELECT
DATE_TRUNC('week', block_timestamp) AS week,
COUNT(DISTINCT borrower) AS new_borrowers
FROM
avalanche.defi.ez_lending_borrows
WHERE
platform = 'Benqi'
AND block_timestamp >= DATE_TRUNC('month', CURRENT_DATE) - INTERVAL '12 months'
AND borrower IN (
SELECT borrower FROM (
SELECT borrower, MIN(block_timestamp) AS first_borrow
FROM avalanche.defi.ez_lending_borrows
WHERE platform = 'Benqi'
GROUP BY borrower
) subquery
WHERE DATE_TRUNC('month', first_borrow) >= DATE_TRUNC('month', CURRENT_DATE) - INTERVAL '12 months'
)
GROUP BY 1
),
NewDepositors AS (
SELECT
DATE_TRUNC('week', block_timestamp) AS week,
COUNT(DISTINCT depositor) AS new_depositors
FROM
avalanche.defi.ez_lending_deposits
WHERE platform = 'Benqi'
AND block_timestamp >= DATE_TRUNC('month', CURRENT_DATE) - INTERVAL '12 months'
AND depositor IN (
SELECT depositor
FROM (SELECT depositor, MIN(block_timestamp) AS first_deposit
FROM avalanche.defi.ez_lending_deposits
WHERE platform = 'Benqi'
GROUP BY depositor) subquery
WHERE DATE_TRUNC('month', first_deposit) >= DATE_TRUNC('month', CURRENT_DATE) - INTERVAL '12 months'
QueryRunArchived: QueryRun has been archived