PREVIEW / futures_1hour / 2016-01-06

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-01-06.parquet
  size:    53 KB
  rows:    1,603

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-01-06 00:00:00	ES	Futures	2143.76	2146.45	2141.34	2145.1	7890.0
2016-01-06 01:00:00	ES	Futures	2145.37	2146.99	2141.88	2143.22	9472.0
2016-01-06 02:00:00	ES	Futures	2143.22	2147.52	2142.15	2144.03	18713.0
2016-01-06 03:00:00	ES	Futures	2143.76	2145.37	2133.82	2138.66	43176.0
2016-01-06 04:00:00	ES	Futures	2138.66	2141.88	2136.51	2137.85	21336.0
2016-01-06 05:00:00	ES	Futures	2137.85	2139.19	2129.79	2130.33	31718.0
2016-01-06 06:00:00	ES	Futures	2130.06	2131.67	2123.34	2130.59	51308.0
2016-01-06 07:00:00	ES	Futures	2130.59	2130.86	2119.85	2121.46	45682.0
2016-01-06 08:00:00	ES	Futures	2121.46	2126.83	2118.77	2126.29	91308.0
2016-01-06 09:00:00	ES	Futures	2126.29	2136.51	2122.0	2135.16	293494.0
2016-01-06 10:00:00	ES	Futures	2134.89	2140.8	2130.06	2135.97	301373.0
2016-01-06 11:00:00	ES	Futures	2135.7	2144.84	2135.43	2136.51	223548.0
2016-01-06 12:00:00	ES	Futures	2136.77	2141.34	2133.82	2135.97	125346.0
2016-01-06 13:00:00	ES	Futures	2136.24	2136.77	2129.79	2130.33	105621.0
2016-01-06 14:00:00	ES	Futures	2130.33	2137.04	2118.77	2119.85	259422.0
2016-01-06 15:00:00	ES	Futures	2119.85	2132.74	2117.96	2131.4	358659.0
2016-01-06 16:00:00	ES	Futures	2131.4	2136.77	2130.59	2135.43	106268.0
2016-01-06 18:00:00	ES	Futures	2136.51	2138.66	2134.09	2138.12	8943.0
2016-01-06 19:00:00	ES	Futures	2138.12	2140.0	2135.7	2136.51	8118.0
2016-01-06 20:00:00	ES	Futures	2136.51	2138.92	2112.05	2112.32	74885.0
2016-01-06 21:00:00	ES	Futures	2112.59	2115.55	2108.83	2109.1	43365.0
2016-01-06 22:00:00	ES	Futures	2108.83	2113.4	2107.75	2112.86	22013.0
2016-01-06 23:00:00	ES	Futures	2112.86	2113.67	2108.29	2108.56	8623.0
2016-01-06 00:00:00	NQ	Futures	5280.03	5286.86	5272.31	5283.0	1893.0
2016-01-06 01:00:00	NQ	Futures	5283.0	5286.57	5273.2	5277.06	1700.0
2016-01-06 02:00:00	NQ	Futures	5276.47	5288.94	5274.99	5278.85	2784.0
2016-01-06 03:00:00	NQ	Futures	5279.44	5281.52	5253.01	5266.67	7096.0
2016-01-06 04:00:00	NQ	Futures	5266.37	5274.69	5259.84	5262.81	3816.0
2016-01-06 05:00:00	NQ	Futures	5263.4	5265.78	5236.09	5240.24	6699.0
2016-01-06 06:00:00	NQ	Futures	5239.65	5239.95	5224.51	5233.41	9574.0
2016-01-06 07:00:00	NQ	Futures	5233.12	5235.49	5212.04	5214.41	6016.0
2016-01-06 08:00:00	NQ	Futures	5214.41	5227.18	5209.36	5226.29	14952.0
2016-01-06 09:00:00	NQ	Futures	5225.69	5265.78	5217.68	5263.11	47862.0
2016-01-06 10:00:00	NQ	Futures	5262.81	5287.16	5247.96	5280.33	48660.0
2016-01-06 11:00:00	NQ	Futures	5279.74	5297.55	5271.13	5281.22	33117.0
2016-01-06 12:00:00	NQ	Futures	5281.22	5288.05	5269.05	5273.2	18609.0
2016-01-06 13:00:00	NQ	Futures	5273.5	5278.25	5255.98	5257.47	17179.0
2016-01-06 14:00:00	NQ	Futures	5258.06	5279.44	5230.74	5234.01	40090.0
2016-01-06 15:00:00	NQ	Futures	5234.31	5273.2	5229.26	5269.34	49788.0
2016-01-06 16:00:00	NQ	Futures	5269.34	5286.86	5268.45	5283.6	12239.0
2016-01-06 18:00:00	NQ	Futures	5285.67	5291.02	5279.44	5289.83	1071.0
2016-01-06 19:00:00	NQ	Futures	5289.24	5295.47	5282.41	5284.78	1717.0
2016-01-06 20:00:00	NQ	Futures	5284.49	5291.61	5221.54	5224.51	13123.0
2016-01-06 21:00:00	NQ	Futures	5224.21	5231.93	5211.74	5212.33	8775.0
2016-01-06 22:00:00	NQ	Futures	5212.63	5225.1	5208.47	5222.43	4429.0
2016-01-06 23:00:00	NQ	Futures	5223.91	5225.69	5212.33	5213.52	1829.0
2016-01-06 00:00:00	YM	Futures	18047.2	18067.4	18022.7	18062.1	2218.0
2016-01-06 01:00:00	YM	Futures	18062.1	18070.6	18033.3	18044.0	2228.0
2016-01-06 02:00:00	YM	Futures	18042.9	18078.0	18035.5	18049.3	3233.0
2016-01-06 03:00:00	YM	Futures	18051.4	18058.9	17967.3	18003.5	9477.0

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

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