PREVIEW / futures_1hour / 2012-11-19

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-11-19.parquet
  size:    46 KB
  rows:    1,447

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-19 00:00:00	ES	Futures	1393.04	1393.3	1391.51	1391.77	5193.0
2012-11-19 01:00:00	ES	Futures	1391.51	1393.55	1391.51	1392.28	3730.0
2012-11-19 02:00:00	ES	Futures	1392.53	1394.83	1391.77	1393.55	10987.0
2012-11-19 03:00:00	ES	Futures	1393.81	1396.11	1392.28	1395.85	30350.0
2012-11-19 04:00:00	ES	Futures	1395.6	1396.62	1394.32	1396.11	24239.0
2012-11-19 05:00:00	ES	Futures	1396.11	1396.62	1395.34	1396.36	12190.0
2012-11-19 06:00:00	ES	Futures	1396.36	1398.92	1395.6	1398.41	26928.0
2012-11-19 07:00:00	ES	Futures	1398.41	1399.17	1396.36	1397.39	28067.0
2012-11-19 08:00:00	ES	Futures	1397.39	1402.5	1397.13	1401.98	79758.0
2012-11-19 09:00:00	ES	Futures	1401.98	1408.37	1401.22	1407.61	262517.0
2012-11-19 10:00:00	ES	Futures	1408.12	1409.9	1405.31	1407.86	273295.0
2012-11-19 11:00:00	ES	Futures	1407.86	1409.39	1406.84	1408.37	207408.0
2012-11-19 12:00:00	ES	Futures	1408.63	1410.93	1408.37	1409.65	129182.0
2012-11-19 13:00:00	ES	Futures	1409.39	1410.16	1407.09	1408.12	75076.0
2012-11-19 14:00:00	ES	Futures	1408.12	1411.95	1408.12	1411.44	118025.0
2012-11-19 15:00:00	ES	Futures	1411.44	1415.01	1409.9	1414.5	253749.0
2012-11-19 16:00:00	ES	Futures	1414.5	1415.01	1412.2	1414.76	123907.0
2012-11-19 17:00:00	ES	Futures	1414.76	1416.04	1410.93	1411.18	14721.0
2012-11-19 18:00:00	ES	Futures	1410.16	1411.95	1409.9	1410.93	15276.0
2012-11-19 19:00:00	ES	Futures	1410.93	1412.2	1410.67	1411.69	6938.0
2012-11-19 20:00:00	ES	Futures	1411.44	1412.71	1411.44	1411.95	5234.0
2012-11-19 21:00:00	ES	Futures	1411.95	1412.97	1411.44	1412.71	3511.0
2012-11-19 22:00:00	ES	Futures	1412.71	1414.5	1412.2	1412.97	6359.0
2012-11-19 23:00:00	ES	Futures	1412.97	1413.23	1410.93	1411.18	4362.0
2012-11-19 00:00:00	NQ	Futures	2952.84	2953.42	2950.51	2950.51	351.0
2012-11-19 01:00:00	NQ	Futures	2950.8	2954.0	2950.8	2952.26	179.0
2012-11-19 02:00:00	NQ	Futures	2951.97	2956.61	2951.09	2953.13	967.0
2012-11-19 03:00:00	NQ	Futures	2953.42	2957.2	2949.35	2956.03	5017.0
2012-11-19 04:00:00	NQ	Futures	2956.03	2959.23	2953.13	2958.94	2542.0
2012-11-19 05:00:00	NQ	Futures	2958.94	2959.23	2956.32	2958.36	1479.0
2012-11-19 06:00:00	NQ	Futures	2958.36	2965.33	2957.49	2964.17	2827.0
2012-11-19 07:00:00	NQ	Futures	2964.46	2965.04	2960.97	2963.01	3194.0
2012-11-19 08:00:00	NQ	Futures	2962.72	2973.47	2962.72	2972.89	12266.0
2012-11-19 09:00:00	NQ	Futures	2972.89	2989.45	2970.56	2987.71	63381.0
2012-11-19 10:00:00	NQ	Futures	2987.13	2996.13	2978.12	2992.07	48198.0
2012-11-19 11:00:00	NQ	Futures	2992.07	2995.55	2989.74	2993.52	24939.0
2012-11-19 12:00:00	NQ	Futures	2993.23	3002.53	2993.23	3000.49	18881.0
2012-11-19 13:00:00	NQ	Futures	3000.49	3002.53	2994.1	2997.88	12427.0
2012-11-19 14:00:00	NQ	Futures	2998.17	3005.72	2997.3	3004.27	19211.0
2012-11-19 15:00:00	NQ	Futures	3004.27	3015.31	3000.78	3012.99	39555.0
2012-11-19 16:00:00	NQ	Futures	3012.99	3013.57	3005.72	3010.95	10582.0
2012-11-19 17:00:00	NQ	Futures	3010.95	3012.99	3003.69	3003.98	765.0
2012-11-19 18:00:00	NQ	Futures	3004.27	3005.14	3002.24	3003.11	998.0
2012-11-19 19:00:00	NQ	Futures	3003.4	3006.3	3003.4	3004.85	517.0
2012-11-19 20:00:00	NQ	Futures	3005.43	3007.47	3004.56	3006.3	559.0
2012-11-19 21:00:00	NQ	Futures	3006.3	3007.76	3005.14	3007.18	345.0
2012-11-19 22:00:00	NQ	Futures	3007.18	3011.53	3006.88	3008.63	531.0
2012-11-19 23:00:00	NQ	Futures	3008.63	3008.63	3003.11	3003.4	505.0
2012-11-19 00:00:00	YM	Futures	12604.5	12605.5	12589.5	12590.5	641.0
2012-11-19 01:00:00	YM	Futures	12589.5	12604.5	12589.5	12597.5	312.0

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

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