[OC] The real 1-year car depreciation across 100+ popular models 🚗

I pulled the latest used-car prices from car sites for popular 2024 models. The “Used Price” is the golden data from our pipeline.

• Data Filters: 2024 only, 5k–50k mileage cars, grouped by Make + Model
• Metric: (Base 2024 MSRP – Used Avg Price) / Base 2024 MSRP. The depreciation percent is not very accurate for trucks or models with a wide MSRP range.
  -Data Source: https://mconomics.com/agents/car-residual
• Stack: BigQuery, chart.js, will use Looker next time

Remember to avoid most of the Red ones. 🚘 I got ripped off on my first Tesla back in 2022😭