PREVIEW / futures_1hour / 2014-11-11

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-11-11.parquet
  size:    49 KB
  rows:    1,526

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-11-11 00:00:00	ES	Futures	2135.82	2136.34	2133.72	2133.72	3917.0
2014-11-11 01:00:00	ES	Futures	2133.72	2134.25	2132.15	2133.46	2919.0
2014-11-11 02:00:00	ES	Futures	2133.46	2135.56	2131.63	2133.99	7498.0
2014-11-11 03:00:00	ES	Futures	2133.99	2134.77	2132.41	2133.2	18138.0
2014-11-11 04:00:00	ES	Futures	2133.2	2134.77	2132.15	2134.51	11066.0
2014-11-11 05:00:00	ES	Futures	2134.51	2134.51	2132.68	2133.2	6882.0
2014-11-11 06:00:00	ES	Futures	2133.2	2133.99	2132.68	2133.99	9641.0
2014-11-11 07:00:00	ES	Futures	2133.99	2136.08	2133.46	2135.56	14563.0
2014-11-11 08:00:00	ES	Futures	2135.3	2135.56	2132.94	2133.46	17188.0
2014-11-11 09:00:00	ES	Futures	2133.46	2133.72	2128.22	2130.58	130675.0
2014-11-11 10:00:00	ES	Futures	2130.58	2134.77	2130.32	2134.25	135620.0
2014-11-11 11:00:00	ES	Futures	2134.25	2135.3	2131.63	2131.89	103981.0
2014-11-11 12:00:00	ES	Futures	2131.89	2132.41	2130.32	2130.84	59548.0
2014-11-11 13:00:00	ES	Futures	2131.1	2131.37	2129.01	2130.32	61960.0
2014-11-11 14:00:00	ES	Futures	2130.58	2132.15	2129.79	2130.84	54166.0
2014-11-11 15:00:00	ES	Futures	2130.84	2134.25	2130.06	2134.25	70251.0
2014-11-11 16:00:00	ES	Futures	2134.25	2135.03	2132.94	2133.72	41668.0
2014-11-11 17:00:00	ES	Futures	2133.99	2134.51	2133.72	2133.99	1037.0
2014-11-11 18:00:00	ES	Futures	2133.99	2133.99	2132.68	2132.68	2991.0
2014-11-11 19:00:00	ES	Futures	2132.94	2133.2	2131.89	2132.41	4158.0
2014-11-11 20:00:00	ES	Futures	2132.68	2132.94	2131.1	2131.89	3146.0
2014-11-11 21:00:00	ES	Futures	2131.63	2132.94	2130.32	2132.41	4326.0
2014-11-11 22:00:00	ES	Futures	2132.15	2132.68	2131.1	2132.41	2342.0
2014-11-11 23:00:00	ES	Futures	2132.68	2133.2	2130.58	2130.84	2511.0
2014-11-11 00:00:00	NQ	Futures	4899.93	4901.11	4896.13	4896.13	1029.0
2014-11-11 01:00:00	NQ	Futures	4896.13	4896.71	4892.02	4894.95	633.0
2014-11-11 02:00:00	NQ	Futures	4895.25	4898.76	4891.14	4894.66	1274.0
2014-11-11 03:00:00	NQ	Futures	4894.66	4897.3	4891.73	4893.49	2381.0
2014-11-11 04:00:00	NQ	Futures	4894.66	4897.59	4891.73	4896.42	1685.0
2014-11-11 05:00:00	NQ	Futures	4896.42	4896.42	4891.73	4892.02	912.0
2014-11-11 06:00:00	NQ	Futures	4892.02	4895.25	4891.44	4895.25	1211.0
2014-11-11 07:00:00	NQ	Futures	4895.54	4899.93	4894.37	4898.76	2016.0
2014-11-11 08:00:00	NQ	Futures	4898.47	4898.76	4893.49	4894.07	2352.0
2014-11-11 09:00:00	NQ	Futures	4894.37	4895.25	4877.96	4880.89	26417.0
2014-11-11 10:00:00	NQ	Futures	4881.18	4899.35	4880.89	4897.3	20645.0
2014-11-11 11:00:00	NQ	Futures	4897.3	4900.52	4891.14	4893.49	17741.0
2014-11-11 12:00:00	NQ	Futures	4893.2	4896.42	4889.68	4892.32	8792.0
2014-11-11 13:00:00	NQ	Futures	4892.32	4896.42	4883.82	4894.37	10701.0
2014-11-11 14:00:00	NQ	Futures	4894.37	4898.18	4892.32	4897.3	9991.0
2014-11-11 15:00:00	NQ	Futures	4897.0	4905.5	4894.66	4905.5	17104.0
2014-11-11 16:00:00	NQ	Futures	4905.21	4906.38	4901.4	4904.33	5026.0
2014-11-11 17:00:00	NQ	Futures	4904.33	4905.5	4902.57	4902.57	281.0
2014-11-11 18:00:00	NQ	Futures	4902.86	4903.45	4901.11	4901.11	366.0
2014-11-11 19:00:00	NQ	Futures	4901.4	4902.28	4899.64	4901.11	595.0
2014-11-11 20:00:00	NQ	Futures	4901.4	4901.99	4898.47	4900.23	595.0
2014-11-11 21:00:00	NQ	Futures	4899.93	4901.69	4896.13	4900.52	714.0
2014-11-11 22:00:00	NQ	Futures	4900.23	4901.11	4897.59	4901.11	539.0
2014-11-11 23:00:00	NQ	Futures	4901.4	4902.57	4896.71	4897.59	610.0
2014-11-11 00:00:00	YM	Futures	18296.7	18298.8	18277.0	18277.0	1015.0
2014-11-11 01:00:00	YM	Futures	18279.0	18282.2	18266.6	18274.9	412.0

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

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