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)/* gas limit before entering the verifier.sol: 4,258,232 *//* gas limit after: 4,141,264 *//* total spending: 116968 *//* https://etherscan.io/tx/0xcdd129cf9ec40f2048bf12d4ec1af7362f9ea1899d3b9254e96eb1a607a1f39b/advanced#internal */LOOPRING AS (SELECTDATE_TRUNC('month', call_block_time) as mon,'LOOPRING' AS name,COUNT(*) AS verify_call,ROUND(TRY_CAST(COUNT(*) * base_verify_cost * eth_gas_price * eth_usd AS DECIMAL(38, 10)) / 1000000000.0,4) AS costFROM loopring_ethereum.LoopringIOExchangeOwner_call_submitBlocksWithCallbacksCROSS JOIN ASSUMPTIONCROSS JOIN ETH_PRICECROSS JOIN MATIC_PRICEWHEREcall_successGROUP BYeth_gas_price,base_verify_cost,eth_usd,DATE_TRUNC('month', call_block_time))SELECT * FROM LOOPRING