Abbas_ra21Active Supply Table
    Updated 2025-02-03
    -- forked from Active Supply Table @ https://flipsidecrypto.xyz/edit/queries/9c5db5f6-31ae-44a2-8c3a-0337eab05366

    -- forked from Borrows Table @ https://flipsidecrypto.xyz/edit/queries/0e60ae35-9afe-41a3-8b46-37b7cb582ccc

    with prices AS (
    select
    SYMBOL,
    PRICE,
    rank() over (
    partition by SYMBOL
    order by
    HOUR desc
    ) AS rank
    from
    base.price.ez_prices_hourly
    where
    TOKEN_ADDRESS in (
    select
    DISTINCT TOKEN_ADDRESS
    from
    base.defi.ez_lending_deposits
    ) qualify rank = 1
    ),
    main AS (
    select
    SYMBOL,
    sum(AMT) AS "Active Supply Amount"
    from
    (
    select
    TOKEN_SYMBOL AS SYMBOL,
    sum(AMOUNT) AS AMT
    from
    base.defi.ez_lending_deposits
    where
    PLATFORM = 'Moonwell'
    Last run: 25 days ago
    SYMBOL
    Active Supply Amount
    Active Supply Amount ($)
    1
    DAI-40236.485564634-40276.722050199
    2
    wstETH5984.20886656714858730.7735983
    3
    WETH38397.95988387995341750.4120726
    4
    AERO27953574.123318821131113.0084851
    5
    USDbC-41555.505736858-41555.505736858
    6
    cbBTC484.4115634445217881.8008705
    7
    EURC6862274.607931997020106.92391442
    8
    weETH.base2643.5141917336563819.30293192
    9
    rETH1040.409512862583326.41633694
    10
    WELL84349360.27213892406390.24679981
    11
    USDC54378817.857137754377512.7655091
    12
    cbETH4706.89512251911687173.5202638
    12
    513B
    3s