SELECT
DATE_TRUNC('day', BLOCK_TIMESTAMP) AS DAY,
AVG(
CASE
WHEN BLOB_VERSIONED_HASHES IS NOT NULL THEN (BLOB_GAS_USED)
ELSE NULL
END
) AS avg_blob_gas_used,
AVG(
CASE
WHEN BLOB_VERSIONED_HASHES IS NULL THEN GAS_USED
ELSE NULL
END
) AS avg_gas_used
FROM
ethereum.core.fact_transactions
WHERE
block_timestamp >= Date '2024-02-01'
GROUP BY
DAY