PREVIEW / futures_1hour / 2012-11-08

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-11-08.parquet
  size:    49 KB
  rows:    1,511

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-08 00:00:00	ES	Futures	1424.21	1425.23	1423.19	1423.95	4543.0
2012-11-08 01:00:00	ES	Futures	1423.95	1424.47	1421.91	1422.17	5799.0
2012-11-08 02:00:00	ES	Futures	1421.91	1425.49	1421.14	1424.47	13815.0
2012-11-08 03:00:00	ES	Futures	1424.21	1424.98	1421.4	1423.7	32520.0
2012-11-08 04:00:00	ES	Futures	1423.95	1424.72	1418.33	1418.33	36806.0
2012-11-08 05:00:00	ES	Futures	1418.59	1421.14	1417.57	1419.87	29915.0
2012-11-08 06:00:00	ES	Futures	1419.87	1421.66	1418.85	1421.14	17714.0
2012-11-08 07:00:00	ES	Futures	1421.4	1426.0	1420.63	1424.98	45482.0
2012-11-08 08:00:00	ES	Futures	1424.98	1424.98	1421.4	1423.7	61717.0
2012-11-08 09:00:00	ES	Futures	1423.7	1428.04	1420.38	1425.23	291039.0
2012-11-08 10:00:00	ES	Futures	1424.98	1425.74	1416.55	1418.59	484716.0
2012-11-08 11:00:00	ES	Futures	1418.59	1420.12	1414.76	1418.59	366972.0
2012-11-08 12:00:00	ES	Futures	1418.59	1418.59	1412.46	1415.27	234045.0
2012-11-08 13:00:00	ES	Futures	1415.01	1415.78	1407.35	1414.25	262955.0
2012-11-08 14:00:00	ES	Futures	1414.5	1414.5	1409.39	1411.18	160991.0
2012-11-08 15:00:00	ES	Futures	1411.18	1412.71	1403.52	1403.77	373190.0
2012-11-08 16:00:00	ES	Futures	1404.03	1406.84	1402.5	1406.07	140148.0
2012-11-08 17:00:00	ES	Futures	1406.07	1406.58	1405.56	1406.33	2511.0
2012-11-08 18:00:00	ES	Futures	1406.07	1407.09	1405.56	1406.84	7005.0
2012-11-08 19:00:00	ES	Futures	1406.58	1406.84	1405.31	1406.33	8386.0
2012-11-08 20:00:00	ES	Futures	1406.33	1409.65	1406.07	1408.88	10447.0
2012-11-08 21:00:00	ES	Futures	1409.14	1410.93	1408.63	1410.42	6381.0
2012-11-08 22:00:00	ES	Futures	1410.16	1410.67	1408.12	1409.14	6013.0
2012-11-08 23:00:00	ES	Futures	1409.14	1410.42	1408.88	1409.9	4019.0
2012-11-08 00:00:00	NQ	Futures	3045.82	3047.57	3043.79	3044.95	458.0
2012-11-08 01:00:00	NQ	Futures	3044.66	3045.53	3041.17	3041.46	635.0
2012-11-08 02:00:00	NQ	Futures	3041.46	3046.4	3039.14	3043.79	1573.0
2012-11-08 03:00:00	NQ	Futures	3043.5	3044.95	3037.98	3043.79	2269.0
2012-11-08 04:00:00	NQ	Futures	3043.79	3045.82	3034.78	3035.07	2894.0
2012-11-08 05:00:00	NQ	Futures	3034.78	3039.43	3031.29	3037.39	2534.0
2012-11-08 06:00:00	NQ	Futures	3037.39	3040.88	3034.2	3040.01	1381.0
2012-11-08 07:00:00	NQ	Futures	3040.3	3046.4	3037.98	3044.08	3706.0
2012-11-08 08:00:00	NQ	Futures	3044.37	3045.53	3039.43	3043.79	8816.0
2012-11-08 09:00:00	NQ	Futures	3044.08	3049.02	3034.2	3043.79	54464.0
2012-11-08 10:00:00	NQ	Futures	3043.79	3046.4	3019.09	3026.35	76641.0
2012-11-08 11:00:00	NQ	Futures	3026.64	3030.13	3012.99	3025.48	53447.0
2012-11-08 12:00:00	NQ	Futures	3025.77	3025.77	3006.88	3013.28	49628.0
2012-11-08 13:00:00	NQ	Futures	3013.57	3014.44	2998.17	3012.11	31586.0
2012-11-08 14:00:00	NQ	Futures	3012.11	3012.41	2994.39	3002.24	26132.0
2012-11-08 15:00:00	NQ	Futures	3001.65	3003.4	2986.54	2986.83	51468.0
2012-11-08 16:00:00	NQ	Futures	2986.83	2994.68	2985.38	2994.1	12178.0
2012-11-08 17:00:00	NQ	Futures	2994.1	2994.39	2992.65	2993.23	96.0
2012-11-08 18:00:00	NQ	Futures	2992.94	2995.55	2992.65	2994.97	422.0
2012-11-08 19:00:00	NQ	Futures	2994.97	2995.26	2993.23	2994.97	874.0
2012-11-08 20:00:00	NQ	Futures	2994.97	3001.94	2994.97	3001.07	1034.0
2012-11-08 21:00:00	NQ	Futures	3001.07	3003.4	2999.04	3002.53	831.0
2012-11-08 22:00:00	NQ	Futures	3002.53	3003.4	2999.04	3000.78	932.0
2012-11-08 23:00:00	NQ	Futures	3000.78	3002.82	3000.49	3002.24	374.0
2012-11-08 00:00:00	YM	Futures	12915.6	12922.7	12906.6	12910.6	468.0
2012-11-08 01:00:00	YM	Futures	12909.6	12915.6	12894.6	12899.6	644.0

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

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