PREVIEW / futures_1hour / 2012-07-23

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-07-23.parquet
  size:    49 KB
  rows:    1,488

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-23 00:00:00	ES	Futures	1373.89	1374.66	1373.64	1373.89	4099.0
2012-07-23 01:00:00	ES	Futures	1373.64	1375.42	1373.38	1373.38	6389.0
2012-07-23 02:00:00	ES	Futures	1373.38	1374.15	1372.11	1372.88	15675.0
2012-07-23 03:00:00	ES	Futures	1372.88	1374.15	1369.32	1370.59	43564.0
2012-07-23 04:00:00	ES	Futures	1370.33	1371.86	1368.81	1369.82	34351.0
2012-07-23 05:00:00	ES	Futures	1369.82	1370.33	1365.25	1366.01	37452.0
2012-07-23 06:00:00	ES	Futures	1366.26	1368.3	1364.23	1367.54	31749.0
2012-07-23 07:00:00	ES	Futures	1367.54	1368.55	1365.25	1366.26	36765.0
2012-07-23 08:00:00	ES	Futures	1366.26	1366.52	1360.42	1362.45	113703.0
2012-07-23 09:00:00	ES	Futures	1362.45	1363.72	1354.82	1357.37	337769.0
2012-07-23 10:00:00	ES	Futures	1357.37	1361.94	1355.08	1360.92	352214.0
2012-07-23 11:00:00	ES	Futures	1360.67	1363.72	1359.65	1362.7	316041.0
2012-07-23 12:00:00	ES	Futures	1362.45	1365.76	1359.91	1364.74	146511.0
2012-07-23 13:00:00	ES	Futures	1364.99	1366.52	1363.72	1365.76	102972.0
2012-07-23 14:00:00	ES	Futures	1366.01	1367.79	1364.99	1365.5	111506.0
2012-07-23 15:00:00	ES	Futures	1365.5	1371.6	1363.72	1368.04	255690.0
2012-07-23 16:00:00	ES	Futures	1368.04	1368.3	1362.96	1363.47	90170.0
2012-07-23 17:00:00	ES	Futures	1363.47	1364.23	1361.18	1361.43	5855.0
2012-07-23 18:00:00	ES	Futures	1360.16	1363.21	1359.91	1362.96	13567.0
2012-07-23 19:00:00	ES	Futures	1362.96	1364.23	1362.45	1363.98	3110.0
2012-07-23 20:00:00	ES	Futures	1363.98	1367.03	1363.98	1365.25	11209.0
2012-07-23 21:00:00	ES	Futures	1364.99	1366.52	1364.74	1366.52	3858.0
2012-07-23 22:00:00	ES	Futures	1366.52	1367.79	1364.99	1366.01	8224.0
2012-07-23 23:00:00	ES	Futures	1366.01	1367.03	1363.98	1367.03	3721.0
2012-07-23 00:00:00	NQ	Futures	3016.54	3017.7	3014.51	3014.8	655.0
2012-07-23 01:00:00	NQ	Futures	3015.09	3016.25	3011.04	3011.04	1780.0
2012-07-23 02:00:00	NQ	Futures	3011.04	3011.9	3003.21	3009.59	2045.0
2012-07-23 03:00:00	NQ	Futures	3009.59	3011.9	3001.47	3004.37	3850.0
2012-07-23 04:00:00	NQ	Futures	3004.66	3007.56	3000.02	3001.76	2992.0
2012-07-23 05:00:00	NQ	Futures	3001.76	3002.92	2991.61	2993.35	3536.0
2012-07-23 06:00:00	NQ	Futures	2993.35	2997.12	2988.71	2995.38	3823.0
2012-07-23 07:00:00	NQ	Futures	2995.67	2996.25	2988.71	2992.19	3390.0
2012-07-23 08:00:00	NQ	Futures	2992.19	2992.77	2978.57	2980.6	10345.0
2012-07-23 09:00:00	NQ	Futures	2980.31	2983.79	2949.0	2958.28	57974.0
2012-07-23 10:00:00	NQ	Futures	2958.28	2973.35	2954.22	2968.13	49420.0
2012-07-23 11:00:00	NQ	Futures	2967.84	2976.83	2964.65	2974.22	32125.0
2012-07-23 12:00:00	NQ	Futures	2974.22	2985.53	2969.29	2982.34	24076.0
2012-07-23 13:00:00	NQ	Futures	2982.63	2992.19	2980.31	2989.87	15207.0
2012-07-23 14:00:00	NQ	Futures	2990.16	2997.41	2987.84	2990.45	16366.0
2012-07-23 15:00:00	NQ	Futures	2990.16	3004.37	2985.82	2994.8	34385.0
2012-07-23 16:00:00	NQ	Futures	2994.51	2995.67	2984.37	2986.1	7986.0
2012-07-23 17:00:00	NQ	Futures	2985.82	2986.68	2982.63	2982.63	437.0
2012-07-23 18:00:00	NQ	Futures	2981.47	2986.39	2979.44	2986.39	710.0
2012-07-23 19:00:00	NQ	Futures	2986.39	2988.13	2984.66	2987.84	469.0
2012-07-23 20:00:00	NQ	Futures	2988.13	2993.06	2986.97	2988.71	1306.0
2012-07-23 21:00:00	NQ	Futures	2988.71	2992.48	2987.84	2991.61	554.0
2012-07-23 22:00:00	NQ	Futures	2991.61	2994.22	2989.58	2991.9	1268.0
2012-07-23 23:00:00	NQ	Futures	2992.19	2994.51	2988.71	2994.51	955.0
2012-07-23 00:00:00	YM	Futures	12633.9	12637.9	12631.9	12631.9	262.0
2012-07-23 01:00:00	YM	Futures	12631.9	12643.8	12626.9	12626.9	432.0

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

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