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: 28 days ago
    TRANSACTIONS
    USERS
    ACTIVE_DAYS
    DAILY_AVERAGE_TRANSACTIONS
    DAILY_AVERAGE_USERS
    1
    21835362549445843738.931507436.547945
    1
    45B
    4s