LittlerDataAvalanche's new nft lending tables
    Updated 2024-02-21

    select
    date_trunc('week',block_timestamp) date
    ,platform
    ,count(tx_hash) loans
    ,count(distinct borrower) borrowers
    ,sum(amount_usd) usd_volume
    from avalanche.defi.ez_lending_borrows
    where block_timestamp > '2024-01-01'
    group by 1, 2

    Last run: about 1 year ago
    DATE
    PLATFORM
    LOANS
    BORROWERS
    USD_VOLUME
    1
    2024-02-05 00:00:00.000Benqi93944412076841.29
    2
    2024-01-15 00:00:00.000Aave V3142150531964800.64
    3
    2024-01-08 00:00:00.000Benqi13436109815923
    4
    2024-02-12 00:00:00.000Benqi9694166266005.17
    5
    2024-02-19 00:00:00.000Aave V376530525847772.63
    6
    2024-01-22 00:00:00.000Trader-Joe95392175255.56
    7
    2024-01-29 00:00:00.000Aave V3162855945019148.55
    8
    2024-01-29 00:00:00.000Benqi10464985612064.02
    9
    2024-02-05 00:00:00.000Aave V3183765744902470.53
    10
    2024-02-05 00:00:00.000Trader-Joe9929511710.55
    11
    2024-02-19 00:00:00.000Trader-Joe241528872.13
    12
    2024-02-12 00:00:00.000Aave V3238393068505820.24
    13
    2024-01-08 00:00:00.000Aave V3173264337204886.42
    14
    2024-01-22 00:00:00.000Benqi113155210790622.75
    15
    2024-01-01 00:00:00.000Trader-Joe9141137030.15
    16
    2024-01-22 00:00:00.000Aave V3157358927621136.98
    17
    2024-01-29 00:00:00.000Trader-Joe93316257030.04
    18
    2024-01-15 00:00:00.000Benqi102849210973402.29
    19
    2024-02-19 00:00:00.000Benqi2411403544913.08
    20
    2024-01-15 00:00:00.000Trader-Joe8428156665.59
    24
    1KB
    1s