0-MIDdepositor stats copy
    Updated 2023-08-13
    select 'WITHDRAWER' as user
    ,count(distinct BLOCK_TIMESTAMP::date) as "ACTIVE DAYS"
    ,count(distinct tx_hash) as "WITHDRAW COUNT"
    ,sum(ETH_VALUE) as "ETH VALUE"
    ,sum(TX_FEE) as "FEE PAID ($ETH)"
    from base.core.fact_transactions
    where TO_ADDRESS in('0x80c67432656d59144ceff962e8faf8926599bcf8','0xe4edb277e41dc89ab076a1f049f4a3efa700bce8','0xd9d74a29307cc6fc8bf424ee4217f1a587fbc8dc')
    and FROM_ADDRESS =lower('{{WITHDRAWER}}')
    group by 1




    Run a query to Download Data