SELECT
SUM(GAS_PRICE) AS total_GAS_PRICE,
AVG(GAS_PRICE) AS avg_GAS_PRICE,
MEDIAN(GAS_PRICE) AS median_GAS_PRICE,
MIN(GAS_PRICE) AS min_GAS_PRICE,
MAX(GAS_PRICE) AS max_GAS_PRICE
FROM ethereum.core.fact_transactions
WHERE block_timestamp::DATE BETWEEN '2022-07-01' AND '2022-07-31'