diff options
| -rw-r--r-- | sql/serenitasdb.sql | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/sql/serenitasdb.sql b/sql/serenitasdb.sql index 0ad36041..7130b35a 100644 --- a/sql/serenitasdb.sql +++ b/sql/serenitasdb.sql @@ -1273,6 +1273,22 @@ CREATE TABLE markit_singlename_quotes ( confidence int
);
+CREATE TABLE markit_bond_quotes (
+ quoteid int8 primary key,
+ identifier text NOT NULL,
+ cusip text NOT NULL,
+ bidprice float,
+ bidsize float,
+ askprice float,
+ asksize float,
+ subtype text,
+ firmness quote_firmness,
+ msg_id text,
+ quotedate timestamptz NULL,
+ quotesource text,
+ confidence int
+ );
+
CREATE TABLE hyg_vol_data (
"date" date NOT NULL,
price float8 NULL,
|