Query editor
-- Six already-qualified, unpriced fees. No fee-recipient discovery.-- Every scan uses explicit date partitions; no query refresh or materialization.-- Nearest prior executed calls are observations, not claimed exact fee-block state.WITH targets(id, fee_tx, fee_block, cutoff, input_token, feed) AS (VALUES(0, 0x3b658508f9e20794c7ba696907abfe3e901528fa3403fa8737f8dba6606b9a35, BIGINT '435414365', TIMESTAMP '2026-02-24 08:25:19', 0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9, 0x3f3f5df88dc9f13eac63df89ec16ef6e7e25dde7),(1, 0x37adb3d3482cfc8796e7fbb00a55b7835b7abcd2ac9eb505aed890df889010b8, BIGINT '443818427', TIMESTAMP '2026-03-20 15:41:13', 0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9, 0x3f3f5df88dc9f13eac63df89ec16ef6e7e25dde7),(2, 0x3c798b55480399acee844b6e7441e2a780d431cfe2422226238ffa39195c3c4b, BIGINT '488382106', TIMESTAMP '2026-07-27 21:17:31', 0xaf88d065e77c8cc2239327c5edb3a432268e5831, 0x50834f3163758fcc1df9973b6e91f0f0f0434ad3),(3, 0x66ab7369a9e25a8bebe0d28950cc4b16b8454bd9e8d93a80a29bc36781ae4f4e, BIGINT '430768833', TIMESTAMP '2026-02-10 22:48:58', 0xaf88d065e77c8cc2239327c5edb3a432268e5831, 0x50834f3163758fcc1df9973b6e91f0f0f0434ad3),(4, 0x33de22e2000367e8a66d0425be4862603eb0d194c87277af305c495798f082a8, BIGINT '454897777', TIMESTAMP '2026-04-21 18:20:25', 0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9, 0x3f3f5df88dc9f13eac63df89ec16ef6e7e25dde7),(5, 0x30603f537996345fb38fc58fc56f19683fc9e7b9ae2d285599e67e6e73184dc2, BIGINT '496845231', TIMESTAMP '2026-08-21 11:31:45', 0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9, 0x3f3f5df88dc9f13eac63df89ec16ef6e7e25dde7)), observations AS (SELECT t.id AS target_id, 'FEED_ROUND' AS observation_kind,q.contract_address, q.call_tx_hash, q.call_tx_index, q.call_trace_address,q.call_block_number, q.call_block_time, CAST(q.output_answer AS varchar) AS raw_value, CAST(q.output_roundId AS varchar) AS round_id, CAST(q.output_startedAt AS varchar) AS started_at, CAST(q.output_updatedAt AS varchar) AS updated_at, CAST(q.output_answeredInRound AS varchar) AS answered_in_roundFROM chainlink_arbitrum.eacaggregatorproxy_call_latestrounddata qJOIN targets t ON q.contract_address = t.feedAND q.call_block_number < t.fee_blockAND q.call_block_time >= t.cutoff - INTERVAL '1' DAYAND q.call_block_time <= t.cutoffWHERE q.call_success AND q.call_block_date IN (DATE '2026-02-09', DATE '2026-02-10', DATE '2026-02-23', DATE '2026-02-24', DATE '2026-03-19', DATE '2026-03-20', DATE '2026-04-20', DATE '2026-04-21', DATE '2026-07-26', DATE '2026-07-27', DATE '2026-08-20', DATE '2026-08-21')UNION ALLSELECT t.id AS target_id, 'SEQUENCER' AS observation_kind,q.contract_address, q.call_tx_hash, q.call_tx_index, q.call_trace_address,q.call_block_number, q.call_block_time, CAST(q.output_answer AS varchar) AS raw_value, CAST(q.output_roundId AS varchar) AS round_id, CAST(q.output_startedAt AS varchar) AS started_at, CAST(q.output_updatedAt AS varchar) AS updated_at, CAST(q.output_answeredInRound AS varchar) AS answered_in_roundFROM chainlink_arbitrum.eacaggregatorproxy_call_latestrounddata qJOIN targets t ON q.contract_address = 0xfdb631f5ee196f0ed6faa767959853a9f217697dAND q.call_block_number < t.fee_blockAND q.call_block_time >= t.cutoff - INTERVAL '1' DAYAND q.call_block_time <= t.cutoffWHERE q.call_success AND q.call_block_date IN (DATE '2026-02-09', DATE '2026-02-10', DATE '2026-02-23', DATE '2026-02-24', DATE '2026-03-19', DATE '2026-03-20', DATE '2026-04-20', DATE '2026-04-21', DATE '2026-07-26', DATE '2026-07-27', DATE '2026-08-20', DATE '2026-08-21')UNION ALLSELECT t.id AS target_id, 'FEED_DECIMALS' AS observation_kind,q.contract_address, q.call_tx_hash, q.call_tx_index, q.call_trace_address,q.call_block_number, q.call_block_time, CAST(q.output_0 AS varchar) AS raw_value, CAST(NULL AS varchar) AS round_id, CAST(NULL AS varchar) AS started_at, CAST(NULL AS varchar) AS updated_at, CAST(NULL AS varchar) AS answered_in_roundFROM chainlink_arbitrum.eacaggregatorproxy_call_decimals qJOIN targets t ON q.contract_address = t.feedAND q.call_block_number < t.fee_blockAND q.call_block_time >= t.cutoff - INTERVAL '7' DAYAND q.call_block_time <= t.cutoffWHERE q.call_success AND q.call_block_date IN (DATE '2026-02-03', DATE '2026-02-04', DATE '2026-02-05', DATE '2026-02-06', DATE '2026-02-07', DATE '2026-02-08', DATE '2026-02-09', DATE '2026-02-10', DATE '2026-02-17', DATE '2026-02-18', DATE '2026-02-19', DATE '2026-02-20', DATE '2026-02-21', DATE '2026-02-22', DATE '2026-02-23', DATE '2026-02-24', DATE '2026-03-13', DATE '2026-03-14', DATE '2026-03-15', DATE '2026-03-16', DATE '2026-03-17', DATE '2026-03-18', DATE '2026-03-19', DATE '2026-03-20', DATE '2026-04-14', DATE '2026-04-15', DATE '2026-04-16', DATE '2026-04-17', DATE '2026-04-18', DATE '2026-04-19', DATE '2026-04-20', DATE '2026-04-21', DATE '2026-07-20', DATE '2026-07-21', DATE '2026-07-22', DATE '2026-07-23', DATE '2026-07-24', DATE '2026-07-25', DATE '2026-07-26', DATE '2026-07-27', DATE '2026-08-14', DATE '2026-08-15', DATE '2026-08-16', DATE '2026-08-17', DATE '2026-08-18', DATE '2026-08-19', DATE '2026-08-20', DATE '2026-08-21')UNION ALLSELECT t.id AS target_id, 'TOKEN_DECIMALS' AS observation_kind,q.contract_address, q.call_tx_hash, q.call_tx_index, q.call_trace_address,q.call_block_number, q.call_block_time, CAST(q.output_0 AS varchar) AS raw_value, CAST(NULL AS varchar) AS round_id, CAST(NULL AS varchar) AS started_at, CAST(NULL AS varchar) AS updated_at, CAST(NULL AS varchar) AS answered_in_roundFROM circle_arbitrum.fiattokenv2_2_call_decimals qJOIN targets t ON q.contract_address = t.input_token AND t.input_token = 0xaf88d065e77c8cc2239327c5edb3a432268e5831AND q.call_block_number < t.fee_blockAND q.call_block_time >= t.cutoff - INTERVAL '7' DAYAND q.call_block_time <= t.cutoffWHERE q.call_success AND q.call_block_date IN (DATE '2026-02-03', DATE '2026-02-04', DATE '2026-02-05', DATE '2026-02-06', DATE '2026-02-07', DATE '2026-02-08', DATE '2026-02-09', DATE '2026-02-10', DATE '2026-02-17', DATE '2026-02-18', DATE '2026-02-19', DATE '2026-02-20', DATE '2026-02-21', DATE '2026-02-22', DATE '2026-02-23', DATE '2026-02-24', DATE '2026-03-13', DATE '2026-03-14', DATE '2026-03-15', DATE '2026-03-16', DATE '2026-03-17', DATE '2026-03-18', DATE '2026-03-19', DATE '2026-03-20', DATE '2026-04-14', DATE '2026-04-15', DATE '2026-04-16', DATE '2026-04-17', DATE '2026-04-18', DATE '2026-04-19', DATE '2026-04-20', DATE '2026-04-21', DATE '2026-07-20', DATE '2026-07-21', DATE '2026-07-22', DATE '2026-07-23', DATE '2026-07-24', DATE '2026-07-25', DATE '2026-07-26', DATE '2026-07-27', DATE '2026-08-14', DATE '2026-08-15', DATE '2026-08-16', DATE '2026-08-17', DATE '2026-08-18', DATE '2026-08-19', DATE '2026-08-20', DATE '2026-08-21')UNION ALLSELECT t.id AS target_id, 'TOKEN_DECIMALS' AS observation_kind,q.contract_address, q.call_tx_hash, q.call_tx_index, q.call_trace_address,q.call_block_number, q.call_block_time, CAST(q.output_0 AS varchar) AS raw_value, CAST(NULL AS varchar) AS round_id, CAST(NULL AS varchar) AS started_at, CAST(NULL AS varchar) AS updated_at, CAST(NULL AS varchar) AS answered_in_roundFROM tether_arbitrum.arbitrumextension_call_decimals qJOIN targets t ON q.contract_address = t.input_token AND t.input_token = 0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9AND q.call_block_number < t.fee_blockAND q.call_block_time >= t.cutoff - INTERVAL '7' DAYAND q.call_block_time <= t.cutoff