PREVIEW / futures_1hour / 2012-06-15

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-06-15.parquet
  size:    41 KB
  rows:    1,207

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-15 00:00:00	ES	Futures	1350.25	1351.52	1350.25	1351.26	2273.0
2012-06-15 01:00:00	ES	Futures	1351.01	1351.26	1349.23	1349.74	3763.0
2012-06-15 02:00:00	ES	Futures	1349.99	1351.77	1348.97	1350.25	9312.0
2012-06-15 03:00:00	ES	Futures	1349.99	1354.57	1348.97	1352.28	39233.0
2012-06-15 04:00:00	ES	Futures	1352.53	1355.08	1352.03	1353.81	24491.0
2012-06-15 05:00:00	ES	Futures	1353.81	1355.59	1353.04	1353.55	31970.0
2012-06-15 06:00:00	ES	Futures	1353.55	1353.81	1350.75	1353.3	30595.0
2012-06-15 07:00:00	ES	Futures	1353.3	1354.57	1351.52	1351.52	48079.0
2012-06-15 08:00:00	ES	Futures	1351.52	1351.77	1348.97	1349.23	83718.0
2012-06-15 09:00:00	ES	Futures	1349.48	1352.28	1348.21	1352.03	289984.0
2012-06-15 10:00:00	ES	Futures	1352.03	1353.81	1349.99	1352.79	280673.0
2012-06-15 11:00:00	ES	Futures	1352.53	1354.57	1351.52	1352.53	192483.0
2012-06-15 12:00:00	ES	Futures	1352.53	1353.3	1350.25	1351.52	111431.0
2012-06-15 13:00:00	ES	Futures	1351.77	1354.82	1351.52	1353.55	82076.0
2012-06-15 14:00:00	ES	Futures	1353.55	1357.11	1353.3	1354.82	102201.0
2012-06-15 15:00:00	ES	Futures	1354.57	1359.91	1354.31	1358.38	264920.0
2012-06-15 16:00:00	ES	Futures	1358.13	1361.43	1356.86	1361.18	130010.0
2012-06-15 00:00:00	NQ	Futures	2944.07	2945.52	2943.49	2944.94	542.0
2012-06-15 01:00:00	NQ	Futures	2944.65	2945.23	2941.75	2942.04	333.0
2012-06-15 02:00:00	NQ	Futures	2942.62	2946.97	2941.17	2943.78	868.0
2012-06-15 03:00:00	NQ	Futures	2944.07	2951.9	2941.17	2948.42	5394.0
2012-06-15 04:00:00	NQ	Futures	2948.42	2954.22	2947.84	2952.19	2875.0
2012-06-15 05:00:00	NQ	Futures	2952.19	2955.67	2950.74	2952.19	3477.0
2012-06-15 06:00:00	NQ	Futures	2952.48	2952.77	2946.39	2951.03	2751.0
2012-06-15 07:00:00	NQ	Futures	2950.74	2955.38	2947.26	2947.55	6804.0
2012-06-15 08:00:00	NQ	Futures	2947.84	2948.71	2941.46	2941.46	11166.0
2012-06-15 09:00:00	NQ	Futures	2942.04	2955.38	2937.69	2955.09	43376.0
2012-06-15 10:00:00	NQ	Futures	2955.38	2962.04	2953.64	2960.02	47533.0
2012-06-15 11:00:00	NQ	Futures	2960.02	2966.39	2957.99	2961.46	23517.0
2012-06-15 12:00:00	NQ	Futures	2961.75	2962.62	2957.12	2960.88	10560.0
2012-06-15 13:00:00	NQ	Futures	2961.17	2965.52	2960.02	2962.91	10745.0
2012-06-15 14:00:00	NQ	Futures	2963.2	2970.74	2962.04	2964.65	13292.0
2012-06-15 15:00:00	NQ	Futures	2964.65	2977.41	2964.07	2974.51	28066.0
2012-06-15 16:00:00	NQ	Futures	2974.22	2975.96	2970.74	2975.38	7535.0
2012-06-15 00:00:00	YM	Futures	12548.4	12556.3	12546.4	12555.3	356.0
2012-06-15 01:00:00	YM	Futures	12554.3	12556.3	12541.4	12545.4	174.0
2012-06-15 02:00:00	YM	Futures	12545.4	12559.3	12538.4	12550.4	640.0
2012-06-15 03:00:00	YM	Futures	12549.4	12585.2	12539.4	12569.2	3736.0
2012-06-15 04:00:00	YM	Futures	12570.2	12589.1	12567.3	12580.2	1919.0
2012-06-15 05:00:00	YM	Futures	12579.2	12595.1	12574.2	12578.2	2593.0
2012-06-15 06:00:00	YM	Futures	12578.2	12580.2	12563.3	12578.2	1927.0
2012-06-15 07:00:00	YM	Futures	12578.2	12591.1	12569.2	12571.2	3375.0
2012-06-15 08:00:00	YM	Futures	12570.2	12573.2	12546.4	12549.4	3869.0
2012-06-15 09:00:00	YM	Futures	12549.4	12584.2	12543.4	12578.2	17481.0
2012-06-15 10:00:00	YM	Futures	12577.2	12591.1	12555.3	12576.2	18368.0
2012-06-15 11:00:00	YM	Futures	12575.2	12586.2	12566.3	12574.2	9359.0
2012-06-15 12:00:00	YM	Futures	12575.2	12578.2	12555.3	12566.3	4707.0
2012-06-15 13:00:00	YM	Futures	12567.3	12592.1	12567.3	12586.2	7172.0
2012-06-15 14:00:00	YM	Futures	12587.1	12613.0	12584.2	12595.1	7187.0
2012-06-15 15:00:00	YM	Futures	12595.1	12635.9	12592.1	12622.0	13730.0

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

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