flipside

    staker's swaps: stETH to ETH
    mo115staker's swaps: stETH to ETH
    Updated 2022-06-15
    with wallets as (select DISTINCT from_address as wallet
    from flipside_prod_db.ethereum.udm_events
    where to_address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84'
    )
    select a.wallet,b.TX_HASH, (b.AMOUNT_OUT-b.AMOUNT_IN) as Gain
    from wallets a inner join ethereum.core.ez_dex_swaps b on a.wallet=b.ORIGIN_FROM_ADDRESS
    and token_IN = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84'
    and TOKEN_OUT = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'

    Run a query to Download Data