Date | Token Borrowed | payers | volume (USD) | Total payers | |
---|---|---|---|---|---|
1 | 2025-01-28 00:00:00.000 | USDT | 1 | 13246.99 | 745 |
2 | 2025-01-27 00:00:00.000 | EURe | 5 | 2273.93 | 745 |
3 | 2025-01-27 00:00:00.000 | USDC | 2 | 15879.48 | 745 |
4 | 2025-01-27 00:00:00.000 | USDC.e | 6 | 12639.52 | 745 |
5 | 2025-01-26 00:00:00.000 | USDT | 1 | 1619.98 | 745 |
6 | 2025-01-26 00:00:00.000 | USDC | 1 | 700 | 745 |
7 | 2025-01-26 00:00:00.000 | WXDAI | 1 | 0.32 | 745 |
8 | 2025-01-26 00:00:00.000 | EURe | 1 | 66.9 | 745 |
9 | 2025-01-26 00:00:00.000 | USDC.e | 2 | 1794.64 | 745 |
10 | 2025-01-25 00:00:00.000 | USDC | 2 | 2269.16 | 745 |
11 | 2025-01-25 00:00:00.000 | WXDAI | 2 | 19908.69 | 745 |
12 | 2025-01-25 00:00:00.000 | USDC.e | 1 | 2.4 | 745 |
13 | 2025-01-25 00:00:00.000 | EURe | 1 | 186.08 | 745 |
14 | 2025-01-24 00:00:00.000 | WXDAI | 1 | 0.01 | 745 |
15 | 2025-01-24 00:00:00.000 | USDC.e | 2 | 2202.01 | 745 |
16 | 2025-01-24 00:00:00.000 | USDC | 2 | 503.05 | 745 |
17 | 2025-01-24 00:00:00.000 | EURe | 1 | 582.34 | 745 |
18 | 2025-01-24 00:00:00.000 | USDT | 1 | 367.17 | 745 |
19 | 2025-01-23 00:00:00.000 | USDC | 1 | 6.95 | 745 |
20 | 2025-01-23 00:00:00.000 | USDC.e | 1 | 4.02 | 745 |
m3jiRepayments
Updated 2025-01-28
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 spark AS(
SELECT
DATE_TRUNC('day', block_timestamp) AS "Date",
token_symbol AS "Token Borrowed",
origin_from_address AS payer,
tx_hash,
amount_usd AS "Amount Repaid USD"
FROM gnosis.defi.ez_lending_repayments AS a
WHERE 1 = 1
AND platform ilike '%spark%'
AND "Amount Repaid USD" IS NOT NULL
AND block_timestamp :: DATE BETWEEN '2024-01-01' AND current_date
---- Filtering for New Repayments in 2024 ----
AND origin_from_address IN(
SELECT origin_from_address
FROM (
SELECT
origin_from_address, MIN(block_timestamp)
FROM gnosis.defi.ez_lending_repayments
WHERE platform ilike '%spark%'
GROUP BY origin_from_address
HAVING MIN(block_timestamp :: DATE) BETWEEN '2024-01-01' AND current_date
) AS sub
)
AND origin_from_address NOT IN(SELECT address FROM gnosis.core.dim_contracts)
),
total AS(
SELECT
COUNT(DISTINCT payer) AS "Total payers"
FROM spark
)
SELECT
"Date",
"Token Borrowed",
COUNT(DISTINCT payer) AS "payers",
SUM("Amount Repaid USD") AS "volume (USD)",
Last run: 3 months agoAuto-refreshes every 24 hours
...
1092
52KB
15s