shahdadi-9ptm8Ystakers(from metamask users)
    Updated 2022-06-25
    with user as(
    select
    distinct origin_from_address as users
    from ethereum.core.fact_event_logs
    where contract_address=lower('0x881D40237659C251811CEC9c364ef91dC08D300C')
    ),
    stakers as(
    select
    count(distinct origin_from_address) stakers
    from ethereum.core.fact_event_logs
    where origin_from_address in (select users from user)
    and event_name='Stake'
    )
    select (stakers/count(users))*100
    from user join stakers
    group by stakers
    Run a query to Download Data