PREVIEW / futures_1hour / 2012-02-15

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-02-15.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-02-15 00:00:00	ES	Futures	1366.53	1368.04	1366.03	1367.79	8559.0
2012-02-15 01:00:00	ES	Futures	1367.79	1367.79	1365.02	1365.77	5883.0
2012-02-15 02:00:00	ES	Futures	1365.77	1366.53	1363.76	1364.01	15804.0
2012-02-15 03:00:00	ES	Futures	1364.01	1366.28	1363.0	1365.52	40757.0
2012-02-15 04:00:00	ES	Futures	1365.52	1367.29	1365.27	1366.53	24104.0
2012-02-15 05:00:00	ES	Futures	1366.78	1367.79	1365.02	1366.28	23003.0
2012-02-15 06:00:00	ES	Futures	1366.28	1367.54	1365.52	1366.03	18477.0
2012-02-15 07:00:00	ES	Futures	1366.28	1368.8	1365.77	1366.28	52474.0
2012-02-15 08:00:00	ES	Futures	1366.28	1367.03	1361.49	1363.0	118159.0
2012-02-15 09:00:00	ES	Futures	1363.0	1365.27	1358.72	1361.49	255336.0
2012-02-15 10:00:00	ES	Futures	1361.24	1362.75	1358.22	1360.23	275782.0
2012-02-15 11:00:00	ES	Futures	1360.23	1364.52	1359.48	1363.76	212823.0
2012-02-15 12:00:00	ES	Futures	1363.76	1364.01	1355.19	1356.2	254161.0
2012-02-15 13:00:00	ES	Futures	1356.2	1357.21	1352.92	1356.96	237125.0
2012-02-15 14:00:00	ES	Futures	1357.21	1358.22	1350.4	1350.4	258900.0
2012-02-15 15:00:00	ES	Futures	1350.4	1353.93	1348.64	1351.66	307244.0
2012-02-15 16:00:00	ES	Futures	1351.66	1354.18	1349.4	1349.9	102289.0
2012-02-15 17:00:00	ES	Futures	1349.9	1350.91	1349.65	1350.4	3104.0
2012-02-15 18:00:00	ES	Futures	1349.65	1350.15	1348.64	1349.65	6211.0
2012-02-15 19:00:00	ES	Futures	1349.65	1349.9	1347.13	1348.89	13091.0
2012-02-15 20:00:00	ES	Futures	1348.89	1349.14	1346.88	1348.14	8581.0
2012-02-15 21:00:00	ES	Futures	1347.88	1348.14	1345.11	1345.62	13951.0
2012-02-15 22:00:00	ES	Futures	1345.62	1346.62	1345.11	1346.12	5138.0
2012-02-15 23:00:00	ES	Futures	1346.37	1346.62	1345.36	1345.62	2709.0
2012-02-15 00:00:00	NQ	Futures	2991.08	2991.95	2989.64	2991.95	909.0
2012-02-15 01:00:00	NQ	Futures	2991.66	2991.66	2988.2	2989.06	444.0
2012-02-15 02:00:00	NQ	Futures	2988.77	2990.51	2986.75	2988.49	1187.0
2012-02-15 03:00:00	NQ	Futures	2988.49	2993.11	2986.46	2991.66	3185.0
2012-02-15 04:00:00	NQ	Futures	2991.66	2995.71	2991.37	2994.26	3366.0
2012-02-15 05:00:00	NQ	Futures	2994.55	2996.57	2990.8	2993.68	2176.0
2012-02-15 06:00:00	NQ	Futures	2992.82	2995.42	2991.95	2992.82	1188.0
2012-02-15 07:00:00	NQ	Futures	2992.53	2997.73	2992.24	2993.39	3565.0
2012-02-15 08:00:00	NQ	Futures	2993.11	2995.13	2986.46	2987.33	10598.0
2012-02-15 09:00:00	NQ	Futures	2987.33	2992.53	2982.42	2991.08	41114.0
2012-02-15 10:00:00	NQ	Futures	2991.37	3000.9	2984.44	2993.97	56494.0
2012-02-15 11:00:00	NQ	Futures	2993.97	3004.08	2993.11	3003.5	27895.0
2012-02-15 12:00:00	NQ	Futures	3003.5	3004.08	2970.29	2973.76	55913.0
2012-02-15 13:00:00	NQ	Futures	2973.47	2978.09	2962.49	2976.93	46384.0
2012-02-15 14:00:00	NQ	Futures	2977.22	2979.82	2956.43	2957.3	44968.0
2012-02-15 15:00:00	NQ	Futures	2957.01	2959.61	2948.63	2952.1	56264.0
2012-02-15 16:00:00	NQ	Futures	2952.1	2957.87	2946.32	2946.61	11150.0
2012-02-15 17:00:00	NQ	Futures	2946.61	2949.79	2946.61	2948.63	402.0
2012-02-15 18:00:00	NQ	Futures	2949.21	2949.21	2944.88	2945.74	610.0
2012-02-15 19:00:00	NQ	Futures	2946.03	2946.32	2943.72	2945.45	803.0
2012-02-15 20:00:00	NQ	Futures	2945.74	2945.74	2940.54	2942.86	1011.0
2012-02-15 21:00:00	NQ	Futures	2943.14	2943.43	2937.66	2937.95	1554.0
2012-02-15 22:00:00	NQ	Futures	2937.95	2940.26	2937.37	2939.68	443.0
2012-02-15 23:00:00	NQ	Futures	2939.97	2940.54	2938.23	2938.81	252.0
2012-02-15 00:00:00	YM	Futures	12794.6	12804.5	12790.6	12802.5	416.0
2012-02-15 01:00:00	YM	Futures	12802.5	12803.5	12781.7	12785.6	781.0

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

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