text: insert into cloud_instances(provider,date_observed,region,name,cpu,ram,cost) values
      ('Google Compute Engine','2018-07-06','us-central1','n1-standard-1',1,3.75,0.0475)
      ,('Google Compute Engine','2018-07-06','us-central1','n1-standard-2',2,7.5,0.0950)
      ,('Google Compute Engine','2018-07-06','us-central1','n1-standard-4',4,15,0.1900)
      ,('Google Compute Engine','2018-07-06','us-central1','n1-standard-8',8,30,0.3800)
      ,('Google Compute Engine','2018-07-06','us-central1','n1-standard-16',16,60,0.7600)
      ,('Google Compute Engine','2018-07-06','us-central1','n1-standard-32',32,120,1.5200)
      ,('Google Compute Engine','2018-07-06','us-central1','n1-standard-64',64,240,3.0400)
      ,('Google Compute Engine','2018-07-06','us-central1','n1-standard-96',96,360,4.5600)
      ,('Google Compute Engine','2018-07-06','us-central1','f1-micro',1,0.60,0.0076)
      ,('Google Compute Engine','2018-07-06','us-central1','g1-small',1,1.70,0.0257)
      ,('Google Compute Engine','2018-07-06','us-central1','n1-highmem-2',2,13,0.1184)
      ,('Google Compute Engine','2018-07-06','us-central1','n1-highmem-4',4,26,0.2368)
      ,('Google Compute Engine','2018-07-06','us-central1','n1-highmem-8',8,52,0.4736)
      ,('Google Compute Engine','2018-07-06','us-central1','n1-highmem-16',16,104,0.9472)
      ,('Google Compute Engine','2018-07-06','us-central1','n1-highmem-32',32,208,1.8944)
      ,('Google Compute Engine','2018-07-06','us-central1','n1-highmem-64',64,416,3.7888)
      ,('Google Compute Engine','2018-07-06','us-central1','n1-highmem-96',96,624,5.6832)
      ,('Google Compute Engine','2018-07-06','us-central1','n1-highcpu-2',2,1.80,0.0709)
      ,('Google Compute Engine','2018-07-06','us-central1','n1-highcpu-4',4,3.60,0.1418)
      ,('Google Compute Engine','2018-07-06','us-central1','n1-highcpu-8',8,7.20,0.2836)
      ,('Google Compute Engine','2018-07-06','us-central1','n1-highcpu-16',16,14.40,0.5672)
      ,('Google Compute Engine','2018-07-06','us-central1','n1-highcpu-32',32,28.80,1.1344)
      ,('Google Compute Engine','2018-07-06','us-central1','n1-highcpu-64',64,57.6,2.2688)
      ,('Google Compute Engine','2018-07-06','us-central1','n1-highcpu-96',96,86.4,3.402)
      ,('Google Compute Engine','2018-07-06','us-central1','n1-ultramem-40',40,938,6.3039)
      ,('Google Compute Engine','2018-07-06','us-central1','n1-ultramem-80',80,1922,12.6078)
      ,('Google Compute Engine','2018-07-06','us-central1','n1-megamem-96',96,1433.6,10.6740)
      ,('Google Compute Engine','2018-07-06','us-central1','n1-ultramem-160',160,3844,25.2156)
  ;
  
  # Preemptibles
  insert into cloud_instances(provider, date_observed, region, name, cpu, ram, cost) values
      ('Google Compute Engine', '2018-07-21', 'us-central1', 'n1-standard-1 preemptible', 1, 3.75, 0.0100)
      ,('Google Compute Engine', '2018-07-21', 'us-central1', 'n1-standard-2 preemptible', 2, 7.5, 0.0200)
      ,('Google Compute Engine', '2018-07-21', 'us-central1', 'n1-standard-4 preemptible', 4, 15, 0.0400)
      ,('Google Compute Engine', '2018-07-21', 'us-central1', 'n1-standard-8 preemptible', 8, 30, 0.0800)
      ,('Google Compute Engine', '2018-07-21', 'us-central1', 'n1-standard-16 preemptible', 16, 60, 0.1600)
      ,('Google Compute Engine', '2018-07-21', 'us-central1', 'n1-standard-32 preemptible', 32, 120, 0.3200)
      ,('Google Compute Engine', '2018-07-21', 'us-central1', 'n1-standard-64 preemptible', 64, 240, 0.6400)
      ,('Google Compute Engine', '2018-07-21', 'us-central1', 'n1-standard-96 preemptible', 96, 360, 0.9600)
      ,('Google Compute Engine', '2018-07-21', 'us-central1', 'f1-micro preemptible', 1, 0.60, 0.0035)
      ,('Google Compute Engine', '2018-07-21', 'us-central1', 'g1-small preemptible', 1, 1.70, 0.0070)
      ,('Google Compute Engine', '2018-07-21', 'us-central1', 'n1-highmem-2 preemptible', 2, 13, 0.0250)
      ,('Google Compute Engine', '2018-07-21', 'us-central1', 'n1-highmem-4 preemptible', 4, 26, 0.0500)
      ,('Google Compute Engine', '2018-07-21', 'us-central1', 'n1-highmem-8 preemptible', 8, 52, 0.1000)
      ,('Google Compute Engine', '2018-07-21', 'us-central1', 'n1-highmem-16 preemptible', 16, 104, 0.2000)
      ,('Google Compute Engine', '2018-07-21', 'us-central1', 'n1-highmem-32 preemptible', 32, 208, 0.4000)
      ,('Google Compute Engine', '2018-07-21', 'us-central1', 'n1-highmem-64 preemptible', 64, 416, 0.8000)
      ,('Google Compute Engine', '2018-07-21', 'us-central1', 'n1-highmem-96 preemptible', 96, 624, 1.2000)
      ,('Google Compute Engine', '2018-07-21', 'us-central1', 'n1-highcpu-2 preemptible', 2, 1.80, 0.0150)
      ,('Google Compute Engine', '2018-07-21', 'us-central1', 'n1-highcpu-4 preemptible', 4, 3.60, 0.0300)
      ,('Google Compute Engine', '2018-07-21', 'us-central1', 'n1-highcpu-8 preemptible', 8, 7.20, 0.0600)
      ,('Google Compute Engine', '2018-07-21', 'us-central1', 'n1-highcpu-16 preemptible', 16, 14.40, 0.1200)
      ,('Google Compute Engine', '2018-07-21', 'us-central1', 'n1-highcpu-32 preemptible', 32, 28.80, 0.2400)
      ,('Google Compute Engine', '2018-07-21', 'us-central1', 'n1-highcpu-64 preemptible', 64, 57.6, 0.4800)
      ,('Google Compute Engine', '2018-07-21', 'us-central1', 'n1-highcpu-96 preemptible', 96, 86.4, 0.7200)
      ,('Google Compute Engine', '2018-07-21', 'us-central1', 'n1-ultramem-40 preemptible', 40, 938, 1.3311)
      ,('Google Compute Engine', '2018-07-21', 'us-central1', 'n1-ultramem-80 preemptible', 80, 1922, 2.6622)
      ,('Google Compute Engine', '2018-07-21', 'us-central1', 'n1-megamem-96 preemptible', 96, 1433.6, 2.2600)
      ,('Google Compute Engine', '2018-07-21', 'us-central1', 'n1-ultramem-160 preemptible', 160, 3844, 5.3244)
  ;
  
  insert into cloud_instances(provider,date_observed,region,name,cpu,ram,cost) values
      ('Google Compute Engine','2019-06-18','us-central1','n1-standard-1',1,3.75,0.0475)
      ,('Google Compute Engine','2019-06-18','us-central1','n1-standard-2',2,7.5,0.0950)
      ,('Google Compute Engine','2019-06-18','us-central1','n1-standard-4',4,15,0.1900)
      ,('Google Compute Engine','2019-06-18','us-central1','n1-standard-8',8,30,0.3800)
      ,('Google Compute Engine','2019-06-18','us-central1','n1-standard-16',16,60,0.7600)
      ,('Google Compute Engine','2019-06-18','us-central1','n1-standard-32',32,120,1.5200)
      ,('Google Compute Engine','2019-06-18','us-central1','n1-standard-64',64,240,3.0400)
      ,('Google Compute Engine','2019-06-18','us-central1','n1-standard-96',96,360,4.5600)
      ,('Google Compute Engine','2019-06-18','us-central1','n1-highmem-2',2,13,0.1184)
      ,('Google Compute Engine','2019-06-18','us-central1','n1-highmem-4',4,26,0.2368)
      ,('Google Compute Engine','2019-06-18','us-central1','n1-highmem-8',8,52,0.4736)
      ,('Google Compute Engine','2019-06-18','us-central1','n1-highmem-16',16,104,0.9472)
      ,('Google Compute Engine','2019-06-18','us-central1','n1-highmem-32',32,208,1.8944)
      ,('Google Compute Engine','2019-06-18','us-central1','n1-highmem-64',64,416,3.7888)
      ,('Google Compute Engine','2019-06-18','us-central1','n1-highmem-96',96,624,5.6832)
      ,('Google Compute Engine','2019-06-18','us-central1','n1-highcpu-2',2,1.80,0.0709)
      ,('Google Compute Engine','2019-06-18','us-central1','n1-highcpu-4',4,3.60,0.1418)
      ,('Google Compute Engine','2019-06-18','us-central1','n1-highcpu-8',8,7.20,0.2836)
      ,('Google Compute Engine','2019-06-18','us-central1','n1-highcpu-16',16,14.40,0.5672)
      ,('Google Compute Engine','2019-06-18','us-central1','n1-highcpu-32',32,28.80,1.1344)
      ,('Google Compute Engine','2019-06-18','us-central1','n1-highcpu-64',64,57.6,2.2688)
      ,('Google Compute Engine','2019-06-18','us-central1','n1-highcpu-96',96,86.4,3.402)
      ,('Google Compute Engine','2019-06-18','us-central1','n1-ultramem-40',40,961,6.3039)
      ,('Google Compute Engine','2019-06-18','us-central1','n1-ultramem-80',80,1922,12.6078)
      ,('Google Compute Engine','2019-06-18','us-central1','n1-ultramem-160',160,3844,25.2156)
      ,('Google Compute Engine','2019-06-18','us-central1','n1-megamem-96',96,1433.6,10.6740)
      ,('Google Compute Engine','2019-06-18','us-central1','f1-micro',1,0.60,0.0076)
      ,('Google Compute Engine','2019-06-18','us-central1','g1-small',1,1.70,0.0257)
  ;
  
  # Preemptibles
  insert into cloud_instances(provider, date_observed, region, name, cpu, ram, cost) values
      ('Google Compute Engine', '2019-06-18', 'us-central1', 'n1-standard-1 preemptible', 1, 3.75, 0.0100)
      ,('Google Compute Engine', '2019-06-18', 'us-central1', 'n1-standard-2 preemptible', 2, 7.5, 0.0200)
      ,('Google Compute Engine', '2019-06-18', 'us-central1', 'n1-standard-4 preemptible', 4, 15, 0.0400)
      ,('Google Compute Engine', '2019-06-18', 'us-central1', 'n1-standard-8 preemptible', 8, 30, 0.0800)
      ,('Google Compute Engine', '2019-06-18', 'us-central1', 'n1-standard-16 preemptible', 16, 60, 0.1600)
      ,('Google Compute Engine', '2019-06-18', 'us-central1', 'n1-standard-32 preemptible', 32, 120, 0.3200)
      ,('Google Compute Engine', '2019-06-18', 'us-central1', 'n1-standard-64 preemptible', 64, 240, 0.6400)
      ,('Google Compute Engine', '2019-06-18', 'us-central1', 'n1-standard-96 preemptible', 96, 360, 0.9600)
      ,('Google Compute Engine', '2019-06-18', 'us-central1', 'n1-highmem-2 preemptible', 2, 13, 0.0250)
      ,('Google Compute Engine', '2019-06-18', 'us-central1', 'n1-highmem-4 preemptible', 4, 26, 0.0500)
      ,('Google Compute Engine', '2019-06-18', 'us-central1', 'n1-highmem-8 preemptible', 8, 52, 0.1000)
      ,('Google Compute Engine', '2019-06-18', 'us-central1', 'n1-highmem-16 preemptible', 16, 104, 0.2000)
      ,('Google Compute Engine', '2019-06-18', 'us-central1', 'n1-highmem-32 preemptible', 32, 208, 0.4000)
      ,('Google Compute Engine', '2019-06-18', 'us-central1', 'n1-highmem-64 preemptible', 64, 416, 0.8000)
      ,('Google Compute Engine', '2019-06-18', 'us-central1', 'n1-highmem-96 preemptible', 96, 624, 1.2000)
      ,('Google Compute Engine', '2019-06-18', 'us-central1', 'n1-highcpu-2 preemptible', 2, 1.80, 0.0150)
      ,('Google Compute Engine', '2019-06-18', 'us-central1', 'n1-highcpu-4 preemptible', 4, 3.60, 0.0300)
      ,('Google Compute Engine', '2019-06-18', 'us-central1', 'n1-highcpu-8 preemptible', 8, 7.20, 0.0600)
      ,('Google Compute Engine', '2019-06-18', 'us-central1', 'n1-highcpu-16 preemptible', 16, 14.40, 0.1200)
      ,('Google Compute Engine', '2019-06-18', 'us-central1', 'n1-highcpu-32 preemptible', 32, 28.80, 0.2400)
      ,('Google Compute Engine', '2019-06-18', 'us-central1', 'n1-highcpu-64 preemptible', 64, 57.6, 0.4800)
      ,('Google Compute Engine', '2019-06-18', 'us-central1', 'n1-highcpu-96 preemptible', 96, 86.4, 0.7200)
      ,('Google Compute Engine', '2019-06-18', 'us-central1', 'n1-ultramem-40 preemptible', 40, 961, 1.3311)
      ,('Google Compute Engine', '2019-06-18', 'us-central1', 'n1-ultramem-80 preemptible', 80, 1922, 2.6622)
      ,('Google Compute Engine', '2019-06-18', 'us-central1', 'n1-ultramem-160 preemptible', 160, 3844, 5.3244)
      ,('Google Compute Engine', '2019-06-18', 'us-central1', 'n1-megamem-96 preemptible', 96, 1433.6, 2.2600)
      ,('Google Compute Engine', '2019-06-18', 'us-central1', 'f1-micro preemptible', 1, 0.60, 0.0035)
      ,('Google Compute Engine', '2019-06-18', 'us-central1', 'g1-small preemptible', 1, 1.70, 0.0070)
  ;
  