Abbas_ra21Top Depositors
    Updated 2025-02-03
    -- forked from Top Depositors @ https://flipsidecrypto.xyz/edit/queries/c9105113-08a9-4a86-a5b7-c752413cfb28

    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_prices_hourly B on B.TOKEN_ADDRESS = A.TOKEN_ADDRESS
    and HOUR = date_trunc('hour', BLOCK_TIMESTAMP)
    where
    PLATFORM = 'Moonwell'
    group by
    1 order by 2 desc limit 100



    Last run: 25 days ago
    Depositor Address
    VOLUME
    Despoits Count
    1
    0x4f4f961a3e9fc5c8845c234e4b44baa4c76f0f323640247344.1650520
    2
    0xc8dc4db49d42372c92f7e02a0ff07ed6bea1464e2968387015.5512276
    3
    0xd491601e2c0948026be03899848496ae5d8805521595099730.7922267
    4
    0x745e14e28805e01e6f4cee308b0c672c2b2a4fb91524088340.1812641
    5
    0x2b2f6c796f594f01a68e5a422c4457b339dd4fda1275942609.1810638
    6
    0x70778cfcfc475c7ea0f24cc625baf6eae475d0c91017056883.37455436
    7
    0x41376c735575f0b20be97dd98e1c181b97e483d9941145911.04508
    8
    0xe487a4b6f394bc8b42230884fa3079bc4f1f8b8c586752364.41673
    9
    0x4019f6bfc129ecbfc09e7d59548856fbfb2455ef491664535.99757
    10
    0x852bf487cc7fc4e0ba6a8ca61bba2afead733586422514369.8816242
    11
    0x744a222750a0681fb2f7167bdd00e2ba611f89a9293487361.5116664
    12
    0x6207ec38da68902cc60d3760c9fe3eb64b426207246773963.13142
    13
    0xf8d7292c418f363805e654f9e86a594696f9f923233960726.3225249
    14
    0x09b2ce57748bb6739b96e7b57843ac1072016b5e232262157.4132810
    15
    0xe860cc946338769bc60d68ec9576a3a258c7d156175670828.832973
    16
    0x8cfc01a1179cc87c7a7ef22f6fd0ea87edb5f5cd149278810.8195
    17
    0xc254f595c4c40d857b63fdb229619eb9efda44c6147815630.7153
    18
    0x2696e8017a422af7ee764fa598c7ac3b75007fdb90612449.341612
    19
    0x60808010a6ea0747b78470ab381febeaa962ed2b78180024.6856
    20
    0x11a020d80b0a4468bf45888a0ab33cf4169f520a65597056.14360
    100
    6KB
    3s