mo115Polygon - 1st stake copy
Updated 2024-09-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
›
⌄
with txs as(select tx_hash
from ethereum.core.ez_token_transfers
where TO_ADDRESS = '0x5e3ef299fddf15eaa0432e6e66473ace8c13d908'
union
select tx_hash
from ethereum.core.ez_token_transfers
where FROM_ADDRESS = '0x5e3ef299fddf15eaa0432e6e66473ace8c13d908')
select (t.tx_hash),EVENT_NAME,e.BLOCK_TIMESTAMP
from txs t left join ethereum.core.ez_decoded_event_logs e on t.tx_hash=e.tx_hash
where EVENT_NAME in (
--'StakeUpdate',
--'DelegatorUnstakeWithId',
--'DelegatorUnstaked',
--*'StakeRewards',--
--*'DelegatorRestaked',--
--'Staked',
--'Restaked',
--'UnstakeInit',
--'Unstaked',
--*'Stake',--
--'Unstake',
'FoundationStake',
'FoundationUnStake',
--'RestakeError'
)
QueryRunArchived: QueryRun has been archived