PREVIEW / futures_1hour / 2012-05-30

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-05-30.parquet
  size:    51 KB
  rows:    1,515

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-30 00:00:00	ES	Futures	1341.58	1343.6	1341.32	1343.09	3947.0
2012-05-30 01:00:00	ES	Futures	1343.09	1343.6	1341.58	1342.84	2830.0
2012-05-30 02:00:00	ES	Futures	1342.84	1343.35	1341.32	1341.58	10191.0
2012-05-30 03:00:00	ES	Futures	1341.58	1341.83	1338.54	1341.32	47282.0
2012-05-30 04:00:00	ES	Futures	1341.32	1341.83	1338.79	1339.3	31183.0
2012-05-30 05:00:00	ES	Futures	1339.3	1340.06	1336.52	1339.05	46773.0
2012-05-30 06:00:00	ES	Futures	1339.05	1339.81	1335.0	1335.76	53718.0
2012-05-30 07:00:00	ES	Futures	1335.5	1346.89	1335.5	1339.81	158421.0
2012-05-30 08:00:00	ES	Futures	1340.06	1340.31	1336.77	1338.29	79693.0
2012-05-30 09:00:00	ES	Futures	1338.29	1338.79	1330.19	1331.71	380042.0
2012-05-30 10:00:00	ES	Futures	1331.71	1332.97	1327.91	1328.17	376870.0
2012-05-30 11:00:00	ES	Futures	1328.17	1332.47	1327.41	1329.69	271786.0
2012-05-30 12:00:00	ES	Futures	1329.69	1330.19	1325.13	1328.42	165499.0
2012-05-30 13:00:00	ES	Futures	1328.42	1331.71	1326.14	1331.2	131764.0
2012-05-30 14:00:00	ES	Futures	1331.2	1332.97	1328.42	1328.93	125674.0
2012-05-30 15:00:00	ES	Futures	1328.93	1330.95	1324.37	1327.91	266569.0
2012-05-30 16:00:00	ES	Futures	1327.66	1329.18	1323.36	1323.61	99320.0
2012-05-30 17:00:00	ES	Futures	1323.61	1323.87	1322.86	1323.36	3523.0
2012-05-30 18:00:00	ES	Futures	1323.11	1324.88	1322.1	1323.87	9604.0
2012-05-30 19:00:00	ES	Futures	1324.12	1324.88	1323.36	1324.37	3882.0
2012-05-30 20:00:00	ES	Futures	1324.37	1325.13	1320.83	1323.36	12736.0
2012-05-30 21:00:00	ES	Futures	1323.36	1324.12	1321.59	1323.36	5129.0
2012-05-30 22:00:00	ES	Futures	1323.36	1323.61	1321.84	1323.36	3428.0
2012-05-30 23:00:00	ES	Futures	1323.61	1324.88	1322.1	1322.1	5080.0
2012-05-30 00:00:00	NQ	Futures	2945.51	2949.56	2945.51	2947.82	326.0
2012-05-30 01:00:00	NQ	Futures	2948.11	2950.71	2945.22	2948.98	529.0
2012-05-30 02:00:00	NQ	Futures	2949.27	2949.56	2945.22	2946.09	851.0
2012-05-30 03:00:00	NQ	Futures	2946.09	2946.09	2936.83	2942.04	5839.0
2012-05-30 04:00:00	NQ	Futures	2942.33	2943.77	2937.12	2937.7	4192.0
2012-05-30 05:00:00	NQ	Futures	2937.7	2938.28	2930.47	2935.67	6209.0
2012-05-30 06:00:00	NQ	Futures	2935.67	2937.12	2927.29	2928.73	5027.0
2012-05-30 07:00:00	NQ	Futures	2928.73	2952.16	2928.73	2940.3	14621.0
2012-05-30 08:00:00	NQ	Futures	2940.59	2941.17	2933.65	2936.25	8932.0
2012-05-30 09:00:00	NQ	Futures	2936.25	2937.12	2915.43	2922.95	53421.0
2012-05-30 10:00:00	NQ	Futures	2922.66	2930.76	2916.88	2918.32	48842.0
2012-05-30 11:00:00	NQ	Futures	2918.61	2931.63	2917.17	2927.58	38641.0
2012-05-30 12:00:00	NQ	Futures	2927.29	2929.6	2916.01	2928.16	24747.0
2012-05-30 13:00:00	NQ	Futures	2928.44	2940.01	2921.5	2939.72	24802.0
2012-05-30 14:00:00	NQ	Futures	2939.43	2944.64	2934.52	2936.54	21133.0
2012-05-30 15:00:00	NQ	Futures	2936.54	2942.04	2923.24	2934.52	36701.0
2012-05-30 16:00:00	NQ	Futures	2934.81	2936.83	2926.71	2926.71	8189.0
2012-05-30 17:00:00	NQ	Futures	2926.71	2927.87	2925.55	2926.71	222.0
2012-05-30 18:00:00	NQ	Futures	2927.0	2930.18	2923.82	2927.29	441.0
2012-05-30 19:00:00	NQ	Futures	2927.29	2929.02	2925.84	2927.87	402.0
2012-05-30 20:00:00	NQ	Futures	2927.58	2929.02	2919.77	2924.69	1289.0
2012-05-30 21:00:00	NQ	Futures	2924.4	2927.29	2921.5	2925.84	661.0
2012-05-30 22:00:00	NQ	Futures	2924.97	2924.97	2921.21	2924.4	644.0
2012-05-30 23:00:00	NQ	Futures	2924.4	2927.58	2921.79	2921.79	510.0
2012-05-30 00:00:00	YM	Futures	12480.6	12495.6	12479.6	12491.6	377.0
2012-05-30 01:00:00	YM	Futures	12490.6	12495.6	12481.6	12491.6	263.0

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

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