PREVIEW / futures_1hour / 2012-06-25

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-06-25.parquet
  size:    48 KB
  rows:    1,456

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-25 00:00:00	ES	Futures	1344.4	1344.65	1343.13	1343.89	2817.0
2012-06-25 01:00:00	ES	Futures	1343.89	1345.16	1342.62	1343.89	4994.0
2012-06-25 02:00:00	ES	Futures	1344.14	1344.91	1342.11	1342.36	11920.0
2012-06-25 03:00:00	ES	Futures	1342.62	1343.13	1339.31	1339.57	62061.0
2012-06-25 04:00:00	ES	Futures	1339.57	1341.09	1339.31	1340.33	24513.0
2012-06-25 05:00:00	ES	Futures	1340.33	1341.09	1338.29	1339.06	27219.0
2012-06-25 06:00:00	ES	Futures	1339.06	1340.07	1337.79	1340.07	29663.0
2012-06-25 07:00:00	ES	Futures	1339.82	1340.07	1336.51	1338.55	37193.0
2012-06-25 08:00:00	ES	Futures	1338.55	1339.82	1336.77	1337.28	44329.0
2012-06-25 09:00:00	ES	Futures	1337.53	1338.55	1331.17	1333.46	262775.0
2012-06-25 10:00:00	ES	Futures	1333.21	1335.24	1328.38	1330.16	372133.0
2012-06-25 11:00:00	ES	Futures	1329.9	1330.67	1325.07	1325.58	229751.0
2012-06-25 12:00:00	ES	Futures	1325.58	1328.63	1324.82	1327.11	108260.0
2012-06-25 13:00:00	ES	Futures	1327.36	1330.67	1325.58	1329.65	102930.0
2012-06-25 14:00:00	ES	Futures	1329.9	1331.43	1326.6	1327.11	117579.0
2012-06-25 15:00:00	ES	Futures	1327.11	1332.7	1326.85	1329.39	267007.0
2012-06-25 16:00:00	ES	Futures	1329.14	1329.9	1327.61	1329.39	91545.0
2012-06-25 17:00:00	ES	Futures	1329.39	1329.65	1328.89	1329.14	2243.0
2012-06-25 18:00:00	ES	Futures	1328.89	1329.9	1328.12	1329.65	3970.0
2012-06-25 19:00:00	ES	Futures	1329.65	1331.17	1329.39	1330.92	3190.0
2012-06-25 20:00:00	ES	Futures	1330.92	1332.7	1330.41	1331.43	7964.0
2012-06-25 21:00:00	ES	Futures	1331.43	1332.95	1331.17	1332.7	6231.0
2012-06-25 22:00:00	ES	Futures	1332.7	1333.21	1331.17	1331.43	3832.0
2012-06-25 23:00:00	ES	Futures	1331.68	1333.21	1330.67	1330.92	5407.0
2012-06-25 00:00:00	NQ	Futures	2976.83	2977.41	2974.22	2975.67	211.0
2012-06-25 01:00:00	NQ	Futures	2975.67	2977.7	2973.35	2975.67	401.0
2012-06-25 02:00:00	NQ	Futures	2975.67	2978.57	2971.03	2971.9	1010.0
2012-06-25 03:00:00	NQ	Futures	2971.61	2973.35	2964.65	2965.52	3876.0
2012-06-25 04:00:00	NQ	Futures	2965.23	2969.87	2965.23	2967.55	2456.0
2012-06-25 05:00:00	NQ	Futures	2967.84	2969.0	2963.49	2965.23	1804.0
2012-06-25 06:00:00	NQ	Futures	2965.23	2967.55	2962.33	2966.97	2007.0
2012-06-25 07:00:00	NQ	Futures	2966.97	2967.26	2960.6	2964.65	2493.0
2012-06-25 08:00:00	NQ	Futures	2964.94	2968.42	2961.46	2963.2	3188.0
2012-06-25 09:00:00	NQ	Futures	2962.91	2966.97	2949.29	2953.06	30769.0
2012-06-25 10:00:00	NQ	Futures	2953.06	2958.28	2934.22	2940.3	36426.0
2012-06-25 11:00:00	NQ	Futures	2940.3	2940.59	2924.07	2924.94	21841.0
2012-06-25 12:00:00	NQ	Futures	2924.65	2934.22	2923.2	2931.03	13740.0
2012-06-25 13:00:00	NQ	Futures	2931.03	2938.85	2926.97	2934.8	11731.0
2012-06-25 14:00:00	NQ	Futures	2934.51	2937.69	2924.94	2927.26	15175.0
2012-06-25 15:00:00	NQ	Futures	2927.26	2940.88	2926.68	2930.16	29063.0
2012-06-25 16:00:00	NQ	Futures	2930.45	2934.22	2928.13	2932.77	8251.0
2012-06-25 17:00:00	NQ	Futures	2933.35	2933.35	2932.48	2932.77	21.0
2012-06-25 18:00:00	NQ	Futures	2932.19	2934.8	2931.32	2933.64	425.0
2012-06-25 19:00:00	NQ	Futures	2933.93	2936.82	2933.64	2935.95	281.0
2012-06-25 20:00:00	NQ	Futures	2935.66	2940.01	2935.66	2937.69	752.0
2012-06-25 21:00:00	NQ	Futures	2937.4	2940.3	2937.4	2939.72	349.0
2012-06-25 22:00:00	NQ	Futures	2939.43	2940.01	2936.82	2936.82	357.0
2012-06-25 23:00:00	NQ	Futures	2937.11	2939.72	2935.38	2935.95	478.0
2012-06-25 00:00:00	YM	Futures	12453.9	12455.9	12446.9	12449.9	210.0
2012-06-25 01:00:00	YM	Futures	12449.9	12457.9	12441.0	12450.9	465.0

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

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