Query editor
with offers as (select distinct(evt_tx_hash) as txn, makerfrom rubicon_optimism.RubiconMarket_evt_LogMakewhere evt_block_time >= date '2021-07-15'),offers_w_gas as (select o.txn, o.maker, (((cast(t.gas_price as bigint) * t.gas_used) + (t.l1_gas_used * t.l1_gas_price * t.l1_fee_scalar)) / power(10,18)) as gas_costfrom offers oleft join optimism.transactions ton o.txn = t.hash)select sum(gas_cost) as total_gas_spendfrom offers_w_gas--select hash, (((cast(gas_price as bigint) * gas_used) + (l1_gas_used * l1_gas_price * l1_fee_scalar)) / power(10,18)) as l2 -- ((gas_price * gas_used) + (l1_gas_used * l1_gas_price * l1_fee_scalar)) as gas_spent--from optimism.transactions--limit 10-- (gas_price * gas) + (l1 gas used * l1 gas price * l1 gas scalar)