Zane Selvans

Manually uploaded a couple of years of processed FERC EQR data if anybody would like to play with it. Working on the automated builds now. There are 4 directories, one for each EQR table under this path:

s3://pudl.catalyst.coop/ferceqr/

Each directory contains one Parquet file per quarter of data.

#Electricity #Energy #OpenData #FERC #Markets #ClimateChange

Dec 23 at 5:59pmWeb
Show threadZane SelvansDec 23

Data dictionaries for the FERC EQR tables can be found here:

https://catalystcoop-pudl.readthedocs.io/en/nightly/data_dictionaries/pudl_db.html#core-ferceqr-contracts

(note that the access URL in the docs is currently wrong though!)

PUDL Data Dictionary - PUDL 2025.12.2.dev8+g9e92116.d20251223 documentation

Show threadRodrigo DiasDec 23
@ZaneSelvans Parquet files are great for big data tasks. What's the use case?
Show threadZane SelvansDec 23
@rgo The FERC Electric Quarterly Reports contain billions of US electricity market transactions. Useful for understanding how electricity markets work (and fail), and how prices of renewable energy and battery storage have evolved over time.