PREVIEW / futures_1hour / 2011-11-10

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-11-10.parquet
  size:    49 KB
  rows:    1,471

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-10 00:00:00	ES	Futures	1229.47	1233.73	1229.22	1231.47	8109.0
2011-11-10 01:00:00	ES	Futures	1231.22	1231.22	1224.2	1224.45	9814.0
2011-11-10 02:00:00	ES	Futures	1224.7	1228.21	1221.94	1223.2	27067.0
2011-11-10 03:00:00	ES	Futures	1223.2	1237.74	1222.95	1236.24	70089.0
2011-11-10 04:00:00	ES	Futures	1236.49	1246.77	1234.48	1244.01	91798.0
2011-11-10 05:00:00	ES	Futures	1244.01	1247.52	1234.98	1241.0	75717.0
2011-11-10 06:00:00	ES	Futures	1241.0	1244.51	1236.99	1244.26	37229.0
2011-11-10 07:00:00	ES	Futures	1244.26	1248.78	1241.25	1246.02	76612.0
2011-11-10 08:00:00	ES	Futures	1246.02	1248.78	1243.01	1247.27	78301.0
2011-11-10 09:00:00	ES	Futures	1247.27	1247.77	1237.24	1237.99	286540.0
2011-11-10 10:00:00	ES	Futures	1237.74	1241.5	1228.21	1232.48	469835.0
2011-11-10 11:00:00	ES	Futures	1232.23	1243.01	1231.47	1240.25	369153.0
2011-11-10 12:00:00	ES	Futures	1240.0	1242.26	1234.73	1240.75	186969.0
2011-11-10 13:00:00	ES	Futures	1240.75	1247.77	1240.0	1244.76	214387.0
2011-11-10 14:00:00	ES	Futures	1245.01	1245.52	1235.99	1236.49	169499.0
2011-11-10 15:00:00	ES	Futures	1236.49	1244.01	1235.74	1241.0	278681.0
2011-11-10 16:00:00	ES	Futures	1241.0	1242.76	1240.75	1242.76	74976.0
2011-11-10 17:00:00	ES	Futures	1242.51	1243.26	1242.51	1242.51	1308.0
2011-11-10 18:00:00	ES	Futures	1241.75	1243.26	1239.75	1241.5	6410.0
2011-11-10 19:00:00	ES	Futures	1241.5	1242.76	1237.49	1239.0	7219.0
2011-11-10 20:00:00	ES	Futures	1239.0	1242.51	1237.99	1241.25	5953.0
2011-11-10 21:00:00	ES	Futures	1241.0	1248.78	1241.0	1246.02	10837.0
2011-11-10 22:00:00	ES	Futures	1246.02	1252.54	1246.02	1249.78	10930.0
2011-11-10 23:00:00	ES	Futures	1249.53	1251.53	1248.52	1250.53	5707.0
2011-11-10 00:00:00	NQ	Futures	2668.42	2675.34	2668.14	2671.6	496.0
2011-11-10 01:00:00	NQ	Futures	2671.02	2671.02	2658.62	2658.62	687.0
2011-11-10 02:00:00	NQ	Futures	2658.62	2664.96	2654.3	2656.31	1036.0
2011-11-10 03:00:00	NQ	Futures	2656.6	2682.26	2656.6	2679.67	3381.0
2011-11-10 04:00:00	NQ	Futures	2679.67	2699.27	2676.21	2693.8	5262.0
2011-11-10 05:00:00	NQ	Futures	2693.51	2699.85	2677.36	2688.61	4370.0
2011-11-10 06:00:00	NQ	Futures	2688.61	2696.1	2679.67	2695.53	3614.0
2011-11-10 07:00:00	NQ	Futures	2695.24	2703.31	2689.18	2698.12	5055.0
2011-11-10 08:00:00	NQ	Futures	2697.83	2701.87	2690.91	2697.55	6832.0
2011-11-10 09:00:00	NQ	Futures	2697.83	2698.12	2662.37	2663.81	39493.0
2011-11-10 10:00:00	NQ	Futures	2663.81	2671.88	2637.0	2647.67	62278.0
2011-11-10 11:00:00	NQ	Futures	2647.67	2672.75	2646.22	2665.83	48554.0
2011-11-10 12:00:00	NQ	Futures	2665.83	2667.27	2650.84	2661.79	22567.0
2011-11-10 13:00:00	NQ	Futures	2661.79	2678.23	2660.64	2673.61	26501.0
2011-11-10 14:00:00	NQ	Futures	2673.61	2674.77	2653.72	2654.01	23064.0
2011-11-10 15:00:00	NQ	Futures	2654.01	2668.71	2652.28	2662.37	38852.0
2011-11-10 16:00:00	NQ	Futures	2662.37	2664.68	2657.18	2663.23	7158.0
2011-11-10 17:00:00	NQ	Futures	2663.81	2666.12	2662.37	2662.66	302.0
2011-11-10 18:00:00	NQ	Futures	2661.79	2664.39	2657.47	2660.64	291.0
2011-11-10 19:00:00	NQ	Futures	2661.5	2663.52	2654.3	2657.47	629.0
2011-11-10 20:00:00	NQ	Futures	2657.76	2663.23	2656.03	2661.22	373.0
2011-11-10 21:00:00	NQ	Futures	2661.22	2674.19	2659.49	2670.15	792.0
2011-11-10 22:00:00	NQ	Futures	2670.15	2681.98	2670.15	2676.5	669.0
2011-11-10 23:00:00	NQ	Futures	2676.5	2681.11	2674.77	2678.52	267.0
2011-11-10 00:00:00	YM	Futures	11544.0	11577.4	11544.0	11558.7	603.0
2011-11-10 01:00:00	YM	Futures	11557.8	11557.8	11497.7	11499.7	1021.0

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

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