LI.FIbungee_overall_figures
    Updated 2024-12-05
    -- forked from socket-cross @ https://flipsidecrypto.xyz/edit/queries/e28810df-355d-43ab-a9a9-d5d5e55920e4
    with prices as (
    select
    *,
    'arbitrum' as chain
    from
    arbitrum.price.ez_prices_hourly

    union
    all
    select
    *,
    'optimism' as chain
    from
    optimism.price.ez_prices_hourly
    union
    all
    select
    *,
    'bnb' as chain
    from
    bsc.price.ez_prices_hourly
    union
    all
    select
    *,
    'base' as chain
    from
    base.price.ez_prices_hourly
    union
    all
    select
    *,
    'ethereum' as chain
    from
    ethereum.price.ez_prices_hourly
    QueryRunArchived: QueryRun has been archived