flipside

    1Total amount USD of gas spent on the Ethereum in the last 30 days
    ML61Total amount USD of gas spent on the Ethereum in the last 30 days
    Updated 2022-11-12
    select avg(price) * sum(gas_used/1e9) as Total_amount
    from ethereum.core.fact_hourly_token_prices inner join ethereum.core.fact_transactions
    on hour::date=block_timestamp::date
    where
    TOKEN_ADDRESS is null
    and hour::date > current_date - interval '30 days'
    and block_timestamp::date > current_date - interval '30 days'

    Run a query to Download Data