Query editor
WITH blob_usage AS (SELECTdate_trunc('day', beacon_slot_time) as dt,ROUND(SUM(CASE WHEN blob_submitter_label = 'Base' THEN CAST(used_blob_byte_count AS DOUBLE PRECISION) ELSE 0 END) / CAST(1024 * 1024 * 1024 AS DOUBLE PRECISION), 4) as "Base",ROUND(SUM(CASE WHEN blob_submitter_label = 'Arbitrum One' THEN CAST(used_blob_byte_count AS DOUBLE PRECISION) ELSE 0 END) / CAST(1024 * 1024 * 1024 AS DOUBLE PRECISION), 4) as "Arbitrum",ROUND(SUM(CASE WHEN blob_submitter_label = 'OP Mainnet' THEN CAST(used_blob_byte_count AS DOUBLE PRECISION) ELSE 0 END) / CAST(1024 * 1024 * 1024 AS DOUBLE PRECISION), 4) as "OP Mainnet",ROUND(SUM(CASE WHEN blob_submitter_label = 'Scroll' THEN CAST(used_blob_byte_count AS DOUBLE PRECISION) ELSE 0 END) / CAST(1024 * 1024 * 1024 AS DOUBLE PRECISION), 4) as "Scroll",ROUND(SUM(CASE WHEN blob_submitter_label = 'Blast' THEN CAST(used_blob_byte_count AS DOUBLE PRECISION) ELSE 0 END) / CAST(1024 * 1024 * 1024 AS DOUBLE PRECISION), 4) as "Blast",ROUND(SUM(CASE WHEN blob_submitter_label = 'Linea' THEN CAST(used_blob_byte_count AS DOUBLE PRECISION) ELSE 0 END) / CAST(1024 * 1024 * 1024 AS DOUBLE PRECISION), 4) as "Linea",ROUND(SUM(CASE WHEN blob_submitter_label = 'Taiko' THEN CAST(used_blob_byte_count AS DOUBLE PRECISION) ELSE 0 END) / CAST(1024 * 1024 * 1024 AS DOUBLE PRECISION), 4) as "Taiko",ROUND(SUM(CASE WHEN blob_submitter_label = 'Unichain' THEN CAST(used_blob_byte_count AS DOUBLE PRECISION) ELSE 0 END) / CAST(1024 * 1024 * 1024 AS DOUBLE PRECISION), 4) as "Unichain",ROUND(SUM(CASE WHEN blob_submitter_label = 'World Chain' THEN CAST(used_blob_byte_count AS DOUBLE PRECISION) ELSE 0 END) / CAST(1024 * 1024 * 1024 AS DOUBLE PRECISION), 4) as "World Chain",ROUND((SUM(CAST(used_blob_byte_count AS DOUBLE PRECISION)) -SUM(CASE WHEN blob_submitter_label IN ('Base', 'Arbitrum One', 'OP Mainnet', 'Scroll', 'Blast', 'Linea', 'Taiko', 'Unichain', 'World Chain')THEN CAST(used_blob_byte_count AS DOUBLE PRECISION) ELSE 0 END)) / CAST(1024 * 1024 * 1024 AS DOUBLE PRECISION), 4) as "All Others"FROMethereum.blobsGROUP BY 1),blob_capacity AS (SELECTdate_trunc('day', time) AS dt,SUM(0.128 * CAST(blob_gas_used AS DOUBLE PRECISION) / 131072 / 1000.0) AS "Blob Capacity Purchased"FROMethereum.blocksWHEREnumber >= 19426589GROUP BY 1)SELECTbu.dt,bu."Base",bu."Arbitrum",bu."OP Mainnet",bu."Scroll",bu."Blast",bu."Linea",bu."Taiko",bu."Unichain",bu."World Chain",bu."All Others",bc."Blob Capacity Purchased",ROUND(bc."Blob Capacity Purchased" - (bu."Base" + bu."Arbitrum" + bu."OP Mainnet" + bu."Scroll" +bu."Blast" + bu."Linea" + bu."Taiko" + bu."Unichain" + bu."World Chain" + bu."All Others"), 4) AS "Unused Capacity"FROMblob_usage buJOINblob_capacity bc ON bu.dt = bc.dtORDER BYbu.dt;