PREVIEW / futures_1hour / 2012-06-11

all futures 1-hour files

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

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-11 00:00:00	ES	Futures	1358.78	1360.55	1357.77	1360.3	3155.0
2012-06-11 01:00:00	ES	Futures	1360.3	1361.56	1360.04	1361.31	3561.0
2012-06-11 02:00:00	ES	Futures	1361.31	1362.83	1359.03	1359.54	9683.0
2012-06-11 03:00:00	ES	Futures	1359.79	1359.79	1356.0	1357.26	15705.0
2012-06-11 04:00:00	ES	Futures	1357.01	1360.04	1356.25	1356.5	12258.0
2012-06-11 05:00:00	ES	Futures	1356.5	1358.02	1353.72	1354.23	9047.0
2012-06-11 06:00:00	ES	Futures	1354.23	1355.49	1353.21	1353.47	8847.0
2012-06-11 07:00:00	ES	Futures	1353.47	1353.72	1348.15	1350.18	17114.0
2012-06-11 08:00:00	ES	Futures	1350.18	1352.2	1348.91	1351.19	16742.0
2012-06-11 09:00:00	ES	Futures	1351.44	1352.71	1341.58	1342.59	68725.0
2012-06-11 10:00:00	ES	Futures	1342.59	1345.12	1336.01	1337.28	96765.0
2012-06-11 11:00:00	ES	Futures	1337.53	1340.06	1335.0	1339.05	52061.0
2012-06-11 12:00:00	ES	Futures	1338.79	1340.31	1336.52	1338.79	26103.0
2012-06-11 13:00:00	ES	Futures	1338.54	1341.58	1336.26	1337.28	24227.0
2012-06-11 14:00:00	ES	Futures	1337.28	1337.28	1332.47	1333.73	27660.0
2012-06-11 15:00:00	ES	Futures	1333.73	1334.24	1322.6	1324.63	55741.0
2012-06-11 16:00:00	ES	Futures	1324.63	1326.4	1321.59	1322.35	26268.0
2012-06-11 17:00:00	ES	Futures	1322.35	1323.11	1320.83	1323.11	674.0
2012-06-11 18:00:00	ES	Futures	1323.11	1324.37	1319.31	1323.36	2094.0
2012-06-11 19:00:00	ES	Futures	1323.36	1323.87	1321.08	1323.11	1261.0
2012-06-11 20:00:00	ES	Futures	1323.36	1325.39	1322.1	1324.63	3080.0
2012-06-11 21:00:00	ES	Futures	1324.88	1327.16	1323.87	1326.14	2004.0
2012-06-11 22:00:00	ES	Futures	1326.4	1327.66	1325.89	1326.4	816.0
2012-06-11 23:00:00	ES	Futures	1326.65	1329.18	1325.89	1328.67	1262.0
2012-06-11 00:00:00	NQ	Futures	2996.41	3001.03	2996.12	3001.03	66.0
2012-06-11 01:00:00	NQ	Futures	3000.74	3002.19	2999.88	3001.9	157.0
2012-06-11 02:00:00	NQ	Futures	3002.19	3004.5	2998.14	2999.3	1221.0
2012-06-11 03:00:00	NQ	Futures	2998.43	2999.59	2989.47	2992.07	757.0
2012-06-11 04:00:00	NQ	Futures	2991.78	2997.85	2990.33	2990.91	397.0
2012-06-11 05:00:00	NQ	Futures	2991.2	2994.09	2985.13	2985.71	505.0
2012-06-11 06:00:00	NQ	Futures	2986.86	2989.18	2983.97	2984.26	411.0
2012-06-11 07:00:00	NQ	Futures	2983.97	2985.13	2972.98	2977.32	975.0
2012-06-11 08:00:00	NQ	Futures	2977.32	2981.95	2974.43	2979.05	2191.0
2012-06-11 09:00:00	NQ	Futures	2980.21	2983.39	2957.94	2960.26	10801.0
2012-06-11 10:00:00	NQ	Futures	2959.97	2965.46	2945.8	2949.56	9198.0
2012-06-11 11:00:00	NQ	Futures	2949.56	2958.52	2946.38	2954.18	9654.0
2012-06-11 12:00:00	NQ	Futures	2954.18	2956.79	2950.13	2952.74	2602.0
2012-06-11 13:00:00	NQ	Futures	2952.45	2959.68	2943.19	2946.38	4114.0
2012-06-11 14:00:00	NQ	Futures	2946.66	2946.66	2933.65	2935.1	4541.0
2012-06-11 15:00:00	NQ	Futures	2935.1	2937.41	2907.62	2912.54	10715.0
2012-06-11 16:00:00	NQ	Futures	2912.54	2917.74	2909.36	2910.51	3425.0
2012-06-11 17:00:00	NQ	Futures	2910.23	2910.8	2907.91	2910.8	31.0
2012-06-11 18:00:00	NQ	Futures	2912.25	2913.98	2905.31	2912.25	180.0
2012-06-11 19:00:00	NQ	Futures	2912.83	2912.83	2907.62	2911.67	84.0
2012-06-11 20:00:00	NQ	Futures	2911.38	2916.3	2909.65	2915.72	85.0
2012-06-11 21:00:00	NQ	Futures	2915.14	2920.06	2913.41	2919.48	107.0
2012-06-11 22:00:00	NQ	Futures	2918.61	2921.21	2918.32	2919.77	53.0
2012-06-11 23:00:00	NQ	Futures	2919.19	2923.53	2918.32	2923.53	55.0
2012-06-11 00:00:00	YM	Futures	12562.3	12574.2	12558.3	12573.2	297.0
2012-06-11 01:00:00	YM	Futures	12572.2	12583.2	12571.2	12583.2	356.0

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

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