PREVIEW / futures_1hour / 2011-12-19

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-12-19.parquet
  size:    46 KB
  rows:    1,419

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-12-19 00:00:00	ES	Futures	1212.31	1213.83	1211.31	1212.06	5444.0
2011-12-19 01:00:00	ES	Futures	1211.81	1215.34	1211.56	1214.33	6967.0
2011-12-19 02:00:00	ES	Futures	1214.58	1217.35	1214.08	1216.35	11358.0
2011-12-19 03:00:00	ES	Futures	1216.35	1223.4	1215.34	1221.39	30788.0
2011-12-19 04:00:00	ES	Futures	1221.13	1227.69	1220.63	1226.43	37557.0
2011-12-19 05:00:00	ES	Futures	1226.43	1229.2	1226.43	1227.43	20629.0
2011-12-19 06:00:00	ES	Futures	1227.18	1229.2	1225.17	1229.2	20440.0
2011-12-19 07:00:00	ES	Futures	1229.2	1229.45	1224.91	1225.17	29418.0
2011-12-19 08:00:00	ES	Futures	1225.17	1228.69	1224.66	1227.43	37008.0
2011-12-19 09:00:00	ES	Futures	1227.43	1228.19	1223.91	1225.42	157150.0
2011-12-19 10:00:00	ES	Futures	1225.67	1227.18	1218.61	1219.62	253297.0
2011-12-19 11:00:00	ES	Futures	1219.37	1220.13	1211.81	1213.32	292524.0
2011-12-19 12:00:00	ES	Futures	1213.32	1216.35	1212.82	1216.35	105542.0
2011-12-19 13:00:00	ES	Futures	1216.35	1218.36	1213.57	1217.35	104970.0
2011-12-19 14:00:00	ES	Futures	1217.61	1217.86	1213.57	1215.59	87738.0
2011-12-19 15:00:00	ES	Futures	1215.59	1215.84	1205.01	1208.03	340462.0
2011-12-19 16:00:00	ES	Futures	1208.03	1210.55	1207.53	1209.04	84575.0
2011-12-19 17:00:00	ES	Futures	1209.04	1209.54	1208.79	1209.54	1557.0
2011-12-19 18:00:00	ES	Futures	1209.54	1213.07	1209.54	1212.82	6669.0
2011-12-19 19:00:00	ES	Futures	1212.82	1215.34	1212.57	1214.83	10541.0
2011-12-19 20:00:00	ES	Futures	1214.58	1216.6	1214.58	1215.34	7274.0
2011-12-19 21:00:00	ES	Futures	1215.59	1216.09	1214.83	1214.83	3468.0
2011-12-19 22:00:00	ES	Futures	1215.09	1215.34	1214.58	1215.09	1959.0
2011-12-19 23:00:00	ES	Futures	1215.09	1215.34	1213.83	1214.08	2244.0
2011-12-19 00:00:00	NQ	Futures	2563.95	2566.55	2561.93	2562.8	298.0
2011-12-19 01:00:00	NQ	Futures	2562.8	2569.44	2561.93	2568.86	382.0
2011-12-19 02:00:00	NQ	Futures	2567.99	2574.64	2567.13	2573.19	969.0
2011-12-19 03:00:00	NQ	Futures	2573.48	2586.77	2570.88	2582.15	2698.0
2011-12-19 04:00:00	NQ	Futures	2582.15	2596.87	2581.28	2594.85	2955.0
2011-12-19 05:00:00	NQ	Futures	2595.14	2599.76	2593.99	2597.45	1603.0
2011-12-19 06:00:00	NQ	Futures	2597.45	2599.47	2592.54	2599.19	1807.0
2011-12-19 07:00:00	NQ	Futures	2599.47	2600.34	2589.65	2591.68	2009.0
2011-12-19 08:00:00	NQ	Futures	2591.39	2597.45	2590.23	2594.85	2307.0
2011-12-19 09:00:00	NQ	Futures	2594.85	2595.72	2583.59	2590.23	19751.0
2011-12-19 10:00:00	NQ	Futures	2590.52	2594.85	2574.64	2576.66	29658.0
2011-12-19 11:00:00	NQ	Futures	2576.66	2578.97	2563.09	2568.86	26380.0
2011-12-19 12:00:00	NQ	Futures	2568.57	2575.79	2567.42	2573.48	10583.0
2011-12-19 13:00:00	NQ	Futures	2573.48	2574.64	2566.26	2572.04	9932.0
2011-12-19 14:00:00	NQ	Futures	2572.04	2572.9	2563.66	2568.86	12922.0
2011-12-19 15:00:00	NQ	Futures	2568.57	2568.86	2546.34	2553.84	46303.0
2011-12-19 16:00:00	NQ	Futures	2554.13	2558.75	2553.84	2558.18	8908.0
2011-12-19 17:00:00	NQ	Futures	2557.89	2559.62	2557.31	2559.62	244.0
2011-12-19 18:00:00	NQ	Futures	2559.04	2566.26	2559.04	2565.11	645.0
2011-12-19 19:00:00	NQ	Futures	2565.11	2569.73	2565.11	2568.57	551.0
2011-12-19 20:00:00	NQ	Futures	2568.57	2572.33	2567.99	2569.73	566.0
2011-12-19 21:00:00	NQ	Futures	2570.31	2571.46	2567.99	2568.28	243.0
2011-12-19 22:00:00	NQ	Futures	2568.57	2569.73	2567.99	2569.44	115.0
2011-12-19 23:00:00	NQ	Futures	2569.73	2569.73	2567.99	2567.99	120.0
2011-12-19 00:00:00	YM	Futures	11600.2	11613.1	11593.3	11597.3	355.0
2011-12-19 01:00:00	YM	Futures	11598.3	11629.0	11594.3	11621.1	566.0

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

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