PREVIEW / futures_1hour / 2012-06-27

all futures 1-hour files

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

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-27 00:00:00	ES	Futures	1337.79	1338.55	1337.02	1338.55	3146.0
2012-06-27 01:00:00	ES	Futures	1338.29	1339.57	1338.04	1339.57	3046.0
2012-06-27 02:00:00	ES	Futures	1339.31	1339.57	1337.79	1338.04	8597.0
2012-06-27 03:00:00	ES	Futures	1338.29	1340.07	1336.26	1339.57	31608.0
2012-06-27 04:00:00	ES	Futures	1339.57	1339.57	1335.75	1337.28	21558.0
2012-06-27 05:00:00	ES	Futures	1337.53	1338.55	1337.02	1338.04	15930.0
2012-06-27 06:00:00	ES	Futures	1338.04	1340.07	1337.79	1339.57	19414.0
2012-06-27 07:00:00	ES	Futures	1339.31	1340.84	1339.06	1340.58	19518.0
2012-06-27 08:00:00	ES	Futures	1340.58	1341.85	1337.53	1338.55	51152.0
2012-06-27 09:00:00	ES	Futures	1338.55	1344.4	1337.53	1342.62	216267.0
2012-06-27 10:00:00	ES	Futures	1342.87	1348.72	1341.6	1346.69	343970.0
2012-06-27 11:00:00	ES	Futures	1346.69	1349.23	1343.89	1347.96	231815.0
2012-06-27 12:00:00	ES	Futures	1347.96	1350.5	1347.7	1348.97	138707.0
2012-06-27 13:00:00	ES	Futures	1349.23	1350.25	1346.18	1347.19	102594.0
2012-06-27 14:00:00	ES	Futures	1347.19	1347.7	1345.16	1346.18	88480.0
2012-06-27 15:00:00	ES	Futures	1346.18	1351.26	1345.67	1348.47	218797.0
2012-06-27 16:00:00	ES	Futures	1348.72	1349.48	1347.7	1348.21	74428.0
2012-06-27 17:00:00	ES	Futures	1348.21	1348.47	1347.19	1347.45	1162.0
2012-06-27 18:00:00	ES	Futures	1347.45	1348.97	1347.45	1347.7	2626.0
2012-06-27 19:00:00	ES	Futures	1347.7	1347.96	1346.69	1346.94	1806.0
2012-06-27 20:00:00	ES	Futures	1346.94	1349.74	1346.43	1349.74	6938.0
2012-06-27 21:00:00	ES	Futures	1349.48	1350.5	1348.21	1348.72	5497.0
2012-06-27 22:00:00	ES	Futures	1348.97	1348.97	1347.19	1348.72	3178.0
2012-06-27 23:00:00	ES	Futures	1348.72	1349.99	1347.19	1349.23	4853.0
2012-06-27 00:00:00	NQ	Futures	2956.25	2957.41	2954.8	2957.41	331.0
2012-06-27 01:00:00	NQ	Futures	2957.12	2962.04	2956.54	2960.02	724.0
2012-06-27 02:00:00	NQ	Futures	2959.73	2959.73	2956.83	2957.12	688.0
2012-06-27 03:00:00	NQ	Futures	2957.7	2961.17	2953.06	2959.73	2977.0
2012-06-27 04:00:00	NQ	Futures	2959.44	2959.44	2950.45	2954.51	2349.0
2012-06-27 05:00:00	NQ	Futures	2954.51	2955.67	2951.61	2954.51	1117.0
2012-06-27 06:00:00	NQ	Futures	2954.22	2958.57	2953.06	2956.25	1482.0
2012-06-27 07:00:00	NQ	Futures	2956.25	2959.44	2955.09	2959.15	2630.0
2012-06-27 08:00:00	NQ	Futures	2958.86	2962.04	2952.77	2954.8	3845.0
2012-06-27 09:00:00	NQ	Futures	2955.09	2971.32	2953.35	2963.2	27825.0
2012-06-27 10:00:00	NQ	Futures	2963.49	2981.76	2961.75	2975.67	43732.0
2012-06-27 11:00:00	NQ	Futures	2975.67	2978.86	2969.0	2974.22	21014.0
2012-06-27 12:00:00	NQ	Futures	2974.22	2980.6	2973.64	2974.22	14043.0
2012-06-27 13:00:00	NQ	Futures	2974.22	2976.25	2962.33	2965.23	14275.0
2012-06-27 14:00:00	NQ	Futures	2964.94	2966.68	2958.86	2962.62	14755.0
2012-06-27 15:00:00	NQ	Futures	2962.62	2976.54	2961.46	2968.71	26367.0
2012-06-27 16:00:00	NQ	Futures	2968.71	2971.61	2966.39	2966.97	4653.0
2012-06-27 17:00:00	NQ	Futures	2966.68	2967.26	2966.39	2966.39	42.0
2012-06-27 18:00:00	NQ	Futures	2966.97	2967.55	2965.52	2966.1	196.0
2012-06-27 19:00:00	NQ	Futures	2966.1	2966.1	2963.49	2964.36	187.0
2012-06-27 20:00:00	NQ	Futures	2964.07	2972.19	2964.07	2971.61	731.0
2012-06-27 21:00:00	NQ	Futures	2971.9	2972.48	2967.55	2968.71	471.0
2012-06-27 22:00:00	NQ	Futures	2968.71	2969.29	2965.81	2968.42	430.0
2012-06-27 23:00:00	NQ	Futures	2968.71	2971.61	2966.39	2969.58	624.0
2012-06-27 00:00:00	YM	Futures	12414.1	12420.1	12409.2	12416.1	244.0
2012-06-27 01:00:00	YM	Futures	12417.1	12424.1	12413.1	12422.1	215.0

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

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