PREVIEW / futures_1hour / 2012-05-10

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-05-10.parquet
  size:    49 KB
  rows:    1,498

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-05-10 00:00:00	ES	Futures	1368.14	1370.92	1367.89	1370.67	3708.0
2012-05-10 01:00:00	ES	Futures	1370.42	1371.43	1369.15	1370.16	7181.0
2012-05-10 02:00:00	ES	Futures	1370.42	1374.21	1370.16	1374.21	13840.0
2012-05-10 03:00:00	ES	Futures	1373.96	1374.21	1370.42	1371.93	32436.0
2012-05-10 04:00:00	ES	Futures	1371.93	1372.44	1367.13	1367.89	34063.0
2012-05-10 05:00:00	ES	Futures	1368.14	1369.66	1364.09	1366.12	37806.0
2012-05-10 06:00:00	ES	Futures	1366.12	1370.92	1364.85	1370.67	29059.0
2012-05-10 07:00:00	ES	Futures	1370.42	1375.73	1367.38	1375.73	63882.0
2012-05-10 08:00:00	ES	Futures	1375.73	1379.27	1374.21	1376.49	113451.0
2012-05-10 09:00:00	ES	Futures	1376.49	1380.03	1374.72	1376.74	238074.0
2012-05-10 10:00:00	ES	Futures	1376.74	1378.76	1369.66	1371.68	297085.0
2012-05-10 11:00:00	ES	Futures	1371.68	1375.98	1369.66	1372.69	202306.0
2012-05-10 12:00:00	ES	Futures	1372.69	1377.25	1369.66	1376.49	165592.0
2012-05-10 13:00:00	ES	Futures	1376.74	1378.26	1373.45	1374.21	121135.0
2012-05-10 14:00:00	ES	Futures	1374.21	1375.98	1372.69	1373.2	70711.0
2012-05-10 15:00:00	ES	Futures	1372.95	1374.46	1367.63	1370.67	241942.0
2012-05-10 16:00:00	ES	Futures	1371.18	1374.72	1364.34	1367.38	131567.0
2012-05-10 17:00:00	ES	Futures	1367.63	1367.63	1360.04	1362.57	28700.0
2012-05-10 18:00:00	ES	Futures	1363.08	1365.36	1362.32	1364.85	15095.0
2012-05-10 19:00:00	ES	Futures	1365.1	1365.86	1362.07	1363.84	15983.0
2012-05-10 20:00:00	ES	Futures	1363.84	1367.13	1363.08	1366.62	8722.0
2012-05-10 21:00:00	ES	Futures	1366.62	1367.13	1363.59	1364.09	11211.0
2012-05-10 22:00:00	ES	Futures	1364.09	1366.12	1364.09	1365.61	4296.0
2012-05-10 23:00:00	ES	Futures	1365.61	1365.86	1363.33	1363.59	5358.0
2012-05-10 00:00:00	NQ	Futures	3022.72	3031.11	3021.86	3030.53	782.0
2012-05-10 01:00:00	NQ	Futures	3030.24	3030.82	3027.64	3028.51	705.0
2012-05-10 02:00:00	NQ	Futures	3028.8	3035.74	3027.93	3035.45	1629.0
2012-05-10 03:00:00	NQ	Futures	3035.74	3040.08	3028.51	3034.0	4027.0
2012-05-10 04:00:00	NQ	Futures	3034.29	3035.16	3023.01	3023.88	2859.0
2012-05-10 05:00:00	NQ	Futures	3023.88	3026.77	3016.07	3019.83	2964.0
2012-05-10 06:00:00	NQ	Futures	3019.54	3029.95	3017.23	3029.38	2148.0
2012-05-10 07:00:00	NQ	Futures	3029.09	3040.65	3023.88	3040.65	4455.0
2012-05-10 08:00:00	NQ	Futures	3040.08	3047.88	3038.34	3043.26	10856.0
2012-05-10 09:00:00	NQ	Futures	3043.26	3049.91	3025.62	3029.95	47925.0
2012-05-10 10:00:00	NQ	Futures	3030.24	3033.42	3013.18	3020.12	60018.0
2012-05-10 11:00:00	NQ	Futures	3019.83	3027.93	3015.49	3018.96	33419.0
2012-05-10 12:00:00	NQ	Futures	3018.96	3031.11	3010.87	3030.82	39564.0
2012-05-10 13:00:00	NQ	Futures	3030.82	3034.29	3023.3	3024.46	34297.0
2012-05-10 14:00:00	NQ	Futures	3024.46	3031.98	3023.88	3025.62	15711.0
2012-05-10 15:00:00	NQ	Futures	3025.62	3028.51	3014.05	3021.28	32673.0
2012-05-10 16:00:00	NQ	Futures	3021.57	3031.4	3014.34	3018.96	10865.0
2012-05-10 17:00:00	NQ	Futures	3018.96	3019.54	3007.97	3014.05	1256.0
2012-05-10 18:00:00	NQ	Futures	3015.78	3018.68	3013.47	3016.94	676.0
2012-05-10 19:00:00	NQ	Futures	3016.65	3017.81	3010.87	3012.02	1261.0
2012-05-10 20:00:00	NQ	Futures	3012.02	3018.96	3010.87	3018.68	682.0
2012-05-10 21:00:00	NQ	Futures	3018.68	3018.96	3011.45	3012.89	869.0
2012-05-10 22:00:00	NQ	Futures	3013.18	3016.07	3012.89	3015.2	605.0
2012-05-10 23:00:00	NQ	Futures	3015.49	3015.49	3011.73	3012.89	401.0
2012-05-10 00:00:00	YM	Futures	12748.6	12761.6	12747.7	12761.6	701.0
2012-05-10 01:00:00	YM	Futures	12759.6	12765.6	12748.6	12753.6	888.0

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

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