Query editor
-- Public source: CoW Protocol Weekly Solver Rewards Report dashboard 195335-- and its per-solver definition query 6081990.-- The dashboard itself warns that its quote/performance attribution omits-- consistency rewards. The application reconciles only published_total_cow-- to the Safe receipt; the two component columns are audit metadata.SELECTdate_parse(payout_date, '%d/%m/%Y') AS payout_date,date_parse(date, '%d/%m/%Y') AS payment_date,lower(CAST(hash__unique_id AS varchar)) AS payout_tx_hash,lower(CAST(other_parties AS varchar)) AS reported_reward_safe_address,other_parties_aliases_contacts AS solver_label,network,CAST(outgoing_volume AS varchar) AS published_total_cow,CAST(quote_rewards AS varchar) AS published_quote_cow,CAST(performance_rewards AS varchar) AS published_performance_cowFROM dune.cowprotocol.dataset_solver_rewards_allocation_to_networkWHERE other_parties_aliases_contacts = '{{solver_label}}'AND network = '{{network}}'AND outgoing_asset_unique_symbol = 'COW'AND date_parse(payout_date, '%d/%m/%Y') >= timestamp '{{from_datetime}}'AND date_parse(payout_date, '%d/%m/%Y') < timestamp '{{to_datetime}}'ORDER BY payout_date, payment_date, payout_tx_hash, published_total_cow