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)DYDX AS (SELECTDATE_TRUNC('month', block_time) AS mon,'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 */AND block_number > 12004790GROUP BYDATE_TRUNC('month', block_time))SELECT * FROM DYDX