flipside

    Active Supply 2
    Abbas_ra21Active Supply 2
    Updated 2024-06-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_hourly_token_prices
    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 = 'Seamless'
    Auto-refreshes every 24 hours
    QueryRunArchived: QueryRun has been archived