0-MIDTop 10 Depositors By Deposit Volume
    Updated 2023-09-23
    select
    TO_ADDRESS as depositor
    ,sum(ETH_VALUE) as "VOLUME IN"
    ,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






    Run a query to Download Data