flipside

    Deposit Assets
    Afonso_DiazDeposit Assets
    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: 21 days ago
    SYMBOL
    TRANSACTIONS
    USERS
    VOLUME_USD
    AVERAGE_AMOUNT_USD
    1
    		weETH.base159752225431652.1115128.88287329
    2
    		DAI11442404688443755.717290.121637817
    3
    		wstETH414719106359538654.28383.590313855
    4
    		WELL24004878060908.363336.468692053
    5
    		rETH8438573321314863.412465.856479639
    6
    		AERO655219851506045796.537538.632689231
    7
    		USDC138502365908437161000.8658024.847673824
    8
    		cbETH2145011760125239499.485692.963292877
    9
    		EURC78441023264170303.2429084.036468127
    10
    		USDbC3613922097151895084.114184.322308201
    11
    		VIRTUAL17785982475636.641378.416837416
    12
    		cbBTC246872252400968447.4915635.345973484
    13
    		WETH60534447869868874971.8116045.437945381
    13
    633B
    3s