PREVIEW / futures_1hour / 2011-11-14

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-11-14.parquet
  size:    47 KB
  rows:    1,412

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
2011-11-14 00:00:00	ES	Futures	1271.84	1272.1	1269.84	1270.34	6188.0
2011-11-14 01:00:00	ES	Futures	1270.09	1271.84	1269.09	1270.84	3188.0
2011-11-14 02:00:00	ES	Futures	1270.84	1272.6	1269.09	1269.59	9929.0
2011-11-14 03:00:00	ES	Futures	1269.59	1272.35	1266.83	1270.84	43174.0
2011-11-14 04:00:00	ES	Futures	1270.84	1271.84	1263.82	1264.32	50750.0
2011-11-14 05:00:00	ES	Futures	1264.32	1267.58	1262.32	1263.32	41373.0
2011-11-14 06:00:00	ES	Futures	1263.32	1263.57	1258.55	1260.31	49372.0
2011-11-14 07:00:00	ES	Futures	1260.06	1260.56	1255.8	1259.56	50727.0
2011-11-14 08:00:00	ES	Futures	1259.56	1263.57	1258.3	1261.06	50506.0
2011-11-14 09:00:00	ES	Futures	1261.31	1262.07	1254.04	1257.3	204055.0
2011-11-14 10:00:00	ES	Futures	1257.3	1260.56	1254.29	1257.8	244574.0
2011-11-14 11:00:00	ES	Futures	1257.8	1261.06	1252.54	1254.04	270380.0
2011-11-14 12:00:00	ES	Futures	1254.29	1254.79	1248.27	1251.53	234256.0
2011-11-14 13:00:00	ES	Futures	1251.53	1254.29	1249.78	1252.03	99236.0
2011-11-14 14:00:00	ES	Futures	1252.03	1254.29	1247.27	1247.52	120536.0
2011-11-14 15:00:00	ES	Futures	1247.77	1254.79	1247.27	1253.04	263185.0
2011-11-14 16:00:00	ES	Futures	1253.04	1256.55	1252.54	1256.3	73020.0
2011-11-14 17:00:00	ES	Futures	1256.3	1256.55	1254.79	1254.79	1303.0
2011-11-14 18:00:00	ES	Futures	1254.54	1255.8	1253.54	1255.8	5387.0
2011-11-14 19:00:00	ES	Futures	1255.8	1257.55	1255.29	1257.3	5874.0
2011-11-14 20:00:00	ES	Futures	1257.3	1257.3	1254.54	1255.04	5387.0
2011-11-14 21:00:00	ES	Futures	1254.79	1256.05	1254.04	1254.54	4696.0
2011-11-14 22:00:00	ES	Futures	1254.54	1255.04	1253.79	1254.04	2542.0
2011-11-14 23:00:00	ES	Futures	1254.29	1255.04	1251.28	1252.03	6208.0
2011-11-14 00:00:00	NQ	Futures	2720.32	2721.19	2716.57	2717.73	350.0
2011-11-14 01:00:00	NQ	Futures	2716.86	2720.03	2716.0	2717.73	296.0
2011-11-14 02:00:00	NQ	Futures	2718.02	2722.63	2714.27	2715.71	723.0
2011-11-14 03:00:00	NQ	Futures	2716.29	2721.19	2710.81	2719.46	2451.0
2011-11-14 04:00:00	NQ	Futures	2718.88	2720.03	2701.58	2705.04	2516.0
2011-11-14 05:00:00	NQ	Futures	2705.04	2711.1	2700.72	2704.46	2789.0
2011-11-14 06:00:00	NQ	Futures	2704.18	2705.04	2695.24	2702.73	4496.0
2011-11-14 07:00:00	NQ	Futures	2702.45	2704.75	2695.24	2703.31	3425.0
2011-11-14 08:00:00	NQ	Futures	2703.31	2712.83	2701.29	2707.92	2792.0
2011-11-14 09:00:00	NQ	Futures	2707.92	2712.54	2697.83	2707.35	23844.0
2011-11-14 10:00:00	NQ	Futures	2707.35	2721.76	2703.6	2708.5	38274.0
2011-11-14 11:00:00	NQ	Futures	2708.5	2717.44	2700.43	2702.73	20427.0
2011-11-14 12:00:00	NQ	Futures	2703.02	2704.75	2687.45	2696.39	21640.0
2011-11-14 13:00:00	NQ	Futures	2696.39	2704.46	2691.78	2701.29	14173.0
2011-11-14 14:00:00	NQ	Futures	2701.29	2704.18	2686.88	2687.17	14178.0
2011-11-14 15:00:00	NQ	Futures	2687.17	2699.85	2686.88	2697.55	22478.0
2011-11-14 16:00:00	NQ	Futures	2697.26	2704.18	2695.82	2703.6	5079.0
2011-11-14 17:00:00	NQ	Futures	2703.6	2704.46	2701.0	2701.0	53.0
2011-11-14 18:00:00	NQ	Futures	2701.0	2703.89	2700.14	2703.31	223.0
2011-11-14 19:00:00	NQ	Futures	2703.02	2706.19	2702.73	2704.75	369.0
2011-11-14 20:00:00	NQ	Futures	2705.04	2705.33	2700.72	2701.87	329.0
2011-11-14 21:00:00	NQ	Futures	2702.16	2704.18	2695.24	2696.1	999.0
2011-11-14 22:00:00	NQ	Futures	2696.68	2697.83	2694.95	2696.68	396.0
2011-11-14 23:00:00	NQ	Futures	2696.97	2697.55	2690.91	2692.93	402.0
2011-11-14 00:00:00	YM	Futures	11988.0	11992.9	11971.3	11978.2	261.0
2011-11-14 01:00:00	YM	Futures	11974.2	11987.0	11967.3	11980.1	194.0

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

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