0-MIDtotal volume avg per count dep
    Updated 2023-09-22
    select
    count(distinct TO_ADDRESS) as "DEPOSITORS"
    ,count(distinct tx_hash) as "DEPOSIT COUNT"
    ,sum(ETH_VALUE) as "ETH VALUE"
    ,"ETH VALUE"/"DEPOSITORS" as "dep volume per depositor"
    ,"ETH VALUE"/"DEPOSIT COUNT" as "dep volume per dep count"
    from base.core.fact_transactions
    where FROM_ADDRESS in('0x80c67432656d59144ceff962e8faf8926599bcf8','0xe4edb277e41dc89ab076a1f049f4a3efa700bce8','0xd9d74a29307cc6fc8bf424ee4217f1a587fbc8dc')





    Run a query to Download Data