PREVIEW / futures_1hour / 2012-05-09

all futures 1-hour files

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

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-09 00:00:00	ES	Futures	1366.87	1369.66	1366.62	1368.14	3590.0
2012-05-09 01:00:00	ES	Futures	1368.14	1370.92	1367.13	1370.92	6773.0
2012-05-09 02:00:00	ES	Futures	1370.92	1373.2	1370.16	1371.18	12188.0
2012-05-09 03:00:00	ES	Futures	1371.18	1372.19	1366.37	1371.18	56256.0
2012-05-09 04:00:00	ES	Futures	1371.18	1372.95	1364.34	1364.85	51302.0
2012-05-09 05:00:00	ES	Futures	1365.1	1367.63	1364.6	1366.12	35850.0
2012-05-09 06:00:00	ES	Futures	1366.12	1367.38	1361.81	1363.59	44071.0
2012-05-09 07:00:00	ES	Futures	1363.59	1365.61	1361.31	1364.85	50175.0
2012-05-09 08:00:00	ES	Futures	1365.1	1365.86	1360.04	1360.8	91959.0
2012-05-09 09:00:00	ES	Futures	1360.8	1364.85	1359.28	1362.57	273185.0
2012-05-09 10:00:00	ES	Futures	1362.32	1365.86	1355.24	1362.32	593195.0
2012-05-09 11:00:00	ES	Futures	1362.32	1372.95	1360.8	1369.4	368195.0
2012-05-09 12:00:00	ES	Futures	1369.4	1369.91	1364.6	1368.65	148934.0
2012-05-09 13:00:00	ES	Futures	1368.65	1376.99	1368.14	1373.96	238186.0
2012-05-09 14:00:00	ES	Futures	1373.96	1374.72	1369.15	1369.4	146463.0
2012-05-09 15:00:00	ES	Futures	1369.66	1372.69	1366.87	1367.89	263995.0
2012-05-09 16:00:00	ES	Futures	1367.89	1368.39	1363.84	1364.09	95186.0
2012-05-09 17:00:00	ES	Futures	1364.34	1364.34	1361.81	1363.59	9740.0
2012-05-09 18:00:00	ES	Futures	1363.08	1364.85	1363.08	1364.6	6383.0
2012-05-09 19:00:00	ES	Futures	1364.6	1365.86	1364.6	1365.61	2959.0
2012-05-09 20:00:00	ES	Futures	1365.61	1367.89	1364.6	1367.63	6679.0
2012-05-09 21:00:00	ES	Futures	1367.38	1370.67	1366.37	1369.91	10117.0
2012-05-09 22:00:00	ES	Futures	1369.91	1373.2	1368.65	1369.66	13943.0
2012-05-09 23:00:00	ES	Futures	1369.66	1370.16	1365.61	1368.14	9523.0
2012-05-09 00:00:00	NQ	Futures	3018.1	3024.46	3018.1	3021.28	430.0
2012-05-09 01:00:00	NQ	Futures	3021.57	3027.93	3019.25	3027.93	592.0
2012-05-09 02:00:00	NQ	Futures	3028.22	3033.42	3024.75	3026.77	1783.0
2012-05-09 03:00:00	NQ	Futures	3027.35	3028.8	3015.2	3026.77	5266.0
2012-05-09 04:00:00	NQ	Futures	3026.77	3030.53	3012.31	3013.47	3821.0
2012-05-09 05:00:00	NQ	Futures	3013.76	3018.68	3012.31	3015.2	3127.0
2012-05-09 06:00:00	NQ	Futures	3015.2	3018.39	3005.95	3008.55	3765.0
2012-05-09 07:00:00	NQ	Futures	3008.26	3013.18	3003.64	3012.6	4610.0
2012-05-09 08:00:00	NQ	Futures	3012.02	3014.63	3002.19	3005.37	16207.0
2012-05-09 09:00:00	NQ	Futures	3005.37	3020.7	2999.59	3017.23	57446.0
2012-05-09 10:00:00	NQ	Futures	3016.94	3022.15	2989.47	3012.6	85658.0
2012-05-09 11:00:00	NQ	Futures	3012.6	3040.65	3008.55	3033.14	50143.0
2012-05-09 12:00:00	NQ	Futures	3033.14	3034.0	3019.54	3027.93	20862.0
2012-05-09 13:00:00	NQ	Futures	3027.64	3044.99	3020.12	3036.89	42963.0
2012-05-09 14:00:00	NQ	Futures	3037.47	3041.81	3030.82	3031.4	19562.0
2012-05-09 15:00:00	NQ	Futures	3031.11	3039.5	3025.04	3031.98	37840.0
2012-05-09 16:00:00	NQ	Futures	3031.69	3034.58	3016.07	3018.96	14718.0
2012-05-09 17:00:00	NQ	Futures	3018.39	3018.39	3008.84	3011.16	1957.0
2012-05-09 18:00:00	NQ	Futures	3011.16	3016.07	3011.16	3015.2	604.0
2012-05-09 19:00:00	NQ	Futures	3015.2	3017.52	3014.92	3016.94	597.0
2012-05-09 20:00:00	NQ	Futures	3016.07	3022.43	3015.2	3022.43	630.0
2012-05-09 21:00:00	NQ	Futures	3022.43	3027.35	3019.83	3025.62	1526.0
2012-05-09 22:00:00	NQ	Futures	3025.33	3032.27	3023.59	3026.19	1428.0
2012-05-09 23:00:00	NQ	Futures	3026.48	3027.64	3017.23	3022.43	997.0
2012-05-09 00:00:00	YM	Futures	12766.6	12788.5	12766.6	12778.5	555.0
2012-05-09 01:00:00	YM	Futures	12778.5	12799.5	12769.6	12799.5	616.0

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

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