price_api/init_sol_usd.sql at master · cryptovibe1/price_api · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
CREATE TABLE sol_usd (
    timestamp   BIGINT NOT NULL,
    open    DECIMAL(18, 8) NOT NULL,
    high    DECIMAL(18, 8) NOT NULL,
    low     DECIMAL(18, 8) NOT NULL,
    close   DECIMAL(18, 8) NOT NULL,
    volume  DECIMAL(24, 10) NOT NULL,

    PRIMARY KEY (timestamp)
);

CREATE INDEX idx_sol_usd_time ON sol_usd (timestamp DESC);