diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/serenitasdb.sql | 13 |
1 files changed, 12 insertions, 1 deletions
diff --git a/sql/serenitasdb.sql b/sql/serenitasdb.sql index 192ffddb..77bd6125 100644 --- a/sql/serenitasdb.sql +++ b/sql/serenitasdb.sql @@ -1271,4 +1271,15 @@ CREATE TABLE markit_singlename_quotes ( quotedate timestamptz NULL,
quotesource text,
confidence int
- );
\ No newline at end of file + );
+
+CREATE TABLE hyg_vol_data (
+ "date" date NOT NULL,
+ price float8 NULL,
+ "30d_implied_vol" float8 NULL,
+ "3M_inplied_vol" float8 NULL,
+ yas_ispread float8 NULL,
+ yas_mod_dur float8 NULL,
+ CONSTRAINT hyg_vol_data_pkey PRIMARY KEY (date)
+);
+
|