PREVIEW / futures_1hour / 2012-06-29

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-06-29.parquet
  size:    44 KB
  rows:    1,236

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-06-29 00:00:00	ES	Futures	1360.67	1361.69	1358.38	1359.65	13991.0
2012-06-29 01:00:00	ES	Futures	1359.4	1363.47	1358.38	1363.21	15050.0
2012-06-29 02:00:00	ES	Futures	1363.21	1366.01	1360.92	1365.25	40338.0
2012-06-29 03:00:00	ES	Futures	1365.25	1366.01	1361.69	1361.94	76292.0
2012-06-29 04:00:00	ES	Futures	1361.94	1363.98	1359.91	1361.69	42754.0
2012-06-29 05:00:00	ES	Futures	1361.43	1363.72	1359.91	1362.2	29678.0
2012-06-29 06:00:00	ES	Futures	1362.2	1363.72	1360.67	1363.72	33480.0
2012-06-29 07:00:00	ES	Futures	1363.47	1366.26	1362.7	1364.23	62202.0
2012-06-29 08:00:00	ES	Futures	1364.23	1372.11	1363.98	1370.08	140839.0
2012-06-29 09:00:00	ES	Futures	1370.08	1370.59	1365.76	1368.3	300767.0
2012-06-29 10:00:00	ES	Futures	1368.3	1373.64	1368.04	1371.35	356206.0
2012-06-29 11:00:00	ES	Futures	1371.35	1373.13	1370.08	1371.86	236817.0
2012-06-29 12:00:00	ES	Futures	1371.86	1372.62	1370.59	1372.62	100311.0
2012-06-29 13:00:00	ES	Futures	1372.37	1374.15	1371.86	1373.64	100266.0
2012-06-29 14:00:00	ES	Futures	1373.38	1376.18	1372.62	1375.93	125802.0
2012-06-29 15:00:00	ES	Futures	1375.93	1380.25	1373.13	1380.0	467886.0
2012-06-29 16:00:00	ES	Futures	1379.74	1382.79	1379.23	1381.52	222865.0
2012-06-29 00:00:00	NQ	Futures	2965.52	2966.68	2960.31	2963.2	1682.0
2012-06-29 01:00:00	NQ	Futures	2963.2	2971.03	2961.17	2971.03	741.0
2012-06-29 02:00:00	NQ	Futures	2970.74	2975.09	2965.81	2974.22	3254.0
2012-06-29 03:00:00	NQ	Futures	2974.22	2976.54	2967.26	2968.13	7025.0
2012-06-29 04:00:00	NQ	Futures	2968.13	2971.61	2964.07	2967.84	3445.0
2012-06-29 05:00:00	NQ	Futures	2967.55	2971.03	2964.36	2967.84	2218.0
2012-06-29 06:00:00	NQ	Futures	2967.55	2971.61	2964.65	2971.03	3245.0
2012-06-29 07:00:00	NQ	Futures	2970.74	2977.41	2969.87	2973.64	4810.0
2012-06-29 08:00:00	NQ	Futures	2973.64	2989.58	2973.64	2986.1	10279.0
2012-06-29 09:00:00	NQ	Futures	2986.39	2996.54	2982.34	2989.29	43608.0
2012-06-29 10:00:00	NQ	Futures	2989.58	3004.95	2989.29	3001.76	41630.0
2012-06-29 11:00:00	NQ	Futures	3001.76	3009.88	3000.6	3005.24	26177.0
2012-06-29 12:00:00	NQ	Futures	3005.53	3011.04	3004.66	3011.04	12683.0
2012-06-29 13:00:00	NQ	Futures	3010.46	3013.93	3010.46	3012.48	11301.0
2012-06-29 14:00:00	NQ	Futures	3012.48	3020.89	3012.19	3020.02	15924.0
2012-06-29 15:00:00	NQ	Futures	3020.02	3027.56	3011.61	3026.98	38653.0
2012-06-29 16:00:00	NQ	Futures	3027.27	3033.65	3026.11	3029.3	12417.0
2012-06-29 00:00:00	YM	Futures	12578.2	12584.2	12562.3	12569.2	1504.0
2012-06-29 01:00:00	YM	Futures	12569.2	12600.1	12565.3	12597.1	771.0
2012-06-29 02:00:00	YM	Futures	12596.1	12614.0	12584.2	12611.0	2294.0
2012-06-29 03:00:00	YM	Futures	12610.0	12616.0	12578.2	12581.2	6320.0
2012-06-29 04:00:00	YM	Futures	12581.2	12595.1	12560.3	12573.2	3185.0
2012-06-29 05:00:00	YM	Futures	12574.2	12587.1	12563.3	12577.2	2075.0
2012-06-29 06:00:00	YM	Futures	12577.2	12592.1	12569.2	12587.1	2559.0
2012-06-29 07:00:00	YM	Futures	12587.1	12607.0	12579.2	12590.1	4181.0
2012-06-29 08:00:00	YM	Futures	12589.1	12659.7	12589.1	12648.8	9711.0
2012-06-29 09:00:00	YM	Futures	12649.8	12662.7	12626.9	12654.8	21711.0
2012-06-29 10:00:00	YM	Futures	12653.8	12690.6	12653.8	12677.6	22093.0
2012-06-29 11:00:00	YM	Futures	12677.6	12686.6	12668.7	12679.6	12493.0
2012-06-29 12:00:00	YM	Futures	12678.6	12684.6	12668.7	12681.6	5314.0
2012-06-29 13:00:00	YM	Futures	12682.6	12699.5	12678.6	12694.5	5889.0
2012-06-29 14:00:00	YM	Futures	12694.5	12711.4	12684.6	12707.5	6031.0
2012-06-29 15:00:00	YM	Futures	12708.5	12740.3	12679.6	12738.3	22068.0

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

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