PREVIEW / futures_1hour / 2012-07-17

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-07-17.parquet
  size:    49 KB
  rows:    1,527

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-07-17 00:00:00	ES	Futures	1377.2	1378.22	1376.69	1377.71	3059.0
2012-07-17 01:00:00	ES	Futures	1377.71	1378.22	1375.67	1376.94	4040.0
2012-07-17 02:00:00	ES	Futures	1376.69	1378.22	1375.93	1377.45	5762.0
2012-07-17 03:00:00	ES	Futures	1377.71	1378.22	1376.18	1376.18	20431.0
2012-07-17 04:00:00	ES	Futures	1376.18	1377.96	1376.18	1376.18	15067.0
2012-07-17 05:00:00	ES	Futures	1376.18	1377.71	1375.42	1375.42	16758.0
2012-07-17 06:00:00	ES	Futures	1375.42	1375.93	1374.66	1374.66	10865.0
2012-07-17 07:00:00	ES	Futures	1374.91	1377.71	1374.66	1376.94	24450.0
2012-07-17 08:00:00	ES	Futures	1376.94	1377.45	1374.4	1376.18	27609.0
2012-07-17 09:00:00	ES	Futures	1375.93	1379.74	1373.13	1374.66	190643.0
2012-07-17 10:00:00	ES	Futures	1374.66	1375.16	1362.2	1365.25	587638.0
2012-07-17 11:00:00	ES	Futures	1365.5	1374.91	1364.74	1374.66	278524.0
2012-07-17 12:00:00	ES	Futures	1374.91	1379.23	1374.91	1376.44	183554.0
2012-07-17 13:00:00	ES	Futures	1376.44	1382.79	1376.18	1380.76	155623.0
2012-07-17 14:00:00	ES	Futures	1380.5	1383.81	1380.5	1382.54	105823.0
2012-07-17 15:00:00	ES	Futures	1382.54	1382.79	1378.47	1381.27	215109.0
2012-07-17 16:00:00	ES	Futures	1381.27	1382.54	1379.49	1381.27	87931.0
2012-07-17 17:00:00	ES	Futures	1381.01	1381.52	1380.76	1381.01	1567.0
2012-07-17 18:00:00	ES	Futures	1381.01	1381.01	1380.25	1380.76	2798.0
2012-07-17 19:00:00	ES	Futures	1380.76	1381.52	1380.76	1381.27	2588.0
2012-07-17 20:00:00	ES	Futures	1381.01	1382.28	1380.25	1380.5	5154.0
2012-07-17 21:00:00	ES	Futures	1380.5	1381.01	1378.98	1379.74	5236.0
2012-07-17 22:00:00	ES	Futures	1379.74	1380.0	1378.47	1380.0	5914.0
2012-07-17 23:00:00	ES	Futures	1379.74	1380.25	1378.22	1378.47	4134.0
2012-07-17 00:00:00	NQ	Futures	2995.38	2999.15	2994.51	2997.12	617.0
2012-07-17 01:00:00	NQ	Futures	2997.41	2997.7	2993.35	2995.67	440.0
2012-07-17 02:00:00	NQ	Futures	2995.96	2997.7	2993.93	2997.41	621.0
2012-07-17 03:00:00	NQ	Futures	2997.12	2998.86	2994.22	2994.8	1890.0
2012-07-17 04:00:00	NQ	Futures	2995.09	2999.15	2995.09	2995.67	1378.0
2012-07-17 05:00:00	NQ	Futures	2995.09	2998.28	2993.93	2993.93	1812.0
2012-07-17 06:00:00	NQ	Futures	2994.22	2994.8	2991.9	2992.77	1037.0
2012-07-17 07:00:00	NQ	Futures	2992.77	2999.44	2991.9	2997.99	3255.0
2012-07-17 08:00:00	NQ	Futures	2997.7	2999.73	2992.77	2997.7	5488.0
2012-07-17 09:00:00	NQ	Futures	2997.41	3006.69	2985.24	2991.61	36647.0
2012-07-17 10:00:00	NQ	Futures	2991.61	2992.19	2954.51	2962.33	70759.0
2012-07-17 11:00:00	NQ	Futures	2962.62	2987.26	2961.17	2987.26	33491.0
2012-07-17 12:00:00	NQ	Futures	2987.26	3000.02	2987.26	2989.87	28165.0
2012-07-17 13:00:00	NQ	Futures	2989.87	3003.79	2988.71	2997.41	17140.0
2012-07-17 14:00:00	NQ	Futures	2997.12	3007.85	2996.83	3004.37	17531.0
2012-07-17 15:00:00	NQ	Futures	3004.37	3005.24	2989.29	2997.41	32279.0
2012-07-17 16:00:00	NQ	Futures	2997.41	3002.92	2990.45	2999.73	12824.0
2012-07-17 17:00:00	NQ	Futures	2999.73	3000.89	2999.44	3000.02	221.0
2012-07-17 18:00:00	NQ	Futures	3000.02	3000.6	2997.99	2999.15	224.0
2012-07-17 19:00:00	NQ	Futures	2999.15	3001.18	2998.86	3000.02	135.0
2012-07-17 20:00:00	NQ	Futures	2999.73	3002.34	2998.28	2998.57	483.0
2012-07-17 21:00:00	NQ	Futures	2998.57	3000.02	2995.96	2997.12	607.0
2012-07-17 22:00:00	NQ	Futures	2997.12	2998.57	2994.51	2997.7	705.0
2012-07-17 23:00:00	NQ	Futures	2997.12	2997.99	2993.64	2994.22	1082.0
2012-07-17 00:00:00	YM	Futures	12639.9	12645.8	12635.9	12643.8	240.0
2012-07-17 01:00:00	YM	Futures	12643.8	12645.8	12625.9	12630.9	464.0

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

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