Query editor
WITH ASSUMPTION AS (SELECT220000 AS base_verify_cost, -- using roughly experienced 22000027 AS eth_gas_price,200 AS matic_gas_price,5 AS op_gas_price),ETH_PRICE AS (SELECT2000 AS eth_usd),/* gas limit before entering the verifier.sol: 4,667,846 *//* gas limit after: 4,078,049 *//* total spending: 589,797 *//* source: https://etherscan.io/tx/0x65f1192061bd0c3690cec8e201a29c60a10aff599a69b55954caf108c26da294/advanced#internal */NOCTURNE AS (SELECT--*'NOCTURNE' AS name,COUNT(*) AS verify_call,ROUND(TRY_CAST(COUNT(*) * 589797 * eth_gas_price * eth_usd AS DECIMAL(38, 10)) / 1000000000.0,4) AS costFROM ethereum.tracesCROSS JOIN ASSUMPTIONCROSS JOIN ETH_PRICEWHERE(to = 0xA561492dFC1A90418Cc8b9577204d56C17CB32Ff)AND BYTEARRAY_SUBSTRING(input, 1, 4) = 0x2a1e64b6 /* processBundle*/AND block_number > 18524519 /* from deploy */GROUP BYeth_gas_price,eth_usd)SELECT * FROM NOCTURNE