PREVIEW / futures_1hour / 2012-07-24

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-07-24.parquet
  size:    50 KB
  rows:    1,505

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-24 00:00:00	ES	Futures	1367.03	1367.79	1366.77	1366.77	2672.0
2012-07-24 01:00:00	ES	Futures	1367.03	1368.81	1366.01	1368.3	5840.0
2012-07-24 02:00:00	ES	Futures	1368.3	1368.55	1364.48	1365.76	10024.0
2012-07-24 03:00:00	ES	Futures	1365.5	1367.54	1360.92	1363.21	51388.0
2012-07-24 04:00:00	ES	Futures	1363.21	1367.28	1362.96	1366.26	29659.0
2012-07-24 05:00:00	ES	Futures	1366.26	1367.28	1364.74	1365.5	18084.0
2012-07-24 06:00:00	ES	Futures	1365.5	1366.77	1361.69	1363.21	35906.0
2012-07-24 07:00:00	ES	Futures	1363.21	1366.01	1362.2	1363.47	43204.0
2012-07-24 08:00:00	ES	Futures	1363.47	1365.76	1362.45	1365.25	42892.0
2012-07-24 09:00:00	ES	Futures	1365.5	1369.57	1362.96	1363.21	208563.0
2012-07-24 10:00:00	ES	Futures	1363.21	1364.99	1357.62	1359.65	299433.0
2012-07-24 11:00:00	ES	Futures	1359.65	1362.7	1355.08	1355.59	309155.0
2012-07-24 12:00:00	ES	Futures	1355.59	1355.84	1348.72	1353.81	278035.0
2012-07-24 13:00:00	ES	Futures	1353.81	1354.31	1349.99	1352.03	107728.0
2012-07-24 14:00:00	ES	Futures	1352.03	1352.28	1346.43	1349.48	167888.0
2012-07-24 15:00:00	ES	Futures	1349.48	1357.87	1346.94	1356.35	360515.0
2012-07-24 16:00:00	ES	Futures	1356.35	1356.86	1343.89	1344.91	117793.0
2012-07-24 17:00:00	ES	Futures	1344.91	1346.94	1344.4	1346.69	3959.0
2012-07-24 18:00:00	ES	Futures	1346.43	1346.43	1344.91	1345.41	4925.0
2012-07-24 19:00:00	ES	Futures	1345.67	1346.94	1345.41	1346.18	2858.0
2012-07-24 20:00:00	ES	Futures	1346.43	1346.43	1344.14	1344.4	5630.0
2012-07-24 21:00:00	ES	Futures	1344.14	1347.19	1343.89	1347.19	8745.0
2012-07-24 22:00:00	ES	Futures	1347.19	1349.74	1346.94	1348.47	8200.0
2012-07-24 23:00:00	ES	Futures	1348.47	1350.75	1348.21	1349.48	5683.0
2012-07-24 00:00:00	NQ	Futures	2994.22	2996.25	2994.22	2995.38	656.0
2012-07-24 01:00:00	NQ	Futures	2995.67	2998.57	2993.06	2997.41	706.0
2012-07-24 02:00:00	NQ	Futures	2997.41	2997.7	2989.58	2991.03	1273.0
2012-07-24 03:00:00	NQ	Futures	2991.03	2994.22	2978.28	2984.08	5526.0
2012-07-24 04:00:00	NQ	Futures	2984.08	2991.32	2982.34	2989.58	3214.0
2012-07-24 05:00:00	NQ	Futures	2989.58	2990.74	2985.53	2987.26	2728.0
2012-07-24 06:00:00	NQ	Futures	2987.26	2989.87	2978.57	2982.63	5094.0
2012-07-24 07:00:00	NQ	Futures	2982.63	2992.48	2981.47	2984.66	5993.0
2012-07-24 08:00:00	NQ	Futures	2984.95	2995.09	2983.5	2994.51	6036.0
2012-07-24 09:00:00	NQ	Futures	2994.8	3003.21	2985.82	2989.87	30432.0
2012-07-24 10:00:00	NQ	Futures	2989.29	2993.93	2978.28	2984.66	41742.0
2012-07-24 11:00:00	NQ	Futures	2984.95	2993.93	2978.86	2980.02	31242.0
2012-07-24 12:00:00	NQ	Futures	2980.02	2980.02	2961.17	2974.51	29490.0
2012-07-24 13:00:00	NQ	Futures	2974.22	2975.67	2964.07	2970.16	19551.0
2012-07-24 14:00:00	NQ	Futures	2970.45	2970.45	2956.83	2960.88	27673.0
2012-07-24 15:00:00	NQ	Futures	2960.6	2971.61	2951.03	2970.45	56647.0
2012-07-24 16:00:00	NQ	Futures	2970.45	2972.48	2918.27	2920.01	19677.0
2012-07-24 17:00:00	NQ	Futures	2920.01	2927.26	2919.72	2926.68	1141.0
2012-07-24 18:00:00	NQ	Futures	2925.81	2925.81	2921.46	2921.46	616.0
2012-07-24 19:00:00	NQ	Futures	2921.46	2923.2	2920.59	2920.88	580.0
2012-07-24 20:00:00	NQ	Futures	2920.88	2924.36	2919.72	2922.91	1355.0
2012-07-24 21:00:00	NQ	Futures	2922.62	2926.97	2921.75	2925.81	1341.0
2012-07-24 22:00:00	NQ	Futures	2926.39	2930.45	2926.1	2927.84	1165.0
2012-07-24 23:00:00	NQ	Futures	2927.55	2932.48	2927.26	2930.16	773.0
2012-07-24 00:00:00	YM	Futures	12579.2	12588.1	12576.2	12580.2	239.0
2012-07-24 01:00:00	YM	Futures	12581.2	12592.1	12570.2	12590.1	451.0

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

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