Why your average beats the average price
The last two rows are the interesting ones, and they are never equal. A fixed spend buys more units when the price is low and fewer when it is high, so your money is weighted towards the cheap days without you doing anything. That pulls the price you paid below the simple average of the prices you paid it at.
Buy $100 a week for a year while the price falls from $95,000 to $77,000 and the prices average $86,000 — but you paid $85,673. The gap widens the more violently the price swings, which is the honest argument for buying on a schedule in a volatile asset: it is not that it times the market, it is that a fixed budget times itself.