Icon

Industry_​Avg_​Reader

Industry Average Reader - reads industry_avg_df.csv files from all 15 sector folders, adds sector/date_key/daily_return columns, and appends to stg.stg_industry_avg in PostgreSQL.

Industry Average Reader - reads industry_avg_df.csv files from all 15 sector folders, adds sector/date_key/daily_return columns, and appends to stg.stg_industry_avg in PostgreSQL.

List Files/Folders
Iterate over file list
Table Row to Variable Loop Start
CSV Reader
Path to String
String to Date&Time
PostgreSQL Connector
Column Renamer
Column Filter
Combine files
Loop End
DB Writer
DB SQL Executor

Nodes

Extensions

Links