strawbettypercentage of dead addresses in eligible addresses
    Updated 2022-05-08
    with t1 as (
    select
    lower(address) as eligible
    from ethereum_sushi.dim_distributor_reward_schedule
    where MERKLE_ROOT = '0x015e6c2cd1a4d6fa77aa1884c436b2435aae4beab5c9a091f18fd0c00dc7e577'
    and REWARDS_SNAPSHOT::date = '2021-10-22'
    ), active_wallet as (
    select
    distinct(lower(FROM_ADDRESS)) as active_address
    from ethereum_core.fact_transactions
    where active_address IN (select * from t1)
    and block_timestamp >= CURRENT_DATE - 90
    )

    select
    count(DISTINCT active_address) as eligible_active_address,
    count(DISTINCT eligible) as eligible_ad,
    eligible_ad-eligible_active_address as dead_address,
    dead_address/ eligible_ad * 100 as dead_percetange
    from active_wallet, t1
    Run a query to Download Data