PREVIEW / futures_1hour / 2012-06-18

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-06-18.parquet
  size:    48 KB
  rows:    1,458

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-18 00:00:00	ES	Futures	1367.28	1367.54	1365.25	1366.77	5652.0
2012-06-18 01:00:00	ES	Futures	1366.52	1367.03	1363.98	1364.99	8375.0
2012-06-18 02:00:00	ES	Futures	1365.25	1367.28	1364.23	1366.01	18281.0
2012-06-18 03:00:00	ES	Futures	1366.01	1366.52	1360.92	1361.43	46054.0
2012-06-18 04:00:00	ES	Futures	1361.43	1362.2	1352.79	1356.86	77668.0
2012-06-18 05:00:00	ES	Futures	1357.11	1359.4	1355.08	1358.64	29754.0
2012-06-18 06:00:00	ES	Futures	1358.64	1360.16	1355.84	1357.11	34620.0
2012-06-18 07:00:00	ES	Futures	1357.37	1358.38	1355.08	1355.08	51613.0
2012-06-18 08:00:00	ES	Futures	1355.08	1356.09	1351.52	1352.79	96858.0
2012-06-18 09:00:00	ES	Futures	1352.79	1357.11	1349.99	1355.84	281587.0
2012-06-18 10:00:00	ES	Futures	1355.84	1362.96	1354.57	1359.65	382264.0
2012-06-18 11:00:00	ES	Futures	1359.4	1359.91	1355.59	1358.89	334870.0
2012-06-18 12:00:00	ES	Futures	1358.89	1360.92	1357.11	1358.64	123972.0
2012-06-18 13:00:00	ES	Futures	1358.64	1362.96	1357.87	1362.2	94050.0
2012-06-18 14:00:00	ES	Futures	1362.2	1364.74	1361.18	1361.94	117791.0
2012-06-18 15:00:00	ES	Futures	1361.69	1363.21	1358.64	1361.43	220937.0
2012-06-18 16:00:00	ES	Futures	1361.43	1365.25	1360.92	1364.74	66082.0
2012-06-18 17:00:00	ES	Futures	1364.48	1364.99	1363.47	1363.98	3622.0
2012-06-18 18:00:00	ES	Futures	1364.23	1364.23	1362.7	1363.21	2467.0
2012-06-18 19:00:00	ES	Futures	1363.21	1364.74	1362.96	1364.74	2584.0
2012-06-18 20:00:00	ES	Futures	1364.48	1365.76	1363.47	1364.74	6660.0
2012-06-18 21:00:00	ES	Futures	1364.48	1364.99	1362.7	1362.96	5959.0
2012-06-18 22:00:00	ES	Futures	1362.96	1363.47	1361.94	1362.7	3301.0
2012-06-18 23:00:00	ES	Futures	1362.7	1363.72	1362.45	1363.21	1814.0
2012-06-18 00:00:00	NQ	Futures	2989.87	2990.16	2984.95	2988.13	356.0
2012-06-18 01:00:00	NQ	Futures	2987.84	2989.0	2984.95	2987.55	478.0
2012-06-18 02:00:00	NQ	Futures	2987.84	2991.03	2985.24	2988.42	1394.0
2012-06-18 03:00:00	NQ	Futures	2988.42	2989.0	2977.99	2979.15	4362.0
2012-06-18 04:00:00	NQ	Futures	2978.86	2980.02	2963.49	2971.61	4960.0
2012-06-18 05:00:00	NQ	Futures	2971.61	2977.7	2967.26	2976.25	3180.0
2012-06-18 06:00:00	NQ	Futures	2976.25	2981.18	2971.9	2974.51	3361.0
2012-06-18 07:00:00	NQ	Futures	2974.51	2975.38	2968.42	2969.29	3587.0
2012-06-18 08:00:00	NQ	Futures	2968.71	2970.74	2958.57	2961.46	8643.0
2012-06-18 09:00:00	NQ	Futures	2961.17	2981.76	2955.96	2978.28	30093.0
2012-06-18 10:00:00	NQ	Futures	2978.86	2997.7	2976.25	2989.58	38558.0
2012-06-18 11:00:00	NQ	Futures	2989.87	2991.9	2979.44	2991.03	32583.0
2012-06-18 12:00:00	NQ	Futures	2990.74	2995.67	2986.39	2991.03	13887.0
2012-06-18 13:00:00	NQ	Futures	2990.74	3004.37	2989.29	3003.79	16429.0
2012-06-18 14:00:00	NQ	Futures	3004.08	3008.43	3000.02	3002.34	13946.0
2012-06-18 15:00:00	NQ	Futures	3002.05	3006.4	2995.67	3000.02	26211.0
2012-06-18 16:00:00	NQ	Futures	3000.02	3004.95	2999.15	3003.79	7327.0
2012-06-18 17:00:00	NQ	Futures	3004.08	3009.88	3004.08	3006.69	1979.0
2012-06-18 18:00:00	NQ	Futures	3006.4	3006.69	3003.21	3003.79	399.0
2012-06-18 19:00:00	NQ	Futures	3004.08	3007.56	3004.08	3006.98	247.0
2012-06-18 20:00:00	NQ	Futures	3006.98	3009.88	3005.24	3007.27	508.0
2012-06-18 21:00:00	NQ	Futures	3006.98	3007.85	3003.5	3003.79	678.0
2012-06-18 22:00:00	NQ	Futures	3004.08	3004.66	3001.76	3002.63	301.0
2012-06-18 23:00:00	NQ	Futures	3003.21	3005.24	3003.21	3003.79	199.0
2012-06-18 00:00:00	YM	Futures	12701.5	12701.5	12674.7	12687.6	1507.0
2012-06-18 01:00:00	YM	Futures	12687.6	12688.6	12660.7	12669.7	661.0

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

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