Simple table

Simple table for stackoverflow question

You must execute the code again to save those values in the database.

create table if not exists my_table
(
    symbol TEXT not null,
    date   TIMESTAMPTZ,
    close  numeric,
    computed    numeric,
    primary key (symbol, date)
);

insert into my_table(symbol, date, close, computed)
values ('TBBB', timestamp with time zone '2024-02-22 14:30:00.000000 +00:00', 19.05, null),
       ('TBBB', timestamp with time zone '2024-02-23 14:30:00.000000 +00:00', 19.55, null),
       ('TBBB', timestamp with time zone '2024-02-24 14:30:00.000000 +00:00', 20.6, null),
       ('TBBB', timestamp with time zone '2024-02-25 14:30:00.000000 +00:00', 21.3, null),
       ('TBBB', timestamp with time zone '2024-02-26 14:30:00.000000 +00:00', 20.43, 20.4),
       ('TBBB', timestamp with time zone '2024-02-27 14:30:00.000000 +00:00', 20.21, null),
       ('TBBB', timestamp with time zone '2024-02-28 14:30:00.000000 +00:00', 20.74, null),
       ('TBBB', timestamp with time zone '2024-02-29 14:30:00.000000 +00:00', 20.09, null),
       ('TBBB', timestamp with time zone '2024-03-01 14:30:00.000000 +00:00', 20.79, null),
       ('TBBB', timestamp with time zone '2024-03-02 14:30:00.000000 +00:00', 20.87, null),
       ('TBBB', timestamp with time zone '2024-03-03 14:30:00.000000 +00:00', 20.69, null),
       ('TBBB', timestamp with time zone '2024-03-04 14:30:00.000000 +00:00', 20.19, null),
       ('TBBB', timestamp with time zone '2024-03-05 14:30:00.000000 +00:00', 20.9, null),
       ('TBBB', timestamp with time zone '2024-03-06 14:30:00.000000 +00:00', 20.99, null),
       ('TBBB', timestamp with time zone '2024-03-07 14:30:00.000000 +00:00', 21.28, null),
       ('TBBB', timestamp with time zone '2024-03-08 14:30:00.000000 +00:00', 21.27, null);

select * FROM my_table;

symbol	date	close	computed
TBBB	2024-02-22 14:30:00+00	19.05
TBBB	2024-02-23 14:30:00+00	19.55
TBBB	2024-02-24 14:30:00+00	20.6
TBBB	2024-02-25 14:30:00+00	21.3
TBBB	2024-02-26 14:30:00+00	20.43	20.4
TBBB	2024-02-27 14:30:00+00	20.21
TBBB	2024-02-28 14:30:00+00	20.74
TBBB	2024-02-29 14:30:00+00	20.09
TBBB	2024-03-01 14:30:00+00	20.79
TBBB	2024-03-02 14:30:00+00	20.87
TBBB	2024-03-03 14:30:00+00	20.69
TBBB	2024-03-04 14:30:00+00	20.19
TBBB	2024-03-05 14:30:00+00	20.9
TBBB	2024-03-06 14:30:00+00	20.99
TBBB	2024-03-07 14:30:00+00	21.28
TBBB	2024-03-08 14:30:00+00	21.27

CREATE TABLE
INSERT 0 16