Release Indexer v8.0.0

What's Changed

• Revert "Add Orderbook Mid Price Cache (#2289)" by @adamfraser in #2333
• [OTE-784] Limit addresses for compliance check to dydx wallets with deposit by @jerryfan01234 in #2330
• Add Orderbook Mid Price Cache by @adamfraser in #2338
• Add current equity as a pnl tick. by @vincentwschau in #2335
• Add sql script latency metrics by @dydxwill in #2356
• enable username generation roundtable by @jerryfan01234 in #2361
• Use vault table rather than placeholder config flags to fetch vaults. by @vincentwschau in #2364
• Add oracle prices index on ("marketId", "effectiveAtHeight") by @dydxwill in #2368
• Include getting main subaccount equity / pnl for megavault PnL query. by @vincentwschau in #2376
• Add function to fetch availability zone id (#2326) by @roy-dydx in #2390
• Create consumer using rack id (#2352) by @roy-dydx in #2393
• [CT-629] Fix entryPrice calc by @dydxwill in #2415
• Filter out to single tick per interval. by @vincentwschau in #2403
• Revert "[CT-629] Fix entryPrice calc" by @dydxwill in #2425
• [OTE-846] Bazooka sequential clear by @jerryfan01234 in #2423
• Fix issue with flaky candle test by @adamfraser in #2430
• Return undefined from getOrderbookMidPriceMap by @adamfraser in #2441
• Split affiliate info fees by taker and maker by @jerryfan01234 in #2439
• Fix bug with PnL aggregation. by @vincentwschau in #2446
• Update indexer testnet url by @Christopher-Li in #2312
• Get latest hourly tick to compute final tick for megavault PnL. by @vincentwschau in #2454
• [OTE-863] update username generation query by @affanv14 in #2482
• [CT-629] Fix entryPrice calc by @dydxwill in #2455
• Fix test flakiness due to using inconsistent time. by @vincentwschau in #2485
• Don't increment messageId for custom ping messages by @dydxwill in #2493
• [OTE-876] update roundtable loop timings for instrumentation and uncrossing by @affanv14 in #2494
• [OTE-877] deprecate OI indexer update event by @affanv14 in #2499
• [OTE-880] Emit log in case of collisions by @affanv14 in #2500
• Remove orderbook cache roundtable job by @adamfraser in #2510
• Add config var to exclude specific stateful order ids from being processed. by @vincentwschau in #2513
• add wallet when transfer to subaccount by @jerryfan01234 in #2519
• update migration to stop excessive consumption of computation by @affanv14 in #2521
• Get funding index maps for vault positions in chunks. by @vincentwschau in #2525
• Vulcan topic to 210 partitions by @roy-dydx in #2528
• Fix typo and add test for invalid vaults. by @vincentwschau in #2535
• Add missing fields to perpetual markets kafka update by @shrenujb in #2539
• De-duplicate and filter out invalid pnl ticks for megavault. by @vincentwschau in #2540
• [CT-1307] Make pnl ticks computation consistent within a transaction. by @vincentwschau in #2548
• Dont set default value for fills rows by @adamfraser in #2552
• fix(affiliates): [OTE-898] Refactor subaccount username generation by @teddyding in #2569
• Allow configuring day vault PnL starts. by @vincentwschau in #2570
• Use alphanumeric suffix for username by @teddyding in #2573
• fix(affiliates): Generate username with address, not subaccount id by @teddyding in #2575
• Use repeatable read for pnl tick generation. by @vincentwschau in #2578
• fix(affiliate): Use DB transaction for username generation; add more stats for update… by @teddyding in #2579
• Fix username generator unit test by @teddyding in #2582
• Optimize query for latest pnl tick at specific time. by @vincentwschau in #2599
• Revert "[CT-629] Fix entryPrice calc (#2455)" by @vincentwschau in #2600
• Use materialized view for vault pnl data. by @vincentwschau in #2598
• Start refresh vault PnL task. by @vincentwschau in #2603
• Candles Cache Improvements by @adamfraser in #2590
• [TRA-507] Add Indexer changes for UpgradeIsolatedPerpetualToCross by @hwray in #2597
• [TRA-890] Return nearest hour PnL as final data point for vaults pnl. by @vincentwschau in #2616
• Fix flaky Candles test by @adamfraser in #2619
• fix transfers parent SA API for external addresses in transfers by @shrenujb in #2630
• Remove unused line in transfer controller by @teddyding in #2632
• Fix uncaught postgres error (backport #2635) by @mergify in #2641
• Increase orderbook mid price cache duration to 60 seconds (backport #2633) by @mergify in #2642
• Improve query to find candles map. (backport #2650) by @mergify in #2670
• Improve vault start pnl query. (backport #2664) by @mergify in #2669

Full Changelog: indexer/v7.0.12...indexer/v8.0.0