PREVIEW / futures_1hour / 2012-06-07

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-06-07.parquet
  size:    50 KB
  rows:    1,500

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-07 00:00:00	ES	Futures	1335.0	1335.5	1332.47	1333.23	6300.0
2012-06-07 01:00:00	ES	Futures	1333.23	1334.49	1332.47	1333.99	4843.0
2012-06-07 02:00:00	ES	Futures	1333.99	1334.24	1331.96	1332.47	12342.0
2012-06-07 03:00:00	ES	Futures	1332.47	1335.76	1330.95	1333.73	44010.0
2012-06-07 04:00:00	ES	Futures	1333.73	1335.0	1331.71	1335.0	33861.0
2012-06-07 05:00:00	ES	Futures	1335.0	1336.52	1333.99	1334.75	35017.0
2012-06-07 06:00:00	ES	Futures	1334.49	1336.01	1331.71	1335.76	32055.0
2012-06-07 07:00:00	ES	Futures	1336.01	1343.85	1335.25	1341.83	142903.0
2012-06-07 08:00:00	ES	Futures	1341.83	1343.35	1339.55	1339.81	79166.0
2012-06-07 09:00:00	ES	Futures	1340.06	1345.37	1339.55	1342.84	298608.0
2012-06-07 10:00:00	ES	Futures	1342.84	1344.11	1332.47	1335.0	480219.0
2012-06-07 11:00:00	ES	Futures	1335.0	1338.29	1332.47	1336.52	247524.0
2012-06-07 12:00:00	ES	Futures	1336.52	1339.55	1334.49	1336.77	167165.0
2012-06-07 13:00:00	ES	Futures	1336.77	1340.82	1336.26	1337.53	103223.0
2012-06-07 14:00:00	ES	Futures	1337.78	1339.3	1336.26	1338.54	67498.0
2012-06-07 15:00:00	ES	Futures	1338.29	1338.54	1327.66	1330.19	284181.0
2012-06-07 16:00:00	ES	Futures	1330.19	1332.72	1329.94	1332.47	65002.0
2012-06-07 17:00:00	ES	Futures	1332.47	1333.73	1331.71	1331.96	3388.0
2012-06-07 18:00:00	ES	Futures	1331.96	1333.23	1331.71	1332.97	2944.0
2012-06-07 19:00:00	ES	Futures	1332.97	1333.48	1332.22	1332.47	2737.0
2012-06-07 20:00:00	ES	Futures	1332.22	1332.47	1325.64	1326.4	12789.0
2012-06-07 21:00:00	ES	Futures	1326.65	1327.66	1323.87	1323.87	9825.0
2012-06-07 22:00:00	ES	Futures	1323.87	1327.16	1323.61	1326.4	6402.0
2012-06-07 23:00:00	ES	Futures	1326.65	1328.17	1324.88	1324.88	4214.0
2012-06-07 00:00:00	NQ	Futures	2960.84	2961.99	2951.29	2953.32	11270.0
2012-06-07 01:00:00	NQ	Futures	2953.61	2956.21	2952.74	2955.34	455.0
2012-06-07 02:00:00	NQ	Futures	2955.34	2955.34	2951.0	2951.58	871.0
2012-06-07 03:00:00	NQ	Futures	2951.58	2957.94	2948.4	2953.61	4735.0
2012-06-07 04:00:00	NQ	Futures	2953.32	2955.92	2948.69	2955.92	3439.0
2012-06-07 05:00:00	NQ	Futures	2955.34	2959.39	2955.05	2956.79	4035.0
2012-06-07 06:00:00	NQ	Futures	2956.5	2957.94	2950.71	2956.79	3244.0
2012-06-07 07:00:00	NQ	Futures	2957.08	2971.54	2956.21	2970.38	12630.0
2012-06-07 08:00:00	NQ	Futures	2970.67	2972.4	2964.02	2964.31	5687.0
2012-06-07 09:00:00	NQ	Futures	2964.31	2973.56	2962.28	2966.04	32638.0
2012-06-07 10:00:00	NQ	Futures	2965.75	2967.49	2940.88	2946.66	44278.0
2012-06-07 11:00:00	NQ	Futures	2946.95	2957.08	2944.06	2951.29	23625.0
2012-06-07 12:00:00	NQ	Futures	2951.29	2958.52	2946.38	2952.45	16406.0
2012-06-07 13:00:00	NQ	Futures	2952.74	2960.84	2948.69	2949.27	12798.0
2012-06-07 14:00:00	NQ	Futures	2948.98	2954.18	2946.38	2952.45	8820.0
2012-06-07 15:00:00	NQ	Futures	2952.45	2953.03	2929.02	2931.63	29203.0
2012-06-07 16:00:00	NQ	Futures	2931.63	2937.12	2930.18	2936.54	6811.0
2012-06-07 17:00:00	NQ	Futures	2936.54	2938.86	2935.67	2935.67	237.0
2012-06-07 18:00:00	NQ	Futures	2935.39	2938.28	2934.81	2937.99	121.0
2012-06-07 19:00:00	NQ	Futures	2938.28	2939.43	2936.25	2936.25	184.0
2012-06-07 20:00:00	NQ	Futures	2936.83	2936.83	2922.95	2925.26	1012.0
2012-06-07 21:00:00	NQ	Futures	2924.69	2927.0	2919.48	2920.35	755.0
2012-06-07 22:00:00	NQ	Futures	2919.48	2927.58	2918.61	2926.13	551.0
2012-06-07 23:00:00	NQ	Futures	2926.13	2929.6	2922.37	2922.66	472.0
2012-06-07 00:00:00	YM	Futures	12402.9	12406.9	12381.0	12386.0	623.0
2012-06-07 01:00:00	YM	Futures	12384.0	12398.9	12383.0	12396.0	441.0

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

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