PREVIEW / futures_1hour / 2012-02-16

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-02-16.parquet
  size:    49 KB
  rows:    1,480

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-02-16 00:00:00	ES	Futures	1345.62	1346.37	1345.36	1345.87	3130.0
2012-02-16 01:00:00	ES	Futures	1346.12	1346.62	1345.11	1345.62	7186.0
2012-02-16 02:00:00	ES	Futures	1345.36	1348.89	1344.86	1348.64	15524.0
2012-02-16 03:00:00	ES	Futures	1348.39	1349.14	1344.86	1347.63	46101.0
2012-02-16 04:00:00	ES	Futures	1347.63	1349.14	1346.37	1347.38	20851.0
2012-02-16 05:00:00	ES	Futures	1347.38	1349.14	1346.37	1348.64	20611.0
2012-02-16 06:00:00	ES	Futures	1348.64	1349.9	1347.38	1348.14	23024.0
2012-02-16 07:00:00	ES	Futures	1348.14	1349.14	1345.11	1346.12	45835.0
2012-02-16 08:00:00	ES	Futures	1346.37	1351.92	1345.62	1350.15	91540.0
2012-02-16 09:00:00	ES	Futures	1350.15	1354.18	1349.14	1352.92	250787.0
2012-02-16 10:00:00	ES	Futures	1352.67	1357.71	1351.92	1355.44	322210.0
2012-02-16 11:00:00	ES	Futures	1355.19	1363.0	1354.69	1362.0	309728.0
2012-02-16 12:00:00	ES	Futures	1362.25	1364.52	1361.49	1363.51	213149.0
2012-02-16 13:00:00	ES	Futures	1363.51	1367.29	1363.26	1365.77	138558.0
2012-02-16 14:00:00	ES	Futures	1366.03	1367.54	1364.77	1366.53	90108.0
2012-02-16 15:00:00	ES	Futures	1366.53	1368.04	1364.52	1366.53	205390.0
2012-02-16 16:00:00	ES	Futures	1366.53	1366.53	1364.77	1365.52	96751.0
2012-02-16 17:00:00	ES	Futures	1365.77	1366.28	1365.52	1366.28	3406.0
2012-02-16 18:00:00	ES	Futures	1366.03	1366.78	1365.27	1365.52	5448.0
2012-02-16 19:00:00	ES	Futures	1365.52	1366.78	1365.27	1366.28	5168.0
2012-02-16 20:00:00	ES	Futures	1366.28	1367.54	1366.28	1366.28	5725.0
2012-02-16 21:00:00	ES	Futures	1366.53	1367.29	1365.52	1366.03	3472.0
2012-02-16 22:00:00	ES	Futures	1365.77	1366.28	1365.02	1365.27	2164.0
2012-02-16 23:00:00	ES	Futures	1365.52	1365.77	1364.77	1365.02	2765.0
2012-02-16 00:00:00	NQ	Futures	2939.1	2941.41	2938.81	2940.83	597.0
2012-02-16 01:00:00	NQ	Futures	2940.83	2943.14	2939.1	2939.97	721.0
2012-02-16 02:00:00	NQ	Futures	2939.97	2947.19	2938.52	2946.9	2465.0
2012-02-16 03:00:00	NQ	Futures	2946.32	2949.5	2940.83	2948.34	4410.0
2012-02-16 04:00:00	NQ	Futures	2948.34	2952.1	2945.74	2948.34	3274.0
2012-02-16 05:00:00	NQ	Futures	2948.05	2952.67	2947.19	2951.52	1431.0
2012-02-16 06:00:00	NQ	Futures	2951.52	2953.83	2949.21	2950.36	2076.0
2012-02-16 07:00:00	NQ	Futures	2950.36	2952.67	2945.17	2946.32	3506.0
2012-02-16 08:00:00	NQ	Futures	2946.03	2957.3	2944.88	2952.96	10394.0
2012-02-16 09:00:00	NQ	Futures	2952.96	2957.3	2946.9	2953.83	54441.0
2012-02-16 10:00:00	NQ	Futures	2953.54	2963.36	2952.67	2953.54	48969.0
2012-02-16 11:00:00	NQ	Futures	2953.25	2972.6	2951.52	2970.0	38690.0
2012-02-16 12:00:00	NQ	Futures	2969.71	2982.71	2969.71	2980.11	36267.0
2012-02-16 13:00:00	NQ	Futures	2980.4	2995.42	2979.53	2993.39	28884.0
2012-02-16 14:00:00	NQ	Futures	2993.39	2996.28	2989.64	2992.82	19631.0
2012-02-16 15:00:00	NQ	Futures	2992.82	2996.86	2989.93	2993.39	36765.0
2012-02-16 16:00:00	NQ	Futures	2993.11	2996.86	2991.95	2995.42	8872.0
2012-02-16 17:00:00	NQ	Futures	2995.71	2996.28	2995.13	2996.28	262.0
2012-02-16 18:00:00	NQ	Futures	2995.99	3000.61	2994.84	2995.42	514.0
2012-02-16 19:00:00	NQ	Futures	2995.42	2998.02	2995.42	2998.02	507.0
2012-02-16 20:00:00	NQ	Futures	2997.44	2998.88	2996.57	2997.73	716.0
2012-02-16 21:00:00	NQ	Futures	2997.73	2998.88	2995.99	2996.86	319.0
2012-02-16 22:00:00	NQ	Futures	2996.57	2996.57	2993.97	2994.26	379.0
2012-02-16 23:00:00	NQ	Futures	2994.26	2994.84	2993.68	2993.68	118.0
2012-02-16 00:00:00	YM	Futures	12595.3	12602.3	12593.4	12601.3	348.0
2012-02-16 01:00:00	YM	Futures	12600.3	12605.3	12591.4	12592.4	641.0

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

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