Query editor
WITH wdl_requests AS (SELECTblock_time AS requested_at, varbinary_to_uint256(topic1) AS request_idFROM ethereum.logsWHERE contract_address = 0x7d5706f6ef3F89B3951E23e557CDFBC3239D4E2cAND topic0 = 0x52ec6b5a2ebc56de823b66702bbb52ae3c6c2859f806c7628c374f32147b5940 -- requestAND block_time > current_timestamp - interval '{{last_n_day}}' day), wdl_finalization AS (SELECTvarbinary_to_uint256(varbinary_substring(input, 5)) AS request_id_finalized, min(block_time) AS finalized_atFROM ethereum.tracesWHERE "to" = 0x7d5706f6ef3f89b3951e23e557cdfbc3239d4e2cAND varbinary_starts_with(input, 0x54768571) -- finalizeRequestsGROUP BY 1)SELECTdate_trunc('day', req.requested_at) AS requested_date, req.request_id, min(date_diff('day', req.requested_at, COALESCE(fin.finalized_at, current_timestamp))) AS days_waited, fin.finalized_at IS NOT NULL AS is_finalizedFROM wdl_requests reqLEFT JOIN wdl_finalization finON req.request_id <= fin.request_id_finalizedGROUP BY 1, 2, 4