PREVIEW / futures_1hour / 2012-05-08

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-05-08.parquet
  size:    50 KB
  rows:    1,496

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-08 00:00:00	ES	Futures	1380.28	1381.55	1380.03	1380.79	2294.0
2012-05-08 01:00:00	ES	Futures	1381.04	1383.32	1380.79	1381.55	5208.0
2012-05-08 02:00:00	ES	Futures	1381.55	1381.8	1378.26	1379.27	9554.0
2012-05-08 03:00:00	ES	Futures	1379.02	1379.27	1375.73	1376.23	40197.0
2012-05-08 04:00:00	ES	Futures	1376.23	1376.74	1372.69	1373.71	40030.0
2012-05-08 05:00:00	ES	Futures	1373.71	1376.23	1373.45	1374.46	27667.0
2012-05-08 06:00:00	ES	Futures	1374.72	1375.73	1373.2	1373.71	22135.0
2012-05-08 07:00:00	ES	Futures	1373.71	1380.28	1373.45	1380.03	45991.0
2012-05-08 08:00:00	ES	Futures	1380.28	1380.79	1372.95	1376.49	93461.0
2012-05-08 09:00:00	ES	Futures	1376.49	1376.49	1370.67	1372.95	273493.0
2012-05-08 10:00:00	ES	Futures	1373.2	1373.45	1362.83	1364.34	454917.0
2012-05-08 11:00:00	ES	Futures	1364.34	1367.63	1359.79	1366.37	378199.0
2012-05-08 12:00:00	ES	Futures	1366.37	1366.62	1362.07	1362.32	129331.0
2012-05-08 13:00:00	ES	Futures	1362.32	1367.89	1362.07	1367.13	131624.0
2012-05-08 14:00:00	ES	Futures	1367.38	1371.93	1365.1	1370.67	159688.0
2012-05-08 15:00:00	ES	Futures	1370.92	1378.51	1369.66	1376.23	376987.0
2012-05-08 16:00:00	ES	Futures	1376.23	1376.49	1374.21	1376.23	89442.0
2012-05-08 17:00:00	ES	Futures	1376.23	1376.49	1375.73	1376.23	1186.0
2012-05-08 18:00:00	ES	Futures	1375.73	1375.73	1373.96	1374.21	4699.0
2012-05-08 19:00:00	ES	Futures	1374.21	1374.46	1372.44	1373.71	6022.0
2012-05-08 20:00:00	ES	Futures	1373.71	1374.97	1372.19	1373.2	7776.0
2012-05-08 21:00:00	ES	Futures	1373.2	1373.71	1369.91	1370.92	11333.0
2012-05-08 22:00:00	ES	Futures	1370.67	1371.18	1368.65	1369.4	7824.0
2012-05-08 23:00:00	ES	Futures	1369.4	1370.67	1366.37	1366.87	8845.0
2012-05-08 00:00:00	NQ	Futures	3046.73	3049.62	3046.73	3048.75	281.0
2012-05-08 01:00:00	NQ	Futures	3048.75	3055.69	3048.75	3051.93	1367.0
2012-05-08 02:00:00	NQ	Futures	3052.22	3052.22	3043.26	3044.41	1161.0
2012-05-08 03:00:00	NQ	Futures	3044.41	3044.41	3034.87	3036.03	4616.0
2012-05-08 04:00:00	NQ	Futures	3035.74	3036.89	3028.51	3030.53	3590.0
2012-05-08 05:00:00	NQ	Futures	3030.24	3035.74	3027.35	3029.38	3284.0
2012-05-08 06:00:00	NQ	Futures	3029.38	3031.98	3027.35	3028.22	2480.0
2012-05-08 07:00:00	NQ	Futures	3027.93	3042.39	3027.93	3041.81	4335.0
2012-05-08 08:00:00	NQ	Futures	3041.81	3044.12	3025.33	3033.42	10871.0
2012-05-08 09:00:00	NQ	Futures	3033.71	3037.18	3020.99	3024.75	48549.0
2012-05-08 10:00:00	NQ	Futures	3025.04	3025.62	2993.23	3001.03	63828.0
2012-05-08 11:00:00	NQ	Futures	3001.32	3014.34	2988.31	3009.13	49326.0
2012-05-08 12:00:00	NQ	Futures	3009.13	3010.58	2996.7	2997.85	19891.0
2012-05-08 13:00:00	NQ	Futures	2997.85	3017.23	2997.85	3015.78	22344.0
2012-05-08 14:00:00	NQ	Futures	3015.78	3032.56	3011.73	3028.51	26912.0
2012-05-08 15:00:00	NQ	Futures	3028.51	3047.6	3024.46	3037.18	55257.0
2012-05-08 16:00:00	NQ	Futures	3036.89	3039.21	3033.71	3037.47	7133.0
2012-05-08 17:00:00	NQ	Futures	3037.47	3038.05	3036.89	3036.89	78.0
2012-05-08 18:00:00	NQ	Futures	3037.18	3038.05	3035.45	3035.74	450.0
2012-05-08 19:00:00	NQ	Futures	3035.74	3036.61	3032.27	3034.87	445.0
2012-05-08 20:00:00	NQ	Futures	3034.29	3037.47	3030.24	3030.82	846.0
2012-05-08 21:00:00	NQ	Futures	3030.82	3031.4	3023.59	3025.04	1287.0
2012-05-08 22:00:00	NQ	Futures	3025.04	3025.91	3021.57	3023.3	790.0
2012-05-08 23:00:00	NQ	Futures	3023.01	3026.48	3016.65	3018.1	998.0
2012-05-08 00:00:00	YM	Futures	12894.1	12903.1	12894.1	12900.1	271.0
2012-05-08 01:00:00	YM	Futures	12901.1	12917.0	12900.1	12906.1	421.0

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

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