Query editor
WITH ASSUMPTION AS (SELECT 50 AS eth_gas_price, 200 AS matic_gas_price, 5 AS op_gas_price),ETH_PRICE AS (SELECT 2000 AS eth_usd-- SELECT price AS eth_usd FROM prices.usd-- WHERE symbol = 'ETH'-- LIMIT 1),MATIC_PRICE AS (SELECT 1 AS matic_usd-- SELECT price AS matic_usd FROM prices.usd-- WHERE symbol = 'MATIC'-- LIMIT 1),WORLDCOIN AS (WITH POLYGON AS (SELECT'WORLDCOIN(polygon)' AS name,DATE_TRUNC('month', block_time) as mon,COUNT(*) AS verify_call,COUNT(*) AS bn256Pairing_call,ROUND(TRY_CAST(COUNT(*) * 79000 * matic_gas_price * matic_usd AS DECIMAL(38, 10)) / 1000000000.0,4) AS gasFROM polygon.tracesCROSS JOIN ASSUMPTIONCROSS JOIN ETH_PRICECROSS JOIN MATIC_PRICEWHERE(to = 0x515f06B36E6D3b707eAecBdeD18d8B384944c87f)AND BYTEARRAY_SUBSTRING(input, 1, 4) = 0x3bc778e3 /* verifyProof. -- TODO : more verifier address ? */AND block_number > 43171172 /* from deploy */GROUP BYDATE_TRUNC('month', block_time),matic_gas_price,matic_usd), MAINNET AS (SELECT'WORLDCOIN(ethereum)' AS name,DATE_TRUNC('month', block_time) as mon,COUNT(*) AS verify_call,COUNT(*) AS bn256Pairing_call,ROUND(TRY_CAST(COUNT(*) * 79000 * eth_gas_price * eth_usd AS DECIMAL(38, 10)) / 1000000000.0,4) AS gasFROM ethereum.tracesCROSS JOIN ASSUMPTIONCROSS JOIN ETH_PRICECROSS JOIN MATIC_PRICEWHERE(to = 0x163b09b4fE21177c455D850BD815B6D583732432)AND BYTEARRAY_SUBSTRING(input, 1, 4) = 0x3bc778e3 /* verifyProof. -- TODO : more verifier address ? */AND block_number > 17584562 /* from deploy */