PREVIEW / futures_1hour / 2012-02-08

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-02-08.parquet
  size:    48 KB
  rows:    1,518

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-02-08 00:00:00	ES	Futures	1355.44	1357.21	1355.19	1356.96	7710.0
2012-02-08 01:00:00	ES	Futures	1357.21	1357.71	1356.7	1357.46	5335.0
2012-02-08 02:00:00	ES	Futures	1357.21	1358.47	1356.96	1357.46	12465.0
2012-02-08 03:00:00	ES	Futures	1357.46	1358.97	1355.95	1357.71	28870.0
2012-02-08 04:00:00	ES	Futures	1357.71	1358.47	1356.45	1356.7	17989.0
2012-02-08 05:00:00	ES	Futures	1356.7	1356.96	1354.69	1355.95	17151.0
2012-02-08 06:00:00	ES	Futures	1355.95	1357.21	1354.69	1356.45	16879.0
2012-02-08 07:00:00	ES	Futures	1356.7	1357.21	1355.19	1356.45	14806.0
2012-02-08 08:00:00	ES	Futures	1356.45	1357.21	1355.44	1355.44	21849.0
2012-02-08 09:00:00	ES	Futures	1355.44	1357.96	1353.68	1357.46	184298.0
2012-02-08 10:00:00	ES	Futures	1357.46	1358.22	1353.93	1355.19	209315.0
2012-02-08 11:00:00	ES	Futures	1355.44	1356.2	1348.89	1351.92	306681.0
2012-02-08 12:00:00	ES	Futures	1351.92	1354.44	1351.16	1354.44	179603.0
2012-02-08 13:00:00	ES	Futures	1354.44	1355.19	1352.92	1353.68	115012.0
2012-02-08 14:00:00	ES	Futures	1353.68	1357.96	1353.43	1356.96	159703.0
2012-02-08 15:00:00	ES	Futures	1356.96	1357.71	1355.95	1357.71	151686.0
2012-02-08 16:00:00	ES	Futures	1357.46	1358.22	1356.2	1356.7	69166.0
2012-02-08 17:00:00	ES	Futures	1356.7	1356.96	1354.44	1354.94	5455.0
2012-02-08 18:00:00	ES	Futures	1354.44	1355.44	1353.43	1354.69	12230.0
2012-02-08 19:00:00	ES	Futures	1354.69	1355.19	1352.17	1352.67	10403.0
2012-02-08 20:00:00	ES	Futures	1352.92	1353.93	1351.41	1353.18	12667.0
2012-02-08 21:00:00	ES	Futures	1352.92	1356.2	1352.92	1355.7	8406.0
2012-02-08 22:00:00	ES	Futures	1355.7	1355.95	1353.18	1353.93	4579.0
2012-02-08 23:00:00	ES	Futures	1353.93	1356.7	1353.43	1356.45	3498.0
2012-02-08 00:00:00	NQ	Futures	2924.08	2926.97	2923.79	2926.68	530.0
2012-02-08 01:00:00	NQ	Futures	2926.68	2927.55	2926.1	2926.97	325.0
2012-02-08 02:00:00	NQ	Futures	2926.97	2929.86	2925.82	2926.97	882.0
2012-02-08 03:00:00	NQ	Futures	2926.97	2931.88	2925.82	2930.15	1862.0
2012-02-08 04:00:00	NQ	Futures	2930.15	2933.32	2928.42	2928.99	1354.0
2012-02-08 05:00:00	NQ	Futures	2928.7	2928.99	2924.66	2926.97	878.0
2012-02-08 06:00:00	NQ	Futures	2926.39	2928.13	2924.08	2927.26	1030.0
2012-02-08 07:00:00	NQ	Futures	2926.97	2927.55	2924.08	2926.68	1247.0
2012-02-08 08:00:00	NQ	Futures	2926.68	2928.13	2924.95	2925.24	3628.0
2012-02-08 09:00:00	NQ	Futures	2925.24	2929.86	2920.62	2929.28	36682.0
2012-02-08 10:00:00	NQ	Futures	2929.28	2934.19	2921.77	2924.66	33901.0
2012-02-08 11:00:00	NQ	Futures	2924.37	2925.53	2912.24	2919.46	35866.0
2012-02-08 12:00:00	NQ	Futures	2919.17	2928.13	2918.88	2927.55	19478.0
2012-02-08 13:00:00	NQ	Futures	2927.84	2931.59	2926.1	2928.7	13030.0
2012-02-08 14:00:00	NQ	Futures	2928.42	2937.08	2928.13	2935.06	19223.0
2012-02-08 15:00:00	NQ	Futures	2935.06	2938.23	2933.61	2937.66	19383.0
2012-02-08 16:00:00	NQ	Futures	2937.66	2942.86	2934.19	2936.21	9635.0
2012-02-08 17:00:00	NQ	Futures	2936.21	2936.5	2930.15	2931.01	1443.0
2012-02-08 18:00:00	NQ	Futures	2931.3	2934.48	2928.7	2933.61	979.0
2012-02-08 19:00:00	NQ	Futures	2933.61	2934.19	2931.01	2932.17	1036.0
2012-02-08 20:00:00	NQ	Futures	2931.88	2933.9	2929.57	2933.04	1423.0
2012-02-08 21:00:00	NQ	Futures	2933.32	2938.52	2933.04	2937.08	960.0
2012-02-08 22:00:00	NQ	Futures	2937.08	2938.23	2933.04	2933.9	438.0
2012-02-08 23:00:00	NQ	Futures	2934.19	2939.39	2933.61	2939.1	314.0
2012-02-08 00:00:00	YM	Futures	12721.2	12737.1	12719.2	12735.1	448.0
2012-02-08 01:00:00	YM	Futures	12735.1	12739.1	12732.1	12736.1	290.0

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

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