freemartianLow Price Stakers
    Updated 2022-06-15
    with low_price as (
    select distinct tx_from_address as staker, sum(event_inputs:amount)/pow(10,18) as staked_amount
    from ethereum.events_emitted
    where contract_address = lower('0xae7ab96520DE3A18E5e111B5EaAb095312D7fE84')
    and event_name = 'Submitted'
    and block_timestamp between '2020-12-23' and '2021-02-01'
    group by tx_from_address
    ),

    now as (
    select user_address, balance, staked_amount
    from flipside_prod_db.ethereum.erc20_balances b
    inner join low_price lp on b.user_address = lp.staker
    where symbol = 'stETH'
    and balance_date = CURRENT_DATE - 1
    )
    select count(user_address) as count, 'Hodlers' as label
    from now
    where balance = staked_amount
    UNION
    select count(user_address) as count, 'Seller' as label
    from now
    where balance < staked_amount
    UNION
    select count(user_address) as count, 'Buyer' as label
    from now
    where balance > staked_amount


    Run a query to Download Data