mo115Ethereum
Updated 2024-09-12
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
with ETH_stake as (
select BLOCK_TIMESTAMP,ORIGIN_FROM_ADDRESS as staker,ADDRESS_NAME,LABEL_TYPE,AMOUNT,TRACE_INDEX
from ethereum.core.ez_native_transfers e left join ethereum.core.dim_labels l on e.ORIGIN_FROM_ADDRESS=l.ADDRESS
where TO_ADDRESS = '0x00000000219ab540356cbb839cbe05303d7705fa'
---UNION
---select BLOCK_TIMESTAMP, ORIGIN_TO_ADDRESS as staker,ADDRESS_NAME,LABEL_TYPE,AMOUNT*-1,TRACE_INDEX
---from ethereum.core.ez_native_transfers e left join ethereum.core.dim_labels l on e.ORIGIN_TO_ADDRESS=l.ADDRESS
---where FROM_ADDRESS = '0x00000000219ab540356cbb839cbe05303d7705fa'limit 10
)
select staker, ADDRESS_NAME,LABEL_TYPE,sum(AMOUNT) as amount
from ETH_stake
---where BLOCK_TIMESTAMP <= '2023-08-31'
group by 1,2,3
order by 4 desc
QueryRunArchived: QueryRun has been archived