PREVIEW / futures_1hour / 2012-12-05

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-12-05.parquet
  size:    47 KB
  rows:    1,475

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-12-05 00:00:00	ES	Futures	1441.84	1441.84	1440.05	1441.07	5848.0
2012-12-05 01:00:00	ES	Futures	1441.07	1442.6	1440.3	1442.35	3497.0
2012-12-05 02:00:00	ES	Futures	1442.09	1443.63	1441.33	1441.33	11220.0
2012-12-05 03:00:00	ES	Futures	1441.58	1443.11	1440.82	1442.09	18384.0
2012-12-05 04:00:00	ES	Futures	1442.09	1442.86	1439.54	1439.79	16141.0
2012-12-05 05:00:00	ES	Futures	1439.79	1440.56	1438.77	1439.54	12232.0
2012-12-05 06:00:00	ES	Futures	1439.54	1441.58	1439.03	1440.56	14459.0
2012-12-05 07:00:00	ES	Futures	1440.56	1442.09	1439.28	1440.82	28261.0
2012-12-05 08:00:00	ES	Futures	1440.56	1441.07	1438.77	1438.77	45924.0
2012-12-05 09:00:00	ES	Futures	1438.77	1440.56	1435.45	1435.96	185997.0
2012-12-05 10:00:00	ES	Futures	1435.96	1438.52	1427.28	1430.09	381515.0
2012-12-05 11:00:00	ES	Futures	1430.34	1441.33	1428.81	1440.3	363973.0
2012-12-05 12:00:00	ES	Futures	1440.56	1445.67	1440.3	1444.14	299038.0
2012-12-05 13:00:00	ES	Futures	1443.88	1444.9	1440.82	1441.33	121540.0
2012-12-05 14:00:00	ES	Futures	1441.07	1444.39	1441.07	1442.09	101450.0
2012-12-05 15:00:00	ES	Futures	1441.84	1445.41	1436.73	1438.52	288724.0
2012-12-05 16:00:00	ES	Futures	1438.52	1439.79	1436.98	1437.24	80838.0
2012-12-05 17:00:00	ES	Futures	1437.24	1437.75	1436.98	1437.49	824.0
2012-12-05 18:00:00	ES	Futures	1437.24	1440.05	1436.98	1439.03	5289.0
2012-12-05 19:00:00	ES	Futures	1439.28	1439.54	1436.22	1436.47	6944.0
2012-12-05 20:00:00	ES	Futures	1436.73	1438.52	1436.22	1436.73	4937.0
2012-12-05 21:00:00	ES	Futures	1436.73	1439.54	1436.22	1438.77	4987.0
2012-12-05 22:00:00	ES	Futures	1438.52	1438.77	1435.71	1436.47	5610.0
2012-12-05 23:00:00	ES	Futures	1436.47	1437.24	1435.45	1435.45	4001.0
2012-12-05 00:00:00	NQ	Futures	3110.33	3110.33	3107.13	3109.75	609.0
2012-12-05 01:00:00	NQ	Futures	3109.75	3112.07	3107.71	3111.49	346.0
2012-12-05 02:00:00	NQ	Futures	3111.2	3114.11	3109.46	3110.04	1406.0
2012-12-05 03:00:00	NQ	Futures	3110.04	3112.94	3108.3	3109.75	2909.0
2012-12-05 04:00:00	NQ	Futures	3109.75	3110.62	3101.61	3102.48	3579.0
2012-12-05 05:00:00	NQ	Futures	3102.48	3103.07	3099.29	3100.74	2328.0
2012-12-05 06:00:00	NQ	Futures	3101.03	3105.39	3099.87	3102.48	2597.0
2012-12-05 07:00:00	NQ	Futures	3102.48	3104.52	3098.71	3102.19	2909.0
2012-12-05 08:00:00	NQ	Futures	3101.9	3102.77	3097.54	3099.0	4965.0
2012-12-05 09:00:00	NQ	Futures	3099.0	3099.29	3072.26	3079.24	42386.0
2012-12-05 10:00:00	NQ	Futures	3078.37	3081.56	3048.73	3056.57	88018.0
2012-12-05 11:00:00	NQ	Futures	3056.28	3080.69	3052.8	3078.37	65859.0
2012-12-05 12:00:00	NQ	Futures	3078.66	3090.57	3077.79	3083.31	45772.0
2012-12-05 13:00:00	NQ	Futures	3083.6	3085.34	3074.3	3074.59	22284.0
2012-12-05 14:00:00	NQ	Futures	3074.59	3083.6	3074.3	3076.04	17376.0
2012-12-05 15:00:00	NQ	Futures	3076.33	3086.79	3062.68	3065.87	43763.0
2012-12-05 16:00:00	NQ	Futures	3065.87	3068.2	3063.26	3063.55	7837.0
2012-12-05 17:00:00	NQ	Futures	3063.55	3063.84	3063.26	3063.55	342.0
2012-12-05 18:00:00	NQ	Futures	3063.84	3068.78	3062.09	3067.91	691.0
2012-12-05 19:00:00	NQ	Futures	3068.2	3068.2	3062.09	3062.97	784.0
2012-12-05 20:00:00	NQ	Futures	3062.97	3066.74	3062.09	3062.68	509.0
2012-12-05 21:00:00	NQ	Futures	3062.68	3069.65	3062.09	3067.91	721.0
2012-12-05 22:00:00	NQ	Futures	3067.61	3067.61	3062.68	3063.26	969.0
2012-12-05 23:00:00	NQ	Futures	3063.26	3064.71	3061.8	3062.09	663.0
2012-12-05 00:00:00	YM	Futures	12983.7	12987.7	12974.7	12984.7	428.0
2012-12-05 01:00:00	YM	Futures	12985.7	12992.7	12976.7	12989.7	296.0

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

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