What is the best way to handle LARGE amount of data?

I'm holding around 200k records of sales information. (All dummy data, deployed project can have unlimited amount -can be millions after a few years- of records.)

I need to access bar charts of these records, grouped by this week - last week (7 days x 2) this month - last month (28 to 31 days x 2) this year - last year (12 months x 2) sale price_totals.

I'm trying to do this and it's taking way too long (like 15 to 20 seconds long)

How would you approach a task like this? I'm also showing monthly and weekly sale price_totals as float numbers in dashboard homepage and that also takes around 10 seconds to load with 200k data.

Sales table :

If it's not too much to ask, if you could explain it in simpler terms or with some keywords that I could search tutorials with, that would be super helpful. I'm still a beginner in laravel.

Clockwork load time

Clockwork queries

Example table I need (this times 3, for weekly and yearly comparisons)

My Model

    public function index()
    {
        $this_week = $this->getWeekly();
        $last_week = $this->getWeekly( 1);

        $this_month = $this->getMonthly();
        $last_month = $this->getMonthly(1);

        $this_year = $this->getYearly();
        $last_year = $this->getYearly(1);

        return view('employee.stats.index', compact('this_week', 'last_week', 'this_month', 'last_month', 'this_year', 'last_year'));

    }

    public function getMonthly($minus = 0)
    {
        $data = Sales::query()
            ->whereYear('created_at', '=', date('Y'))
            ->where('status', '>', '1')
            ->orderBy('created_at')
            ->get(["price_total", 'created_at'])
            ->groupBy(fn($item) => intval($item->created_at->format('m')));


        $get_this = $data[date('m') - $minus]->groupBy(fn($item) => $item->created_at->format('d'));

        $this_arr = [];
        foreach ($get_this as $day){
            $this_arr[intval($day->first()->created_at->format('d'))] = $day->sum('price_total');
        }

        return json_encode($this_arr);

    }
    public function getWeekly($minus = 0)
    {
        $data = Sales::query()
            ->whereYear('created_at', '=', date('Y'))
            ->where('status', '>', '1')
            ->orderBy('created_at')
            ->get(["price_total", 'created_at'])
            ->groupBy(fn($item) => intval($item->created_at->format('W')));


        $get_this = $data[date('W') - $minus]->groupBy(fn($item) => $item->created_at->format('D'));


        $this_arr = [];
        foreach ($get_this as $day){
            $this_arr[$day->first()->created_at->format('D')] = $day->sum('price_total');
        }

        return json_encode($this_arr);

    }


    public function getYearly($minus = 0)
    {
        $data = Sales::query()
            ->whereYear('created_at', '=', date('Y') - $minus)
            ->where('status', '>', '1')
            ->orderBy('created_at')
            ->get(["price_total", 'created_at'])
            ->groupBy(fn($item) => $item->created_at->format('m'));


        $this_arr = [];
        foreach ($data as $day){
            $this_arr[intval($day->first()->created_at->format('m'))] = $day->sum('price_total');
        }

        return json_encode($this_arr);

    }

Suggestions I saw :

Caching : I can't cache this because new sale records are being inserted into sales table constantly and I need to show an up-to-date representation of sales.

Chunking : I don't think that works with my problem, because as I stated above I'm also showing monthly and weekly sale price_totals as float numbers in dashboard homepage and that also takes around 10 seconds to load with 200k data.

Thank you all so much for your comments and suggestions in advance. I've been dealing with this slowness issue for the last 4 days, I got 2 brand new grays in my beard and a migraine.