PREVIEW / futures_1hour / 2016-10-11

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-10-11.parquet
  size:    53 KB
  rows:    1,628

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-10-11 00:00:00	ES	Futures	2344.78	2346.14	2344.23	2345.59	3740.0
2016-10-11 01:00:00	ES	Futures	2345.87	2345.87	2344.23	2344.78	4753.0
2016-10-11 02:00:00	ES	Futures	2345.05	2345.32	2343.69	2345.05	6856.0
2016-10-11 03:00:00	ES	Futures	2345.05	2346.14	2343.69	2344.78	20094.0
2016-10-11 04:00:00	ES	Futures	2344.78	2345.59	2342.06	2342.87	14250.0
2016-10-11 05:00:00	ES	Futures	2342.6	2345.32	2341.78	2344.78	13936.0
2016-10-11 06:00:00	ES	Futures	2344.5	2345.87	2343.69	2345.32	10238.0
2016-10-11 07:00:00	ES	Futures	2345.32	2346.95	2342.6	2343.42	21123.0
2016-10-11 08:00:00	ES	Futures	2343.14	2343.96	2341.78	2342.87	24338.0
2016-10-11 09:00:00	ES	Futures	2343.14	2343.96	2332.81	2334.71	280303.0
2016-10-11 10:00:00	ES	Futures	2334.71	2335.8	2325.73	2326.0	325235.0
2016-10-11 11:00:00	ES	Futures	2326.0	2326.55	2320.02	2323.83	310196.0
2016-10-11 12:00:00	ES	Futures	2323.55	2328.45	2321.65	2325.46	147543.0
2016-10-11 13:00:00	ES	Futures	2325.19	2325.19	2312.67	2313.49	244618.0
2016-10-11 14:00:00	ES	Futures	2313.76	2316.21	2309.13	2313.76	276723.0
2016-10-11 15:00:00	ES	Futures	2313.76	2321.11	2311.86	2318.93	361242.0
2016-10-11 16:00:00	ES	Futures	2318.66	2323.55	2318.66	2321.92	127756.0
2016-10-11 18:00:00	ES	Futures	2321.38	2323.01	2319.47	2322.74	7797.0
2016-10-11 19:00:00	ES	Futures	2322.47	2324.1	2320.83	2323.55	7512.0
2016-10-11 20:00:00	ES	Futures	2323.55	2326.55	2323.28	2326.55	13841.0
2016-10-11 21:00:00	ES	Futures	2326.28	2329.81	2326.28	2327.64	15797.0
2016-10-11 22:00:00	ES	Futures	2327.91	2329.0	2327.09	2327.91	5977.0
2016-10-11 23:00:00	ES	Futures	2327.91	2327.91	2324.92	2325.19	6612.0
2016-10-11 00:00:00	NQ	Futures	5827.67	5831.25	5827.38	5830.66	1050.0
2016-10-11 01:00:00	NQ	Futures	5831.25	5831.25	5827.67	5828.87	728.0
2016-10-11 02:00:00	NQ	Futures	5828.87	5830.36	5825.88	5829.46	1116.0
2016-10-11 03:00:00	NQ	Futures	5828.87	5831.25	5824.99	5828.87	2122.0
2016-10-11 04:00:00	NQ	Futures	5828.87	5831.25	5823.8	5824.99	1552.0
2016-10-11 05:00:00	NQ	Futures	5824.69	5831.85	5822.01	5830.96	2097.0
2016-10-11 06:00:00	NQ	Futures	5830.06	5834.54	5827.67	5833.04	1570.0
2016-10-11 07:00:00	NQ	Futures	5832.75	5839.61	5831.85	5833.34	3295.0
2016-10-11 08:00:00	NQ	Futures	5833.64	5834.54	5829.46	5830.66	3524.0
2016-10-11 09:00:00	NQ	Futures	5830.66	5832.45	5796.65	5802.02	42479.0
2016-10-11 10:00:00	NQ	Futures	5802.32	5803.51	5774.57	5775.47	47158.0
2016-10-11 11:00:00	NQ	Futures	5775.47	5778.15	5761.74	5768.01	45151.0
2016-10-11 12:00:00	NQ	Futures	5768.01	5774.27	5758.46	5768.6	25444.0
2016-10-11 13:00:00	NQ	Futures	5768.31	5768.31	5736.38	5739.37	33027.0
2016-10-11 14:00:00	NQ	Futures	5739.67	5745.33	5725.64	5738.17	40798.0
2016-10-11 15:00:00	NQ	Futures	5737.88	5753.09	5732.21	5748.91	45883.0
2016-10-11 16:00:00	NQ	Futures	5749.21	5760.85	5748.91	5757.57	9025.0
2016-10-11 18:00:00	NQ	Futures	5754.58	5759.36	5750.7	5757.27	1385.0
2016-10-11 19:00:00	NQ	Futures	5757.57	5761.15	5754.28	5759.65	1431.0
2016-10-11 20:00:00	NQ	Futures	5759.36	5767.41	5758.76	5766.52	1746.0
2016-10-11 21:00:00	NQ	Futures	5766.52	5778.15	5766.22	5770.1	2302.0
2016-10-11 22:00:00	NQ	Futures	5770.39	5773.68	5768.6	5771.59	883.0
2016-10-11 23:00:00	NQ	Futures	5770.99	5772.18	5763.53	5764.13	1258.0
2016-10-11 00:00:00	YM	Futures	19691.5	19705.5	19690.4	19702.3	1018.0
2016-10-11 01:00:00	YM	Futures	19703.4	19703.4	19690.4	19696.9	810.0
2016-10-11 02:00:00	YM	Futures	19695.8	19701.2	19690.4	19699.1	1320.0
2016-10-11 03:00:00	YM	Futures	19700.1	19709.9	19688.3	19696.9	2386.0

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

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