PREVIEW / futures_1hour / 2015-09-22

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-09-22.parquet
  size:    53 KB
  rows:    1,564

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2015-09-22 00:00:00	ES	Futures	2096.2	2097.53	2095.66	2096.46	2081.0
2015-09-22 01:00:00	ES	Futures	2096.73	2098.6	2095.93	2097.8	2404.0
2015-09-22 02:00:00	ES	Futures	2098.07	2101.01	2095.39	2095.93	10739.0
2015-09-22 03:00:00	ES	Futures	2095.66	2095.93	2079.61	2082.28	45831.0
2015-09-22 04:00:00	ES	Futures	2082.01	2084.42	2069.71	2074.79	61441.0
2015-09-22 05:00:00	ES	Futures	2074.52	2074.79	2067.03	2068.1	46507.0
2015-09-22 06:00:00	ES	Futures	2068.1	2071.85	2063.82	2071.85	62242.0
2015-09-22 07:00:00	ES	Futures	2072.11	2073.72	2068.1	2072.38	37965.0
2015-09-22 08:00:00	ES	Futures	2072.38	2072.38	2061.14	2065.16	75531.0
2015-09-22 09:00:00	ES	Futures	2064.89	2071.85	2063.55	2068.37	231952.0
2015-09-22 10:00:00	ES	Futures	2068.37	2072.92	2055.52	2059.27	305376.0
2015-09-22 11:00:00	ES	Futures	2059.27	2062.48	2056.33	2059.8	211575.0
2015-09-22 12:00:00	ES	Futures	2059.54	2065.69	2054.19	2054.45	171165.0
2015-09-22 13:00:00	ES	Futures	2054.45	2060.34	2052.58	2058.47	156883.0
2015-09-22 14:00:00	ES	Futures	2058.47	2063.28	2054.99	2061.68	188875.0
2015-09-22 15:00:00	ES	Futures	2061.95	2071.04	2057.93	2066.76	273654.0
2015-09-22 16:00:00	ES	Futures	2066.76	2071.31	2064.89	2065.42	74460.0
2015-09-22 18:00:00	ES	Futures	2066.23	2066.49	2059.8	2062.21	7022.0
2015-09-22 19:00:00	ES	Futures	2062.48	2063.02	2060.61	2062.75	3881.0
2015-09-22 20:00:00	ES	Futures	2062.75	2067.56	2062.75	2066.76	5491.0
2015-09-22 21:00:00	ES	Futures	2066.76	2068.1	2044.82	2046.69	29974.0
2015-09-22 22:00:00	ES	Futures	2046.69	2054.19	2046.43	2052.31	17829.0
2015-09-22 23:00:00	ES	Futures	2052.31	2052.85	2048.03	2049.37	7108.0
2015-09-22 00:00:00	NQ	Futures	5133.74	5136.41	5132.56	5134.34	282.0
2015-09-22 01:00:00	NQ	Futures	5134.93	5141.75	5132.85	5138.78	387.0
2015-09-22 02:00:00	NQ	Futures	5138.78	5148.27	5132.56	5135.22	1827.0
2015-09-22 03:00:00	NQ	Futures	5134.63	5134.63	5091.05	5095.79	9214.0
2015-09-22 04:00:00	NQ	Futures	5095.79	5102.31	5066.14	5079.19	9978.0
2015-09-22 05:00:00	NQ	Futures	5078.3	5078.59	5053.69	5055.17	10537.0
2015-09-22 06:00:00	NQ	Futures	5055.17	5061.99	5037.09	5061.69	13176.0
2015-09-22 07:00:00	NQ	Futures	5061.69	5066.74	5051.91	5063.18	5303.0
2015-09-22 08:00:00	NQ	Futures	5063.47	5064.36	5037.68	5046.28	9667.0
2015-09-22 09:00:00	NQ	Futures	5045.98	5068.22	5041.53	5047.17	48092.0
2015-09-22 10:00:00	NQ	Futures	5046.87	5063.77	5017.52	5026.41	45636.0
2015-09-22 11:00:00	NQ	Futures	5026.71	5033.82	5014.55	5024.93	30240.0
2015-09-22 12:00:00	NQ	Futures	5024.93	5039.46	5009.51	5011.29	25554.0
2015-09-22 13:00:00	NQ	Futures	5011.29	5025.23	5005.36	5023.74	21200.0
2015-09-22 14:00:00	NQ	Futures	5023.74	5039.16	5015.44	5038.27	26984.0
2015-09-22 15:00:00	NQ	Futures	5037.98	5062.29	5027.3	5053.69	44649.0
2015-09-22 16:00:00	NQ	Futures	5053.69	5068.22	5052.8	5055.17	9374.0
2015-09-22 18:00:00	NQ	Futures	5057.25	5058.14	5040.94	5046.87	1468.0
2015-09-22 19:00:00	NQ	Futures	5046.57	5048.65	5042.72	5046.87	494.0
2015-09-22 20:00:00	NQ	Futures	5047.17	5059.32	5047.17	5057.54	883.0
2015-09-22 21:00:00	NQ	Futures	5056.95	5061.1	5006.55	5009.81	4175.0
2015-09-22 22:00:00	NQ	Futures	5009.51	5027.01	5009.22	5022.56	3596.0
2015-09-22 23:00:00	NQ	Futures	5021.96	5024.34	5010.4	5014.85	1129.0
2015-09-22 00:00:00	YM	Futures	17395.1	17403.5	17391.9	17399.3	294.0
2015-09-22 01:00:00	YM	Futures	17399.3	17416.2	17392.9	17408.8	403.0
2015-09-22 02:00:00	YM	Futures	17409.9	17435.3	17390.8	17396.1	1557.0
2015-09-22 03:00:00	YM	Futures	17395.1	17395.1	17264.8	17279.6	7333.0

> showing 50 of 1,564 rows — these rows as CSV

> unlock the full archive -- $79 one-time