PREVIEW / futures_1hour / 2012-07-16

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-07-16.parquet
  size:    48 KB
  rows:    1,461

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
2012-07-16 00:00:00	ES	Futures	1372.37	1372.37	1371.35	1371.6	1973.0
2012-07-16 01:00:00	ES	Futures	1371.86	1372.37	1371.1	1372.11	2849.0
2012-07-16 02:00:00	ES	Futures	1372.11	1372.62	1370.59	1371.1	5680.0
2012-07-16 03:00:00	ES	Futures	1370.84	1372.11	1369.57	1371.1	19763.0
2012-07-16 04:00:00	ES	Futures	1371.35	1372.62	1370.33	1370.59	11647.0
2012-07-16 05:00:00	ES	Futures	1370.59	1372.11	1369.82	1370.84	8249.0
2012-07-16 06:00:00	ES	Futures	1370.59	1372.88	1370.59	1371.35	7558.0
2012-07-16 07:00:00	ES	Futures	1371.35	1372.11	1370.84	1371.35	13639.0
2012-07-16 08:00:00	ES	Futures	1371.35	1371.86	1369.06	1371.1	65028.0
2012-07-16 09:00:00	ES	Futures	1371.35	1372.62	1367.03	1367.28	194948.0
2012-07-16 10:00:00	ES	Futures	1367.28	1373.13	1366.01	1371.1	268363.0
2012-07-16 11:00:00	ES	Futures	1370.84	1375.67	1370.33	1372.62	230129.0
2012-07-16 12:00:00	ES	Futures	1372.62	1373.89	1368.81	1371.1	166482.0
2012-07-16 13:00:00	ES	Futures	1371.1	1373.38	1369.57	1372.11	120610.0
2012-07-16 14:00:00	ES	Futures	1372.11	1374.91	1371.86	1372.62	134178.0
2012-07-16 15:00:00	ES	Futures	1372.88	1373.89	1369.32	1371.35	218639.0
2012-07-16 16:00:00	ES	Futures	1371.35	1371.86	1369.57	1370.33	58616.0
2012-07-16 17:00:00	ES	Futures	1370.33	1370.59	1369.57	1369.82	1005.0
2012-07-16 18:00:00	ES	Futures	1369.82	1370.33	1369.06	1369.57	2771.0
2012-07-16 19:00:00	ES	Futures	1369.57	1370.08	1369.32	1369.82	1410.0
2012-07-16 20:00:00	ES	Futures	1370.08	1371.6	1369.82	1371.1	5154.0
2012-07-16 21:00:00	ES	Futures	1371.35	1376.94	1370.59	1374.66	16504.0
2012-07-16 22:00:00	ES	Futures	1374.91	1376.44	1374.91	1375.16	4323.0
2012-07-16 23:00:00	ES	Futures	1375.16	1377.71	1375.16	1377.2	7328.0
2012-07-16 00:00:00	NQ	Futures	2982.63	2982.63	2980.6	2981.76	146.0
2012-07-16 01:00:00	NQ	Futures	2982.05	2983.5	2980.89	2981.76	172.0
2012-07-16 02:00:00	NQ	Futures	2981.47	2984.37	2979.73	2980.31	429.0
2012-07-16 03:00:00	NQ	Futures	2980.31	2982.34	2977.41	2981.47	1305.0
2012-07-16 04:00:00	NQ	Futures	2981.18	2984.66	2979.44	2980.02	800.0
2012-07-16 05:00:00	NQ	Futures	2979.73	2982.92	2978.57	2980.6	702.0
2012-07-16 06:00:00	NQ	Futures	2980.31	2985.24	2980.31	2982.05	695.0
2012-07-16 07:00:00	NQ	Futures	2981.47	2983.79	2980.02	2981.76	1323.0
2012-07-16 08:00:00	NQ	Futures	2981.76	2983.79	2978.57	2981.47	4156.0
2012-07-16 09:00:00	NQ	Futures	2981.76	2989.58	2970.45	2971.9	23245.0
2012-07-16 10:00:00	NQ	Futures	2973.06	2987.55	2969.87	2982.92	23591.0
2012-07-16 11:00:00	NQ	Futures	2982.92	2996.83	2981.18	2989.58	23330.0
2012-07-16 12:00:00	NQ	Futures	2989.58	2993.06	2975.67	2980.89	19850.0
2012-07-16 13:00:00	NQ	Futures	2981.18	2991.32	2978.86	2986.68	15628.0
2012-07-16 14:00:00	NQ	Futures	2986.39	2991.61	2980.89	2983.79	12542.0
2012-07-16 15:00:00	NQ	Futures	2983.79	2987.55	2975.38	2981.76	22159.0
2012-07-16 16:00:00	NQ	Futures	2981.76	2984.37	2979.44	2982.34	6036.0
2012-07-16 17:00:00	NQ	Futures	2982.34	2982.63	2980.6	2980.6	72.0
2012-07-16 18:00:00	NQ	Futures	2980.89	2982.34	2980.02	2980.31	236.0
2012-07-16 19:00:00	NQ	Futures	2980.6	2981.76	2980.02	2981.18	148.0
2012-07-16 20:00:00	NQ	Futures	2981.18	2984.66	2981.18	2984.37	382.0
2012-07-16 21:00:00	NQ	Futures	2984.37	2995.67	2982.34	2991.32	2141.0
2012-07-16 22:00:00	NQ	Futures	2991.32	2993.93	2991.03	2991.9	564.0
2012-07-16 23:00:00	NQ	Futures	2992.19	2996.54	2992.19	2995.09	808.0
2012-07-16 00:00:00	YM	Futures	12614.0	12617.0	12608.0	12612.0	172.0
2012-07-16 01:00:00	YM	Futures	12613.0	12617.0	12608.0	12615.0	214.0

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

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