hessAverage Monthly APY
    Updated 2024-10-06
    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