moonshot21Staking EigenLayer
Updated 2024-09-17
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
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with claimed as
(SELECT
block_timestamp,
decoded_log:account::string as claimer,
decoded_log:amount::int / 1e18 as amount_claimed
FROM ethereum.core.fact_decoded_event_logs
where contract_address = lower('0x035bdAeaB85E47710C27EdA7FD754bA80aD4ad02')
and block_timestamp::date >= '2024-01-01'
and event_name = 'Claimed'
),
staked as (
SELECT
decoded_log:from::string as depositor,
decoded_log:value::int / 1e18 as amount_staked
from ethereum.core.fact_decoded_event_logs
where contract_address = lower('0xec53bf9167f50cdeb3ae105f56099aaab9061f83')
and event_name = 'Transfer'
--and decoded_log:token::string = lower('0xbe9895146f7af43049ca1c1ae358b0541ea49704')
),
combined as (
select
c.claimer as user,
c.amount_claimed as eigen_amount,
s.amount_staked as eigen_staked
from claimed c inner join staked s on user = s.depositor
),
together as (
select
decoded_log:depositor::string as staker,
decoded_log:shares::int / 1e18 as amount
FROM
ethereum.core.fact_decoded_event_logs
where contract_address = lower('0x858646372CC42E1A627fcE94aa7A7033e7CF075A')