MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE stock_prices1 (country_exchange_code VARCHAR(2), stock_code VARCHAR(4), date DATE, close FLOAT, PRIMARY KEY (country_exchange_code,stock_code,date));

INSERT INTO stock_prices1 VALUES
    ("T", "1301",   '2019-10-29',   75.2),
    ("T", "1301",   '2019-10-30',   76.6),
    ("T", "1301",   '2019-10-31',   77.6),
    ("T", "1301",   '2019-11-01',   77.2)
  ;

CREATE TABLE stock_shares1 (country_exchange_code VARCHAR(2), stock_code VARCHAR(4), Num_Shares INT, PRIMARY KEY (country_exchange_code,stock_code));    

INSERT INTO stock_shares1 VALUES
    ("T", "1301",   241587962),
    ("T", "1332",   369875187),
    ("T", "1333",   958621587);
SELECT Stock_Code, Date, Num_Shares, Close,

        Num_Shares * (last_value(Close) OVER (PARTITION BY Stock_Code
         ORDER BY Date 
         ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING)) AS Mkt_Cap
    FROM stock_prices1 LEFT JOIN stock_shares1 USING (Country_Exchange_Code, Stock_Code)
    WHERE Country_Exchange_Code = 'T' AND Date >= '2019-10-29' 
    ORDER BY Stock_Code, Date;


Stock_Code
Date
Num_Shares
Close
Mkt_Cap


1301
2019-10-29
241587962
75.2
18650589929.13205

1301
2019-10-30
241587962
76.6
18650589929.13205

1301
2019-10-31
241587962
77.6
18650589929.13205

1301
2019-11-01
241587962
77.2
18650589929.13205


SELECT Stock_Code, Date, Num_Shares, Close,

        last_value(Close) OVER (PARTITION BY Stock_Code
         ORDER BY Date 
         ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) AS Mkt_Cap
    FROM stock_prices1 LEFT JOIN stock_shares1 USING (Country_Exchange_Code, Stock_Code)
    WHERE Country_Exchange_Code = 'T' AND Date >= '2019-10-29' 
    ORDER BY Stock_Code, Date;


Stock_Code
Date
Num_Shares
Close
Mkt_Cap


1301
2019-10-29
241587962
75.2
77.19999694824219

1301
2019-10-30
241587962
76.6
77.19999694824219

1301
2019-10-31
241587962
77.6
77.19999694824219

1301
2019-11-01
241587962
77.2
77.19999694824219


CREATE TABLE stock_prices2 (country_exchange_code VARCHAR(2), stock_code VARCHAR(4), date DATE, close FLOAT, PRIMARY KEY (country_exchange_code,stock_code,date));

INSERT INTO stock_prices2 VALUES

   ("T", "1301",   '2019-10-29',   75.2),
    ("T", "1301",   '2019-10-30',   76.6),
    ("T", "1301",   '2019-10-31',   77.6),
    ("T", "1301",   '2019-11-01',   77.2),
    ("T", "1332",   '2019-10-29',   52.5),
    ("T", "1332",   '2019-10-30',   49.7),
    ("T", "1332",   '2019-10-31',   50.8),
    ("T", "1332",   '2019-11-01',   50.4)
;

CREATE TABLE stock_shares2 (country_exchange_code VARCHAR(2), stock_code VARCHAR(4), Num_Shares INT, PRIMARY KEY (country_exchange_code,stock_code));    

INSERT INTO stock_shares2 VALUES
    ("T", "1301",   241587962),
    ("T", "1332",   369875187),
    ("T", "1333",   958621597);
SELECT Stock_Code, Date, Num_Shares, Close,

        Num_Shares * (last_value(Close) OVER (PARTITION BY Stock_Code
         ORDER BY Date 
         ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING)) AS Mkt_Cap
    FROM stock_prices2 LEFT JOIN stock_shares2 USING (Country_Exchange_Code, Stock_Code)
    WHERE Country_Exchange_Code = 'T' AND Date >= '2019-10-29' 
    ORDER BY Stock_Code, Date;


Stock_Code
Date
Num_Shares
Close
Mkt_Cap


1301
2019-10-29
241587962
75.2
null

1301
2019-10-30
241587962
76.6
18650589929.13205

1301
2019-10-31
241587962
77.6
18650589929.13205

1301
2019-11-01
241587962
77.2
18650589929.13205

1332
2019-10-29
369875187
52.5
18641709989.184746

1332
2019-10-30
369875187
49.7
18641709989.184746

1332
2019-10-31
369875187
50.8
18641709989.184746

1332
2019-11-01
369875187
50.4
18641709989.184746


