aboutsummaryrefslogtreecommitdiffstats
path: root/sql/serenitasdb.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql/serenitasdb.sql')
-rw-r--r--sql/serenitasdb.sql3
1 files changed, 2 insertions, 1 deletions
diff --git a/sql/serenitasdb.sql b/sql/serenitasdb.sql
index 3f6792e1..9582cf5b 100644
--- a/sql/serenitasdb.sql
+++ b/sql/serenitasdb.sql
@@ -1134,7 +1134,8 @@ CREATE OR REPLACE VIEW public.on_the_run AS
index_quotes.duration,
index_quotes.theta,
index_quotes.closeprice,
- index_quotes.closespread
+ index_quotes.closespread,
+ index_quotes.duration2
FROM index_quotes
WHERE index_quotes.tenor = '5yr'::tenor
ORDER BY index_quotes.date, index_quotes.index, index_quotes.series DESC, index_quotes.version;