—————————————————————-
<label for="stock"><b>Select sector:</b></label>
<select id="sector" onchange="optionChanged(this.value)"></select>
<label for="stock"><b>Select a Stock:</b></label>
<select id="selDataset" onchange="optionChanged(this.value)"></select>
To enable the above functionality, the logic was separated into two funnels.
Python Libraries:
JavaScript Libraries:
APIs:
.
│ ├── ETL
│ | ├── clean_db_data # This folder contains the database tables
│ | | ├── clean_asset_type.csv
│ | | ├── clean_country.csv
│ | | ├── clean_currency.csv
│ | | ├── clean_industry.csv
│ | | ├── clean_metadata.csv
│ | | ├── clean_sector.csv
│ | | ├── clean_trade_data.csv
│ | ├── ERD.png
│ | ├── alpha_vantage_constants.py
│ | ├── alpha_vantage_extract.ipynb
│ | ├── alpha_vantage_load.ipynb
│ | ├── alpha_vantage_transform.ipynb
│ | ├── NASDAQ_Tickers.csv # This CSV file contains the tickers names from the slickercharts website
│ | ├── nasdaq_tickers_isolate.ipynb # This file retrieves the tickers from the slickercharts website
│ | ├── alpha_vantage_transform.ipynb
│ | ├── nasdaq.sqlite # This is the database
│ ├── flask_sqlite
│ | ├── routes
│ | | ├── __pycache__
│ | | | ├── get_all_data.cpython-310.pyc
│ | | | ├── get_data_by_date.cpython-310.pyc
│ | | | ├── get_data_by_sector.cpython-310.pyc
│ | | ├── get_all_data.py
│ | | ├── get_data_by_date.py
│ | ├── app.py # To run the api use the file (commend => python app.py)
│ ├── html_css_js # This folder contains the JavaScript, the CSS, and the HTML code
│ | ├── CSS
│ | | ├── about.css
│ | | ├── index.css
│ | ├── CSV_Data # This folder contains the CSV data for "all the data returned by the API "
│ | | ├── nytimes_articles.json # This folder contains the data extracted from the NYT API
│ | | ├── response.json
│ | ├── Icons
│ | | ├── dashboard.png
│ | | ├── info.png
│ | | ├── stock_image2.jpeg
│ | | ├── stocks_image.jpeg
│ | ├── js
│ | | ├── about.js
│ | | ├── logic.js
│ | ├── CSV_Data
│ | | ├── nytimes_articles.json
│ | | ├── response.json
│ | ├── about.html
│ | ├── index.html
│ ├── NYTimes API
│ | ├── Constants.py
│ | ├── import_articles.py
│ ├── Dashboard_images
│ | ├── dashboard.png
│ | ├── image.png
│ | ├── information.png
|___README.md
|___.gitignore