SELECT Stock_Code, Date, Num_Shares, Close,

        1 + 1 * last_value(Close) OVER (PARTITION BY Stock_Code
         ORDER BY Date 
         ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) AS Mkt_Cap
    FROM stock_prices2 LEFT JOIN stock_shares2 USING (Country_Exchange_Code, Stock_Code)
    WHERE Country_Exchange_Code = 'T' AND Date >= '2019-10-29' 
    ORDER BY Stock_Code, Date;


Stock_Code
Date
Num_Shares
Close
Mkt_Cap


1301
2019-10-29
241587962
75.2
null

1301
2019-10-30
241587962
76.6
78.19999694824219

1301
2019-10-31
241587962
77.6
78.19999694824219

1301
2019-11-01
241587962
77.2
78.19999694824219

1332
2019-10-29
369875187
52.5
51.400001525878906

1332
2019-10-30
369875187
49.7
51.400001525878906

1332
2019-10-31
369875187
50.8
51.400001525878906

1332
2019-11-01
369875187
50.4
51.400001525878906


SELECT Stock_Code, Date, Num_Shares, Close,

        last_value(Close) OVER (PARTITION BY Stock_Code
         ORDER BY Date 
         ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) AS Mkt_Cap
    FROM stock_prices2 LEFT JOIN stock_shares2 USING (Country_Exchange_Code, Stock_Code)
    WHERE Country_Exchange_Code = 'T' AND Date >= '2019-10-29' 
    ORDER BY Stock_Code, Date;


Stock_Code
Date
Num_Shares
Close
Mkt_Cap


1301
2019-10-29
241587962
75.2
77.19999694824219

1301
2019-10-30
241587962
76.6
77.19999694824219

1301
2019-10-31
241587962
77.6
77.19999694824219

1301
2019-11-01
241587962
77.2
77.19999694824219

1332
2019-10-29
369875187
52.5
50.400001525878906

1332
2019-10-30
369875187
49.7
50.400001525878906

1332
2019-10-31
369875187
50.8
50.400001525878906

1332
2019-11-01
369875187
50.4
50.400001525878906


SELECT Stock_Code, Date, Num_Shares, Close,

        last_value(Close) OVER (PARTITION BY Stock_Code
         ORDER BY Date 
         ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) AS Mkt_Cap
    FROM stock_prices2 LEFT JOIN stock_shares2 USING (Country_Exchange_Code, Stock_Code)
    WHERE Country_Exchange_Code = 'T' AND Date >= '2019-10-29' 
    ORDER BY Stock_Code, Date;


Stock_Code
Date
Num_Shares
Close
Mkt_Cap


1301
2019-10-29
241587962
75.2
77.19999694824219

1301
2019-10-30
241587962
76.6
77.19999694824219

1301
2019-10-31
241587962
77.6
77.19999694824219

1301
2019-11-01
241587962
77.2
77.19999694824219

1332
2019-10-29
369875187
52.5
50.400001525878906

1332
2019-10-30
369875187
49.7
50.400001525878906

1332
2019-10-31
369875187
50.8
50.400001525878906

1332
2019-11-01
369875187
50.4
50.400001525878906


CREATE TABLE stock_prices (country_exchange_code VARCHAR(2), stock_code VARCHAR(4), date DATE, close FLOAT, PRIMARY KEY (country_exchange_code,stock_code,date));

INSERT INTO stock_prices VALUES

   ("T", "1301",   '2019-10-29',   75.2),
    ("T", "1301",   '2019-10-30',   76.6),
    ("T", "1301",   '2019-10-31',   77.6),
    ("T", "1301",   '2019-11-01',   77.2),
    ("T", "1332",   '2019-10-29',   52.5),
    ("T", "1332",   '2019-10-30',   49.7),
    ("T", "1332",   '2019-10-31',   50.8),
    ("T", "1332",   '2019-11-01',   50.4),
    ("T", "1333",   '2019-10-29',   13.9),
    ("T", "1333",   '2019-10-30',   13.8),
    ("T", "1333",   '2019-10-31',   14.3),
    ("T", "1333",   '2019-11-01',   14.4);

CREATE TABLE stock_shares (country_exchange_code VARCHAR(2), stock_code VARCHAR(4), Num_Shares INT, PRIMARY KEY (country_exchange_code,stock_code));    

INSERT INTO stock_shares VALUES
    ("T", "1301",   241587962),
    ("T", "1332",   369875187),
    ("T", "1333",   958621597);
