Updated 2025-05-04
    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: 27 days ago
    EVENT_NAME
    TRANSACTIONS
    USERS
    VOLUME_USD
    AVERAGE_AMOUNT_USD
    DAILY_AVERAGE_TRANSACTIONS
    DAILY_AVERAGE_USERS
    1
    Liquidate14555450133003248.132083.40686383434.08665110.540984
    2
    Withdraw86769124866220896725866.2523640.7021667441366.44252391.593701
    3
    Deposit10824548995921174667155.8418966.9009216581704.651969141.667717
    4
    Borrow3554385675666770351979.77176515.52725645559.74488289.379528
    5
    Repay5310254721766599117046.4116980.52239065837.57886474.474763
    5
    383B
    2s