notebooks/01_DGS_Download_IntervalData_HourlyZip.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Download the interval data (1 hour) in .zip format from http://www.buildsmartdc.com/ using the HTTP REST API\n",
    "\n",
    "##### API Format is\n",
    "https://api.newcityenergy.com/v1/buildings/1/60_minute_intervals\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "slideshow": {
     "slide_type": "-"
    }
   },
   "outputs": [],
   "source": [
    "import os\n",
    "import json\n",
    "import requests\n",
    "import string\n",
    "import pandas as pd\n",
    "import zipfile, StringIO\n",
    "import flatdict #https://pypi.org/project/flatdict/"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "raw_dir       = \"../data/raw/dgs_1hr/tmp/\"\n",
    "#https://api.newcityenergy.com/v1/buildings/145/interval_data?start_time=1528516800&end_time=1531112400\n",
    "API_FORMAT = 'https://api.newcityenergy.com/v1/buildings/{}/60_minute_intervals'\n",
    "\n",
    "bdg_ids = [1,3,4,6,7,8,9,11,13,14,15,16,18,19,20,21,22,23,24,26,28,29,30,31,32,34,35,36,37,38,39,41,43,\n",
    "            44,46,47,49,50,51,52,53,54,55,56,57,58,60,61,62,63,64,66,67,69,70,72,73,74,75,76,77,78,79,80,\n",
    "            81,82,83,84,85,87,88,89,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,\n",
    "            112,113,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,\n",
    "            136,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,156,157,158,159,160,161,\n",
    "            164,165,166,167,168,169,171,172,174,175,176,177,178,180,181,182,183,184,186,187,188,189,190,\n",
    "            191,192,193,194,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,\n",
    "            216,217,219,220,221,222,223,224,225,226,227,229,230,231,232,234,235,236,237,238,239,242,243,\n",
    "            244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,265,266,267,\n",
    "            268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,285,286,288,290,291,292,299,\n",
    "            300,304,305,306,307,308,336,347,348,351,354,357,359,363,364,369,370,371,373,377,379,380,381,\n",
    "            382,383,384,385,387,388,413,414,415,419,420,421,426,430,434,435,448,449,450,451,452,462,464,\n",
    "            466,467,469,470,499,503,504,505,512,517,518,525,527,530,531,539,608,610,612,613,614,620,623,626]\n",
    "\n",
    "if not os.path.exists(raw_dir):\n",
    "    os.makedirs(raw_dir)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "https://api.newcityenergy.com/v1/buildings/47/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/48/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/49/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/50/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/51/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/52/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/53/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/54/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/55/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/56/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/57/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/58/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/59/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/60/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/61/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/62/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/63/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/64/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/65/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/66/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/67/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/68/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/69/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/70/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/71/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/72/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/73/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/74/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/75/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/76/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/77/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/78/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/79/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/80/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/81/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/82/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/83/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/84/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/85/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/86/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/87/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/88/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/89/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/90/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/91/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/92/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/93/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/94/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/95/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/96/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/97/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/98/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/99/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/100/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/101/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/102/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/103/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/104/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/105/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/106/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/107/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/108/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/109/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/110/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/111/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/112/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/113/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/114/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/115/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/116/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/117/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/118/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/119/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/120/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/121/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/122/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/123/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/124/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/125/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/126/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/127/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/128/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/129/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/130/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/131/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/132/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/133/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/134/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/135/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/136/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/137/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/138/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/139/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/140/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/141/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/142/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/143/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/144/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/145/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/146/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/147/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/148/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/149/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/150/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/151/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/152/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/153/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/154/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/155/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/156/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/157/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/158/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/159/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/160/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/161/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/162/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/163/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/164/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/165/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/166/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/167/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/168/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/169/60_minute_intervals\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "https://api.newcityenergy.com/v1/buildings/170/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/171/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/172/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/173/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/174/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/175/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/176/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/177/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/178/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/179/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/180/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/181/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/182/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/183/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/184/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/185/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/186/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/187/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/188/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/189/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/190/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/191/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/192/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/193/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/194/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/195/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/196/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/197/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/198/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/199/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/200/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/201/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/202/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/203/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/204/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/205/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/206/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/207/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/208/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/209/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/210/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/211/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/212/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/213/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/214/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/215/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/216/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/217/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/218/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/219/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/220/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/221/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/222/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/223/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/224/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/225/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/226/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/227/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/228/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/229/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/230/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/231/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/232/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/233/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/234/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/235/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/236/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/237/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/238/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/239/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/240/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/241/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/242/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/243/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/244/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/245/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/246/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/247/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/248/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/249/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/250/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/251/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/252/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/253/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/254/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/255/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/256/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/257/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/258/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/259/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/260/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/261/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/262/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/263/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/264/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/265/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/266/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/267/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/268/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/269/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/270/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/271/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/272/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/273/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/274/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/275/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/276/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/277/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/278/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/279/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/280/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/281/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/282/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/283/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/284/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/285/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/286/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/287/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/288/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/289/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/290/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/291/60_minute_intervals\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "https://api.newcityenergy.com/v1/buildings/292/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/293/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/294/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/295/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/296/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/297/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/298/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/299/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/300/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/301/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/302/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/303/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/304/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/305/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/306/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/307/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/308/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/309/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/310/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/311/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/312/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/313/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/314/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/315/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/316/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/317/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/318/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/319/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/320/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/321/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/322/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/323/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/324/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/325/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/326/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/327/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/328/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/329/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/330/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/331/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/332/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/333/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/334/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/335/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/336/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/337/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/338/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/339/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/340/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/341/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/342/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/343/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/344/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/345/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/346/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/347/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/348/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/349/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/350/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/351/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/352/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/353/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/354/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/355/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/356/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/357/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/358/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/359/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/360/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/361/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/362/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/363/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/364/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/365/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/366/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/367/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/368/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/369/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/370/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/371/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/372/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/373/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/374/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/375/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/376/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/377/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/378/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/379/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/380/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/381/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/382/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/383/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/384/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/385/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/386/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/387/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/388/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/389/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/390/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/391/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/392/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/393/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/394/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/395/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/396/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/397/60_minute_intervals\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "https://api.newcityenergy.com/v1/buildings/398/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/399/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/400/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/401/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/402/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/403/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/404/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/405/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/406/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/407/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/408/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/409/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/410/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/411/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/412/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/413/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/414/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/415/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/416/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/417/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/418/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/419/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/420/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/421/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/422/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/423/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/424/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/425/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/426/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/427/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/428/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/429/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/430/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/431/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/432/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/433/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/434/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/435/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/436/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/437/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/438/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/439/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/440/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/441/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/442/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/443/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/444/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/445/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/446/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/447/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/448/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/449/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/450/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/451/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/452/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/453/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/454/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/455/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/456/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/457/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/458/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/459/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/460/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/461/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/462/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/463/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/464/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/465/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/466/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/467/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/468/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/469/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/470/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/471/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/472/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/473/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/474/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/475/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/476/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/477/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/478/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/479/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/480/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/481/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/482/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/483/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/484/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/485/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/486/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/487/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/488/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/489/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/490/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/491/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/492/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/493/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/494/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/495/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/496/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/497/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/498/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/499/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/500/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/501/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/502/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/503/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/504/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/505/60_minute_intervals\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "https://api.newcityenergy.com/v1/buildings/506/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/507/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/508/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/509/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/510/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/511/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/512/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/513/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/514/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/515/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/516/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/517/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/518/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/519/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/520/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/521/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/522/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/523/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/524/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/525/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/526/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/527/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/528/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/529/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/530/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/531/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/532/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/533/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/534/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/535/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/536/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/537/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/538/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/539/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/540/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/541/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/542/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/543/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/544/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/545/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/546/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/547/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/548/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/549/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/550/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/551/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/552/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/553/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/554/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/555/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/556/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/557/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/558/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/559/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/560/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/561/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/562/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/563/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/564/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/565/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/566/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/567/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/568/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/569/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/570/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/571/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/572/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/573/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/574/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/575/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/576/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/577/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/578/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/579/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/580/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/581/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/582/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/583/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/584/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/585/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/586/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/587/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/588/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/589/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/590/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/591/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/592/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/593/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/594/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/595/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/596/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/597/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/598/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/599/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/600/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/601/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/602/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/603/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/604/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/605/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/606/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/607/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/608/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/609/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/610/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/611/60_minute_intervals\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/612/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/613/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/614/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/615/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/616/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/617/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/618/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/619/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/620/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/621/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/622/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/623/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/624/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/625/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/626/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/627/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/628/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/629/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/630/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/631/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/632/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/633/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/634/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/635/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/636/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/637/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/638/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/639/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/640/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/641/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/642/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/643/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/644/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/645/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/646/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/647/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/648/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/649/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/650/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/651/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/652/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/653/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/654/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/655/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/656/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/657/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/658/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/659/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/660/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/661/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/662/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/663/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/664/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/665/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/666/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/667/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/668/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/669/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/670/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/671/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/672/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/673/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/674/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/675/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/676/60_minute_intervals\n",
      "https://api.newcityenergy.com/v1/buildings/677/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/678/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/679/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/680/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/681/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/682/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/683/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/684/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/685/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/686/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/687/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/688/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/689/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/690/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/691/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/692/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/693/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/694/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/695/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/696/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/697/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/698/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/699/60_minute_intervals\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/700/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/701/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/702/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/703/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/704/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/705/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/706/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/707/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/708/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/709/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/710/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/711/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/712/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/713/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/714/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/715/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/716/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/717/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/718/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/719/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/720/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/721/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/722/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/723/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/724/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/725/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/726/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/727/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/728/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/729/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/730/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/731/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/732/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/733/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/734/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/735/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/736/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/737/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/738/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/739/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/740/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/741/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/742/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/743/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/744/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/745/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/746/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/747/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/748/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/749/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/750/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/751/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/752/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/753/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/754/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/755/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/756/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/757/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/758/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/759/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/760/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/761/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/762/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/763/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/764/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/765/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/766/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/767/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/768/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/769/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/770/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/771/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/772/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/773/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/774/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/775/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/776/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/777/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/778/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/779/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/780/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/781/60_minute_intervals\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/782/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/783/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/784/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/785/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/786/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/787/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/788/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/789/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/790/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/791/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/792/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/793/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/794/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/795/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/796/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/797/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/798/60_minute_intervals\n",
      "Exception File is not a zip file\n",
      "https://api.newcityenergy.com/v1/buildings/799/60_minute_intervals\n",
      "Exception File is not a zip file\n"
     ]
    }
   ],
   "source": [
    "for bid in range(1,800):\n",
    "    url = API_FORMAT.format(bid)\n",
    "    print url\n",
    "    try:\n",
    "        r = requests.get(url, stream=True)\n",
    "        z = zipfile.ZipFile(StringIO.StringIO(r.content))\n",
    "        \n",
    "        new_dir = os.path.join(raw_dir, str(bid))\n",
    "        if not os.path.exists(raw_dir):\n",
    "            os.makedirs(raw_dir)\n",
    "        x = z.extractall(new_dir)\n",
    "    except Exception as e:\n",
    "        print 'Exception ' + str(e)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 2",
   "language": "python",
   "name": "python2"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.15"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}