1 files changed, 10 insertions, 0 deletions
diff --git a/sql/serenitasdb.sql b/sql/serenitasdb.sql
index cdf769c2..446777af 100644
--- a/sql/serenitasdb.sql
+++ b/sql/serenitasdb.sql
@@ -225,3 +225,13 @@ CREATE OR REPLACE FUNCTION curve_quotes_fmt(varchar(4), date) RETURNS
        ON b.curve_ticker = a.curve_ticker GROUP by company_id ORDER BY t;
        END;
        $$ LANGUAGE plpgsql;
+
+CREATE TABLE index_quotes(
+       Date date,
+       Index index_type,
+       Series smallint,
+       Version smallint,
+       Tenor tenor,
+       Price float,
+       Spread float
+       PRIMARY KEY(Date, Index, Series, Tenor));