PREVIEW / futures_1hour / 2012-06-21

all futures 1-hour files

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

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-21 00:00:00	ES	Futures	1369.06	1369.57	1366.77	1367.03	6327.0
2012-06-21 01:00:00	ES	Futures	1367.28	1369.06	1366.26	1368.04	5523.0
2012-06-21 02:00:00	ES	Futures	1368.04	1369.06	1367.28	1368.55	7482.0
2012-06-21 03:00:00	ES	Futures	1368.81	1371.6	1366.01	1366.77	42584.0
2012-06-21 04:00:00	ES	Futures	1366.77	1370.08	1366.01	1369.32	26890.0
2012-06-21 05:00:00	ES	Futures	1369.57	1371.35	1368.3	1370.33	24673.0
2012-06-21 06:00:00	ES	Futures	1370.33	1371.1	1369.57	1370.08	14169.0
2012-06-21 07:00:00	ES	Futures	1370.08	1376.44	1369.82	1373.89	53089.0
2012-06-21 08:00:00	ES	Futures	1373.89	1375.42	1371.86	1373.13	74121.0
2012-06-21 09:00:00	ES	Futures	1373.13	1376.18	1370.08	1370.59	240315.0
2012-06-21 10:00:00	ES	Futures	1370.84	1370.84	1364.74	1367.03	369472.0
2012-06-21 11:00:00	ES	Futures	1367.03	1367.28	1357.37	1360.67	472892.0
2012-06-21 12:00:00	ES	Futures	1360.67	1360.92	1351.26	1353.55	348059.0
2012-06-21 13:00:00	ES	Futures	1353.81	1354.82	1348.47	1349.48	231584.0
2012-06-21 14:00:00	ES	Futures	1349.48	1350.25	1344.65	1347.19	223576.0
2012-06-21 15:00:00	ES	Futures	1347.19	1347.96	1340.07	1341.6	409010.0
2012-06-21 16:00:00	ES	Futures	1341.35	1344.65	1340.33	1341.09	130787.0
2012-06-21 17:00:00	ES	Futures	1341.09	1344.4	1340.84	1344.14	6679.0
2012-06-21 18:00:00	ES	Futures	1344.4	1345.16	1343.63	1344.14	6851.0
2012-06-21 19:00:00	ES	Futures	1343.89	1345.16	1343.13	1343.38	3750.0
2012-06-21 20:00:00	ES	Futures	1343.38	1344.65	1342.87	1343.63	7070.0
2012-06-21 21:00:00	ES	Futures	1343.38	1345.16	1342.87	1343.38	5091.0
2012-06-21 22:00:00	ES	Futures	1343.38	1345.16	1343.38	1343.89	4688.0
2012-06-21 23:00:00	ES	Futures	1343.89	1344.65	1342.62	1343.38	4234.0
2012-06-21 00:00:00	NQ	Futures	3026.98	3027.27	3022.05	3022.63	476.0
2012-06-21 01:00:00	NQ	Futures	3022.63	3025.53	3020.02	3023.79	421.0
2012-06-21 02:00:00	NQ	Futures	3023.21	3024.95	3021.47	3024.37	467.0
2012-06-21 03:00:00	NQ	Futures	3024.37	3029.59	3018.28	3020.31	4535.0
2012-06-21 04:00:00	NQ	Futures	3020.02	3026.69	3018.57	3025.82	2892.0
2012-06-21 05:00:00	NQ	Futures	3026.11	3029.3	3023.79	3026.98	2466.0
2012-06-21 06:00:00	NQ	Futures	3027.27	3029.01	3025.24	3027.27	1516.0
2012-06-21 07:00:00	NQ	Futures	3027.27	3038.57	3026.4	3033.94	5366.0
2012-06-21 08:00:00	NQ	Futures	3033.65	3037.41	3029.3	3030.17	9045.0
2012-06-21 09:00:00	NQ	Futures	3030.75	3035.68	3021.76	3022.63	28297.0
2012-06-21 10:00:00	NQ	Futures	3023.79	3023.79	3010.75	3020.31	39965.0
2012-06-21 11:00:00	NQ	Futures	3020.6	3020.89	2995.09	3001.76	44138.0
2012-06-21 12:00:00	NQ	Futures	3001.76	3002.92	2982.92	2986.1	30524.0
2012-06-21 13:00:00	NQ	Futures	2985.82	2989.29	2976.54	2980.89	23263.0
2012-06-21 14:00:00	NQ	Futures	2980.6	2980.89	2969.0	2974.8	27851.0
2012-06-21 15:00:00	NQ	Futures	2975.09	2975.67	2955.09	2959.15	54242.0
2012-06-21 16:00:00	NQ	Futures	2959.15	2966.68	2958.28	2959.73	10558.0
2012-06-21 17:00:00	NQ	Futures	2959.73	2965.23	2958.86	2964.94	352.0
2012-06-21 18:00:00	NQ	Futures	2965.23	2966.68	2962.91	2963.2	404.0
2012-06-21 19:00:00	NQ	Futures	2963.49	2965.81	2961.46	2962.04	262.0
2012-06-21 20:00:00	NQ	Futures	2962.33	2966.1	2961.46	2962.91	496.0
2012-06-21 21:00:00	NQ	Futures	2962.91	2966.1	2962.04	2962.91	458.0
2012-06-21 22:00:00	NQ	Futures	2963.2	2966.1	2962.91	2963.49	340.0
2012-06-21 23:00:00	NQ	Futures	2963.78	2964.94	2961.46	2963.2	345.0
2012-06-21 00:00:00	YM	Futures	12657.8	12657.8	12637.9	12640.8	315.0
2012-06-21 01:00:00	YM	Futures	12638.9	12655.8	12632.9	12645.8	306.0

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

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