Query editor
-- CoW rewards golden fixture: production Base protocol-fee raw-string-- precision diagnostic for the single authorized accounting week-- [2026-07-14T00:00:00Z, 2026-07-21T00:00:00Z).---- Catalog metadata reports `protocol_fee` as VARCHAR in-- dataset_prod_batch_data_base_2026_07. The retained performance query first-- cast that value to DOUBLE and formatted the binary64 result, which is not an-- atom-exact representation of the uploaded decimal string. This query keeps-- the raw VARCHAR for every production performance row. Returning the full-- scoped population is necessary because fractional parts can change a-- solver/auction aggregate even when each row has the same rounded atom.---- This is diagnostic-only. Even if every raw string rounds to the retained-- batch atom amount, the batch value can include partner fees and therefore-- cannot replace the exact operator fee-policy/native-price export required-- for canonical reward-cap replay.with scoped as (selectcast(auction_id as bigint) as auction_id,cast(solution_uid as varchar) as solution_uid_raw,cast(block_number as bigint) as block_number,cast(block_deadline as bigint) as block_deadline,cast(solver as varbinary) as solver,cast(tx_hash as varbinary) as tx_hash,winning_score as winning_score_raw,protocol_fee as protocol_fee_raw_varchar,cast(nullif(protocol_fee, 'null') as decimal(38, 18)) as protocol_fee_raw_decimal,cast(nullif(protocol_fee, 'null') as decimal(38, 0))as protocol_fee_raw_rounded_atoms,format('%.17f', cast(nullif(protocol_fee, 'null') as double))as protocol_fee_binary64_decimal,cast(nullif(format('%.17f', cast(nullif(protocol_fee, 'null') as double)),'null')as decimal(38, 0)) as protocol_fee_binary64_rounded_atoms,cast(nullif(protocol_fee, 'null') as decimal(38, 0))<> cast(nullif(format('%.17f', cast(nullif(protocol_fee, 'null') as double)),'null')as decimal(38, 0)) as binary64_changed_rounded_atomfrom dune.cowprotocol.dataset_prod_batch_data_base_2026_07wherecast(auction_id as bigint) between 28204067 and 28304206)selectauction_id,solution_uid_raw,block_number,block_deadline,solver,tx_hash,winning_score_raw,