Skip to content
Dune Analytics

@phabc / New Query

SQL query

1WITH gas_prices AS(
2    SELECT t.gas_price * t.gas_used / 1e9 AS gwei_times_used
3    FROM ethereum.transactions t
4    WHERE t.block_time > now() - interval '15 minute'
5)
6SELECT
7    gas_prices.gwei as gas_prices_gwei,
8    ROUND(CAST(CUME_DIST() OVER (ORDER BY gas_prices.gwei_times_used ASC) * 100 as decimal(38,2)),2) || '%' cume_dist
9FROM gas_prices

SQL query results

Loading