PREVIEW / futures_1hour / 2012-07-12

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-07-12.parquet
  size:    49 KB
  rows:    1,502

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-12 00:00:00	ES	Futures	1358.13	1358.13	1355.08	1355.33	7536.0
2012-07-12 01:00:00	ES	Futures	1355.33	1356.09	1353.55	1353.81	8553.0
2012-07-12 02:00:00	ES	Futures	1353.81	1354.57	1352.03	1352.28	12032.0
2012-07-12 03:00:00	ES	Futures	1352.03	1352.53	1348.47	1350.75	44360.0
2012-07-12 04:00:00	ES	Futures	1350.5	1355.84	1350.5	1351.52	35932.0
2012-07-12 05:00:00	ES	Futures	1351.26	1353.3	1350.75	1352.03	19019.0
2012-07-12 06:00:00	ES	Futures	1352.03	1352.28	1346.69	1347.96	39145.0
2012-07-12 07:00:00	ES	Futures	1347.96	1349.48	1346.94	1349.23	35584.0
2012-07-12 08:00:00	ES	Futures	1349.23	1352.53	1348.21	1349.74	66781.0
2012-07-12 09:00:00	ES	Futures	1349.48	1350.75	1344.14	1346.18	233917.0
2012-07-12 10:00:00	ES	Futures	1346.18	1346.94	1342.36	1345.67	273325.0
2012-07-12 11:00:00	ES	Futures	1345.41	1351.77	1344.91	1350.75	228130.0
2012-07-12 12:00:00	ES	Futures	1350.75	1351.52	1348.72	1350.75	107703.0
2012-07-12 13:00:00	ES	Futures	1350.75	1357.11	1349.74	1353.04	193022.0
2012-07-12 14:00:00	ES	Futures	1352.79	1355.84	1351.52	1354.82	159201.0
2012-07-12 15:00:00	ES	Futures	1354.82	1357.87	1351.52	1352.53	317202.0
2012-07-12 16:00:00	ES	Futures	1352.79	1353.81	1350.75	1353.3	86000.0
2012-07-12 17:00:00	ES	Futures	1353.3	1353.3	1352.28	1353.04	1542.0
2012-07-12 18:00:00	ES	Futures	1353.04	1354.57	1353.04	1353.81	4949.0
2012-07-12 19:00:00	ES	Futures	1353.81	1354.06	1351.52	1352.03	3963.0
2012-07-12 20:00:00	ES	Futures	1352.28	1354.31	1351.77	1352.53	8109.0
2012-07-12 21:00:00	ES	Futures	1352.28	1355.33	1352.28	1354.31	8173.0
2012-07-12 22:00:00	ES	Futures	1354.31	1357.87	1353.3	1355.59	14319.0
2012-07-12 23:00:00	ES	Futures	1355.59	1357.62	1355.59	1356.86	5028.0
2012-07-12 00:00:00	NQ	Futures	2969.58	2969.58	2963.49	2963.49	794.0
2012-07-12 01:00:00	NQ	Futures	2963.2	2966.39	2960.6	2961.46	826.0
2012-07-12 02:00:00	NQ	Futures	2961.46	2962.91	2958.86	2958.86	852.0
2012-07-12 03:00:00	NQ	Futures	2959.15	2959.15	2950.16	2953.64	3636.0
2012-07-12 04:00:00	NQ	Futures	2953.35	2964.65	2953.06	2954.8	3234.0
2012-07-12 05:00:00	NQ	Futures	2954.22	2959.44	2953.35	2957.41	2259.0
2012-07-12 06:00:00	NQ	Futures	2957.41	2957.99	2947.26	2950.16	2883.0
2012-07-12 07:00:00	NQ	Futures	2949.87	2953.64	2947.55	2953.06	3316.0
2012-07-12 08:00:00	NQ	Futures	2953.06	2957.99	2946.97	2949.0	5820.0
2012-07-12 09:00:00	NQ	Futures	2949.0	2951.61	2929.29	2932.48	37393.0
2012-07-12 10:00:00	NQ	Futures	2932.48	2934.22	2917.98	2926.39	38614.0
2012-07-12 11:00:00	NQ	Futures	2926.68	2943.2	2924.94	2941.17	27710.0
2012-07-12 12:00:00	NQ	Futures	2941.46	2942.91	2933.93	2938.56	14550.0
2012-07-12 13:00:00	NQ	Futures	2938.85	2957.12	2937.98	2944.94	23472.0
2012-07-12 14:00:00	NQ	Futures	2945.23	2953.64	2941.46	2951.03	20229.0
2012-07-12 15:00:00	NQ	Futures	2950.74	2956.83	2941.75	2945.81	39464.0
2012-07-12 16:00:00	NQ	Futures	2945.52	2947.26	2940.88	2945.52	6872.0
2012-07-12 17:00:00	NQ	Futures	2945.81	2946.68	2945.23	2946.68	200.0
2012-07-12 18:00:00	NQ	Futures	2946.1	2950.45	2946.1	2949.0	335.0
2012-07-12 19:00:00	NQ	Futures	2949.29	2949.58	2944.65	2946.1	402.0
2012-07-12 20:00:00	NQ	Futures	2946.1	2949.87	2945.52	2947.26	834.0
2012-07-12 21:00:00	NQ	Futures	2946.97	2952.48	2946.97	2950.45	1011.0
2012-07-12 22:00:00	NQ	Futures	2950.16	2957.12	2948.71	2953.35	1631.0
2012-07-12 23:00:00	NQ	Futures	2953.93	2958.28	2953.93	2956.25	652.0
2012-07-12 00:00:00	YM	Futures	12452.9	12452.9	12430.0	12430.0	673.0
2012-07-12 01:00:00	YM	Futures	12430.0	12438.0	12416.1	12418.1	995.0

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

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