Updated 2025-03-14
    with

    main as (
    select
    tx_hash,
    block_timestamp,
    borrower as user,
    token_symbol as symbol,
    amount_usd,
    'Borrow' as event_name
    from
    base.defi.ez_lending_borrows
    where
    platform = 'Moonwell'

    union all

    select
    tx_hash,
    block_timestamp,
    depositor as user,
    token_symbol as symbol,
    amount_usd,
    'Deposit' as event_name
    from
    base.defi.ez_lending_deposits
    where
    platform = 'Moonwell'

    union all

    select
    tx_hash,
    block_timestamp,
    depositor as user,
    token_symbol as symbol,
    Last run: 26 days ago
    EVENT_NAME
    TRANSACTIONS
    USERS
    VOLUME_USD
    AVERAGE_AMOUNT_USD
    DAILY_AVERAGE_TRANSACTIONS
    DAILY_AVERAGE_USERS
    1
    Liquidate9266338029121478.282780.09339188524.6436178.989362
    2
    Deposit10004378371920259620573.9519723.2468751791713.077055143.354452
    3
    Repay4798274604764435477863.23125359.876310749823.03087578.982847
    4
    Borrow3204575545264564761860.03190091.48172692548.7277494.952055
    5
    Withdraw79660823886220026413676.3524716.1559758271364.054795409.010274
    5
    383B
    4s