PREVIEW / futures_1hour / 2012-02-22

all futures 1-hour files

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

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-22 00:00:00	ES	Futures	1372.33	1373.59	1372.07	1373.59	2488.0
2012-02-22 01:00:00	ES	Futures	1373.33	1373.84	1372.83	1373.59	2840.0
2012-02-22 02:00:00	ES	Futures	1373.84	1374.85	1373.33	1374.09	7293.0
2012-02-22 03:00:00	ES	Futures	1374.09	1374.85	1371.32	1371.57	30867.0
2012-02-22 04:00:00	ES	Futures	1371.57	1371.82	1369.05	1370.31	32789.0
2012-02-22 05:00:00	ES	Futures	1370.06	1370.81	1369.3	1369.81	15395.0
2012-02-22 06:00:00	ES	Futures	1370.06	1370.06	1367.54	1367.54	28007.0
2012-02-22 07:00:00	ES	Futures	1367.54	1370.81	1367.29	1369.3	27655.0
2012-02-22 08:00:00	ES	Futures	1369.3	1369.81	1367.29	1369.81	34375.0
2012-02-22 09:00:00	ES	Futures	1369.81	1370.56	1367.79	1369.55	157883.0
2012-02-22 10:00:00	ES	Futures	1369.55	1371.57	1366.53	1369.05	298945.0
2012-02-22 11:00:00	ES	Futures	1369.05	1370.56	1364.26	1365.52	254755.0
2012-02-22 12:00:00	ES	Futures	1365.52	1366.28	1363.76	1366.03	99853.0
2012-02-22 13:00:00	ES	Futures	1366.03	1369.55	1365.52	1368.8	94510.0
2012-02-22 14:00:00	ES	Futures	1369.05	1369.81	1366.53	1366.53	68849.0
2012-02-22 15:00:00	ES	Futures	1366.53	1368.8	1364.77	1366.28	184327.0
2012-02-22 16:00:00	ES	Futures	1366.03	1367.54	1365.52	1367.54	65781.0
2012-02-22 17:00:00	ES	Futures	1367.54	1367.54	1365.52	1366.03	2319.0
2012-02-22 18:00:00	ES	Futures	1366.03	1366.28	1365.27	1366.28	2818.0
2012-02-22 19:00:00	ES	Futures	1366.28	1366.53	1364.01	1364.01	6347.0
2012-02-22 20:00:00	ES	Futures	1364.26	1366.03	1364.01	1365.27	4915.0
2012-02-22 21:00:00	ES	Futures	1365.27	1366.53	1365.02	1366.28	2947.0
2012-02-22 22:00:00	ES	Futures	1366.28	1367.03	1365.52	1365.77	3555.0
2012-02-22 23:00:00	ES	Futures	1365.77	1366.28	1365.52	1365.52	2257.0
2012-02-22 00:00:00	NQ	Futures	2998.3	2999.75	2997.44	2999.46	228.0
2012-02-22 01:00:00	NQ	Futures	2999.46	2999.75	2998.59	2999.75	232.0
2012-02-22 02:00:00	NQ	Futures	2999.75	3003.5	2999.46	3002.06	1184.0
2012-02-22 03:00:00	NQ	Futures	3002.35	3004.08	2997.73	2997.73	2854.0
2012-02-22 04:00:00	NQ	Futures	2997.44	2998.3	2991.66	2993.97	2005.0
2012-02-22 05:00:00	NQ	Futures	2994.26	2994.84	2991.08	2992.24	1291.0
2012-02-22 06:00:00	NQ	Futures	2992.24	2992.82	2987.33	2987.62	2707.0
2012-02-22 07:00:00	NQ	Futures	2987.62	2994.55	2986.75	2990.51	2642.0
2012-02-22 08:00:00	NQ	Futures	2990.51	2991.08	2985.31	2990.8	3223.0
2012-02-22 09:00:00	NQ	Futures	2990.8	2991.66	2980.98	2989.64	25177.0
2012-02-22 10:00:00	NQ	Futures	2989.35	2995.71	2980.98	2987.62	36000.0
2012-02-22 11:00:00	NQ	Futures	2987.91	2991.08	2976.36	2980.4	29443.0
2012-02-22 12:00:00	NQ	Futures	2980.11	2980.69	2974.91	2978.38	12649.0
2012-02-22 13:00:00	NQ	Futures	2978.38	2989.64	2976.93	2988.49	15609.0
2012-02-22 14:00:00	NQ	Futures	2988.77	2989.93	2979.82	2979.82	13913.0
2012-02-22 15:00:00	NQ	Futures	2979.82	2985.89	2975.78	2979.82	27841.0
2012-02-22 16:00:00	NQ	Futures	2979.82	2983.58	2978.67	2981.55	6442.0
2012-02-22 17:00:00	NQ	Futures	2981.55	2981.55	2978.38	2978.67	120.0
2012-02-22 18:00:00	NQ	Futures	2978.67	2980.11	2977.8	2980.11	132.0
2012-02-22 19:00:00	NQ	Futures	2980.4	2980.98	2976.07	2976.93	509.0
2012-02-22 20:00:00	NQ	Futures	2976.64	2979.24	2976.07	2978.67	213.0
2012-02-22 21:00:00	NQ	Futures	2978.38	2980.4	2978.09	2980.4	118.0
2012-02-22 22:00:00	NQ	Futures	2980.4	2981.55	2979.82	2980.11	188.0
2012-02-22 23:00:00	NQ	Futures	2980.4	2981.27	2979.82	2980.11	119.0
2012-02-22 00:00:00	YM	Futures	12841.1	12853.0	12841.1	12852.1	157.0
2012-02-22 01:00:00	YM	Futures	12851.1	12853.0	12848.1	12850.1	82.0

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

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