mo115eigenlayer - wallets
Updated 2023-08-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
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