0-MIDWithdrawers & Count
    Updated 2024-01-16


    select BLOCK_TIMESTAMP::date as date
    ,count(distinct FROM_ADDRESS) as "WITHDRAWERS"
    ,count(distinct tx_hash) as "WITHDRAW COUNT"
    ,sum(ETH_VALUE) as "ETH VALUE"
    ,avg(ETH_VALUE) as "AVG ETH VALUE"
    from base.core.fact_transactions
    where TO_ADDRESS in('0x80c67432656d59144ceff962e8faf8926599bcf8','0xe4edb277e41dc89ab076a1f049f4a3efa700bce8','0xd9d74a29307cc6fc8bf424ee4217f1a587fbc8dc')
    group by 1




    QueryRunArchived: QueryRun has been archived