CarlOwOsgas per mill
    Updated 2022-11-15
    WITH eth AS (
    SELECT
    1e6 * SUM(tx_fee*price) / SUM(eth_value*price) AS gas_per_mill
    FROM
    ethereum.core.fact_transactions JOIN ethereum.core.fact_hourly_token_prices ON hour = DATE_TRUNC('HOUR', block_timestamp)
    WHERE
    block_timestamp >= CURRENT_DATE-30
    AND token_address = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'
    ),
    op AS (
    SELECT
    1e6 * SUM(tx_fee*price) / SUM(eth_value*price) AS gas_per_mill
    FROM
    optimism.core.fact_transactions JOIN optimism.core.fact_hourly_token_prices ON hour = DATE_TRUNC('HOUR', block_timestamp)
    WHERE
    block_timestamp >= CURRENT_DATE-30
    AND token_address = '0x4200000000000000000000000000000000000006'
    ),
    /*sol AS (
    SELECT
    1e6 * SUM(fee*1e-9*close) / SUM(t.amount*1e-9*close) AS gas_per_mill
    FROM
    solana.core.fact_transactions
    JOIN solana.core.fact_token_prices_hourly ON recorded_hour = DATE_TRUNC('HOUR', block_timestamp)
    LEFT JOIN solana.core.fact_transfers t USING(tx_id)
    WHERE
    block_timestamp >= CURRENT_DATE-30
    AND symbol = 'SOL'
    AND t.mint = 'So11111111111111111111111111111111111111112'
    ),*/
    algo AS (
    SELECT
    1e6 * SUM(fee*price_usd) / SUM(amount*1e-6*price_usd) AS gas_per_mill
    FROM
    algorand.core.fact_transaction JOIN algorand.core.ez_price_pool_balances ON block_hour = DATE_TRUNC('HOUR', block_timestamp)
    WHERE
    Run a query to Download Data