MostlyData_test_arbs
    Updated 2023-01-05
    with swap_list as(
    select
    block_number,
    block_timestamp,
    tx_hash,
    tx_to,
    sender,
    origin_from_address,
    origin_to_address,
    pool_name,
    amount_in,
    amount_in_usd,
    amount_out,
    amount_out_usd,
    event_index,
    platform,
    symbol_in,
    symbol_out

    from ethereum.core.ez_dex_swaps
    where block_timestamp < '{{end_date}}'
    and block_timestamp > '{{start_date}}'
    ),

    possible_arbs as (
    select
    block_number,
    block_timestamp,
    tx_hash,
    origin_from_address,
    origin_to_address,
    tx_to,
    sender as searcher,
    symbol_out as symbol,
    pool_name,
    event_index,
    Run a query to Download Data