PREVIEW / futures_1hour / 2016-06-08

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-06-08.parquet
  size:    52 KB
  rows:    1,582

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-08 00:00:00	ES	Futures	2277.82	2278.09	2277.01	2277.55	2105.0
2016-06-08 01:00:00	ES	Futures	2277.82	2279.44	2277.01	2279.17	2648.0
2016-06-08 02:00:00	ES	Futures	2279.17	2279.98	2278.63	2278.63	6541.0
2016-06-08 03:00:00	ES	Futures	2278.63	2281.33	2277.55	2278.63	22017.0
2016-06-08 04:00:00	ES	Futures	2278.9	2279.71	2277.55	2278.63	13209.0
2016-06-08 05:00:00	ES	Futures	2278.63	2281.06	2278.63	2280.52	8260.0
2016-06-08 06:00:00	ES	Futures	2280.52	2282.68	2280.52	2282.41	10414.0
2016-06-08 07:00:00	ES	Futures	2282.41	2283.76	2281.33	2283.49	14757.0
2016-06-08 08:00:00	ES	Futures	2283.76	2283.76	2282.14	2283.22	18905.0
2016-06-08 09:00:00	ES	Futures	2283.22	2288.08	2281.6	2287.81	173101.0
2016-06-08 10:00:00	ES	Futures	2287.54	2288.08	2280.79	2282.95	219994.0
2016-06-08 11:00:00	ES	Futures	2282.95	2285.65	2279.98	2284.57	141892.0
2016-06-08 12:00:00	ES	Futures	2284.3	2287.0	2284.03	2285.38	73919.0
2016-06-08 13:00:00	ES	Futures	2285.65	2286.19	2283.49	2284.84	56863.0
2016-06-08 14:00:00	ES	Futures	2285.11	2289.16	2283.76	2287.81	111886.0
2016-06-08 15:00:00	ES	Futures	2288.08	2288.89	2285.65	2287.27	162735.0
2016-06-08 16:00:00	ES	Futures	2287.27	2287.81	2286.19	2287.0	61348.0
2016-06-08 18:00:00	ES	Futures	2287.0	2287.54	2286.46	2286.73	4904.0
2016-06-08 19:00:00	ES	Futures	2286.73	2287.27	2285.65	2285.92	2926.0
2016-06-08 20:00:00	ES	Futures	2285.92	2287.81	2285.65	2286.19	3921.0
2016-06-08 21:00:00	ES	Futures	2286.19	2286.46	2284.57	2284.57	7509.0
2016-06-08 22:00:00	ES	Futures	2284.84	2285.38	2284.3	2284.84	2181.0
2016-06-08 23:00:00	ES	Futures	2284.84	2285.11	2284.03	2284.3	2289.0
2016-06-08 00:00:00	NQ	Futures	5370.11	5371.01	5368.03	5369.52	317.0
2016-06-08 01:00:00	NQ	Futures	5369.52	5373.68	5368.03	5373.68	317.0
2016-06-08 02:00:00	NQ	Futures	5373.98	5375.47	5371.3	5371.9	927.0
2016-06-08 03:00:00	NQ	Futures	5371.9	5377.85	5367.44	5372.2	2058.0
2016-06-08 04:00:00	NQ	Futures	5372.49	5373.39	5368.33	5371.01	1176.0
2016-06-08 05:00:00	NQ	Futures	5371.01	5375.47	5371.01	5374.28	969.0
2016-06-08 06:00:00	NQ	Futures	5374.58	5378.44	5374.28	5376.66	1110.0
2016-06-08 07:00:00	NQ	Futures	5376.66	5383.2	5375.47	5382.91	1636.0
2016-06-08 08:00:00	NQ	Futures	5382.61	5386.18	5380.23	5385.29	3046.0
2016-06-08 09:00:00	NQ	Futures	5384.99	5391.54	5377.55	5389.45	25037.0
2016-06-08 10:00:00	NQ	Futures	5389.16	5390.05	5360.3	5366.25	38654.0
2016-06-08 11:00:00	NQ	Futures	5366.54	5383.8	5362.68	5377.85	24568.0
2016-06-08 12:00:00	NQ	Futures	5377.85	5386.18	5377.25	5382.61	11956.0
2016-06-08 13:00:00	NQ	Futures	5382.91	5385.88	5376.06	5378.74	10563.0
2016-06-08 14:00:00	NQ	Futures	5378.74	5388.56	5374.58	5384.69	13949.0
2016-06-08 15:00:00	NQ	Futures	5384.69	5387.07	5377.25	5379.93	16179.0
2016-06-08 16:00:00	NQ	Futures	5379.93	5382.01	5377.25	5378.44	4052.0
2016-06-08 18:00:00	NQ	Futures	5377.25	5379.93	5376.66	5377.55	319.0
2016-06-08 19:00:00	NQ	Futures	5377.25	5379.04	5376.06	5377.55	493.0
2016-06-08 20:00:00	NQ	Futures	5377.85	5382.31	5376.66	5377.25	371.0
2016-06-08 21:00:00	NQ	Futures	5377.25	5379.04	5373.98	5374.28	852.0
2016-06-08 22:00:00	NQ	Futures	5374.58	5376.96	5372.79	5375.17	664.0
2016-06-08 23:00:00	NQ	Futures	5375.47	5375.77	5372.49	5373.68	357.0
2016-06-08 00:00:00	YM	Futures	19188.9	19192.1	19182.5	19186.7	311.0
2016-06-08 01:00:00	YM	Futures	19187.8	19203.9	19180.3	19201.7	710.0
2016-06-08 02:00:00	YM	Futures	19201.7	19204.9	19193.2	19195.3	793.0
2016-06-08 03:00:00	YM	Futures	19195.3	19214.6	19182.5	19194.2	2488.0

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

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