Query editor
withfirst_block_of_week AS (SELECTdate_trunc('week', time) as week, replace(cast(to_big_endian_32(cast(min(number) AS integer)) AS varchar), '0x0', '0x') as block_number_hexFROM ethereum.blocksWHERE time > now() - INTERVAL '2' monthGROUP BY 1),raw_rpc_result AS (SELECT http_post((SELECT q_key FROM query_3574377),concat('{"method":"eth_call","params":[{"from": null,"to":"0xc3d688b66703497daa19211eedff47f25384cdc3","data":"0x7eb71131"}, "',block_number_hex,'"],"id":1,"jsonrpc":"2.0"}'),ARRAY['Content-Type: application/json']) as result_util, http_post((SELECT q_key FROM query_3574377),concat('{"method":"eth_call","params":[{"from": null,"to":"0xc3d688b66703497daa19211eedff47f25384cdc3","data":"0x0902f1ac"}, "',block_number_hex,'"],"id":1,"jsonrpc":"2.0"}'),ARRAY['Content-Type: application/json']) as result_reserve, f.*FROM first_block_of_week f), raw_all_data as (SELECTweek, json_value(result_util, 'lax $.result') as utilization_rate, json_value(result_reserve, 'lax $.result') as reserves, json_value(http_post((SELECT q_key FROM query_3574377),concat('{"method":"eth_call","params":[{"from": null,"to":"0xc3d688b66703497daa19211eedff47f25384cdc3","data":"0xd955759d',substring(json_value(result_util, 'lax $.result'),3),'"}, "',block_number_hex,'"],"id":1,"jsonrpc":"2.0"}'),ARRAY['Content-Type: application/json']), 'lax $.result') as supply_rate, json_value(http_post((SELECT q_key FROM query_3574377),concat('{"method":"eth_call","params":[{"from": null,"to":"0xc3d688b66703497daa19211eedff47f25384cdc3","data":"0x9fa83b5a',substring(json_value(result_util, 'lax $.result'),3),'"}, "',block_number_hex,'"],"id":1,"jsonrpc":"2.0"}'),ARRAY['Content-Type: application/json']), 'lax $.result') as borrow_rateFROM raw_rpc_result)SELECT