Abbas_ra21Borrows Table
    Updated 2025-01-21
    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_borrows
    ) qualify rank = 1
    ),
    main AS (
    select
    SYMBOL,
    sum(AMT) AS "Amount Borrowed"
    from
    (
    select
    TOKEN_SYMBOL AS SYMBOL,
    sum(AMOUNT) AS AMT
    from
    base.defi.ez_lending_borrows
    where
    PLATFORM = 'Seamless'
    group by
    1
    union
    ALL
    Last run: about 1 month agoAuto-refreshes every 24 hours
    SYMBOL
    Amount Borrowed
    PRICE
    Amount Borrowed ($)
    1
    DAI47717.9926651961.00147765.710657861
    2
    AERO45319.8245422881.0690987248451.366386946
    3
    EURC294135.856281.04305901.2905312
    4
    USDC26736066.6087990.99999926736039.8727323
    5
    WETH1406.5726182953259.844585201.68402174
    5
    241B
    12s