yasminuser benqi
Updated 2025-02-02
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 depositors AS (
SELECT
DATE_TRUNC('month', block_timestamp) AS date,
COUNT(DISTINCT ORIGIN_FROM_ADDRESS) AS depositors
FROM
avalanche.defi.ez_lending_deposits
WHERE
PLATFORM = 'Benqi'
AND block_timestamp >= DATE_TRUNC('month', CURRENT_DATE) - INTERVAL '12 month'
GROUP BY 1
),
borrowers AS (
SELECT
DATE_TRUNC('month', block_timestamp) AS date,
COUNT(DISTINCT ORIGIN_FROM_ADDRESS) AS borrowers
FROM
avalanche.defi.ez_lending_borrows
WHERE
PLATFORM = 'Benqi'
AND block_timestamp >= DATE_TRUNC('month', CURRENT_DATE) - INTERVAL '12 month'
GROUP BY 1
),
redeemers AS (
SELECT
DATE_TRUNC('month', block_timestamp) AS date,
COUNT(DISTINCT ORIGIN_FROM_ADDRESS) AS redeemers
FROM
avalanche.defi.ez_lending_withdraws
WHERE
PLATFORM = 'Benqi'
AND block_timestamp >= DATE_TRUNC('month', CURRENT_DATE) - INTERVAL '12 month'
GROUP BY 1
),
liquidations AS (
SELECT
DATE_TRUNC('month', block_timestamp) AS date,
QueryRunArchived: QueryRun has been archived