pandaArbitrum & Layer 2 Comparison Fee
    Updated 2023-03-06
    WITH eth_Price AS
    (
    SELECT
    date_trunc('day', hour) as daily_timestamp,
    EXTRACT(HOUR FROM HOUR) as hourly_time,
    price
    FROM
    ethereum.core.fact_hourly_token_prices
    WHERE
    TOKEN_ADDRESS is NULL
    AND
    SYMBOL is NULL
    ),
    mat_raw AS
    (
    SELECT
    hour, price
    FROM
    ethereum.core.fact_hourly_token_prices
    WHERE
    SYMBOL = 'MATIC'
    ),

    matic_Price AS
    (
    SELECT
    date_trunc('day', hour) as daily_timestamp,
    EXTRACT(HOUR FROM HOUR) as hourly_time,
    price
    FROM
    mat_raw
    WHERE
    daily_timestamp >= '2023-01-01'
    ),

    gnosis_Price AS --xDAI token is 1:1 with DAI on Ethereum
    Run a query to Download Data