PREVIEW / futures_1hour / 2011-12-20

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-12-20.parquet
  size:    48 KB
  rows:    1,463

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-20 00:00:00	ES	Futures	1214.08	1214.83	1212.57	1214.33	2909.0
2011-12-20 01:00:00	ES	Futures	1214.33	1215.84	1214.33	1214.83	2091.0
2011-12-20 02:00:00	ES	Futures	1214.83	1215.34	1212.57	1215.09	5774.0
2011-12-20 03:00:00	ES	Futures	1215.09	1218.61	1212.31	1218.11	29322.0
2011-12-20 04:00:00	ES	Futures	1218.11	1220.88	1217.1	1220.88	25774.0
2011-12-20 05:00:00	ES	Futures	1220.63	1222.14	1219.37	1220.13	21033.0
2011-12-20 06:00:00	ES	Futures	1220.13	1221.64	1218.61	1219.12	19550.0
2011-12-20 07:00:00	ES	Futures	1219.12	1222.65	1217.86	1222.65	24239.0
2011-12-20 08:00:00	ES	Futures	1222.39	1225.67	1220.38	1224.16	62079.0
2011-12-20 09:00:00	ES	Futures	1224.41	1237.01	1224.16	1234.99	338732.0
2011-12-20 10:00:00	ES	Futures	1234.99	1240.03	1233.73	1238.77	284005.0
2011-12-20 11:00:00	ES	Futures	1238.77	1241.54	1237.77	1239.53	248446.0
2011-12-20 12:00:00	ES	Futures	1239.78	1241.29	1238.02	1240.79	100952.0
2011-12-20 13:00:00	ES	Futures	1241.04	1244.82	1240.79	1242.55	118767.0
2011-12-20 14:00:00	ES	Futures	1242.55	1246.08	1241.04	1244.57	103415.0
2011-12-20 15:00:00	ES	Futures	1244.57	1247.09	1243.06	1244.57	290529.0
2011-12-20 16:00:00	ES	Futures	1244.57	1247.59	1244.57	1246.58	119162.0
2011-12-20 17:00:00	ES	Futures	1246.58	1246.84	1244.57	1245.58	3394.0
2011-12-20 18:00:00	ES	Futures	1245.07	1246.33	1245.07	1245.58	5689.0
2011-12-20 19:00:00	ES	Futures	1245.58	1246.58	1245.07	1245.83	5538.0
2011-12-20 20:00:00	ES	Futures	1245.83	1247.09	1245.07	1245.83	5815.0
2011-12-20 21:00:00	ES	Futures	1245.83	1246.84	1245.07	1246.58	2512.0
2011-12-20 22:00:00	ES	Futures	1246.33	1246.58	1245.58	1246.08	2649.0
2011-12-20 23:00:00	ES	Futures	1246.08	1246.58	1245.83	1246.33	2635.0
2011-12-20 00:00:00	NQ	Futures	2567.99	2569.15	2565.68	2568.28	229.0
2011-12-20 01:00:00	NQ	Futures	2569.15	2571.46	2568.86	2569.73	143.0
2011-12-20 02:00:00	NQ	Futures	2569.73	2570.31	2565.11	2569.44	654.0
2011-12-20 03:00:00	NQ	Futures	2569.15	2574.06	2562.22	2573.19	2566.0
2011-12-20 04:00:00	NQ	Futures	2573.48	2581.86	2573.48	2580.7	2277.0
2011-12-20 05:00:00	NQ	Futures	2580.99	2583.01	2577.53	2579.26	1251.0
2011-12-20 06:00:00	NQ	Futures	2579.55	2582.43	2575.5	2576.37	1384.0
2011-12-20 07:00:00	NQ	Futures	2576.37	2585.03	2573.19	2584.75	2506.0
2011-12-20 08:00:00	NQ	Futures	2585.03	2587.06	2577.53	2585.32	4543.0
2011-12-20 09:00:00	NQ	Futures	2585.32	2613.34	2584.75	2609.29	52387.0
2011-12-20 10:00:00	NQ	Futures	2609.58	2619.98	2606.41	2616.8	34609.0
2011-12-20 11:00:00	NQ	Futures	2616.8	2628.35	2615.07	2624.89	34573.0
2011-12-20 12:00:00	NQ	Futures	2624.89	2625.47	2621.71	2624.6	12084.0
2011-12-20 13:00:00	NQ	Futures	2624.31	2633.55	2624.31	2627.49	15370.0
2011-12-20 14:00:00	NQ	Futures	2627.49	2631.82	2624.31	2628.93	12494.0
2011-12-20 15:00:00	NQ	Futures	2628.93	2632.69	2624.31	2630.09	33225.0
2011-12-20 16:00:00	NQ	Futures	2630.38	2637.6	2616.51	2623.73	16336.0
2011-12-20 17:00:00	NQ	Futures	2624.02	2624.02	2617.96	2619.98	1720.0
2011-12-20 18:00:00	NQ	Futures	2619.11	2620.27	2617.96	2618.82	801.0
2011-12-20 19:00:00	NQ	Futures	2618.82	2620.27	2618.53	2620.27	472.0
2011-12-20 20:00:00	NQ	Futures	2619.98	2622.58	2619.98	2621.13	497.0
2011-12-20 21:00:00	NQ	Futures	2620.85	2623.73	2620.56	2623.44	228.0
2011-12-20 22:00:00	NQ	Futures	2623.44	2623.44	2621.42	2622.29	146.0
2011-12-20 23:00:00	NQ	Futures	2621.71	2622.87	2621.71	2622.58	82.0
2011-12-20 00:00:00	YM	Futures	11640.9	11647.8	11632.0	11642.9	298.0
2011-12-20 01:00:00	YM	Futures	11643.9	11655.8	11643.9	11647.8	239.0

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

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