flipside

    Deposit Assets
    Afonso_DiazDeposit Assets
    Updated 5 days ago
    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: 5 days ago
    SYMBOL
    TRANSACTIONS
    USERS
    VOLUME_USD
    AVERAGE_AMOUNT_USD
    1
    		DAI11548413288478499.587229.816929237
    2
    		MORPHO5952351813519.422772.965474006
    3
    		weETH.base172757725899252.0614301.077890668
    4
    		wstETH5172411476383951025.117145.534868889
    5
    		WELL37796429471966.762490.001777077
    6
    		USDC153676397579016355695.7955478.09634318
    7
    		cbETH2470013942127940352.035067.145313874
    8
    		AERO7315012017517445502.66917.443185434
    9
    		WETH639363480310113807212.4215502.29720469
    10
    		EURC90171077278208183.3126794.585698738
    11
    		VIRTUAL32699566322917.281920.691761847
    12
    		cbBTC274832468431290337.1515067.964125004
    13
    		USDbC3613922097151895084.114184.322308201
    14
    		rETH8852594021787608.222405.344250386
    14
    680B
    3s