PREVIEW / futures_1hour / 2011-11-16

all futures 1-hour files

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

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-16 00:00:00	ES	Futures	1247.27	1248.02	1242.0	1244.26	11422.0
2011-11-16 01:00:00	ES	Futures	1244.01	1244.76	1242.51	1242.76	7317.0
2011-11-16 02:00:00	ES	Futures	1243.01	1249.53	1242.26	1248.02	24441.0
2011-11-16 03:00:00	ES	Futures	1247.77	1258.55	1245.52	1257.05	73160.0
2011-11-16 04:00:00	ES	Futures	1257.05	1261.06	1254.29	1261.06	44775.0
2011-11-16 05:00:00	ES	Futures	1261.06	1262.57	1247.27	1249.78	80129.0
2011-11-16 06:00:00	ES	Futures	1250.03	1250.03	1242.76	1246.52	78745.0
2011-11-16 07:00:00	ES	Futures	1246.52	1253.29	1244.51	1249.03	74511.0
2011-11-16 08:00:00	ES	Futures	1248.78	1250.53	1244.01	1245.01	83458.0
2011-11-16 09:00:00	ES	Futures	1245.26	1252.03	1244.26	1250.03	268452.0
2011-11-16 10:00:00	ES	Futures	1250.28	1255.04	1246.27	1253.79	338332.0
2011-11-16 11:00:00	ES	Futures	1254.04	1258.3	1251.78	1252.03	296606.0
2011-11-16 12:00:00	ES	Futures	1252.03	1255.8	1251.03	1253.54	173136.0
2011-11-16 13:00:00	ES	Futures	1253.54	1261.56	1253.29	1258.81	179572.0
2011-11-16 14:00:00	ES	Futures	1258.55	1259.81	1253.79	1255.29	158974.0
2011-11-16 15:00:00	ES	Futures	1255.29	1256.05	1236.99	1238.74	619354.0
2011-11-16 16:00:00	ES	Futures	1239.0	1240.25	1231.97	1233.98	144797.0
2011-11-16 17:00:00	ES	Futures	1234.23	1234.48	1231.72	1233.23	3505.0
2011-11-16 18:00:00	ES	Futures	1233.23	1234.48	1231.22	1233.48	10962.0
2011-11-16 19:00:00	ES	Futures	1233.23	1235.48	1230.72	1231.97	10869.0
2011-11-16 20:00:00	ES	Futures	1231.97	1235.74	1229.47	1235.48	13131.0
2011-11-16 21:00:00	ES	Futures	1235.74	1237.24	1233.98	1236.49	7367.0
2011-11-16 22:00:00	ES	Futures	1236.49	1240.25	1235.74	1238.74	9909.0
2011-11-16 23:00:00	ES	Futures	1238.49	1241.0	1237.24	1240.5	6194.0
2011-11-16 00:00:00	NQ	Futures	2706.48	2707.64	2696.68	2700.43	715.0
2011-11-16 01:00:00	NQ	Futures	2700.72	2700.72	2696.68	2697.55	442.0
2011-11-16 02:00:00	NQ	Futures	2696.68	2710.23	2695.82	2707.06	1423.0
2011-11-16 03:00:00	NQ	Futures	2707.35	2725.22	2702.45	2722.63	4495.0
2011-11-16 04:00:00	NQ	Futures	2722.92	2731.86	2717.73	2731.28	2893.0
2011-11-16 05:00:00	NQ	Futures	2731.28	2735.03	2707.64	2711.67	5138.0
2011-11-16 06:00:00	NQ	Futures	2711.96	2711.96	2696.97	2706.48	4306.0
2011-11-16 07:00:00	NQ	Futures	2706.19	2720.61	2701.87	2712.83	6349.0
2011-11-16 08:00:00	NQ	Futures	2712.83	2715.42	2704.18	2705.62	5476.0
2011-11-16 09:00:00	NQ	Futures	2705.33	2718.02	2699.56	2713.4	33423.0
2011-11-16 10:00:00	NQ	Futures	2713.69	2720.9	2701.29	2718.59	38973.0
2011-11-16 11:00:00	NQ	Futures	2718.88	2724.36	2708.21	2709.08	26382.0
2011-11-16 12:00:00	NQ	Futures	2709.08	2717.44	2707.06	2712.54	15453.0
2011-11-16 13:00:00	NQ	Futures	2712.54	2727.24	2711.67	2720.61	20490.0
2011-11-16 14:00:00	NQ	Futures	2720.61	2722.63	2711.38	2714.56	19982.0
2011-11-16 15:00:00	NQ	Futures	2714.56	2716.86	2676.21	2680.82	80913.0
2011-11-16 16:00:00	NQ	Futures	2680.53	2681.69	2658.04	2666.12	14750.0
2011-11-16 17:00:00	NQ	Futures	2666.12	2666.69	2663.52	2664.68	389.0
2011-11-16 18:00:00	NQ	Futures	2665.25	2666.98	2661.5	2665.54	1079.0
2011-11-16 19:00:00	NQ	Futures	2665.25	2669.0	2660.64	2663.23	843.0
2011-11-16 20:00:00	NQ	Futures	2662.37	2671.31	2658.33	2671.02	1267.0
2011-11-16 21:00:00	NQ	Futures	2671.02	2674.48	2667.85	2673.33	895.0
2011-11-16 22:00:00	NQ	Futures	2672.75	2679.38	2671.31	2678.23	767.0
2011-11-16 23:00:00	NQ	Futures	2677.94	2683.42	2676.5	2682.26	1106.0
2011-11-16 00:00:00	YM	Futures	11764.5	11769.4	11725.1	11743.8	687.0
2011-11-16 01:00:00	YM	Futures	11742.9	11746.8	11728.1	11734.0	660.0

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

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