Transportation Fuels Spot Prices: Beginning 2006

Transportation Fuels Spot Prices dataset provides weekly average spot price information for New York Harbor Conventional Gasoline, New York Harbor Ultra-Low Sulfur Diesel as well as Western Texas Intermediate (WTI) and Brent crude oil. The data is presented as a weekly average from June 2006 through current. Jet fuel wholesale price is included on a monthly basis on a 3 month lag.

How does your organization use this dataset? What other NYSERDA or energy-related datasets would you like to see on Open NY? Let us know by emailing OpenNY@nyserda.ny.gov.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"ny-gov/transportation-fuels-spot-prices-beginning-2006-k7gz-mn77\".\"transportation_fuels_spot_prices_beginning_2006\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.