PREVIEW / futures_1hour / 2016-06-15

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-06-15.parquet
  size:    54 KB
  rows:    1,636

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
2016-06-15 00:00:00	ES	Futures	2240.27	2240.54	2238.37	2239.19	4152.0
2016-06-15 01:00:00	ES	Futures	2238.92	2240.0	2237.83	2238.92	7034.0
2016-06-15 02:00:00	ES	Futures	2238.92	2243.53	2238.64	2243.25	14993.0
2016-06-15 03:00:00	ES	Futures	2243.25	2246.78	2241.08	2243.8	40982.0
2016-06-15 04:00:00	ES	Futures	2243.53	2247.59	2243.53	2246.78	23562.0
2016-06-15 05:00:00	ES	Futures	2246.51	2248.95	2245.97	2247.05	20615.0
2016-06-15 06:00:00	ES	Futures	2247.32	2248.14	2245.15	2245.97	18050.0
2016-06-15 07:00:00	ES	Futures	2245.97	2246.51	2243.8	2245.15	23114.0
2016-06-15 08:00:00	ES	Futures	2245.15	2247.05	2244.34	2245.15	27818.0
2016-06-15 09:00:00	ES	Futures	2244.88	2249.49	2242.71	2247.59	187724.0
2016-06-15 10:00:00	ES	Futures	2247.86	2251.39	2247.32	2248.95	201631.0
2016-06-15 11:00:00	ES	Futures	2248.68	2251.12	2245.42	2248.68	143993.0
2016-06-15 12:00:00	ES	Futures	2248.41	2249.22	2245.42	2245.69	88467.0
2016-06-15 13:00:00	ES	Futures	2245.69	2250.58	2245.42	2249.76	76929.0
2016-06-15 14:00:00	ES	Futures	2249.76	2255.73	2243.8	2249.49	239284.0
2016-06-15 15:00:00	ES	Futures	2249.76	2250.85	2235.66	2237.83	286831.0
2016-06-15 16:00:00	ES	Futures	2238.1	2239.19	2236.2	2237.29	79537.0
2016-06-15 18:00:00	ES	Futures	2237.29	2237.56	2234.85	2236.47	6697.0
2016-06-15 19:00:00	ES	Futures	2236.47	2240.0	2236.2	2238.92	6237.0
2016-06-15 20:00:00	ES	Futures	2238.92	2239.73	2238.1	2239.19	6704.0
2016-06-15 21:00:00	ES	Futures	2239.19	2239.46	2236.75	2237.29	7812.0
2016-06-15 22:00:00	ES	Futures	2237.02	2237.83	2232.14	2233.76	16923.0
2016-06-15 23:00:00	ES	Futures	2233.49	2235.12	2231.59	2232.41	9383.0
2016-06-15 00:00:00	NQ	Futures	5268.66	5269.25	5262.7	5265.38	437.0
2016-06-15 01:00:00	NQ	Futures	5265.08	5268.06	5262.1	5265.38	559.0
2016-06-15 02:00:00	NQ	Futures	5265.68	5276.11	5264.19	5275.81	2003.0
2016-06-15 03:00:00	NQ	Futures	5275.81	5281.77	5269.25	5275.51	3859.0
2016-06-15 04:00:00	NQ	Futures	5274.92	5286.54	5274.02	5284.45	2146.0
2016-06-15 05:00:00	NQ	Futures	5284.16	5288.33	5280.88	5283.26	2502.0
2016-06-15 06:00:00	NQ	Futures	5283.56	5285.94	5277.9	5279.39	1402.0
2016-06-15 07:00:00	NQ	Futures	5279.09	5280.28	5274.92	5278.2	2194.0
2016-06-15 08:00:00	NQ	Futures	5277.9	5282.07	5275.81	5277.0	3583.0
2016-06-15 09:00:00	NQ	Futures	5276.7	5282.37	5270.74	5273.43	29959.0
2016-06-15 10:00:00	NQ	Futures	5274.02	5282.67	5265.08	5275.51	31005.0
2016-06-15 11:00:00	NQ	Futures	5275.51	5280.88	5260.91	5274.32	19480.0
2016-06-15 12:00:00	NQ	Futures	5274.32	5275.21	5265.38	5265.38	11477.0
2016-06-15 13:00:00	NQ	Futures	5265.38	5276.7	5265.38	5274.32	8285.0
2016-06-15 14:00:00	NQ	Futures	5275.51	5288.03	5262.1	5277.0	40136.0
2016-06-15 15:00:00	NQ	Futures	5276.7	5280.28	5241.53	5249.58	35751.0
2016-06-15 16:00:00	NQ	Futures	5249.58	5253.75	5246.3	5249.88	7309.0
2016-06-15 18:00:00	NQ	Futures	5249.28	5250.77	5244.22	5248.09	753.0
2016-06-15 19:00:00	NQ	Futures	5248.69	5256.44	5247.2	5253.16	673.0
2016-06-15 20:00:00	NQ	Futures	5253.46	5254.95	5250.77	5253.46	996.0
2016-06-15 21:00:00	NQ	Futures	5253.46	5253.75	5246.3	5247.79	975.0
2016-06-15 22:00:00	NQ	Futures	5247.5	5249.28	5235.57	5239.45	1895.0
2016-06-15 23:00:00	NQ	Futures	5238.85	5243.03	5234.38	5236.17	1171.0
2016-06-15 00:00:00	YM	Futures	18918.6	18918.6	18902.5	18908.9	551.0
2016-06-15 01:00:00	YM	Futures	18907.8	18916.5	18900.3	18908.9	1093.0
2016-06-15 02:00:00	YM	Futures	18906.8	18943.4	18905.7	18943.4	2198.0
2016-06-15 03:00:00	YM	Futures	18943.4	18966.0	18926.1	18945.5	4648.0

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

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