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



    QueryRunArchived: QueryRun has been archived