Package index • ffiec.pq

Configuration

ffiec_raw_data_dir(): Resolve the FFIEC raw data repository directory
ffiec_data_dir(): Resolve the FFIEC Parquet data repository directory

Processing data

ffiec_process(): Process FFIEC call report bulk data
ffiec_process_xbrls(): Process FFIEC XBRL bulk zip files
ffiec_list_zips(): List FFIEC bulk zip files

Reading Parquet data

ffiec_scan_pqs(): Scan FFIEC Parquet files into DuckDB
ffiec_list_pqs(): List generated FFIEC Parquet files
ffiec_pivot(): Pivot long FFIEC data to wide format using DuckDB
ffiec_check_pq_keys(): Check primary-key and non-NULL constraints in FFIEC Parquet files

Metadata

ffiec_items: FFIEC item master table
ffiec_item_details: FFIEC item metadata and reporting details