[Epic] 9.1 Streamline mainnet payouts process

[harisang]

Epic label: E:9.1
Planned start date: 09-09-2024 (Sep, 2024)
Due date: 04-10-2024 (Oct, 2024)

Summary

The goal is to streamline the mainnet payouts script and verification of the proposed transaction, with a heavy focus on slippage accounting, that needs to be more robust and faster to compute. Additionally, we want to provide clean data on Dune that can be used by anyone to get the complete breakdown of each tx/auction, in terms of fees collected, rewards, and slippage.

Acceptance Criteria

Payouts script should run reliably every Tuesday with a runtime that is no more than 5min, so that it can be easily re-triggered if needed. The proposed tx should be easily verifiable with relevant data provided on Dune, in the form of a Dune dashboard that correctly showcases all necessary info relevant to the proposed tx.

Additionally, and very importantly, we should a very robust price feed, with prices from multiple sources per transaction and token imbalance, and moreover start using this price feed for evaluating slippage.

Tasks

• Task: Migrate all queries used in mainnet solver accounting to this repo dune-queries#28
• Task: Enrich and productionize price feeds for mainnet token imbalances token-imbalances#60
• Task: Simplify dune-sync jobs and use Dune api to upload new data on Dune dune-sync#110
• Make payouts script compatible with above changes and execute first payout on Oct 8, 2024, using the improved accounting.