MySQL 5.6

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE calendar (`date` DATE);
INSERT INTO calendar VALUES
('2021-04-13'),
('2021-04-14'),
('2021-04-15'),
('2021-04-16'),
('2021-04-17'),
('2021-04-18'),
('2021-04-19'),
('2021-04-20');
SELECT * FROM calendar;

Records: 8  Duplicates: 0  Warnings: 0




date


2021-04-13

2021-04-14

2021-04-15

2021-04-16

2021-04-17

2021-04-18

2021-04-19

2021-04-20


CREATE TABLE companies (capture_date DATE, company VARCHAR(255), value DECIMAL(3,2));
INSERT INTO companies VALUES
('2021-04-13',	'Electronic Arts Inc.',	3.01),
('2021-04-14',	'Electronic Arts Inc.',	2.99),
('2021-04-16',	'Electronic Arts Inc.',	3.03),
('2021-04-17',	'Electronic Arts Inc.',	3.05),
('2021-04-20',	'Electronic Arts Inc.', 3.04),
('2021-04-13',	'Apple',	3.01);
SELECT * FROM companies;

Records: 6  Duplicates: 0  Warnings: 0




capture_date
company
value


2021-04-13
Electronic Arts Inc.
3.01

2021-04-14
Electronic Arts Inc.
2.99

2021-04-16
Electronic Arts Inc.
3.03

2021-04-17
Electronic Arts Inc.
3.05

2021-04-20
Electronic Arts Inc.
3.04

2021-04-13
Apple
3.01


SELECT *
FROM calendar t1
JOIN companies t2 ON t1.`date` >= t2.capture_date
WHERE NOT EXISTS ( SELECT NULL
                   FROM companies t3
                   WHERE t1.`date` >= t3.capture_date
                     AND t3.capture_date > t2.capture_date
                     AND t2.company = t3.company )
  AND t2.company = 'Electronic Arts Inc.';


date
capture_date
company
value


2021-04-13
2021-04-13
Electronic Arts Inc.
3.01

2021-04-14
2021-04-14
Electronic Arts Inc.
2.99

2021-04-15
2021-04-14
Electronic Arts Inc.
2.99

2021-04-16
2021-04-16
Electronic Arts Inc.
3.03

2021-04-17
2021-04-17
Electronic Arts Inc.
3.05

2021-04-18
2021-04-17
Electronic Arts Inc.
3.05

2021-04-19
2021-04-17
Electronic Arts Inc.
3.05

2021-04-20
2021-04-20
Electronic Arts Inc.
3.04


SELECT *
FROM calendar t1
JOIN companies t2 ON t1.`date` >= t2.capture_date
WHERE NOT EXISTS ( SELECT NULL
                   FROM companies t3
                   WHERE t1.`date` >= t3.capture_date
                     AND t3.capture_date > t2.capture_date
                     AND t2.company = t3.company )
  AND t2.company = 'Apple';


date
capture_date
company
value


2021-04-13
2021-04-13
Apple
3.01

2021-04-14
2021-04-13
Apple
3.01

2021-04-15
2021-04-13
Apple
3.01

2021-04-16
2021-04-13
Apple
3.01

2021-04-17
2021-04-13
Apple
3.01

2021-04-18
2021-04-13
Apple
3.01

2021-04-19
2021-04-13
Apple
3.01

2021-04-20
2021-04-13
Apple
3.01

capture_date	company	value
2021-04-13	Electronic Arts Inc.	3.01
2021-04-14	Electronic Arts Inc.	2.99
2021-04-16	Electronic Arts Inc.	3.03
2021-04-17	Electronic Arts Inc.	3.05
2021-04-20	Electronic Arts Inc.	3.04
2021-04-13	Apple	3.01