headitmanagerSwapping ETH to stETH : Number of Gain and Loss Swaps
    Updated 2022-06-14
    with base as (select distinct(origin_from_address) as staker,
    sum(amount) as amount_staked
    from ethereum.core.ez_eth_transfers
    where --tx_id = '0x4026d646872f7cb6da67725b2a0b7dc20665c4aa02d1893c6cec51ea3022820d'
    --origin_function_name = 'submit'
    --event_name = 'transfer'
    eth_to_address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84'
    group by 1),

    in_table as (select tx_id, amount_in
    from ethereum.dex_swaps
    where direction = 'IN'
    and token_address = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'),

    out_table as (select tx_id, amount_out
    from ethereum.dex_swaps
    where direction = 'OUT'
    and token_address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84'),

    combo as (select a.tx_id, amount_in, amount_out
    from in_table a
    join out_table b
    on a.tx_id = b.tx_id),
    base2 as (select origin_address,
    sum(amount_in) as ETH_sent,
    sum(amount_out) as stETH_received
    from combo a
    join ethereum.udm_events b
    where a.tx_id = b.tx_id
    and origin_address in (select staker from base)
    group by 1)

    select origin_address,
    stETH_received - ETH_sent as gain_loss,
    case
    Run a query to Download Data