PREVIEW / futures_1hour / 2011-12-08

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-12-08.parquet
  size:    49 KB
  rows:    1,444

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-08 00:00:00	ES	Futures	1269.09	1269.34	1266.33	1267.08	3113.0
2011-12-08 01:00:00	ES	Futures	1266.83	1267.58	1266.08	1267.58	2044.0
2011-12-08 02:00:00	ES	Futures	1267.58	1269.34	1266.08	1266.83	9058.0
2011-12-08 03:00:00	ES	Futures	1266.83	1268.84	1265.58	1267.58	21086.0
2011-12-08 04:00:00	ES	Futures	1267.33	1267.83	1262.57	1265.07	21928.0
2011-12-08 05:00:00	ES	Futures	1265.07	1266.83	1261.06	1261.31	29831.0
2011-12-08 06:00:00	ES	Futures	1261.31	1266.83	1261.06	1265.58	31524.0
2011-12-08 07:00:00	ES	Futures	1265.83	1269.09	1263.82	1267.33	44055.0
2011-12-08 08:00:00	ES	Futures	1267.58	1275.86	1259.81	1262.82	210705.0
2011-12-08 09:00:00	ES	Futures	1262.82	1263.07	1253.29	1255.8	346893.0
2011-12-08 10:00:00	ES	Futures	1255.8	1257.3	1250.03	1252.03	288038.0
2011-12-08 11:00:00	ES	Futures	1252.03	1252.29	1244.51	1248.52	222373.0
2011-12-08 12:00:00	ES	Futures	1248.78	1250.53	1245.52	1246.52	101729.0
2011-12-08 13:00:00	ES	Futures	1246.52	1246.52	1240.5	1244.26	148238.0
2011-12-08 14:00:00	ES	Futures	1244.26	1246.02	1239.25	1240.5	108630.0
2011-12-08 15:00:00	ES	Futures	1240.75	1250.28	1234.48	1237.74	316748.0
2011-12-08 16:00:00	ES	Futures	1237.99	1240.75	1236.24	1236.24	67554.0
2011-12-08 17:00:00	ES	Futures	1236.49	1237.24	1235.48	1235.48	1868.0
2011-12-08 18:00:00	ES	Futures	1237.24	1240.0	1236.74	1239.5	5275.0
2011-12-08 19:00:00	ES	Futures	1239.75	1241.5	1238.49	1239.25	3242.0
2011-12-08 20:00:00	ES	Futures	1239.25	1245.01	1239.25	1245.01	8117.0
2011-12-08 21:00:00	ES	Futures	1245.01	1246.77	1241.75	1242.26	7803.0
2011-12-08 22:00:00	ES	Futures	1242.0	1242.0	1234.98	1235.48	10425.0
2011-12-08 23:00:00	ES	Futures	1235.48	1245.52	1235.48	1241.5	10146.0
2011-12-08 00:00:00	NQ	Futures	2682.84	2683.42	2677.94	2678.8	166.0
2011-12-08 01:00:00	NQ	Futures	2678.8	2680.25	2677.36	2680.25	122.0
2011-12-08 02:00:00	NQ	Futures	2679.96	2684.57	2678.52	2679.96	666.0
2011-12-08 03:00:00	NQ	Futures	2680.25	2683.99	2677.65	2681.4	1484.0
2011-12-08 04:00:00	NQ	Futures	2681.4	2682.26	2672.46	2677.36	1401.0
2011-12-08 05:00:00	NQ	Futures	2677.36	2680.25	2668.71	2669.0	1146.0
2011-12-08 06:00:00	NQ	Futures	2669.0	2680.25	2668.71	2677.94	1619.0
2011-12-08 07:00:00	NQ	Futures	2677.65	2686.3	2675.63	2683.99	2802.0
2011-12-08 08:00:00	NQ	Futures	2683.99	2699.85	2667.56	2671.6	11306.0
2011-12-08 09:00:00	NQ	Futures	2671.88	2680.82	2652.86	2671.6	37111.0
2011-12-08 10:00:00	NQ	Futures	2671.6	2675.34	2656.31	2664.1	31332.0
2011-12-08 11:00:00	NQ	Futures	2663.81	2665.25	2653.43	2660.93	19772.0
2011-12-08 12:00:00	NQ	Futures	2660.64	2663.23	2653.14	2654.87	10294.0
2011-12-08 13:00:00	NQ	Futures	2654.58	2655.16	2640.46	2649.4	17255.0
2011-12-08 14:00:00	NQ	Futures	2649.11	2652.57	2639.3	2642.19	10709.0
2011-12-08 15:00:00	NQ	Futures	2642.19	2658.62	2626.91	2632.38	32539.0
2011-12-08 16:00:00	NQ	Futures	2632.38	2636.42	2624.02	2624.6	7541.0
2011-12-08 17:00:00	NQ	Futures	2624.31	2626.62	2623.16	2623.16	159.0
2011-12-08 18:00:00	NQ	Futures	2625.75	2630.65	2625.75	2629.21	233.0
2011-12-08 19:00:00	NQ	Futures	2628.92	2632.96	2628.35	2630.37	348.0
2011-12-08 20:00:00	NQ	Futures	2630.65	2639.59	2630.65	2639.59	864.0
2011-12-08 21:00:00	NQ	Futures	2639.3	2643.34	2634.11	2635.27	429.0
2011-12-08 22:00:00	NQ	Futures	2634.4	2634.4	2621.43	2621.72	853.0
2011-12-08 23:00:00	NQ	Futures	2621.72	2640.17	2621.72	2633.83	652.0
2011-12-08 00:00:00	YM	Futures	12034.3	12036.2	12009.7	12019.5	255.0
2011-12-08 01:00:00	YM	Futures	12019.5	12025.4	12014.6	12022.5	300.0

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

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