m3jiRepayments
    Updated 2025-01-28
    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
    Date
    Token Borrowed
    payers
    volume (USD)
    Total payers
    1
    2025-01-28 00:00:00.000USDT113246.99745
    2
    2025-01-27 00:00:00.000EURe52273.93745
    3
    2025-01-27 00:00:00.000USDC215879.48745
    4
    2025-01-27 00:00:00.000USDC.e612639.52745
    5
    2025-01-26 00:00:00.000USDT11619.98745
    6
    2025-01-26 00:00:00.000USDC1700745
    7
    2025-01-26 00:00:00.000WXDAI10.32745
    8
    2025-01-26 00:00:00.000EURe166.9745
    9
    2025-01-26 00:00:00.000USDC.e21794.64745
    10
    2025-01-25 00:00:00.000USDC22269.16745
    11
    2025-01-25 00:00:00.000WXDAI219908.69745
    12
    2025-01-25 00:00:00.000USDC.e12.4745
    13
    2025-01-25 00:00:00.000EURe1186.08745
    14
    2025-01-24 00:00:00.000WXDAI10.01745
    15
    2025-01-24 00:00:00.000USDC.e22202.01745
    16
    2025-01-24 00:00:00.000USDC2503.05745
    17
    2025-01-24 00:00:00.000EURe1582.34745
    18
    2025-01-24 00:00:00.000USDT1367.17745
    19
    2025-01-23 00:00:00.000USDC16.95745
    20
    2025-01-23 00:00:00.000USDC.e14.02745
    ...
    1092
    52KB
    15s