freeman_7AmountStakED
Updated 2024-11-29
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 claimers as (
select
count(distinct decoded_log:recipient) as Claimer,
sum(decoded_log:amount /power(10,18)) as TotalClaimed,
from optimism.core.fact_decoded_event_logs
where contract_address = '0x4ee97a759aaca2edf9c1445223b6cd17c2ed3fb4'
and event_name = 'TokensClaimed'
),
stake as (
select
count(decoded_log:provider) as staker,
sum(decoded_log:amount/ power(10,18)) as AmountStaked,
--datediff('week', current_timestamp ,to_timestamp(decoded_log:locktime)) as lockDuration,
from optimism.core.fact_decoded_event_logs
where contract_address = lower('0x521b4c065bbdbe3e20b3727340730936912dfa46')
and event_name = 'Deposit'
)
Select
Claimer,
staker,
AmountStaked,
TotalClaimed,
30000000 as ToTalClaimable
From stake,claimers
QueryRunArchived: QueryRun has been archived