-- forked from Total Gas Used by Uniswap Txn (Last 6 months) @ https://flipsidecrypto.xyz/edit/queries/ba042bf0-3d8b-45b6-9723-16722f6b1337
SELECT
--Date_trunc(day, block_timestamp) AS Week
EXTRACT(HOUR FROM BLOCK_TIMESTAMP) AS Hour_Of_Day
,SUM(gas_price)/1e9 as "Gas Price"
FROM
ethereum.core.fact_transactions
WHERE
TX_HASH IN ( SELECT
DISTINCT TX_HASH
FROM
ethereum.defi.ez_dex_swaps
WHERE
BLOCK_TIMESTAMP >= CURRENT_DATE - INTERVAL '6 MONTHS'
AND PLATFORM LIKE '%uniswap%'
)
GROUP BY
1