PREVIEW / futures_1hour / 2012-06-26

all futures 1-hour files

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

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-26 00:00:00	ES	Futures	1330.92	1331.43	1329.9	1330.92	3918.0
2012-06-26 01:00:00	ES	Futures	1330.92	1331.94	1330.41	1331.94	3145.0
2012-06-26 02:00:00	ES	Futures	1331.68	1332.95	1330.67	1331.68	5977.0
2012-06-26 03:00:00	ES	Futures	1331.68	1334.99	1330.92	1333.97	36574.0
2012-06-26 04:00:00	ES	Futures	1333.97	1335.24	1330.41	1330.41	27796.0
2012-06-26 05:00:00	ES	Futures	1330.67	1333.97	1328.89	1333.72	30623.0
2012-06-26 06:00:00	ES	Futures	1333.72	1333.97	1331.94	1332.95	16698.0
2012-06-26 07:00:00	ES	Futures	1332.95	1333.72	1329.14	1330.67	31452.0
2012-06-26 08:00:00	ES	Futures	1330.41	1331.68	1328.89	1331.43	56411.0
2012-06-26 09:00:00	ES	Futures	1331.17	1336.51	1330.67	1333.21	183333.0
2012-06-26 10:00:00	ES	Futures	1333.21	1336.26	1327.87	1330.41	347044.0
2012-06-26 11:00:00	ES	Futures	1330.41	1333.97	1325.58	1332.45	299940.0
2012-06-26 12:00:00	ES	Futures	1332.7	1337.28	1332.45	1335.24	152380.0
2012-06-26 13:00:00	ES	Futures	1335.24	1336.51	1332.95	1335.24	93015.0
2012-06-26 14:00:00	ES	Futures	1335.5	1340.58	1334.99	1338.04	207684.0
2012-06-26 15:00:00	ES	Futures	1337.79	1340.33	1336.01	1336.26	194747.0
2012-06-26 16:00:00	ES	Futures	1336.51	1338.55	1335.75	1338.04	84481.0
2012-06-26 17:00:00	ES	Futures	1338.04	1338.04	1337.53	1337.79	1713.0
2012-06-26 18:00:00	ES	Futures	1337.79	1338.8	1337.02	1337.28	2595.0
2012-06-26 19:00:00	ES	Futures	1337.02	1337.53	1336.26	1336.51	2343.0
2012-06-26 20:00:00	ES	Futures	1336.51	1336.77	1334.73	1335.5	6968.0
2012-06-26 21:00:00	ES	Futures	1335.5	1337.28	1334.48	1336.77	5455.0
2012-06-26 22:00:00	ES	Futures	1336.77	1338.04	1336.77	1337.79	3340.0
2012-06-26 23:00:00	ES	Futures	1337.53	1339.06	1337.53	1338.04	3565.0
2012-06-26 00:00:00	NQ	Futures	2936.24	2937.69	2934.51	2937.11	283.0
2012-06-26 01:00:00	NQ	Futures	2936.53	2939.14	2935.66	2939.14	402.0
2012-06-26 02:00:00	NQ	Futures	2939.14	2941.17	2936.53	2938.27	435.0
2012-06-26 03:00:00	NQ	Futures	2937.98	2943.78	2935.66	2942.04	2965.0
2012-06-26 04:00:00	NQ	Futures	2941.75	2944.94	2935.66	2935.66	2706.0
2012-06-26 05:00:00	NQ	Futures	2935.66	2942.62	2931.9	2942.62	3075.0
2012-06-26 06:00:00	NQ	Futures	2942.33	2942.91	2939.14	2940.88	1574.0
2012-06-26 07:00:00	NQ	Futures	2940.59	2942.62	2932.77	2935.38	3805.0
2012-06-26 08:00:00	NQ	Futures	2935.38	2937.4	2931.9	2936.82	6297.0
2012-06-26 09:00:00	NQ	Futures	2936.82	2952.48	2934.22	2945.81	24953.0
2012-06-26 10:00:00	NQ	Futures	2945.52	2956.83	2933.35	2938.56	38055.0
2012-06-26 11:00:00	NQ	Futures	2938.27	2947.26	2928.13	2943.78	30060.0
2012-06-26 12:00:00	NQ	Futures	2943.78	2951.03	2941.75	2946.97	13025.0
2012-06-26 13:00:00	NQ	Futures	2946.97	2947.84	2938.27	2943.78	11800.0
2012-06-26 14:00:00	NQ	Futures	2943.78	2958.86	2943.78	2952.48	22001.0
2012-06-26 15:00:00	NQ	Futures	2952.19	2957.7	2949.87	2950.74	24275.0
2012-06-26 16:00:00	NQ	Futures	2950.74	2956.25	2949.58	2953.64	5826.0
2012-06-26 17:00:00	NQ	Futures	2953.35	2954.8	2953.35	2953.93	39.0
2012-06-26 18:00:00	NQ	Futures	2953.64	2955.09	2952.77	2952.77	174.0
2012-06-26 19:00:00	NQ	Futures	2952.48	2953.06	2951.03	2951.32	152.0
2012-06-26 20:00:00	NQ	Futures	2951.03	2951.03	2948.13	2949.29	299.0
2012-06-26 21:00:00	NQ	Futures	2949.87	2954.51	2948.13	2953.06	437.0
2012-06-26 22:00:00	NQ	Futures	2953.35	2956.54	2952.77	2955.67	417.0
2012-06-26 23:00:00	NQ	Futures	2955.96	2958.57	2955.09	2956.54	311.0
2012-06-26 00:00:00	YM	Futures	12379.3	12381.3	12372.4	12377.3	413.0
2012-06-26 01:00:00	YM	Futures	12377.3	12386.3	12375.3	12386.3	241.0

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

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