0-MIDTop 10 Depositors By Deposit Count
    Updated 2024-01-29
    select
    TO_ADDRESS as depositor
    ,count(distinct tx_hash) as "DEPOSIT COUNT"
    ,count(distinct BLOCK_TIMESTAMP::date) as "ACTIVE DAYS"
    from base.core.fact_transactions
    where FROM_ADDRESS in('0x80c67432656d59144ceff962e8faf8926599bcf8','0xe4edb277e41dc89ab076a1f049f4a3efa700bce8','0xd9d74a29307cc6fc8bf424ee4217f1a587fbc8dc')
    group by 1
    order by 2 desc
    limit 10





    Last run: about 1 year ago
    DEPOSITOR
    DEPOSIT COUNT
    ACTIVE DAYS
    1
    0x13e46b2a3f8512ed4682a8fb8b560589fe3c2172222384
    2
    0x7e689c1ef962160685da69742170b3629e6299ae4392
    3
    0xe530a4ad020b8628b4031998bcd05904a4cd6e0e4388
    4
    0x102ee22d378e9cec65c6095b0bbfbab8f236d59c2942
    5
    0x49fbb9f90e78dd1c0569816e1eeeaf2c28414ed72436
    6
    0x91d4feb0451254b8024d03d09d9b62a1a2e38e2822422
    7
    0x4f45eceb38221b338b4651cc1cdf51b1b61fddf420822
    8
    0x8513fafe1813b6ec3bbd9fc4baf5340bda8d670b1842
    9
    0x23254912de2b8c6e3d158efc8721f8dc1eb4a27a17515
    10
    0xe4b479ccf9c5665b55dcb35c15d155dbf29d431b17413
    10
    537B
    17s