PREVIEW / futures_1hour / 2012-06-20

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-06-20.parquet
  size:    50 KB
  rows:    1,509

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-06-20 00:00:00	ES	Futures	1370.84	1371.35	1370.59	1371.35	1918.0
2012-06-20 01:00:00	ES	Futures	1371.1	1372.88	1371.1	1371.35	3185.0
2012-06-20 02:00:00	ES	Futures	1371.6	1372.88	1370.59	1372.62	10915.0
2012-06-20 03:00:00	ES	Futures	1372.62	1372.88	1369.82	1370.08	33997.0
2012-06-20 04:00:00	ES	Futures	1370.08	1374.91	1369.82	1374.66	35616.0
2012-06-20 05:00:00	ES	Futures	1374.66	1375.93	1373.64	1374.4	20428.0
2012-06-20 06:00:00	ES	Futures	1374.4	1374.66	1371.86	1374.15	16027.0
2012-06-20 07:00:00	ES	Futures	1374.15	1377.71	1373.89	1376.18	35290.0
2012-06-20 08:00:00	ES	Futures	1376.44	1376.94	1374.91	1375.16	37535.0
2012-06-20 09:00:00	ES	Futures	1375.16	1376.18	1370.84	1372.88	177158.0
2012-06-20 10:00:00	ES	Futures	1372.62	1374.91	1370.59	1371.35	219721.0
2012-06-20 11:00:00	ES	Futures	1371.35	1373.38	1370.84	1371.35	193517.0
2012-06-20 12:00:00	ES	Futures	1371.1	1372.62	1361.69	1371.86	504163.0
2012-06-20 13:00:00	ES	Futures	1371.6	1378.72	1371.35	1374.4	316501.0
2012-06-20 14:00:00	ES	Futures	1374.15	1375.93	1364.99	1367.79	321530.0
2012-06-20 15:00:00	ES	Futures	1368.04	1372.62	1363.47	1372.62	309039.0
2012-06-20 16:00:00	ES	Futures	1372.11	1375.16	1372.11	1374.66	95441.0
2012-06-20 17:00:00	ES	Futures	1374.91	1374.91	1374.15	1374.91	1519.0
2012-06-20 18:00:00	ES	Futures	1374.66	1374.91	1372.11	1372.88	6845.0
2012-06-20 19:00:00	ES	Futures	1372.88	1373.64	1372.11	1372.88	2278.0
2012-06-20 20:00:00	ES	Futures	1372.62	1372.88	1371.35	1371.6	4935.0
2012-06-20 21:00:00	ES	Futures	1371.6	1372.88	1370.84	1370.84	3331.0
2012-06-20 22:00:00	ES	Futures	1371.1	1371.1	1368.3	1368.81	7730.0
2012-06-20 23:00:00	ES	Futures	1368.81	1369.57	1368.3	1369.06	2908.0
2012-06-20 00:00:00	NQ	Futures	3028.14	3028.72	3026.69	3027.85	235.0
2012-06-20 01:00:00	NQ	Futures	3027.85	3031.04	3027.85	3028.72	489.0
2012-06-20 02:00:00	NQ	Futures	3028.72	3031.91	3027.56	3031.33	755.0
2012-06-20 03:00:00	NQ	Futures	3031.04	3032.78	3026.69	3027.56	3077.0
2012-06-20 04:00:00	NQ	Futures	3027.56	3036.83	3027.27	3036.26	2880.0
2012-06-20 05:00:00	NQ	Futures	3036.54	3038.57	3033.65	3035.68	2121.0
2012-06-20 06:00:00	NQ	Futures	3035.39	3036.26	3031.04	3035.1	1981.0
2012-06-20 07:00:00	NQ	Futures	3035.39	3040.89	3034.52	3037.7	4393.0
2012-06-20 08:00:00	NQ	Futures	3037.99	3040.02	3034.81	3036.26	6260.0
2012-06-20 09:00:00	NQ	Futures	3036.54	3042.34	3028.14	3035.68	25087.0
2012-06-20 10:00:00	NQ	Futures	3035.68	3038.57	3029.01	3030.17	25249.0
2012-06-20 11:00:00	NQ	Futures	3030.17	3037.7	3029.59	3032.2	17725.0
2012-06-20 12:00:00	NQ	Futures	3032.2	3038.57	3011.9	3035.97	53070.0
2012-06-20 13:00:00	NQ	Futures	3036.26	3047.56	3032.49	3039.73	33461.0
2012-06-20 14:00:00	NQ	Futures	3039.73	3042.05	3020.02	3026.11	37424.0
2012-06-20 15:00:00	NQ	Futures	3026.4	3036.26	3016.25	3035.39	33638.0
2012-06-20 16:00:00	NQ	Futures	3035.1	3039.44	3034.23	3037.7	7620.0
2012-06-20 17:00:00	NQ	Futures	3037.41	3037.7	3036.26	3037.7	161.0
2012-06-20 18:00:00	NQ	Futures	3037.12	3037.12	3031.62	3033.36	366.0
2012-06-20 19:00:00	NQ	Futures	3033.36	3034.52	3032.2	3033.07	192.0
2012-06-20 20:00:00	NQ	Futures	3032.78	3033.36	3029.88	3030.75	593.0
2012-06-20 21:00:00	NQ	Futures	3031.04	3033.36	3029.3	3029.59	291.0
2012-06-20 22:00:00	NQ	Futures	3029.59	3029.88	3024.95	3026.11	997.0
2012-06-20 23:00:00	NQ	Futures	3025.53	3027.56	3024.66	3026.69	409.0
2012-06-20 00:00:00	YM	Futures	12665.7	12670.7	12659.7	12665.7	204.0
2012-06-20 01:00:00	YM	Futures	12666.7	12677.6	12665.7	12670.7	293.0

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

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