Query editor
with prep as (selectdate_parse(payout_date, '%d/%m/%Y') as payout_date--, regexp_extract(other_parties_aliases_contacts, 'Solver - (.*)', 1) as solver,replace(replace(replace(other_parties_aliases_contacts, 'Solver', ''), 'Rewards', ''), ' - ', '') as solver,sum(outgoing_volume) as total_rewards_cow,sum(quote_rewards) as quote_rewards_cow,sum(performance_rewards) as performance_rewards_cow,sum(outgoing_volume*p.price) as total_rewards_usd,sum(quote_rewards*p.price) as quote_rewards_usd,sum(performance_rewards*p.price) as performance_rewards_usdfrom dune.cowprotocol.dataset_solver_rewards_allocation_to_network as rleft join prices.day as pon date_parse(r.payout_date,'%d/%m/%Y')=p.timestampand p.blockchain='ethereum'and p.contract_address=0xdef1ca1fb7fbcdc777520aa7f396b4e015f497abwhere network in (select chain from unnest(split('{{network}}', ',')) as t(chain))and date_parse(payout_date, '%d/%m/%Y') >= timestamp '{{start_date}}'group by 1,2)selectpayout_date,solver,total_rewards_{{unit}} as total_rewards,quote_rewards_{{unit}} as quote_rewards,performance_rewards_{{unit}} as performance_rewardsfrom prepwhere solver = 'Rizzolver'order by 1,2