NYSgptData LibraryConnectPricing

EIA hourly grid monitor

Hourly demand, generation and interchange by balancing authority (Form EIA-930), with generator and plant extracts.

41.9MRecords
104Tables
1,256Fields
CurrentYears

Publisher: U.S. Energy Information Administration

Try it

This runs against the full table, free, with no key.

Tables
eia930_interchange29.7Meia930_region6.2Meia930_subregion6Meia923_plant_operations1.2Keia923_plant_operations_t1.2Keia860m_t131eia930_fuel_mix_t18eia930_interchange_t18eia930_region_t18eia930_subregion_t18eia930_fuel_mix16eia930_region_t_jul_dec14eia930_interchange_t_jul_dec13eia930_subregion_t_jul_dec13eia930_interchange_t_jan_jun12eia930_region_t_jan_jun12eia930_subregion_t_jan_jun12eia930_gridmonitor_t_cal3eia930_gridmonitor_t_car3eia930_gridmonitor_t_cent3eia930_gridmonitor_t_fla3eia930_gridmonitor_t_mida3eia_henry_hub1eia_henry_hub_t1eia930_gridmonitor_t_aec1eia930_gridmonitor_t_aeci1eia930_gridmonitor_t_ava1eia930_gridmonitor_t_avrn1eia930_gridmonitor_t_azps1eia930_gridmonitor_t_banc1eia930_gridmonitor_t_bhba1eia930_gridmonitor_t_bpat1eia930_gridmonitor_t_chpd1eia930_gridmonitor_t_ciso1eia930_gridmonitor_t_cple1eia930_gridmonitor_t_cplw1eia930_gridmonitor_t_deaa1eia930_gridmonitor_t_dopd1eia930_gridmonitor_t_duk1eia930_gridmonitor_t_eei1eia930_gridmonitor_t_epe1eia930_gridmonitor_t_erco1eia930_gridmonitor_t_fmpp1eia930_gridmonitor_t_fpc1eia930_gridmonitor_t_fpl1eia930_gridmonitor_t_gcpd1eia930_gridmonitor_t_glhb1eia930_gridmonitor_t_grid1eia930_gridmonitor_t_grif1eia930_gridmonitor_t_grma1eia930_gridmonitor_t_gvl1eia930_gridmonitor_t_gwa1eia930_gridmonitor_t_hgma1eia930_gridmonitor_t_hst1eia930_gridmonitor_t_iid1eia930_gridmonitor_t_ipco1eia930_gridmonitor_t_isne1eia930_gridmonitor_t_jea1eia930_gridmonitor_t_ldwp1eia930_gridmonitor_t_lgee1eia930_gridmonitor_t_midw1eia930_gridmonitor_t_miso1eia930_gridmonitor_t_ne1eia930_gridmonitor_t_nevp1eia930_gridmonitor_t_nsb1eia930_gridmonitor_t_nw1eia930_gridmonitor_t_nwmt1eia930_gridmonitor_t_ny1eia930_gridmonitor_t_nyis1eia930_gridmonitor_t_ovec1eia930_gridmonitor_t_pace1eia930_gridmonitor_t_pacw1eia930_gridmonitor_t_pge1eia930_gridmonitor_t_pjm1eia930_gridmonitor_t_pnm1eia930_gridmonitor_t_psco1eia930_gridmonitor_t_psei1eia930_gridmonitor_t_sc1eia930_gridmonitor_t_sceg1eia930_gridmonitor_t_scl1eia930_gridmonitor_t_se1eia930_gridmonitor_t_sec1eia930_gridmonitor_t_sepa1eia930_gridmonitor_t_sike1eia930_gridmonitor_t_soco1eia930_gridmonitor_t_spa1eia930_gridmonitor_t_srp1eia930_gridmonitor_t_sw1eia930_gridmonitor_t_swpp1eia930_gridmonitor_t_swpw1eia930_gridmonitor_t_tal1eia930_gridmonitor_t_tec1eia930_gridmonitor_t_ten1eia930_gridmonitor_t_tepc1eia930_gridmonitor_t_tex1eia930_gridmonitor_t_tidc1eia930_gridmonitor_t_tpwr1eia930_gridmonitor_t_tva1eia930_gridmonitor_t_us1eia930_gridmonitor_t_wacm1eia930_gridmonitor_t_walc1eia930_gridmonitor_t_wauw1eia930_gridmonitor_t_wwa1eia930_gridmonitor_t_yad1
Fields in eia930_interchange
FieldTypeExample
balancing_authoritystringNYIS
data_datestring09/28/2016
hour_numberstring22
directly_interconnected_balancing_authoritystringISNE
interchange_mwstring254
local_time_at_end_of_hourstring09/28/2016 10:00:00 PM
utc_time_at_end_of_hourstring09/29/2016 2:00:00 AM
regionstringNY
diba_regionstringNE
filenamestring/data/j/eia930_interchange/x/2026/08/31/776c37c84343.csv
Connect

Claude

Settings, Connectors, Add custom connector. Paste this address:

https://data.nysgpt.com/mcp

Claude Code

claude mcp add --transport http nysgpt-data https://data.nysgpt.com/mcp

HTTP

curl -s https://data.nysgpt.com/query -H "content-type: application/json" \
  -d '{"sql":"SELECT count(*) FROM govblock_awards.usaspending_contracts"}'

Any MCP client works. The tools are list_databases, list_tables, describe_table and query (Athena SQL, read-only, up to 1,000 rows a query). With a paid key, add ?key=YOUR_KEY to the address or send the header X-Api-Key.

Pricing

Free

$0

30 queries a day, 1 GB scanned per query. No key, no sign-up.

Connect

Day pass

$29

300 queries and 100 GB scanned in 24 hours. One payment.

Buy a day pass

Monthly

$149/month

2,000 queries and 200 GB scanned a day. Cancel any time.

Subscribe

Institution

$1,500/month

20,000 queries and 1 TB scanned a day, for a lab, department or team.

Subscribe

Payment is by card through Stripe. The key appears on screen as soon as payment completes.

More in Electricity Grid and Energy