PREVIEW / futures_1hour / 2011-11-01

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-11-01.parquet
  size:    52 KB
  rows:    1,511

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-01 00:00:00	ES	Futures	1245.26	1245.77	1243.26	1243.51	3003.0
2011-11-01 01:00:00	ES	Futures	1243.51	1244.26	1241.5	1243.01	6893.0
2011-11-01 02:00:00	ES	Futures	1242.76	1243.51	1240.0	1240.25	9157.0
2011-11-01 03:00:00	ES	Futures	1240.25	1240.75	1233.73	1237.74	40558.0
2011-11-01 04:00:00	ES	Futures	1237.49	1238.24	1229.72	1232.23	68520.0
2011-11-01 05:00:00	ES	Futures	1232.23	1236.99	1231.97	1232.23	46274.0
2011-11-01 06:00:00	ES	Futures	1232.23	1232.73	1226.21	1227.21	61445.0
2011-11-01 07:00:00	ES	Futures	1227.21	1231.47	1216.18	1223.7	111763.0
2011-11-01 08:00:00	ES	Futures	1223.95	1226.71	1212.16	1216.18	161316.0
2011-11-01 09:00:00	ES	Futures	1216.18	1224.7	1212.42	1224.45	433180.0
2011-11-01 10:00:00	ES	Futures	1224.45	1232.48	1218.43	1226.21	517775.0
2011-11-01 11:00:00	ES	Futures	1226.46	1229.47	1216.43	1217.43	367668.0
2011-11-01 12:00:00	ES	Futures	1217.43	1223.2	1214.42	1215.93	324394.0
2011-11-01 13:00:00	ES	Futures	1215.93	1231.47	1214.17	1224.45	461297.0
2011-11-01 14:00:00	ES	Futures	1224.45	1233.23	1222.45	1225.71	292656.0
2011-11-01 15:00:00	ES	Futures	1225.71	1228.97	1214.92	1217.93	544012.0
2011-11-01 16:00:00	ES	Futures	1218.18	1228.71	1217.68	1227.71	133350.0
2011-11-01 17:00:00	ES	Futures	1227.71	1229.97	1226.71	1229.47	3273.0
2011-11-01 18:00:00	ES	Futures	1229.22	1229.47	1223.95	1224.2	8577.0
2011-11-01 19:00:00	ES	Futures	1224.2	1224.95	1220.19	1222.95	13532.0
2011-11-01 20:00:00	ES	Futures	1222.7	1225.45	1222.19	1225.2	9482.0
2011-11-01 21:00:00	ES	Futures	1225.2	1230.47	1224.2	1228.97	13323.0
2011-11-01 22:00:00	ES	Futures	1229.22	1229.47	1226.96	1227.46	6620.0
2011-11-01 23:00:00	ES	Futures	1227.71	1231.22	1226.96	1229.97	4944.0
2011-11-01 00:00:00	NQ	Futures	2705.33	2706.77	2700.43	2700.43	263.0
2011-11-01 01:00:00	NQ	Futures	2700.43	2702.73	2696.97	2700.43	647.0
2011-11-01 02:00:00	NQ	Futures	2699.56	2701.0	2694.09	2694.66	435.0
2011-11-01 03:00:00	NQ	Futures	2694.66	2694.95	2680.53	2688.9	2584.0
2011-11-01 04:00:00	NQ	Futures	2688.32	2689.47	2671.02	2675.34	5961.0
2011-11-01 05:00:00	NQ	Futures	2675.34	2683.71	2673.9	2674.19	3949.0
2011-11-01 06:00:00	NQ	Futures	2674.48	2675.34	2663.81	2666.98	5595.0
2011-11-01 07:00:00	NQ	Futures	2666.98	2679.38	2654.87	2663.23	9247.0
2011-11-01 08:00:00	NQ	Futures	2662.95	2669.0	2644.49	2652.86	13626.0
2011-11-01 09:00:00	NQ	Futures	2652.57	2662.08	2643.34	2660.64	53211.0
2011-11-01 10:00:00	NQ	Futures	2660.64	2673.04	2641.32	2664.68	66789.0
2011-11-01 11:00:00	NQ	Futures	2664.1	2667.27	2637.0	2641.61	48819.0
2011-11-01 12:00:00	NQ	Futures	2641.9	2653.43	2632.67	2638.15	45354.0
2011-11-01 13:00:00	NQ	Futures	2638.44	2669.0	2633.83	2657.47	63832.0
2011-11-01 14:00:00	NQ	Futures	2657.76	2672.75	2654.01	2661.22	40454.0
2011-11-01 15:00:00	NQ	Futures	2661.22	2666.41	2640.17	2647.09	70133.0
2011-11-01 16:00:00	NQ	Futures	2647.67	2661.22	2646.8	2659.2	10658.0
2011-11-01 17:00:00	NQ	Futures	2659.77	2664.1	2658.33	2663.81	257.0
2011-11-01 18:00:00	NQ	Futures	2663.23	2663.23	2652.57	2653.14	433.0
2011-11-01 19:00:00	NQ	Futures	2652.86	2654.3	2645.65	2651.13	698.0
2011-11-01 20:00:00	NQ	Futures	2650.84	2654.87	2648.53	2654.87	535.0
2011-11-01 21:00:00	NQ	Futures	2655.16	2664.68	2654.3	2662.66	802.0
2011-11-01 22:00:00	NQ	Futures	2662.66	2663.23	2658.04	2659.49	373.0
2011-11-01 23:00:00	NQ	Futures	2659.2	2666.12	2658.33	2664.68	405.0
2011-11-01 00:00:00	YM	Futures	11680.8	11687.7	11667.0	11667.0	274.0
2011-11-01 01:00:00	YM	Futures	11670.0	11674.9	11651.3	11665.1	531.0

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

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