NYSgptData LibraryConnectPricing

California (CAISO)

Locational prices, loads, intertie flows, fuel mix, renewables and interconnection requests.

25.3MRecords
125Tables
1,518Fields
CurrentYears

Publisher: California Independent System Operator

Try it

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

Tables
caiso_ir_rc_prices_cap_prc_grp_n_v2.8Mcaiso_tie_flows_real_time_15_min_ene_eim_transfer_tie_rtpd_v2.6Mcaiso_lmp_real_time_5_min_prc_intvl_lmp_rtm_lmp_v2.2Mcaiso_lmp_real_time_5_min_prc_intvl_lmp_rtm_mcc_v2.2Mcaiso_lmp_real_time_5_min_prc_intvl_lmp_rtm_mce_v2.2Mcaiso_lmp_real_time_5_min_prc_intvl_lmp_rtm_mcl_v2.2Mcaiso_lmp_real_time_5_min_prc_intvl_lmp_rtm_mghg_v2.2Mcaiso_tie_flows_real_time_5_min_ene_eim_transfer_tie_rtd_v1.5Mcaiso_lmp_day_ahead_hourly_prc_lmp_dam_lmp_v473Kcaiso_lmp_day_ahead_hourly_prc_lmp_dam_mcc_v473Kcaiso_lmp_day_ahead_hourly_prc_lmp_dam_mce_v473Kcaiso_lmp_day_ahead_hourly_prc_lmp_dam_mcl_v473Kcaiso_lmp_day_ahead_hourly_prc_lmp_dam_mghg_v473Kcaiso_lmp_real_time_15_min_prc_rtpd_lmp_rtpd_lmp_v426Kcaiso_lmp_real_time_15_min_prc_rtpd_lmp_rtpd_mcc_v426Kcaiso_lmp_real_time_15_min_prc_rtpd_lmp_rtpd_mce_v426Kcaiso_lmp_real_time_15_min_prc_rtpd_lmp_rtpd_mcl_v426Kcaiso_lmp_real_time_15_min_prc_rtpd_lmp_rtpd_mghg_v426Kcaiso_system_load_and_resource_schedules_real_time_5_min_ene_slrs_rtm_v259Kcaiso_lmp_hasp_15_min_prc_hasp_lmp_hasp_lmp_v232Kcaiso_lmp_hasp_15_min_prc_hasp_lmp_hasp_mcc_v232Kcaiso_lmp_hasp_15_min_prc_hasp_lmp_hasp_mce_v232Kcaiso_lmp_hasp_15_min_prc_hasp_lmp_hasp_mcl_v232Kcaiso_lmp_hasp_15_min_prc_hasp_lmp_hasp_mghg_v232Kcaiso_load_forecast_5_min_sld_fcst_rtm_v116Kcaiso_lmp_scheduling_point_tie_real_time_5_min_prc_sptie_lmp_rtd_lmp_v95.6Kcaiso_lmp_scheduling_point_tie_real_time_5_min_prc_sptie_lmp_rtd_mcc_v95.6Kcaiso_lmp_scheduling_point_tie_real_time_5_min_prc_sptie_lmp_rtd_mce_v95.6Kcaiso_lmp_scheduling_point_tie_real_time_5_min_prc_sptie_lmp_rtd_mcl_v95.6Kcaiso_lmp_scheduling_point_tie_real_time_5_min_prc_sptie_lmp_rtd_mghg_v95.6Kcaiso_load_forecast_15_min_sld_fcst_rtm_v93.5Kcaiso_fuel_prices_prc_fuel_n_v91.7Kcaiso_load_forecast_sld_fcst_dam_v62.9Kcaiso_as_procurement_dam_as_results_dam_v49.9Kcaiso_lmp_scheduling_point_tie_day_ahead_hourly_prc_sptie_lmp_dam_lmp_v42.9Kcaiso_lmp_scheduling_point_tie_day_ahead_hourly_prc_sptie_lmp_dam_mcc_v42.9Kcaiso_lmp_scheduling_point_tie_day_ahead_hourly_prc_sptie_lmp_dam_mce_v42.9Kcaiso_lmp_scheduling_point_tie_day_ahead_hourly_prc_sptie_lmp_dam_mcl_v42.9Kcaiso_lmp_scheduling_point_tie_day_ahead_hourly_prc_sptie_lmp_dam_mghg_v42.9Kcaiso_aggregated_generation_outages_aggr_outage_sch_n_v33.1Kcaiso_renewables_forecast_rtd_sld_ren_fcst_rtd_v31.2Kcaiso_renewables_forecast_rtpd_sld_ren_fcst_rtpd_v25.3Kcaiso_load_forecast_day_ahead_sld_fcst_dam_v22.2Kcaiso_lmp_scheduling_point_tie_real_time_15_min_prc_sptie_lmp_rtpd_lmp_v20.6Kcaiso_lmp_scheduling_point_tie_real_time_15_min_prc_sptie_lmp_rtpd_mcc_v20.6Kcaiso_lmp_scheduling_point_tie_real_time_15_min_prc_sptie_lmp_rtpd_mce_v20.6Kcaiso_lmp_scheduling_point_tie_real_time_15_min_prc_sptie_lmp_rtpd_mcl_v20.6Kcaiso_lmp_scheduling_point_tie_real_time_15_min_prc_sptie_lmp_rtpd_mghg_v20.6Kcaiso_load_forecast_2_day_sld_fcst_da_v17.3Kcaiso_load_forecast_7_day_sld_fcst_da_v17.3Kcaiso_system_load_and_resource_schedules_day_ahead_ene_slrs_dam_v16.1Kcaiso_system_load_and_resource_schedules_hasp_ene_slrs_hasp_v11.4Kcaiso_intertie_constraint_shadow_prices_real_time_5_min_prc_rtm_flowgate_n_v9Kcaiso_branch_shadow_prices_rtm_5_min_prc_rtm_nomogram_n_v8.1Kcaiso_load_hourly_sld_fcst_actual_v6.9Kcaiso_system_load_and_resource_schedules_ruc_ene_slrs_ruc_v6.8Kcaiso_branch_shadow_prices_dam_hourly_prc_nomogram_dam_v6.1Kcaiso_load_forecast_dam_sld_fcst_dam_v4.3Kcaiso_renewables_forecast_dam_sld_ren_fcst_dam_v3.7Kcaiso_branch_shadow_prices_rtpd_15_min_prc_nomogram_rtm_v3.3Kcaiso_as_prices_prc_as_dam_v1.9Kcaiso_renewables_forecast_hasp_sld_ren_fcst_hasp_v1.4Kcaiso_branch_shadow_prices_hasp_hourly_prc_nomogram_hasp_v1.3Kcaiso_renewables_hourly_sld_ren_fcst_actual_v1.1Kcaiso_ir_rc_requirements_awards_dam_cap_req_awrd_grp_dam_v864caiso_solar_and_wind_forecast_dam_sld_ren_fcst_dam_v720caiso_storage_soc_hourly602caiso_ir_rc_requirements_awards_2da_cap_req_awrd_grp_da_v432caiso_ir_rc_requirements_awards_3da_cap_req_awrd_grp_da_v432caiso_curtailment342caiso_storage_awards_ifm206caiso_storage_energy_bids_ifm206caiso_lmp_scheduling_point_tie_real_time_15_min162caiso_lmp_scheduling_point_tie_real_time_5_min162caiso_lmp_hasp_15_min156caiso_lmp_real_time_5_min138caiso_storage_awards_fmm138caiso_storage_energy_bids_fmm138caiso_lmp_real_time_15_min132caiso_storage_awards_rtd108caiso_storage_energy_awards_ruc108caiso_storage_soc_fmm108caiso_storage_soc_rtd108caiso_seven_day_resource_adequacy_outlook87caiso_tie_flows_real_time_15_min82caiso_fuel_mix75caiso_load74caiso_load_forecast73caiso_renewables_forecast_rtpd69caiso_curtailed_non_operational_generator_report68caiso_load_forecast_15_min68caiso_aggregated_generation_outages55caiso_as_prices52caiso_edam_wind_solar_forecast52caiso_load_forecast_5_min44caiso_renewables_forecast_rtd43caiso_system_load_and_resource_schedules_real_time_5_min43caiso_storage42caiso_intertie_constraint_shadow_prices_real_time_5_min35caiso_lmp_scheduling_point_tie_day_ahead_hourly32caiso_load_forecast_day_ahead29caiso_lmp_day_ahead_hourly28caiso_fuel_regions26caiso_ir_rc_requirements_awards_2da26caiso_ir_rc_requirements_awards_3da26caiso_ir_rc_requirements_awards_dam26caiso_load_hourly26caiso_renewables_forecast_dam26caiso_system_load_and_resource_schedules_day_ahead26caiso_system_load_and_resource_schedules_ruc26caiso_tie_flows_real_time_5_min25caiso_renewables_forecast_hasp23caiso_renewables_hourly23caiso_system_load_and_resource_schedules_hasp23caiso_ir_rc_prices22caiso_as_procurement_dam20caiso_branch_shadow_prices_dam_hourly20caiso_branch_shadow_prices_hasp_hourly20caiso_branch_shadow_prices_rtm_5_min20caiso_branch_shadow_prices_rtpd_15_min20caiso_fuel_prices20caiso_load_forecast_2_day20caiso_load_forecast_7_day20caiso_load_forecast_dam5caiso_solar_and_wind_forecast_dam5
Fields in caiso_ir_rc_prices_cap_prc_grp_n_v
FieldTypeExample
mkt_typestringDAM
interval_start_gmtstring2026-08-30T23:00:00-00:00
interval_end_gmtstring2026-08-31T00:00:00-00:00
nodestring0096WD_7_N001
productstringIRD
marginal_clearing_pricestring0.13064
capacity_pricestring0.13064
congestion_pricestring0
loss_pricestring0
_groupstring1
filenamestring/data/j/caiso_ir_rc_prices/x/2026/08/30/047b587a7656_z/20260
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