Abbas_ra21Top Depositors
    Updated 2024-05-22
    select
    DEPOSITOR AS "Depositor Address",
    sum(
    case
    when Amount_USD is not null then Amount_USD
    else Amount * Price
    end
    ) AS Volume,
    Count(*) AS "Despoits Count"
    from
    base.defi.ez_lending_deposits A
    inner join base.price.ez_hourly_token_prices B on B.TOKEN_ADDRESS = A.TOKEN_ADDRESS
    and HOUR = date_trunc('hour', BLOCK_TIMESTAMP)
    where
    PLATFORM = 'Seamless'
    group by
    1 order by 2 desc limit 100


    Auto-refreshes every 24 hours
    QueryRunArchived: QueryRun has been archived