I have these 3 tables :

CREATE TABLE table_1 (
    name VARCHAR(10),
    entry DATE,
    today DATE
);

INSERT INTO table_1 (name, entry, today) VALUES
('red', '2000-01-01', '2020-01-01'),
('blue', '1999-01-01', '2020-01-01'),
('green', '2004-01-01', '2020-01-01');


CREATE TABLE table_2 (
    name VARCHAR(10),
    entry DATE,
    today DATE
);


INSERT INTO table_2 (name, entry, today) VALUES
('red', '2000-01-01', '2020-01-02'),
('blue', '1999-01-01', '2020-01-02'),
('yellow', '1995-01-01', '2020-01-02'),
('purple', '2010-01-01', '2020-01-02');

CREATE TABLE table_3 (
    name VARCHAR(10),
    entry DATE,
    today DATE
);

INSERT INTO table_3 (name, entry, today) VALUES
('red', '2000-01-01', '2020-01-03'),
('purple', '2010-01-01', '2020-01-03'),
('orange', '2006-01-01', '2020-01-03');

On day 1 (2020-01-01), I only have access to table_1. On day 2 (2020-01-02), I only have access to table_2. On day 3 (2020-01-03), I only have access to table_3. I would like to create a cumulative table that shows which colors available on any given day.

For example:

On day 2, I want to create the following table (temp_day2):

    name      entry date_disappeared      today
    red 2000-01-01             NULL 2020-01-02
   blue 1999-01-01             NULL 2020-01-02
  green 2004-01-01       2020-01-01 2020-01-02
 yellow 1995-01-01             NULL 2020-01-02
 purple 2010-01-01             NULL 2020-01-02

I am allowed to keep this table I created, and on day 3, I want to create (temp_day3):

   name      entry date_disappeared      today
    red 2000-01-01             NULL 2020-01-03
   blue 1999-01-01       2020-01-03 2020-01-03
  green 2004-01-01       2020-01-01 2020-01-03
 yellow 1995-01-01       2020-01-03 2020-01-03
 purple 2010-01-01             NULL 2020-01-03
 orange 2006-01-01             NULL 2020-01-03

Here is my attempt for temp_table2:

CREATE TABLE temp_day2 AS
SELECT 
    t1.name,
    t1.entry,
    CASE 
        WHEN t2.name IS NULL THEN t1.today
        ELSE NULL
    END AS date_disappeared,
    t2.today AS today
FROM table_1 t1
LEFT JOIN table_2 t2 ON t1.name = t2.name

UNION

SELECT 
    t2.name,
    t2.entry,
    NULL AS date_disappeared,
    t2.today AS today
FROM table_2 t2
LEFT JOIN table_1 t1 ON t2.name = t1.name
WHERE t1.name IS NULL;

But this is not producing the correct results for the second day:

    name      entry date_disappeared      today
   blue 1999-01-01             <NA> 2020-01-02
  green 2004-01-01       2020-01-01       <NA>
 purple 2010-01-01             <NA> 2020-01-02
    red 2000-01-01             <NA> 2020-01-02
 yellow 1995-01-01             <NA> 2020-01-02

Can someone please show me how I can fix this and then write the SQL for the third day?

Thanks!