octavionotpunkgas-fee-computation-jumper-hours
    Updated 2024-04-01
    -- forked from gas-fee-computation-jumper @ https://flipsidecrypto.xyz/edit/queries/c586f40b-26c0-4ec9-b3e9-1f6fc40d371d

    -- forked from jumper-samechain-swap @ https://flipsidecrypto.xyz/edit/queries/e8b15b3d-417d-4695-91d4-e42a28f57928
    with prices as (
    select
    *,
    'arbitrum' as chain
    from
    arbitrum.price.ez_hourly_token_prices
    union
    all
    select
    *,
    'optimism' as chain
    from
    optimism.price.ez_hourly_token_prices
    union
    all
    select
    *,
    'bnb' as chain
    from
    bsc.price.ez_hourly_token_prices
    union
    all
    select
    *,
    'base' as chain
    from
    base.price.ez_hourly_token_prices
    union
    all
    select
    *,
    'ethereum' as chain
    from
    QueryRunArchived: QueryRun has been archived