strawbettyETH amount swap to stETH
    Updated 2022-06-15
    with
    swap_in as (
    select
    block_timestamp,
    tx_id,
    from_address as user,
    case when token_address = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2' then 'WETH' else 'stETH' end as token_in,
    amount_out as swap_in,
    amount_usd as swap_in_usd
    from ethereum.dex_swaps
    where direction = 'OUT'
    and pool_address = '0xdc24316b9ae028f1497c275eb9192a3ea0f67022'
    ),
    swap_out as (
    select
    block_timestamp,
    tx_id,
    from_address as user,
    case when token_address = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2' then 'WETH' else 'stETH' end as token_out,
    amount_in as swap_out,
    amount_usd as swap_out_usd
    from ethereum.dex_swaps
    where direction = 'IN'
    and pool_address = '0xdc24316b9ae028f1497c275eb9192a3ea0f67022'
    ),
    swaps as (
    select
    i.block_timestamp,
    i.tx_id,
    i.user,
    token_in,
    token_out,
    swap_in,
    swap_out,
    Run a query to Download Data