PREVIEW / futures_1hour / 2012-05-29

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-05-29.parquet
  size:    48 KB
  rows:    1,464

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-05-29 00:00:00	ES	Futures	1340.56	1340.82	1339.81	1340.82	4698.0
2012-05-29 01:00:00	ES	Futures	1340.56	1343.09	1340.56	1342.59	5651.0
2012-05-29 02:00:00	ES	Futures	1342.59	1343.35	1341.58	1342.59	7642.0
2012-05-29 03:00:00	ES	Futures	1342.59	1344.86	1341.83	1344.61	36229.0
2012-05-29 04:00:00	ES	Futures	1344.36	1344.61	1339.3	1340.06	37408.0
2012-05-29 05:00:00	ES	Futures	1340.31	1341.58	1336.26	1337.53	34779.0
2012-05-29 06:00:00	ES	Futures	1337.53	1340.06	1336.52	1339.81	28445.0
2012-05-29 07:00:00	ES	Futures	1339.81	1340.56	1338.29	1339.55	26029.0
2012-05-29 08:00:00	ES	Futures	1339.55	1340.31	1337.28	1339.3	52500.0
2012-05-29 09:00:00	ES	Futures	1339.3	1344.86	1338.29	1342.08	266632.0
2012-05-29 10:00:00	ES	Futures	1342.08	1349.67	1340.31	1348.15	386570.0
2012-05-29 11:00:00	ES	Futures	1347.9	1348.15	1339.3	1340.56	347400.0
2012-05-29 12:00:00	ES	Futures	1340.56	1341.58	1337.53	1339.3	246364.0
2012-05-29 13:00:00	ES	Futures	1339.3	1341.58	1337.28	1341.07	110916.0
2012-05-29 14:00:00	ES	Futures	1341.07	1343.6	1339.3	1343.09	118407.0
2012-05-29 15:00:00	ES	Futures	1343.09	1347.9	1341.83	1347.39	234224.0
2012-05-29 16:00:00	ES	Futures	1347.14	1350.18	1346.89	1348.66	110251.0
2012-05-29 17:00:00	ES	Futures	1348.66	1348.66	1347.39	1347.65	5448.0
2012-05-29 18:00:00	ES	Futures	1347.39	1347.9	1345.12	1345.88	10232.0
2012-05-29 19:00:00	ES	Futures	1345.62	1346.38	1344.86	1345.62	5744.0
2012-05-29 20:00:00	ES	Futures	1345.62	1346.38	1341.83	1342.33	14544.0
2012-05-29 21:00:00	ES	Futures	1342.33	1343.35	1341.07	1342.33	10183.0
2012-05-29 22:00:00	ES	Futures	1342.33	1342.59	1340.56	1341.32	6119.0
2012-05-29 23:00:00	ES	Futures	1341.58	1342.84	1341.07	1341.58	4079.0
2012-05-29 00:00:00	NQ	Futures	2943.77	2944.93	2942.62	2944.35	306.0
2012-05-29 01:00:00	NQ	Futures	2944.35	2947.82	2944.06	2947.24	882.0
2012-05-29 02:00:00	NQ	Futures	2947.24	2949.27	2945.8	2947.53	1004.0
2012-05-29 03:00:00	NQ	Futures	2946.95	2954.76	2946.66	2953.03	5224.0
2012-05-29 04:00:00	NQ	Futures	2953.03	2953.32	2943.77	2944.93	3744.0
2012-05-29 05:00:00	NQ	Futures	2944.64	2947.82	2935.96	2938.57	4014.0
2012-05-29 06:00:00	NQ	Futures	2938.28	2945.8	2936.83	2945.22	3450.0
2012-05-29 07:00:00	NQ	Futures	2944.93	2945.51	2940.01	2942.33	3247.0
2012-05-29 08:00:00	NQ	Futures	2942.04	2943.19	2936.25	2941.46	8440.0
2012-05-29 09:00:00	NQ	Futures	2941.75	2949.27	2937.99	2943.19	37783.0
2012-05-29 10:00:00	NQ	Futures	2944.06	2972.98	2939.15	2965.46	51557.0
2012-05-29 11:00:00	NQ	Futures	2965.17	2965.75	2940.3	2942.9	36570.0
2012-05-29 12:00:00	NQ	Futures	2942.9	2945.22	2932.2	2940.3	33427.0
2012-05-29 13:00:00	NQ	Futures	2940.3	2945.51	2935.1	2944.93	19868.0
2012-05-29 14:00:00	NQ	Futures	2944.93	2954.18	2942.04	2953.03	20690.0
2012-05-29 15:00:00	NQ	Futures	2953.03	2961.12	2947.53	2957.36	32197.0
2012-05-29 16:00:00	NQ	Futures	2957.36	2967.2	2957.36	2960.26	8314.0
2012-05-29 17:00:00	NQ	Futures	2960.26	2960.55	2957.94	2958.81	284.0
2012-05-29 18:00:00	NQ	Futures	2959.1	2961.12	2955.63	2957.08	416.0
2012-05-29 19:00:00	NQ	Futures	2957.08	2957.94	2954.47	2955.34	475.0
2012-05-29 20:00:00	NQ	Futures	2955.63	2956.79	2948.4	2948.4	1098.0
2012-05-29 21:00:00	NQ	Futures	2948.98	2950.42	2945.8	2947.82	731.0
2012-05-29 22:00:00	NQ	Futures	2947.53	2948.11	2943.48	2945.8	731.0
2012-05-29 23:00:00	NQ	Futures	2945.22	2948.98	2944.64	2945.22	437.0
2012-05-29 00:00:00	YM	Futures	12456.7	12461.7	12451.8	12458.7	258.0
2012-05-29 01:00:00	YM	Futures	12459.7	12478.7	12459.7	12473.7	646.0

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

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