.
date, SUM((CAST(receipt_blob_gas_used AS NUMERIC) * CAST(receipt_blob_gas_price AS NUMERIC))) AS gas_spend FROM bigquery-public-data.crypto_ethereum.transactions WHERE DATE(block_timestamp) > '2024-04-13' GROUP BY date ORDER BY date DESC """ # Run the query query_job = client.query(query) results =