PREVIEW / futures_1hour / 2014-12-11

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-12-11.parquet
  size:    50 KB
  rows:    1,488

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
2014-12-11 00:00:00	ES	Futures	2128.48	2129.01	2126.91	2128.48	3567.0
2014-12-11 01:00:00	ES	Futures	2128.48	2128.75	2125.34	2126.13	3606.0
2014-12-11 02:00:00	ES	Futures	2126.39	2129.79	2125.6	2128.48	12239.0
2014-12-11 03:00:00	ES	Futures	2128.75	2132.41	2127.96	2131.89	33618.0
2014-12-11 04:00:00	ES	Futures	2131.89	2132.15	2130.06	2131.37	16602.0
2014-12-11 05:00:00	ES	Futures	2131.37	2132.15	2126.65	2128.22	33954.0
2014-12-11 06:00:00	ES	Futures	2127.96	2129.01	2124.29	2124.56	23638.0
2014-12-11 07:00:00	ES	Futures	2124.29	2131.89	2124.29	2130.84	30655.0
2014-12-11 08:00:00	ES	Futures	2130.84	2133.72	2124.56	2132.94	77627.0
2014-12-11 09:00:00	ES	Futures	2132.68	2147.08	2130.32	2144.73	250242.0
2014-12-11 10:00:00	ES	Futures	2144.99	2153.63	2143.42	2149.97	298375.0
2014-12-11 11:00:00	ES	Futures	2149.97	2154.68	2148.92	2154.42	174727.0
2014-12-11 12:00:00	ES	Futures	2154.16	2154.94	2151.01	2153.11	77791.0
2014-12-11 13:00:00	ES	Futures	2152.85	2153.37	2145.51	2145.51	111520.0
2014-12-11 14:00:00	ES	Futures	2145.51	2147.08	2133.2	2134.25	202956.0
2014-12-11 15:00:00	ES	Futures	2133.99	2144.73	2128.48	2133.46	275718.0
2014-12-11 16:00:00	ES	Futures	2133.46	2133.72	2120.63	2124.29	102419.0
2014-12-11 17:00:00	ES	Futures	2124.29	2126.91	2124.03	2126.65	2857.0
2014-12-11 18:00:00	ES	Futures	2126.65	2128.48	2125.6	2126.13	7866.0
2014-12-11 19:00:00	ES	Futures	2126.65	2127.7	2123.25	2127.18	8475.0
2014-12-11 20:00:00	ES	Futures	2126.91	2127.44	2125.34	2125.87	5006.0
2014-12-11 21:00:00	ES	Futures	2125.87	2127.96	2124.29	2125.87	6891.0
2014-12-11 22:00:00	ES	Futures	2126.13	2127.7	2124.29	2124.82	5387.0
2014-12-11 23:00:00	ES	Futures	2124.82	2125.08	2121.15	2123.25	4161.0
2014-12-11 00:00:00	NQ	Futures	4964.98	4965.57	4960.0	4963.52	1176.0
2014-12-11 01:00:00	NQ	Futures	4963.52	4964.1	4957.66	4960.0	693.0
2014-12-11 02:00:00	NQ	Futures	4959.41	4968.79	4959.12	4964.1	2159.0
2014-12-11 03:00:00	NQ	Futures	4963.81	4972.01	4962.93	4969.67	4923.0
2014-12-11 04:00:00	NQ	Futures	4969.96	4972.01	4964.4	4969.96	3018.0
2014-12-11 05:00:00	NQ	Futures	4969.67	4970.26	4955.61	4959.71	7765.0
2014-12-11 06:00:00	NQ	Futures	4959.12	4962.64	4948.87	4949.16	5791.0
2014-12-11 07:00:00	NQ	Futures	4949.16	4966.74	4948.57	4965.27	6335.0
2014-12-11 08:00:00	NQ	Futures	4965.27	4973.48	4953.55	4971.72	14931.0
2014-12-11 09:00:00	NQ	Futures	4971.72	5007.17	4967.62	5005.71	56364.0
2014-12-11 10:00:00	NQ	Futures	5005.71	5031.79	4997.8	5025.34	58086.0
2014-12-11 11:00:00	NQ	Futures	5025.05	5037.35	5021.53	5034.72	26732.0
2014-12-11 12:00:00	NQ	Futures	5034.72	5036.48	5023.0	5030.32	17029.0
2014-12-11 13:00:00	NQ	Futures	5030.03	5032.08	5017.14	5017.14	21284.0
2014-12-11 14:00:00	NQ	Futures	5017.43	5020.95	4984.03	4986.96	39323.0
2014-12-11 15:00:00	NQ	Futures	4986.96	5013.03	4967.91	4978.46	68108.0
2014-12-11 16:00:00	NQ	Futures	4978.46	4978.75	4946.23	4955.9	15687.0
2014-12-11 17:00:00	NQ	Futures	4955.61	4961.76	4955.31	4961.47	227.0
2014-12-11 18:00:00	NQ	Futures	4961.17	4966.45	4958.54	4961.47	883.0
2014-12-11 19:00:00	NQ	Futures	4962.05	4966.45	4955.31	4964.4	883.0
2014-12-11 20:00:00	NQ	Futures	4964.1	4964.1	4957.95	4959.71	730.0
2014-12-11 21:00:00	NQ	Futures	4959.12	4962.93	4954.43	4957.95	648.0
2014-12-11 22:00:00	NQ	Futures	4957.66	4962.93	4952.97	4956.19	764.0
2014-12-11 23:00:00	NQ	Futures	4956.48	4956.78	4947.99	4952.68	434.0
2014-12-11 00:00:00	YM	Futures	18282.5	18283.5	18263.7	18281.4	301.0
2014-12-11 01:00:00	YM	Futures	18278.3	18278.3	18255.3	18255.3	25.0

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

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