PREVIEW / futures_1hour / 2012-11-26

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-11-26.parquet
  size:    45 KB
  rows:    1,453

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-11-26 00:00:00	ES	Futures	1431.62	1432.13	1430.09	1430.34	5198.0
2012-11-26 01:00:00	ES	Futures	1430.09	1431.11	1429.06	1430.34	4667.0
2012-11-26 02:00:00	ES	Futures	1430.6	1432.64	1430.09	1432.13	9069.0
2012-11-26 03:00:00	ES	Futures	1431.87	1432.64	1429.83	1430.09	20655.0
2012-11-26 04:00:00	ES	Futures	1430.09	1431.36	1427.79	1428.55	24826.0
2012-11-26 05:00:00	ES	Futures	1428.81	1431.11	1428.04	1430.85	15671.0
2012-11-26 06:00:00	ES	Futures	1430.85	1432.64	1429.83	1430.34	19502.0
2012-11-26 07:00:00	ES	Futures	1430.09	1430.6	1428.55	1429.06	27945.0
2012-11-26 08:00:00	ES	Futures	1429.32	1431.36	1428.55	1430.6	37638.0
2012-11-26 09:00:00	ES	Futures	1430.85	1432.13	1428.04	1431.62	174677.0
2012-11-26 10:00:00	ES	Futures	1431.36	1432.64	1428.55	1428.81	198891.0
2012-11-26 11:00:00	ES	Futures	1428.81	1429.32	1425.49	1429.06	164925.0
2012-11-26 12:00:00	ES	Futures	1429.06	1431.62	1427.02	1430.85	105527.0
2012-11-26 13:00:00	ES	Futures	1430.6	1432.39	1429.57	1430.34	86789.0
2012-11-26 14:00:00	ES	Futures	1430.34	1433.15	1429.57	1432.13	81036.0
2012-11-26 15:00:00	ES	Futures	1432.13	1435.2	1430.6	1434.94	147279.0
2012-11-26 16:00:00	ES	Futures	1434.94	1435.71	1433.41	1434.43	48369.0
2012-11-26 17:00:00	ES	Futures	1434.43	1435.71	1434.43	1435.71	4127.0
2012-11-26 18:00:00	ES	Futures	1434.68	1435.45	1434.17	1435.45	9278.0
2012-11-26 19:00:00	ES	Futures	1435.45	1438.52	1434.68	1436.47	19978.0
2012-11-26 20:00:00	ES	Futures	1436.47	1438.01	1435.71	1436.22	8644.0
2012-11-26 21:00:00	ES	Futures	1436.22	1436.73	1434.94	1435.96	5049.0
2012-11-26 22:00:00	ES	Futures	1435.96	1437.24	1434.94	1436.98	3971.0
2012-11-26 23:00:00	ES	Futures	1436.98	1437.75	1436.22	1437.49	3793.0
2012-11-26 00:00:00	NQ	Futures	3053.96	3054.54	3050.76	3051.63	422.0
2012-11-26 01:00:00	NQ	Futures	3051.34	3052.5	3049.6	3051.63	413.0
2012-11-26 02:00:00	NQ	Futures	3051.34	3057.15	3051.34	3055.41	978.0
2012-11-26 03:00:00	NQ	Futures	3054.83	3057.74	3051.63	3051.92	2239.0
2012-11-26 04:00:00	NQ	Futures	3051.92	3054.83	3048.73	3050.47	2405.0
2012-11-26 05:00:00	NQ	Futures	3050.18	3053.96	3049.02	3053.96	1413.0
2012-11-26 06:00:00	NQ	Futures	3053.67	3058.61	3051.92	3053.67	1727.0
2012-11-26 07:00:00	NQ	Futures	3053.38	3055.41	3052.21	3053.38	1716.0
2012-11-26 08:00:00	NQ	Futures	3053.67	3058.32	3052.5	3057.15	4055.0
2012-11-26 09:00:00	NQ	Futures	3057.74	3067.61	3052.8	3065.87	34684.0
2012-11-26 10:00:00	NQ	Futures	3065.87	3066.74	3057.15	3058.32	30386.0
2012-11-26 11:00:00	NQ	Futures	3058.61	3062.38	3049.31	3061.22	26493.0
2012-11-26 12:00:00	NQ	Futures	3061.22	3071.39	3059.19	3068.2	17342.0
2012-11-26 13:00:00	NQ	Futures	3068.2	3073.14	3066.45	3069.94	18006.0
2012-11-26 14:00:00	NQ	Futures	3069.94	3078.08	3066.16	3076.62	21508.0
2012-11-26 15:00:00	NQ	Futures	3076.91	3080.98	3071.68	3079.82	29746.0
2012-11-26 16:00:00	NQ	Futures	3079.53	3080.69	3075.75	3078.95	5507.0
2012-11-26 17:00:00	NQ	Futures	3078.95	3080.69	3078.37	3080.4	127.0
2012-11-26 18:00:00	NQ	Futures	3078.37	3080.11	3077.79	3079.82	292.0
2012-11-26 19:00:00	NQ	Futures	3080.11	3085.92	3078.66	3083.02	2249.0
2012-11-26 20:00:00	NQ	Futures	3083.02	3085.34	3080.69	3081.27	915.0
2012-11-26 21:00:00	NQ	Futures	3081.27	3083.02	3079.53	3082.14	469.0
2012-11-26 22:00:00	NQ	Futures	3081.85	3084.18	3080.4	3083.89	347.0
2012-11-26 23:00:00	NQ	Futures	3084.18	3085.34	3083.02	3084.47	317.0
2012-11-26 00:00:00	YM	Futures	12936.7	12940.7	12926.7	12928.7	471.0
2012-11-26 01:00:00	YM	Futures	12928.7	12933.7	12918.6	12926.7	551.0

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

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