mhmUniswap vs. Sushiswap vs. Velodrome
    Updated 2022-10-27
    -- Uniswap section credit to: Haen98 (https://app.flipsidecrypto.com/dashboard/SNzVeP)
    with sushiswap_ez_swaps as (
    select
    e.block_timestamp as dt,
    tx_hash,
    ORIGIN_FROM_ADDRESS,
    AMOUNT_IN_USD,
    tx_fee
    from optimism.sushi.ez_swaps e inner join optimism.core.fact_transactions using(tx_hash)
    ), velodrome_ez_swaps as (
    select
    e.block_timestamp as dt,
    tx_hash,
    ORIGIN_FROM_ADDRESS,
    AMOUNT_IN_USD,
    tx_fee
    from optimism.velodrome.ez_swaps e inner join optimism.core.fact_transactions using(tx_hash)
    ), uniswap_swaps_log as (
    select
    block_timestamp,
    tx_hash, origin_function_signature,
    router_address,
    swapper, index_group,
    max_row_num,
    tx_fee,
    max(sender) as sender,
    max(recipient) as recipient,
    max(pool_address) as pool_address,
    max(in_amount) as in_amount,
    max(in_decimals) as in_decimals,
    max(in_token_address) as in_token_address,
    max(in_token_symbol) as in_token_symbol,
    max(out_amount) as out_amount,
    max(out_decimals) as out_decimals,
    max(out_token_address) as out_token_address,
    max(out_token_symbol) as out_token_symbol,
    Run a query to Download Data