I’m trying to conduct some backtesting in a Jupyter notebook. My idea is to have a SQL query in the catalog that queries based on a date parameter so I can pull historical data.
What is the best way to write this SQL query so that I can change the date based on how far I want to go back in time? Should I store a date parameter in the parameters file and then call it in the catalog? What would the syntax look like? Or, is there a better alternative?