SocioAnalyticaCurrent liquidity Available
    Updated 2024-06-03
    with supply as (
    SELECT
    token_symbol,
    sum(amount) as amount_supply_usd
    FROM base.defi.ez_lending_deposits
    WHERE platform = 'Moonwell'
    group by 1
    )
    , withdraw as (
    SELECT
    token_symbol,
    sum(amount) as amount_withdraw_usd
    FROM base.defi.ez_lending_withdraws
    WHERE platform = 'Moonwell'
    group by 1
    )
    ,
    borrowed as (
    SELECT
    token_symbol,
    sum(amount) as amount_borrowed_usd
    FROM base.defi.ez_lending_borrows
    WHERE platform = 'Moonwell'
    group by 1
    )
    ,
    repaid as (
    SELECT
    token_symbol,
    sum(amount) as amount_repaid_usd
    FROM base.defi.ez_lending_repayments
    WHERE platform = 'Moonwell'
    group by 1
    )
    ,
    final as (
    Auto-refreshes every 24 hours
    QueryRunArchived: QueryRun has been archived