PREVIEW / futures_1hour / 2012-07-25

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-07-25.parquet
  size:    49 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-07-25 00:00:00	ES	Futures	1349.48	1350.5	1349.48	1350.25	3869.0
2012-07-25 01:00:00	ES	Futures	1349.99	1350.5	1347.45	1348.21	8030.0
2012-07-25 02:00:00	ES	Futures	1348.21	1350.25	1347.7	1348.21	9134.0
2012-07-25 03:00:00	ES	Futures	1348.21	1354.57	1347.96	1351.52	66330.0
2012-07-25 04:00:00	ES	Futures	1351.52	1355.33	1350.5	1354.31	43712.0
2012-07-25 05:00:00	ES	Futures	1354.06	1357.37	1353.3	1356.86	30880.0
2012-07-25 06:00:00	ES	Futures	1356.86	1359.4	1355.84	1358.13	30164.0
2012-07-25 07:00:00	ES	Futures	1357.87	1359.65	1357.11	1358.64	36258.0
2012-07-25 08:00:00	ES	Futures	1358.64	1362.96	1356.86	1360.67	74429.0
2012-07-25 09:00:00	ES	Futures	1360.67	1362.45	1355.59	1357.62	221359.0
2012-07-25 10:00:00	ES	Futures	1357.62	1357.62	1348.97	1349.99	378795.0
2012-07-25 11:00:00	ES	Futures	1349.99	1354.57	1349.74	1353.04	235412.0
2012-07-25 12:00:00	ES	Futures	1353.04	1356.35	1352.03	1354.57	99761.0
2012-07-25 13:00:00	ES	Futures	1354.82	1361.94	1354.82	1360.67	138646.0
2012-07-25 14:00:00	ES	Futures	1360.42	1361.94	1358.64	1360.16	100390.0
2012-07-25 15:00:00	ES	Futures	1359.91	1360.42	1353.3	1356.09	222091.0
2012-07-25 16:00:00	ES	Futures	1356.35	1358.38	1356.09	1357.62	66438.0
2012-07-25 17:00:00	ES	Futures	1357.62	1358.13	1356.86	1358.13	1331.0
2012-07-25 18:00:00	ES	Futures	1358.38	1358.38	1356.86	1357.37	1778.0
2012-07-25 19:00:00	ES	Futures	1357.11	1357.37	1356.35	1356.6	1635.0
2012-07-25 20:00:00	ES	Futures	1356.6	1357.11	1354.06	1356.35	6671.0
2012-07-25 21:00:00	ES	Futures	1356.35	1358.13	1355.59	1357.11	7465.0
2012-07-25 22:00:00	ES	Futures	1356.86	1357.87	1356.09	1356.86	3591.0
2012-07-25 23:00:00	ES	Futures	1356.86	1357.37	1355.08	1355.33	2685.0
2012-07-25 00:00:00	NQ	Futures	2930.16	2931.61	2929.58	2929.87	384.0
2012-07-25 01:00:00	NQ	Futures	2930.45	2930.74	2925.52	2926.39	804.0
2012-07-25 02:00:00	NQ	Futures	2926.68	2932.19	2926.68	2928.13	1075.0
2012-07-25 03:00:00	NQ	Futures	2928.71	2938.85	2928.71	2932.19	6896.0
2012-07-25 04:00:00	NQ	Futures	2931.9	2941.46	2930.74	2937.98	5035.0
2012-07-25 05:00:00	NQ	Futures	2937.4	2942.62	2935.66	2940.88	3153.0
2012-07-25 06:00:00	NQ	Futures	2940.88	2945.23	2940.3	2942.91	2981.0
2012-07-25 07:00:00	NQ	Futures	2943.2	2948.71	2940.59	2945.52	4741.0
2012-07-25 08:00:00	NQ	Futures	2945.81	2953.93	2942.33	2952.19	6744.0
2012-07-25 09:00:00	NQ	Futures	2951.9	2966.97	2945.52	2957.41	46515.0
2012-07-25 10:00:00	NQ	Futures	2957.12	2960.02	2932.19	2934.8	49810.0
2012-07-25 11:00:00	NQ	Futures	2934.8	2951.9	2934.22	2948.42	32039.0
2012-07-25 12:00:00	NQ	Futures	2948.71	2954.22	2945.52	2951.9	16514.0
2012-07-25 13:00:00	NQ	Futures	2951.9	2968.71	2951.61	2965.23	18278.0
2012-07-25 14:00:00	NQ	Futures	2965.23	2969.29	2958.86	2962.33	14940.0
2012-07-25 15:00:00	NQ	Futures	2962.33	2964.94	2944.07	2949.87	35019.0
2012-07-25 16:00:00	NQ	Futures	2949.58	2954.22	2945.81	2951.03	8440.0
2012-07-25 17:00:00	NQ	Futures	2950.74	2952.48	2950.74	2952.48	226.0
2012-07-25 18:00:00	NQ	Futures	2952.48	2953.64	2949.58	2950.74	279.0
2012-07-25 19:00:00	NQ	Futures	2950.74	2951.9	2949.87	2951.03	430.0
2012-07-25 20:00:00	NQ	Futures	2950.74	2951.32	2945.52	2949.29	830.0
2012-07-25 21:00:00	NQ	Futures	2949.0	2952.19	2945.81	2949.87	1355.0
2012-07-25 22:00:00	NQ	Futures	2949.87	2951.9	2949.0	2949.87	895.0
2012-07-25 23:00:00	NQ	Futures	2950.16	2950.45	2945.23	2946.39	594.0
2012-07-25 00:00:00	YM	Futures	12446.9	12453.9	12444.9	12447.9	305.0
2012-07-25 01:00:00	YM	Futures	12447.9	12447.9	12426.1	12433.0	709.0

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

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