PREVIEW / futures_1hour / 2012-05-31

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-05-31.parquet
  size:    50 KB
  rows:    1,506

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-31 00:00:00	ES	Futures	1322.35	1324.63	1322.1	1324.63	3502.0
2012-05-31 01:00:00	ES	Futures	1324.37	1327.66	1324.37	1326.9	9201.0
2012-05-31 02:00:00	ES	Futures	1327.16	1328.17	1326.14	1326.65	14934.0
2012-05-31 03:00:00	ES	Futures	1326.4	1329.43	1325.13	1327.91	44878.0
2012-05-31 04:00:00	ES	Futures	1327.91	1331.96	1327.16	1330.44	46564.0
2012-05-31 05:00:00	ES	Futures	1330.44	1331.71	1329.94	1330.7	25622.0
2012-05-31 06:00:00	ES	Futures	1330.44	1331.2	1327.91	1329.94	27436.0
2012-05-31 07:00:00	ES	Futures	1329.94	1330.44	1328.17	1329.94	31013.0
2012-05-31 08:00:00	ES	Futures	1329.69	1330.19	1323.87	1327.41	123733.0
2012-05-31 09:00:00	ES	Futures	1327.41	1328.42	1317.54	1319.31	367395.0
2012-05-31 10:00:00	ES	Futures	1319.31	1320.33	1314.25	1315.77	430891.0
2012-05-31 11:00:00	ES	Futures	1315.77	1321.08	1312.74	1318.05	354509.0
2012-05-31 12:00:00	ES	Futures	1318.05	1327.16	1317.29	1324.37	283454.0
2012-05-31 13:00:00	ES	Futures	1324.37	1329.18	1321.59	1322.86	220607.0
2012-05-31 14:00:00	ES	Futures	1322.6	1327.16	1322.1	1325.89	148703.0
2012-05-31 15:00:00	ES	Futures	1326.14	1334.75	1324.12	1325.39	411588.0
2012-05-31 16:00:00	ES	Futures	1325.39	1325.64	1321.08	1322.35	146435.0
2012-05-31 17:00:00	ES	Futures	1322.35	1322.35	1321.08	1321.84	3111.0
2012-05-31 18:00:00	ES	Futures	1321.84	1323.11	1321.34	1322.1	4499.0
2012-05-31 19:00:00	ES	Futures	1322.35	1323.11	1321.84	1323.11	1822.0
2012-05-31 20:00:00	ES	Futures	1322.86	1323.11	1317.04	1317.54	12943.0
2012-05-31 21:00:00	ES	Futures	1317.29	1319.06	1315.01	1318.05	22451.0
2012-05-31 22:00:00	ES	Futures	1317.8	1319.57	1317.04	1319.31	7526.0
2012-05-31 23:00:00	ES	Futures	1319.31	1319.57	1316.02	1317.54	6423.0
2012-05-31 00:00:00	NQ	Futures	2921.5	2929.6	2921.5	2928.44	416.0
2012-05-31 01:00:00	NQ	Futures	2928.73	2934.23	2928.73	2933.65	881.0
2012-05-31 02:00:00	NQ	Futures	2933.94	2934.52	2929.6	2931.05	1167.0
2012-05-31 03:00:00	NQ	Futures	2930.76	2935.96	2928.16	2933.94	5361.0
2012-05-31 04:00:00	NQ	Futures	2934.23	2941.17	2932.49	2937.7	4799.0
2012-05-31 05:00:00	NQ	Futures	2937.7	2940.59	2936.83	2938.57	2061.0
2012-05-31 06:00:00	NQ	Futures	2937.99	2939.43	2933.07	2937.99	2815.0
2012-05-31 07:00:00	NQ	Futures	2937.99	2938.86	2933.94	2937.41	2746.0
2012-05-31 08:00:00	NQ	Futures	2937.41	2938.86	2925.26	2933.65	9807.0
2012-05-31 09:00:00	NQ	Futures	2933.65	2934.52	2908.49	2911.67	46237.0
2012-05-31 10:00:00	NQ	Futures	2911.38	2915.14	2898.95	2905.02	50118.0
2012-05-31 11:00:00	NQ	Futures	2904.73	2917.74	2899.24	2909.94	32571.0
2012-05-31 12:00:00	NQ	Futures	2910.23	2929.6	2908.2	2922.37	30399.0
2012-05-31 13:00:00	NQ	Futures	2922.37	2933.94	2912.25	2913.98	32921.0
2012-05-31 14:00:00	NQ	Futures	2913.98	2924.4	2912.83	2922.08	25584.0
2012-05-31 15:00:00	NQ	Futures	2922.08	2937.41	2916.3	2921.21	42962.0
2012-05-31 16:00:00	NQ	Futures	2921.21	2921.5	2912.83	2916.59	11931.0
2012-05-31 17:00:00	NQ	Futures	2916.59	2916.59	2913.98	2914.27	122.0
2012-05-31 18:00:00	NQ	Futures	2913.98	2916.59	2913.12	2915.14	642.0
2012-05-31 19:00:00	NQ	Futures	2915.72	2917.46	2914.56	2917.17	237.0
2012-05-31 20:00:00	NQ	Futures	2917.46	2917.46	2905.02	2905.02	842.0
2012-05-31 21:00:00	NQ	Futures	2905.31	2908.78	2900.68	2907.62	1783.0
2012-05-31 22:00:00	NQ	Futures	2907.62	2910.8	2905.31	2909.65	553.0
2012-05-31 23:00:00	NQ	Futures	2910.23	2910.8	2903.86	2907.04	531.0
2012-05-31 00:00:00	YM	Futures	12322.2	12342.2	12321.2	12341.2	338.0
2012-05-31 01:00:00	YM	Futures	12340.2	12363.1	12340.2	12361.1	559.0

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

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