PREVIEW / futures_1hour / 2012-05-21

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-05-21.parquet
  size:    48 KB
  rows:    1,460

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-21 00:00:00	ES	Futures	1313.24	1313.49	1311.72	1312.48	2871.0
2012-05-21 01:00:00	ES	Futures	1312.48	1313.49	1311.47	1312.99	3850.0
2012-05-21 02:00:00	ES	Futures	1312.99	1314.0	1309.7	1312.99	13556.0
2012-05-21 03:00:00	ES	Futures	1312.74	1316.28	1309.95	1316.02	51361.0
2012-05-21 04:00:00	ES	Futures	1316.02	1318.3	1315.01	1315.27	35565.0
2012-05-21 05:00:00	ES	Futures	1315.01	1316.53	1312.99	1314.51	25407.0
2012-05-21 06:00:00	ES	Futures	1314.25	1316.53	1313.24	1315.77	18751.0
2012-05-21 07:00:00	ES	Futures	1316.02	1316.78	1313.24	1313.75	26172.0
2012-05-21 08:00:00	ES	Futures	1313.75	1314.25	1310.46	1311.22	64098.0
2012-05-21 09:00:00	ES	Futures	1311.22	1314.76	1309.19	1313.24	306623.0
2012-05-21 10:00:00	ES	Futures	1313.24	1324.37	1312.23	1323.36	398540.0
2012-05-21 11:00:00	ES	Futures	1323.36	1323.61	1319.82	1320.58	205181.0
2012-05-21 12:00:00	ES	Futures	1320.33	1325.64	1319.82	1323.11	160134.0
2012-05-21 13:00:00	ES	Futures	1323.11	1326.14	1322.6	1324.63	113338.0
2012-05-21 14:00:00	ES	Futures	1324.88	1327.41	1322.35	1326.65	136915.0
2012-05-21 15:00:00	ES	Futures	1326.65	1330.19	1326.4	1329.69	292924.0
2012-05-21 16:00:00	ES	Futures	1329.69	1331.71	1329.18	1329.94	114987.0
2012-05-21 17:00:00	ES	Futures	1329.94	1330.44	1329.43	1330.19	2650.0
2012-05-21 18:00:00	ES	Futures	1329.94	1331.46	1329.69	1330.44	4527.0
2012-05-21 19:00:00	ES	Futures	1330.44	1331.2	1330.19	1331.2	4179.0
2012-05-21 20:00:00	ES	Futures	1330.95	1331.2	1329.43	1329.69	5660.0
2012-05-21 21:00:00	ES	Futures	1329.69	1330.19	1328.42	1329.94	6779.0
2012-05-21 22:00:00	ES	Futures	1329.94	1331.2	1328.67	1330.44	3704.0
2012-05-21 23:00:00	ES	Futures	1330.44	1330.7	1329.18	1329.94	1700.0
2012-05-21 00:00:00	NQ	Futures	2873.79	2874.94	2872.05	2872.92	493.0
2012-05-21 01:00:00	NQ	Futures	2873.21	2874.07	2869.74	2873.21	345.0
2012-05-21 02:00:00	NQ	Futures	2872.92	2875.52	2864.82	2871.76	1413.0
2012-05-21 03:00:00	NQ	Futures	2871.76	2878.99	2864.82	2878.12	5394.0
2012-05-21 04:00:00	NQ	Futures	2878.41	2883.04	2875.23	2875.81	2491.0
2012-05-21 05:00:00	NQ	Futures	2875.81	2878.41	2870.89	2873.5	1854.0
2012-05-21 06:00:00	NQ	Futures	2873.79	2880.15	2872.63	2878.7	2108.0
2012-05-21 07:00:00	NQ	Futures	2878.7	2880.44	2872.92	2873.79	2504.0
2012-05-21 08:00:00	NQ	Futures	2873.79	2875.52	2866.27	2867.42	9661.0
2012-05-21 09:00:00	NQ	Futures	2867.42	2881.3	2863.66	2876.1	49312.0
2012-05-21 10:00:00	NQ	Futures	2876.1	2912.83	2873.5	2910.23	69447.0
2012-05-21 11:00:00	NQ	Futures	2909.94	2911.09	2901.26	2907.91	29633.0
2012-05-21 12:00:00	NQ	Futures	2908.2	2933.94	2905.89	2927.58	32994.0
2012-05-21 13:00:00	NQ	Futures	2927.87	2933.07	2923.24	2928.44	19736.0
2012-05-21 14:00:00	NQ	Futures	2928.73	2935.39	2922.08	2933.36	19000.0
2012-05-21 15:00:00	NQ	Futures	2933.36	2945.22	2932.2	2941.17	37518.0
2012-05-21 16:00:00	NQ	Futures	2941.17	2945.8	2940.59	2942.9	8059.0
2012-05-21 17:00:00	NQ	Futures	2942.62	2943.19	2941.75	2942.9	120.0
2012-05-21 18:00:00	NQ	Futures	2942.62	2945.8	2942.33	2944.06	861.0
2012-05-21 19:00:00	NQ	Futures	2944.06	2945.8	2943.77	2945.51	568.0
2012-05-21 20:00:00	NQ	Futures	2945.22	2946.09	2942.9	2942.9	415.0
2012-05-21 21:00:00	NQ	Futures	2943.19	2943.48	2939.15	2941.17	866.0
2012-05-21 22:00:00	NQ	Futures	2941.46	2943.77	2939.43	2942.62	458.0
2012-05-21 23:00:00	NQ	Futures	2942.33	2942.9	2939.43	2940.88	339.0
2012-05-21 00:00:00	YM	Futures	12347.1	12350.1	12339.2	12341.2	405.0
2012-05-21 01:00:00	YM	Futures	12343.2	12348.1	12335.2	12348.1	375.0

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

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