PREVIEW / futures_1hour / 2012-05-22

all futures 1-hour files

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

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-22 00:00:00	ES	Futures	1329.69	1331.46	1329.69	1330.7	2695.0
2012-05-22 01:00:00	ES	Futures	1330.7	1333.73	1330.44	1332.97	7549.0
2012-05-22 02:00:00	ES	Futures	1332.97	1333.73	1331.71	1332.97	10157.0
2012-05-22 03:00:00	ES	Futures	1332.97	1334.75	1331.96	1333.48	40581.0
2012-05-22 04:00:00	ES	Futures	1333.73	1334.49	1330.19	1331.46	34270.0
2012-05-22 05:00:00	ES	Futures	1331.46	1331.71	1328.67	1329.94	41570.0
2012-05-22 06:00:00	ES	Futures	1329.69	1330.19	1327.91	1329.94	22248.0
2012-05-22 07:00:00	ES	Futures	1329.94	1335.76	1329.69	1335.25	58276.0
2012-05-22 08:00:00	ES	Futures	1335.25	1336.01	1330.95	1331.96	73522.0
2012-05-22 09:00:00	ES	Futures	1331.71	1335.25	1329.43	1332.47	253052.0
2012-05-22 10:00:00	ES	Futures	1332.72	1341.83	1332.47	1341.58	415376.0
2012-05-22 11:00:00	ES	Futures	1341.58	1342.33	1337.28	1337.78	327047.0
2012-05-22 12:00:00	ES	Futures	1337.78	1338.29	1333.23	1337.02	246072.0
2012-05-22 13:00:00	ES	Futures	1337.28	1338.79	1333.23	1335.25	132646.0
2012-05-22 14:00:00	ES	Futures	1335.25	1338.79	1334.24	1335.76	138200.0
2012-05-22 15:00:00	ES	Futures	1335.5	1336.52	1323.11	1330.7	499926.0
2012-05-22 16:00:00	ES	Futures	1330.7	1333.48	1328.93	1330.19	110386.0
2012-05-22 17:00:00	ES	Futures	1330.19	1330.44	1329.18	1329.43	1656.0
2012-05-22 18:00:00	ES	Futures	1329.18	1329.94	1327.91	1328.17	6180.0
2012-05-22 19:00:00	ES	Futures	1328.17	1328.42	1326.14	1326.65	7367.0
2012-05-22 20:00:00	ES	Futures	1326.9	1327.16	1324.37	1324.63	9702.0
2012-05-22 21:00:00	ES	Futures	1324.88	1327.66	1322.86	1327.66	15034.0
2012-05-22 22:00:00	ES	Futures	1327.91	1328.42	1324.63	1325.39	6280.0
2012-05-22 23:00:00	ES	Futures	1325.39	1325.39	1322.6	1324.37	6479.0
2012-05-22 00:00:00	NQ	Futures	2940.88	2943.77	2940.3	2942.04	330.0
2012-05-22 01:00:00	NQ	Futures	2942.04	2948.11	2942.04	2947.24	937.0
2012-05-22 02:00:00	NQ	Futures	2946.95	2947.82	2943.77	2946.66	991.0
2012-05-22 03:00:00	NQ	Futures	2946.38	2953.89	2944.06	2947.82	4484.0
2012-05-22 04:00:00	NQ	Futures	2948.11	2949.85	2940.3	2942.62	3415.0
2012-05-22 05:00:00	NQ	Futures	2942.33	2942.9	2936.54	2939.43	4036.0
2012-05-22 06:00:00	NQ	Futures	2939.15	2940.01	2934.52	2939.43	3082.0
2012-05-22 07:00:00	NQ	Futures	2939.43	2953.89	2938.28	2952.16	9223.0
2012-05-22 08:00:00	NQ	Futures	2952.45	2955.05	2942.9	2945.8	9050.0
2012-05-22 09:00:00	NQ	Futures	2945.51	2954.76	2937.99	2948.69	45707.0
2012-05-22 10:00:00	NQ	Futures	2948.11	2963.15	2946.66	2957.36	48972.0
2012-05-22 11:00:00	NQ	Futures	2957.36	2962.86	2951.58	2952.74	25747.0
2012-05-22 12:00:00	NQ	Futures	2952.45	2955.34	2941.75	2953.61	25208.0
2012-05-22 13:00:00	NQ	Futures	2953.89	2959.39	2942.62	2947.24	17516.0
2012-05-22 14:00:00	NQ	Futures	2947.53	2956.79	2943.19	2944.93	24615.0
2012-05-22 15:00:00	NQ	Futures	2945.22	2949.27	2917.74	2938.28	55674.0
2012-05-22 16:00:00	NQ	Futures	2937.99	2941.46	2931.63	2934.23	10786.0
2012-05-22 17:00:00	NQ	Futures	2934.81	2934.81	2932.2	2932.49	101.0
2012-05-22 18:00:00	NQ	Futures	2932.49	2934.23	2930.76	2931.34	413.0
2012-05-22 19:00:00	NQ	Futures	2931.92	2932.78	2928.16	2929.89	659.0
2012-05-22 20:00:00	NQ	Futures	2929.6	2930.76	2922.08	2923.82	1377.0
2012-05-22 21:00:00	NQ	Futures	2924.11	2929.6	2919.48	2929.6	1064.0
2012-05-22 22:00:00	NQ	Futures	2929.6	2931.05	2923.24	2924.69	829.0
2012-05-22 23:00:00	NQ	Futures	2924.4	2924.4	2918.9	2922.08	530.0
2012-05-22 00:00:00	YM	Futures	12430.8	12443.8	12429.8	12439.8	228.0
2012-05-22 01:00:00	YM	Futures	12440.8	12467.7	12439.8	12462.7	849.0

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

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