hessAverage Monthly APY
Updated 2024-10-06
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 base as (select date_trunc('day', block_timestamp) as day,
sum(raw_amount/1e18) as staked_amount
from ethereum.core.fact_token_transfers
where -- tx_hash = '0x6b298e69474080bd5f8a1bebb2562110a72a58e3655265feb7d90a0ddbf19df0'
origin_function_signature = '0x6e553f65'
and contract_address = '0xa5f2211b9b8170f694421f2046281775e8468044'
and origin_to_address = '0x815c23eca83261b6ec689b60cc4a58b54bc24d8d'
group by 1),
base2 as (select date_trunc('day', block_timestamp) as day,
sum(raw_amount/1e18) as unstaked_amount
from ethereum.core.fact_token_transfers
where --tx_hash = '0x7ed54a0e738b84d61ee4d0f738be15e7eda8af810190bbb5791bbdc622f1daef'
origin_function_signature = '0xba087652'
and contract_address = '0xa5f2211b9b8170f694421f2046281775e8468044'
and origin_to_address = '0x815c23eca83261b6ec689b60cc4a58b54bc24d8d'
group by 1),
base3 as (select a.day,
staked_amount,
ifnull(unstaked_amount,0) as unstaked_amountz,
staked_amount - unstaked_amountz as net_staked,
sum(net_staked) over (order by a.day) as cumulative_net_staked
from base a
left join base2 b
on a.day = b.day
where a.day >= '2022-05-04'),
base4 as (select date_trunc('day', block_timestamp) as day,
sum(raw_amount/1e18) as protocol_emission
from ethereum.core.fact_token_transfers
where --tx_hash = '0xf52ee7b46438099010dfc64df9de5091753f6d17f8c991907d9b70ad2b728415'
from_address = '0x8f631816043c8e8cad0c4c602bfe7bff1b22b182'
and to_address = '0x815c23eca83261b6ec689b60cc4a58b54bc24d8d'
group by 1),
QueryRunArchived: QueryRun has been archived