PREVIEW / futures_1hour / 2011-05-27

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-05-27.parquet
  size:    39 KB
  rows:    1,168

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
2011-05-27 00:00:00	ES	Futures	1321.15	1321.15	1320.16	1320.66	1984.0
2011-05-27 01:00:00	ES	Futures	1320.66	1321.15	1319.41	1320.16	5100.0
2011-05-27 02:00:00	ES	Futures	1320.16	1320.91	1319.41	1320.16	5473.0
2011-05-27 03:00:00	ES	Futures	1320.16	1322.15	1319.41	1320.66	25905.0
2011-05-27 04:00:00	ES	Futures	1320.66	1322.4	1317.43	1317.68	27586.0
2011-05-27 05:00:00	ES	Futures	1317.68	1319.66	1316.18	1318.42	27476.0
2011-05-27 06:00:00	ES	Futures	1318.67	1320.16	1317.43	1318.17	11250.0
2011-05-27 07:00:00	ES	Futures	1317.92	1320.41	1317.68	1319.66	14839.0
2011-05-27 08:00:00	ES	Futures	1319.41	1322.64	1319.17	1320.91	46027.0
2011-05-27 09:00:00	ES	Futures	1321.15	1323.64	1318.92	1322.15	209492.0
2011-05-27 10:00:00	ES	Futures	1322.15	1323.64	1318.42	1323.14	258143.0
2011-05-27 11:00:00	ES	Futures	1323.14	1325.38	1322.4	1324.13	241717.0
2011-05-27 12:00:00	ES	Futures	1323.89	1324.63	1321.65	1322.15	90220.0
2011-05-27 13:00:00	ES	Futures	1321.9	1323.14	1320.66	1321.65	86806.0
2011-05-27 14:00:00	ES	Futures	1321.9	1322.4	1319.41	1319.66	63932.0
2011-05-27 15:00:00	ES	Futures	1319.91	1322.4	1318.67	1321.65	163226.0
2011-05-27 16:00:00	ES	Futures	1321.65	1322.15	1320.66	1321.65	73727.0
2011-05-27 00:00:00	NQ	Futures	2679.79	2680.65	2678.64	2679.21	188.0
2011-05-27 01:00:00	NQ	Futures	2678.64	2680.93	2677.49	2679.21	374.0
2011-05-27 02:00:00	NQ	Futures	2678.92	2680.93	2677.2	2678.06	550.0
2011-05-27 03:00:00	NQ	Futures	2678.06	2681.51	2676.34	2678.06	2505.0
2011-05-27 04:00:00	NQ	Futures	2678.35	2681.51	2672.03	2672.03	1895.0
2011-05-27 05:00:00	NQ	Futures	2672.31	2675.48	2668.87	2673.18	2310.0
2011-05-27 06:00:00	NQ	Futures	2672.89	2676.05	2671.45	2671.45	1321.0
2011-05-27 07:00:00	NQ	Futures	2671.45	2676.91	2671.17	2675.48	1702.0
2011-05-27 08:00:00	NQ	Futures	2675.48	2681.51	2674.61	2677.49	4945.0
2011-05-27 09:00:00	NQ	Futures	2677.49	2680.65	2674.04	2678.35	30097.0
2011-05-27 10:00:00	NQ	Futures	2678.64	2685.24	2673.75	2684.67	28611.0
2011-05-27 11:00:00	NQ	Futures	2684.38	2687.54	2683.52	2686.68	22605.0
2011-05-27 12:00:00	NQ	Futures	2686.68	2687.54	2683.23	2683.81	11487.0
2011-05-27 13:00:00	NQ	Futures	2683.81	2686.11	2682.08	2684.38	8125.0
2011-05-27 14:00:00	NQ	Futures	2684.09	2685.53	2678.35	2679.21	10750.0
2011-05-27 15:00:00	NQ	Futures	2679.21	2685.24	2677.49	2684.96	18981.0
2011-05-27 16:00:00	NQ	Futures	2684.96	2685.82	2680.36	2681.22	5723.0
2011-05-27 00:00:00	YM	Futures	11970.5	11971.5	11964.7	11965.7	81.0
2011-05-27 01:00:00	YM	Futures	11965.7	11971.5	11956.0	11964.7	271.0
2011-05-27 02:00:00	YM	Futures	11964.7	11971.5	11958.9	11963.8	600.0
2011-05-27 03:00:00	YM	Futures	11962.8	11975.3	11956.0	11965.7	2266.0
2011-05-27 04:00:00	YM	Futures	11966.6	11979.2	11938.7	11939.7	2441.0
2011-05-27 05:00:00	YM	Futures	11938.7	11951.2	11926.2	11944.5	2076.0
2011-05-27 06:00:00	YM	Futures	11944.5	11958.0	11936.8	11939.7	1263.0
2011-05-27 07:00:00	YM	Futures	11939.7	11961.8	11937.7	11955.1	1378.0
2011-05-27 08:00:00	YM	Futures	11954.1	11978.2	11951.2	11969.5	2703.0
2011-05-27 09:00:00	YM	Futures	11968.6	11997.5	11955.1	11985.9	11954.0
2011-05-27 10:00:00	YM	Futures	11984.9	11987.8	11949.3	11985.9	12785.0
2011-05-27 11:00:00	YM	Futures	11985.9	12014.8	11984.9	12005.2	12979.0
2011-05-27 12:00:00	YM	Futures	12005.2	12009.0	11986.9	11987.8	5285.0
2011-05-27 13:00:00	YM	Futures	11987.8	11995.5	11972.4	11979.2	4000.0
2011-05-27 14:00:00	YM	Futures	11979.2	11984.9	11956.0	11958.0	4029.0
2011-05-27 15:00:00	YM	Futures	11958.0	11984.9	11948.3	11974.4	9789.0

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

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