SELECT Stock_Code, Date, Num_Shares, Close,

        Num_Shares * (last_value(Close) OVER (PARTITION BY Stock_Code
         ORDER BY Date 
         ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING)) AS Mkt_Cap
    FROM stock_prices LEFT JOIN stock_shares USING (Country_Exchange_Code, Stock_Code)
    WHERE Country_Exchange_Code = 'T' AND Date >= '2019-10-29' 
    ORDER BY Stock_Code, Date;


Stock_Code
Date
Num_Shares
Close
Mkt_Cap


1301
2019-10-29
241587962
75.2
null

1301
2019-10-30
241587962
76.6
18650589929.13205

1301
2019-10-31
241587962
77.6
18650589929.13205

1301
2019-11-01
241587962
77.2
18650589929.13205

1332
2019-10-29
369875187
52.5
null

1332
2019-10-30
369875187
49.7
18641709989.184746

1332
2019-10-31
369875187
50.8
18641709989.184746

1332
2019-11-01
369875187
50.4
18641709989.184746

1333
2019-10-29
958621597
13.9
13804150631.114882

1333
2019-10-30
958621597
13.8
13804150631.114882

1333
2019-10-31
958621597
14.3
13804150631.114882

1333
2019-11-01
958621597
14.4
13804150631.114882


SELECT Stock_Code, Date, Num_Shares, Close,

        last_value(Close) OVER (PARTITION BY Stock_Code
         ORDER BY Date 
         ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) AS Mkt_Cap
    FROM stock_prices LEFT JOIN stock_shares USING (Country_Exchange_Code, Stock_Code)
    WHERE Country_Exchange_Code = 'T' AND Date >= '2019-10-29' 
    ORDER BY Stock_Code, Date;


Stock_Code
Date
Num_Shares
Close
Mkt_Cap


1301
2019-10-29
241587962
75.2
77.19999694824219

1301
2019-10-30
241587962
76.6
77.19999694824219

1301
2019-10-31
241587962
77.6
77.19999694824219

1301
2019-11-01
241587962
77.2
77.19999694824219

1332
2019-10-29
369875187
52.5
50.400001525878906

1332
2019-10-30
369875187
49.7
50.400001525878906

1332
2019-10-31
369875187
50.8
50.400001525878906

1332
2019-11-01
369875187
50.4
50.400001525878906

1333
2019-10-29
958621597
13.9
14.399999618530273

1333
2019-10-30
958621597
13.8
14.399999618530273

1333
2019-10-31
958621597
14.3
14.399999618530273

1333
2019-11-01
958621597
14.4
14.399999618530273


CREATE TABLE stock_prices3 (country_exchange_code VARCHAR(2), stock_code VARCHAR(4), date DATE, close FLOAT, PRIMARY KEY (country_exchange_code,stock_code,date));

INSERT INTO stock_prices3 VALUES

   ("T", "1301",   '2019-10-29',   75.2),
    ("T", "1301",   '2019-10-30',   76.6),
    ("T", "1301",   '2019-10-31',   77.6),
    ("T", "1301",   '2019-11-01',   77.2),
    ("T", "1332",   '2019-10-29',   52.5),
    ("T", "1332",   '2019-10-30',   49.7),
    ("T", "1332",   '2019-10-31',   50.8),
    ("T", "1332",   '2019-11-01',   50.4),
    ("T", "1333",   '2019-10-29',   13.9),
    ("T", "1333",   '2019-10-30',   13.8),
    ("T", "1333",   '2019-10-31',   14.3),
    ("T", "1333",   '2019-11-01',   14.4),
    ("T", "1334",   '2019-10-29',   20.9),
    ("T", "1334",   '2019-10-30',   20.8),
    ("T", "1334",   '2019-10-31',   21.3),
    ("T", "1334",   '2019-11-01',   21.4);

CREATE TABLE stock_shares3 (country_exchange_code VARCHAR(2), stock_code VARCHAR(4), Num_Shares INT, PRIMARY KEY (country_exchange_code,stock_code));    

INSERT INTO stock_shares3 VALUES
    ("T", "1301",   241587962),
    ("T", "1332",   369875187),
    ("T", "1333",   958621597),
    ("T", "1334",   958621599);
SELECT Stock_Code, Date, Num_Shares, Close,

        Num_Shares * (last_value(Close) OVER (PARTITION BY Stock_Code
         ORDER BY Date 
         ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING)) AS Mkt_Cap
    FROM stock_prices3 LEFT JOIN stock_shares3 USING (Country_Exchange_Code, Stock_Code)
    WHERE Country_Exchange_Code = 'T' AND Date >= '2019-10-29' 
    ORDER BY Stock_Code, Date;


