PREVIEW / futures_1hour / 2016-03-03

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-03-03.parquet
  size:    52 KB
  rows:    1,580

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
2016-03-03 00:00:00	ES	Futures	2134.89	2135.7	2133.55	2135.16	6321.0
2016-03-03 01:00:00	ES	Futures	2135.43	2136.51	2132.47	2133.28	6361.0
2016-03-03 02:00:00	ES	Futures	2133.28	2133.55	2129.52	2131.94	13467.0
2016-03-03 03:00:00	ES	Futures	2131.94	2132.74	2126.56	2128.71	27473.0
2016-03-03 04:00:00	ES	Futures	2128.98	2134.36	2128.98	2133.28	18872.0
2016-03-03 05:00:00	ES	Futures	2133.55	2134.89	2131.94	2134.89	16298.0
2016-03-03 06:00:00	ES	Futures	2134.62	2135.16	2130.59	2131.67	17241.0
2016-03-03 07:00:00	ES	Futures	2131.4	2131.94	2128.71	2130.59	19165.0
2016-03-03 08:00:00	ES	Futures	2130.59	2131.67	2128.44	2130.33	26035.0
2016-03-03 09:00:00	ES	Futures	2130.33	2130.86	2123.61	2125.76	162713.0
2016-03-03 10:00:00	ES	Futures	2125.76	2132.21	2122.53	2130.33	268950.0
2016-03-03 11:00:00	ES	Futures	2130.33	2131.4	2122.53	2126.56	225260.0
2016-03-03 12:00:00	ES	Futures	2126.56	2128.98	2124.14	2128.71	114219.0
2016-03-03 13:00:00	ES	Futures	2128.44	2134.89	2128.44	2134.09	115713.0
2016-03-03 14:00:00	ES	Futures	2133.82	2137.58	2131.67	2135.97	137469.0
2016-03-03 15:00:00	ES	Futures	2136.24	2140.8	2134.36	2140.54	225637.0
2016-03-03 16:00:00	ES	Futures	2140.54	2141.61	2138.39	2140.54	62591.0
2016-03-03 18:00:00	ES	Futures	2140.0	2140.27	2138.12	2138.92	7328.0
2016-03-03 19:00:00	ES	Futures	2138.92	2139.73	2138.12	2139.46	4903.0
2016-03-03 20:00:00	ES	Futures	2139.19	2140.54	2138.39	2138.92	6398.0
2016-03-03 21:00:00	ES	Futures	2138.92	2141.34	2138.66	2140.8	4623.0
2016-03-03 22:00:00	ES	Futures	2140.54	2142.15	2140.27	2140.54	5045.0
2016-03-03 23:00:00	ES	Futures	2140.8	2141.07	2139.19	2140.27	3590.0
2016-03-03 00:00:00	NQ	Futures	5155.03	5158.89	5153.84	5157.7	1342.0
2016-03-03 01:00:00	NQ	Futures	5157.99	5160.07	5150.27	5152.65	1016.0
2016-03-03 02:00:00	NQ	Futures	5152.95	5152.95	5141.66	5148.49	1472.0
2016-03-03 03:00:00	NQ	Futures	5148.49	5150.27	5132.16	5138.1	2915.0
2016-03-03 04:00:00	NQ	Futures	5138.4	5154.43	5138.1	5151.16	2068.0
2016-03-03 05:00:00	NQ	Futures	5151.16	5155.03	5147.3	5154.43	1323.0
2016-03-03 06:00:00	NQ	Futures	5154.73	5155.92	5138.99	5141.96	2396.0
2016-03-03 07:00:00	NQ	Futures	5141.96	5144.93	5136.02	5142.26	1906.0
2016-03-03 08:00:00	NQ	Futures	5141.66	5144.34	5137.21	5142.26	2884.0
2016-03-03 09:00:00	NQ	Futures	5142.55	5143.74	5121.17	5125.33	26009.0
2016-03-03 10:00:00	NQ	Futures	5125.63	5131.86	5110.49	5123.85	37781.0
2016-03-03 11:00:00	NQ	Futures	5123.85	5126.22	5099.5	5112.27	30660.0
2016-03-03 12:00:00	NQ	Futures	5112.27	5117.61	5106.33	5113.45	16192.0
2016-03-03 13:00:00	NQ	Futures	5113.16	5131.86	5112.86	5130.08	18718.0
2016-03-03 14:00:00	NQ	Futures	5130.38	5134.83	5122.66	5130.68	15907.0
2016-03-03 15:00:00	NQ	Futures	5130.97	5137.21	5123.25	5136.91	25928.0
2016-03-03 16:00:00	NQ	Futures	5136.91	5137.51	5128.3	5135.72	5946.0
2016-03-03 18:00:00	NQ	Futures	5134.54	5134.54	5129.49	5130.08	481.0
2016-03-03 19:00:00	NQ	Futures	5130.08	5132.46	5128.6	5132.16	547.0
2016-03-03 20:00:00	NQ	Futures	5131.57	5135.72	5129.79	5130.97	1108.0
2016-03-03 21:00:00	NQ	Futures	5130.68	5138.1	5129.79	5136.91	478.0
2016-03-03 22:00:00	NQ	Futures	5136.91	5141.37	5136.02	5137.21	648.0
2016-03-03 23:00:00	NQ	Futures	5136.91	5137.8	5132.46	5135.72	394.0
2016-03-03 00:00:00	YM	Futures	17981.2	17989.7	17971.6	17983.3	914.0
2016-03-03 01:00:00	YM	Futures	17984.4	17993.9	17963.1	17968.4	957.0
2016-03-03 02:00:00	YM	Futures	17969.5	17970.5	17940.7	17958.8	1211.0
2016-03-03 03:00:00	YM	Futures	17957.7	17965.2	17919.4	17937.5	4481.0

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

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