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),MATIC_PRICE AS (SELECT1 AS matic_usd),--DATE_TRUNC('month', call_block_time) as mon,--DATE_TRUNC('month', call_block_time)SHARP AS (SELECTDATE_TRUNC('month', block_time) as mon,'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 */AND block_number > 13480127GROUP BYDATE_TRUNC('month', block_time))SELECT * FROM SHARP