Stock_Code
Date
Num_Shares
Close
Mkt_Cap


1301
2019-10-29
241587962
75.2
null

1301
2019-10-30
241587962
76.6
18650589929.13205

1301
2019-10-31
241587962
77.6
18650589929.13205

1301
2019-11-01
241587962
77.2
18650589929.13205

1332
2019-10-29
369875187
52.5
null

1332
2019-10-30
369875187
49.7
18641709989.184746

1332
2019-10-31
369875187
50.8
18641709989.184746

1332
2019-11-01
369875187
50.4
18641709989.184746

1333
2019-10-29
958621597
13.9
null

1333
2019-10-30
958621597
13.8
13804150631.114882

1333
2019-10-31
958621597
14.3
13804150631.114882

1333
2019-11-01
958621597
14.4
13804150631.114882

1334
2019-10-29
958621599
20.9
20514501852.91488

1334
2019-10-30
958621599
20.8
20514501852.91488

1334
2019-10-31
958621599
21.3
20514501852.91488

1334
2019-11-01
958621599
21.4
20514501852.91488


SELECT Stock_Code, Date, Num_Shares, Close,

         (last_value(Close) OVER (PARTITION BY Stock_Code
         ORDER BY Date 
         ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING)) AS Mkt_Cap
    FROM stock_prices3 LEFT JOIN stock_shares3 USING (Country_Exchange_Code, Stock_Code)
    WHERE Country_Exchange_Code = 'T' AND Date >= '2019-10-29' 
    ORDER BY Stock_Code, Date;


Stock_Code
Date
Num_Shares
Close
Mkt_Cap


1301
2019-10-29
241587962
75.2
77.19999694824219

1301
2019-10-30
241587962
76.6
77.19999694824219

1301
2019-10-31
241587962
77.6
77.19999694824219

1301
2019-11-01
241587962
77.2
77.19999694824219

1332
2019-10-29
369875187
52.5
50.400001525878906

1332
2019-10-30
369875187
49.7
50.400001525878906

1332
2019-10-31
369875187
50.8
50.400001525878906

1332
2019-11-01
369875187
50.4
50.400001525878906

1333
2019-10-29
958621597
13.9
14.399999618530273

1333
2019-10-30
958621597
13.8
14.399999618530273

1333
2019-10-31
958621597
14.3
14.399999618530273

1333
2019-11-01
958621597
14.4
14.399999618530273

1334
2019-10-29
958621599
20.9
21.399999618530273

1334
2019-10-30
958621599
20.8
21.399999618530273

1334
2019-10-31
958621599
21.3
21.399999618530273

1334
2019-11-01
958621599
21.4
21.399999618530273


SELECT
  Stock_Code, `Date`, Num_Shares, (Num_Shares * Mkt_Cap) Mkt_Cap
FROM
(SELECT Stock_Code, Date, Num_Shares, Close,

         (last_value(Close) OVER (PARTITION BY Stock_Code
         ORDER BY `Date` 
         ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING)) AS Mkt_Cap
    FROM stock_prices3 LEFT JOIN stock_shares3 USING (Country_Exchange_Code, Stock_Code)
    WHERE Country_Exchange_Code = 'T' AND Date >= '2019-10-29' 
    ORDER BY Stock_Code, Date) t1
 ORDER BY Stock_Code, `Date`;


Stock_Code
Date
Num_Shares
Mkt_Cap


1301
2019-10-29
241587962
18650589929.13205

1301
2019-10-30
241587962
18650589929.13205

1301
2019-10-31
241587962
18650589929.13205

1301
2019-11-01
241587962
18650589929.13205

1332
2019-10-29
369875187
18641709989.184746

1332
2019-10-30
369875187
18641709989.184746

1332
2019-10-31
369875187
18641709989.184746

1332
2019-11-01
369875187
18641709989.184746

1333
2019-10-29
958621597
13804150631.114882

1333
2019-10-30
958621597
13804150631.114882

1333
2019-10-31
958621597
13804150631.114882

1333
2019-11-01
958621597
13804150631.114882

1334
2019-10-29
958621599
20514501852.91488

1334
2019-10-30
958621599
20514501852.91488

1334
2019-10-31
958621599
20514501852.91488

1334
2019-11-01
958621599
20514501852.91488
Stock_Code	Date	Num_Shares	Close	Mkt_Cap
1301	2019-10-29	241587962	75.2	18650589929.13205
1301	2019-10-30	241587962	76.6	18650589929.13205
1301	2019-10-31	241587962	77.6	18650589929.13205
1301	2019-11-01	241587962	77.2	18650589929.13205