Query editor
WITH ASSUMPTION AS (SELECT220000 AS base_verify_cost, /* using roughly experienced 220000 */27 AS eth_gas_price,200 AS matic_gas_price,5 AS op_gas_price), ETH_PRICE AS (SELECT2000 AS eth_usd), MATIC_PRICE AS (SELECT1 AS matic_usd), SHARP AS (SELECT'StarkNet/ImmutableX' AS name,SUM(1) AS verify_call,SUM(gas_used * gas_price / 1000000000000000000.0 * eth_usd) AS costFROM ethereum.transactionsCROSS JOIN ETH_PRICEWHERE(to = 0x47312450B3Ac8b5b8e247a6bB6d523e7605bDb60)AND successAND BYTEARRAY_SUBSTRING(data, 1, 4) = 0x9b3b76cc /* verifyProofAndRegister */), DYDX AS (SELECT'dydx(starkEx)' AS name,SUM(1) AS verify_call,SUM(gas_used * gas_price / 1000000000000000000.0 * eth_usd) AS costFROM ethereum.transactionsCROSS JOIN ETH_PRICEWHERE(to = 0xC8c212f11f6ACca77A7afeB7282dEBa5530eb46C)AND successAND BYTEARRAY_SUBSTRING(data, 1, 4) = 0x9b3b76cc /* verifyProofAndRegister */), ALL_ZKSTART_PROJECT AS (SELECTname,verify_call,costFROM SHARPUNION ALLSELECTname,verify_call,costFROM DYDX)SELECT*,(SELECTSUM(cost)FROM ALL_ZKSTART_PROJECT) AS zkstark_costFROM ALL_ZKSTART_PROJECT