PREVIEW / futures_1hour / 2012-07-02

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-07-02.parquet
  size:    49 KB
  rows:    1,468

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-07-02 00:00:00	ES	Futures	1377.71	1377.96	1376.44	1376.69	2374.0
2012-07-02 01:00:00	ES	Futures	1376.69	1377.71	1375.67	1376.94	5322.0
2012-07-02 02:00:00	ES	Futures	1377.2	1377.45	1376.18	1376.69	5623.0
2012-07-02 03:00:00	ES	Futures	1376.94	1378.98	1375.67	1377.71	29680.0
2012-07-02 04:00:00	ES	Futures	1377.71	1385.59	1377.45	1384.06	57415.0
2012-07-02 05:00:00	ES	Futures	1384.06	1384.57	1380.5	1380.76	34343.0
2012-07-02 06:00:00	ES	Futures	1380.76	1382.28	1380.25	1382.03	17574.0
2012-07-02 07:00:00	ES	Futures	1381.78	1384.06	1381.01	1382.79	30997.0
2012-07-02 08:00:00	ES	Futures	1382.79	1382.79	1378.72	1380.5	44370.0
2012-07-02 09:00:00	ES	Futures	1380.76	1384.32	1380.5	1381.27	166936.0
2012-07-02 10:00:00	ES	Futures	1381.52	1381.78	1372.88	1375.16	492025.0
2012-07-02 11:00:00	ES	Futures	1375.16	1376.69	1372.62	1374.91	219521.0
2012-07-02 12:00:00	ES	Futures	1375.16	1380.0	1374.66	1377.96	115373.0
2012-07-02 13:00:00	ES	Futures	1378.22	1379.49	1377.2	1377.71	53353.0
2012-07-02 14:00:00	ES	Futures	1377.71	1380.5	1376.44	1379.23	104899.0
2012-07-02 15:00:00	ES	Futures	1379.49	1383.05	1377.45	1382.03	195655.0
2012-07-02 16:00:00	ES	Futures	1382.28	1383.05	1380.0	1380.25	74245.0
2012-07-02 17:00:00	ES	Futures	1380.25	1382.54	1379.74	1381.78	3345.0
2012-07-02 18:00:00	ES	Futures	1381.78	1383.81	1381.52	1382.03	5010.0
2012-07-02 19:00:00	ES	Futures	1382.03	1382.28	1380.25	1380.76	3627.0
2012-07-02 20:00:00	ES	Futures	1380.76	1381.01	1379.74	1379.74	6228.0
2012-07-02 21:00:00	ES	Futures	1380.0	1381.52	1379.49	1381.52	5282.0
2012-07-02 22:00:00	ES	Futures	1381.52	1382.54	1381.27	1382.28	3136.0
2012-07-02 23:00:00	ES	Futures	1382.54	1383.05	1381.52	1382.54	2694.0
2012-07-02 00:00:00	NQ	Futures	3019.73	3020.31	3017.12	3017.41	190.0
2012-07-02 01:00:00	NQ	Futures	3017.7	3019.44	3016.25	3018.28	256.0
2012-07-02 02:00:00	NQ	Futures	3018.57	3019.44	3016.83	3018.28	662.0
2012-07-02 03:00:00	NQ	Futures	3017.99	3023.21	3015.38	3021.47	3792.0
2012-07-02 04:00:00	NQ	Futures	3021.47	3035.68	3020.89	3031.91	6050.0
2012-07-02 05:00:00	NQ	Futures	3031.91	3033.36	3023.79	3024.08	3884.0
2012-07-02 06:00:00	NQ	Futures	3023.79	3028.14	3023.5	3027.56	1983.0
2012-07-02 07:00:00	NQ	Futures	3026.98	3032.2	3026.4	3030.46	3681.0
2012-07-02 08:00:00	NQ	Futures	3030.17	3030.46	3022.05	3026.98	4736.0
2012-07-02 09:00:00	NQ	Futures	3026.69	3038.28	3022.05	3030.46	26665.0
2012-07-02 10:00:00	NQ	Futures	3030.75	3034.52	3014.22	3024.66	52031.0
2012-07-02 11:00:00	NQ	Futures	3024.66	3027.56	3017.7	3022.34	20779.0
2012-07-02 12:00:00	NQ	Futures	3022.63	3032.78	3019.44	3029.01	13023.0
2012-07-02 13:00:00	NQ	Futures	3029.01	3030.75	3025.82	3026.69	7920.0
2012-07-02 14:00:00	NQ	Futures	3026.69	3032.49	3023.79	3030.17	11878.0
2012-07-02 15:00:00	NQ	Futures	3029.88	3037.7	3024.95	3035.97	19732.0
2012-07-02 16:00:00	NQ	Futures	3035.97	3037.7	3030.46	3030.75	6595.0
2012-07-02 17:00:00	NQ	Futures	3030.75	3033.94	3030.46	3033.94	137.0
2012-07-02 18:00:00	NQ	Futures	3034.23	3036.54	3033.07	3033.65	243.0
2012-07-02 19:00:00	NQ	Futures	3033.65	3033.65	3030.75	3031.33	206.0
2012-07-02 20:00:00	NQ	Futures	3031.04	3033.36	3030.46	3030.75	404.0
2012-07-02 21:00:00	NQ	Futures	3031.04	3035.39	3030.46	3035.39	532.0
2012-07-02 22:00:00	NQ	Futures	3035.39	3037.7	3034.81	3037.12	440.0
2012-07-02 23:00:00	NQ	Futures	3037.12	3039.15	3035.39	3038.86	523.0
2012-07-02 00:00:00	YM	Futures	12714.4	12714.4	12705.5	12707.5	118.0
2012-07-02 01:00:00	YM	Futures	12708.5	12713.4	12702.5	12708.5	227.0

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

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