PREVIEW / futures_1hour / 2012-02-14

all futures 1-hour files

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

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-14 00:00:00	ES	Futures	1355.95	1356.45	1355.44	1355.95	5914.0
2012-02-14 01:00:00	ES	Futures	1356.2	1356.45	1354.94	1355.7	3772.0
2012-02-14 02:00:00	ES	Futures	1355.7	1356.7	1354.44	1356.45	8942.0
2012-02-14 03:00:00	ES	Futures	1356.7	1357.96	1354.69	1355.95	26598.0
2012-02-14 04:00:00	ES	Futures	1356.2	1357.96	1355.19	1357.46	18719.0
2012-02-14 05:00:00	ES	Futures	1357.71	1362.75	1357.71	1361.49	37079.0
2012-02-14 06:00:00	ES	Futures	1361.49	1362.0	1360.23	1361.49	13691.0
2012-02-14 07:00:00	ES	Futures	1361.49	1362.25	1358.97	1359.73	26383.0
2012-02-14 08:00:00	ES	Futures	1359.48	1360.99	1354.44	1355.7	79860.0
2012-02-14 09:00:00	ES	Futures	1355.7	1357.46	1353.68	1355.19	158562.0
2012-02-14 10:00:00	ES	Futures	1355.19	1355.95	1351.66	1353.18	283269.0
2012-02-14 11:00:00	ES	Futures	1353.18	1357.21	1352.67	1355.44	213906.0
2012-02-14 12:00:00	ES	Futures	1355.44	1356.2	1352.42	1352.67	89287.0
2012-02-14 13:00:00	ES	Futures	1352.92	1354.18	1350.91	1353.18	125519.0
2012-02-14 14:00:00	ES	Futures	1353.43	1353.93	1348.64	1350.91	138621.0
2012-02-14 15:00:00	ES	Futures	1350.91	1358.72	1348.39	1358.22	385951.0
2012-02-14 16:00:00	ES	Futures	1358.47	1358.72	1357.21	1358.22	84374.0
2012-02-14 17:00:00	ES	Futures	1358.47	1358.72	1357.71	1358.22	2577.0
2012-02-14 18:00:00	ES	Futures	1358.22	1358.47	1357.46	1358.47	4610.0
2012-02-14 19:00:00	ES	Futures	1358.22	1358.72	1357.46	1357.71	6347.0
2012-02-14 20:00:00	ES	Futures	1357.46	1358.22	1357.21	1357.71	3262.0
2012-02-14 21:00:00	ES	Futures	1357.46	1368.29	1357.46	1366.53	33814.0
2012-02-14 22:00:00	ES	Futures	1366.78	1367.54	1365.52	1365.77	9016.0
2012-02-14 23:00:00	ES	Futures	1365.77	1366.78	1365.52	1366.78	6174.0
2012-02-14 00:00:00	NQ	Futures	2961.63	2962.2	2960.76	2961.92	253.0
2012-02-14 01:00:00	NQ	Futures	2962.2	2962.2	2959.32	2961.63	291.0
2012-02-14 02:00:00	NQ	Futures	2960.47	2962.49	2958.74	2961.92	442.0
2012-02-14 03:00:00	NQ	Futures	2962.2	2965.96	2959.03	2961.63	1647.0
2012-02-14 04:00:00	NQ	Futures	2961.63	2965.67	2960.47	2965.67	1064.0
2012-02-14 05:00:00	NQ	Futures	2965.96	2974.91	2965.67	2972.02	2390.0
2012-02-14 06:00:00	NQ	Futures	2972.31	2973.18	2970.0	2972.89	898.0
2012-02-14 07:00:00	NQ	Futures	2972.6	2973.76	2966.25	2967.11	2648.0
2012-02-14 08:00:00	NQ	Futures	2967.4	2969.71	2957.58	2959.89	6809.0
2012-02-14 09:00:00	NQ	Futures	2959.89	2967.4	2956.43	2963.07	26308.0
2012-02-14 10:00:00	NQ	Futures	2963.07	2965.38	2953.83	2957.3	31018.0
2012-02-14 11:00:00	NQ	Futures	2957.3	2965.38	2955.56	2959.89	18395.0
2012-02-14 12:00:00	NQ	Futures	2960.18	2961.34	2953.83	2955.27	13972.0
2012-02-14 13:00:00	NQ	Futures	2954.98	2960.76	2951.52	2958.74	17219.0
2012-02-14 14:00:00	NQ	Futures	2958.74	2961.05	2949.5	2954.41	18350.0
2012-02-14 15:00:00	NQ	Futures	2954.41	2974.33	2950.94	2974.05	37628.0
2012-02-14 16:00:00	NQ	Futures	2974.05	2977.51	2973.18	2976.64	9565.0
2012-02-14 17:00:00	NQ	Futures	2976.93	2977.51	2975.49	2976.07	182.0
2012-02-14 18:00:00	NQ	Futures	2976.07	2976.36	2974.62	2975.78	437.0
2012-02-14 19:00:00	NQ	Futures	2976.07	2976.64	2973.76	2974.91	968.0
2012-02-14 20:00:00	NQ	Futures	2974.91	2975.78	2974.05	2975.2	251.0
2012-02-14 21:00:00	NQ	Futures	2974.91	2991.66	2974.62	2990.22	2269.0
2012-02-14 22:00:00	NQ	Futures	2989.93	2991.08	2988.49	2989.64	819.0
2012-02-14 23:00:00	NQ	Futures	2989.35	2991.08	2988.2	2991.08	698.0
2012-02-14 00:00:00	YM	Futures	12693.5	12697.4	12691.5	12695.5	310.0
2012-02-14 01:00:00	YM	Futures	12694.5	12695.5	12682.6	12690.5	310.0

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

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