ngxuan885Sushi Reward Program for Farmers: wallets
    Updated 2022-05-07
    with receivers as ( SELECT to_address as claimers
    FROM ethereum_core.ez_token_transfers
    where BLOCK_TIMESTAMP::date >= '2021-10-22'
    and SYMBOL = 'SUSHI'
    and FROM_ADDRESS = '0x1026cbed7b7e851426b959bc69dcc1bf5876512d' )
    SELECT case
    when lower(ADDRESS) in (SELECT lower(claimers) from receivers) THEN 'received reward'
    else 'no' end as address, count(*) as numbers

    from ethereum_sushi.dim_distributor_reward_schedule
    where REWARDS_SNAPSHOT = '2021-10-22 23:10:00.000'
    and MERKLE_ROOT = '0x015e6c2cd1a4d6fa77aa1884c436b2435aae4beab5c9a091f18fd0c00dc7e577'

    GROUP by 1

    Run a query to Download Data