mo115eigenlayer - wallets
    Updated 2023-08-18
    with txs as (select a.*, b.TX_FEE
    from ethereum.core.ez_token_transfers a left join ethereum.core.fact_transactions b on a.TX_HASH=b.TX_HASH
    where (a.TO_ADDRESS = '0x54945180db7943c0ed0fee7edab2bd24620256bc' or
    a.TO_ADDRESS = '0x1bee69b7dfffa4e2d53c2a2df135c388ad25dcd2' or
    a.TO_ADDRESS = '0x93c4b944d05dfe6df7645a86cd2206016c51564d')
    and ( a.SYMBOL = 'rETH' or a.SYMBOL = 'cbETH' or a.SYMBOL = 'stETH' ) )
    select ORIGIN_FROM_ADDRESS as wallet,
    count (distinct TX_HASH) as transactions,
    count (distinct SYMBOL) as pools,
    sum (AMOUNT) as total_AMOUNT,
    sum (TX_FEE) as total_TX_FEE,
    (total_TX_FEE/total_AMOUNT) as "TX_FEE/AMOUNT"
    from txs
    group by 1
    order by 4 DESC
    Run a query to Download Data