0xHaM-dTotal Over Time by Action
    Updated 2025-02-11
    with eventTb as (
    SELECT
    EVENT_NAME,
    BLOCK_TIMESTAMP,
    TX_HASH,
    ORIGIN_FROM_ADDRESS,
    PLATFORM,
    TOKEN_SYMBOL,
    AMOUNT,
    AMOUNT_USD
    FROM avalanche.defi.ez_lending_borrows
    WHERE TOKEN_SYMBOL ilike ANY ('%USDC%', '%USDT%', 'AUSD','BUSD')

    UNION ALL

    SELECT
    EVENT_NAME,
    BLOCK_TIMESTAMP,
    TX_HASH,
    ORIGIN_FROM_ADDRESS,
    PLATFORM,
    TOKEN_SYMBOL,
    AMOUNT,
    AMOUNT_USD
    FROM avalanche.defi.ez_lending_deposits
    WHERE TOKEN_SYMBOL ilike ANY ('%USDC%', '%USDT%', 'AUSD','BUSD')

    UNION ALL

    SELECT
    EVENT_NAME,
    BLOCK_TIMESTAMP,
    TX_HASH,
    ORIGIN_FROM_ADDRESS,
    PLATFORM,
    FLASHLOAN_TOKEN_SYMBOL,
    Last run: about 2 months ago
    DATE
    EVENT_NAME
    N_TXS
    N_USERS
    TOTAL_AMT
    TOTAL_N_TXS
    TOTAL_VOLUME
    1
    2025-02-10 00:00:00.000FlashLoan10632985040.7613997172641783.6
    2
    2025-02-10 00:00:00.000Withdraw57325119395176.811416696009175560.67
    3
    2025-02-10 00:00:00.000LiquidationCall511.74578044813081.8
    4
    2025-02-10 00:00:00.000Supply2749118316820.77724994080591734.22
    5
    2025-02-10 00:00:00.000Borrow41519611308963.341359444623934807.24
    6
    2025-02-10 00:00:00.000Repay35313911007071.121029654490035730.2
    7
    2025-02-10 00:00:00.000Deposit6992039924247.69808292763208498.62
    8
    2025-02-03 00:00:00.000Borrow2781110060520062.891355294612625843.9
    9
    2025-02-03 00:00:00.000Deposit4838248988979472.47801302753284250.93
    10
    2025-02-03 00:00:00.000FlashLoan6992006668585.5713891171656742.84
    11
    2025-02-03 00:00:00.000Withdraw72163049193502448.261410965989780383.86
    12
    2025-02-03 00:00:00.000Supply2511549111143870.11722254062274913.45
    13
    2025-02-03 00:00:00.000LiquidationCall618935337618.52577544813080.06
    14
    2025-02-03 00:00:00.000Repay3706121281088197.741026124479028659.08
    15
    2025-01-27 00:00:00.000Repay38621040102494895.23989064397940461.34
    16
    2025-01-27 00:00:00.000Supply273969573832314.48697143951131043.34
    17
    2025-01-27 00:00:00.000Borrow32171084103341626.041327484552105781.01
    18
    2025-01-27 00:00:00.000LiquidationCall312743379723.58515739475461.54
    19
    2025-01-27 00:00:00.000Withdraw58401380178867977.61338805796277935.6
    20
    2025-01-27 00:00:00.000FlashLoan57113211774024.9713192164988157.27
    ...
    413
    31KB
    6s