PREVIEW / futures_1hour / 2012-03-12

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-03-12.parquet
  size:    45 KB
  rows:    1,387

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-03-12 00:00:00	ES	Futures	1379.63	1380.14	1378.88	1378.88	1226.0
2012-03-12 01:00:00	ES	Futures	1378.88	1379.13	1377.37	1378.12	2876.0
2012-03-12 02:00:00	ES	Futures	1378.12	1379.63	1377.37	1379.63	1648.0
2012-03-12 03:00:00	ES	Futures	1379.38	1380.39	1379.13	1380.14	2681.0
2012-03-12 04:00:00	ES	Futures	1380.39	1380.64	1377.87	1380.39	10935.0
2012-03-12 05:00:00	ES	Futures	1380.64	1383.41	1380.14	1382.41	7049.0
2012-03-12 06:00:00	ES	Futures	1382.66	1383.41	1381.65	1381.9	3861.0
2012-03-12 07:00:00	ES	Futures	1381.9	1382.66	1380.89	1381.65	6134.0
2012-03-12 08:00:00	ES	Futures	1381.65	1381.9	1378.88	1380.89	12665.0
2012-03-12 09:00:00	ES	Futures	1381.15	1383.67	1380.14	1381.4	25605.0
2012-03-12 10:00:00	ES	Futures	1381.15	1381.65	1377.87	1379.63	39312.0
2012-03-12 11:00:00	ES	Futures	1379.63	1380.39	1377.87	1377.87	46473.0
2012-03-12 12:00:00	ES	Futures	1377.87	1380.89	1376.86	1379.63	41585.0
2012-03-12 13:00:00	ES	Futures	1379.89	1382.91	1378.88	1381.65	20422.0
2012-03-12 14:00:00	ES	Futures	1381.4	1382.66	1380.89	1382.41	13843.0
2012-03-12 15:00:00	ES	Futures	1382.41	1382.91	1380.64	1381.9	31193.0
2012-03-12 16:00:00	ES	Futures	1381.9	1383.67	1381.4	1383.67	13414.0
2012-03-12 17:00:00	ES	Futures	1383.67	1384.67	1383.41	1384.17	1215.0
2012-03-12 18:00:00	ES	Futures	1384.17	1384.42	1382.91	1383.92	998.0
2012-03-12 19:00:00	ES	Futures	1383.92	1384.42	1383.67	1384.17	554.0
2012-03-12 20:00:00	ES	Futures	1384.17	1386.19	1383.92	1385.68	1678.0
2012-03-12 21:00:00	ES	Futures	1385.43	1386.94	1384.93	1385.93	3710.0
2012-03-12 22:00:00	ES	Futures	1386.19	1396.01	1385.68	1388.96	9229.0
2012-03-12 23:00:00	ES	Futures	1388.96	1390.47	1388.45	1390.47	917.0
2012-03-12 00:00:00	NQ	Futures	3051.15	3051.73	3049.71	3050.0	113.0
2012-03-12 01:00:00	NQ	Futures	3050.0	3050.0	3047.11	3047.98	245.0
2012-03-12 02:00:00	NQ	Futures	3047.4	3050.87	3047.11	3050.29	279.0
2012-03-12 03:00:00	NQ	Futures	3050.29	3052.6	3049.42	3052.31	185.0
2012-03-12 04:00:00	NQ	Futures	3052.6	3053.75	3047.69	3052.31	800.0
2012-03-12 05:00:00	NQ	Futures	3053.75	3058.66	3053.75	3057.8	326.0
2012-03-12 06:00:00	NQ	Futures	3057.22	3058.37	3055.2	3055.78	159.0
2012-03-12 07:00:00	NQ	Futures	3056.06	3058.37	3052.31	3055.2	1987.0
2012-03-12 08:00:00	NQ	Futures	3055.49	3056.06	3049.71	3054.91	1958.0
2012-03-12 09:00:00	NQ	Futures	3054.91	3062.71	3053.75	3059.53	4484.0
2012-03-12 10:00:00	NQ	Futures	3060.11	3060.4	3046.82	3050.58	6003.0
2012-03-12 11:00:00	NQ	Futures	3050.87	3052.31	3044.22	3049.13	4663.0
2012-03-12 12:00:00	NQ	Futures	3049.13	3056.06	3046.53	3054.62	3323.0
2012-03-12 13:00:00	NQ	Futures	3054.91	3061.26	3051.73	3057.51	2107.0
2012-03-12 14:00:00	NQ	Futures	3057.51	3059.82	3055.78	3058.09	1067.0
2012-03-12 15:00:00	NQ	Futures	3058.09	3058.95	3054.04	3058.66	3686.0
2012-03-12 16:00:00	NQ	Futures	3058.95	3064.15	3058.09	3062.42	2128.0
2012-03-12 17:00:00	NQ	Futures	3061.84	3063.28	3061.84	3062.42	25.0
2012-03-12 18:00:00	NQ	Futures	3062.42	3063.0	3061.26	3062.71	34.0
2012-03-12 19:00:00	NQ	Futures	3062.42	3063.86	3061.84	3063.0	37.0
2012-03-12 20:00:00	NQ	Futures	3062.71	3066.46	3062.71	3066.46	78.0
2012-03-12 21:00:00	NQ	Futures	3067.04	3069.64	3066.46	3068.19	312.0
2012-03-12 22:00:00	NQ	Futures	3068.19	3077.72	3068.19	3072.53	456.0
2012-03-12 23:00:00	NQ	Futures	3072.81	3077.15	3072.24	3077.15	133.0
2012-03-12 00:00:00	YM	Futures	12785.5	12789.5	12780.5	12781.5	197.0
2012-03-12 01:00:00	YM	Futures	12779.5	12780.5	12769.6	12772.6	218.0

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

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