rachAverage Gas Fee weekly
    Updated 2024-05-16
    WITH
    eth_tx_gas_fees AS (
    SELECT
    'ethereum' AS dataset,
    GAS_PRICE * GAS_USED AS gas_fee
    FROM
    ethereum.core.fact_transactions
    WHERE
    BLOCK_TIMESTAMP >= CURRENT_DATE() - 7
    ),
    polygon_tx_gas_fees AS (
    SELECT
    'polygon' AS dataset,
    GAS_PRICE * GAS_USED AS gas_fee
    FROM
    polygon.core.fact_transactions
    WHERE
    BLOCK_TIMESTAMP >= CURRENT_DATE() - 7
    ),
    bsc_tx_gas_fees AS (
    SELECT
    'bsc' AS dataset,
    GAS_PRICE * GAS_USED AS gas_fee
    FROM
    bsc.core.fact_transactions
    WHERE
    BLOCK_TIMESTAMP >= CURRENT_DATE() - 7
    ),
    avalanche_tx_gas_fees AS (
    SELECT
    'avalanche' AS dataset,
    GAS_PRICE * GAS_USED AS gas_fee
    FROM
    avalanche.core.fact_transactions
    WHERE
    BLOCK_TIMESTAMP >= CURRENT_DATE() - 7
    QueryRunArchived: QueryRun has been archived