PREVIEW / futures_1hour / 2015-10-13

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-10-13.parquet
  size:    52 KB
  rows:    1,593

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
2015-10-13 00:00:00	ES	Futures	2150.78	2151.05	2147.84	2148.91	3641.0
2015-10-13 01:00:00	ES	Futures	2148.91	2149.98	2148.11	2149.44	2652.0
2015-10-13 02:00:00	ES	Futures	2149.44	2150.78	2147.3	2150.78	6384.0
2015-10-13 03:00:00	ES	Futures	2150.78	2151.32	2142.22	2143.29	29381.0
2015-10-13 04:00:00	ES	Futures	2143.56	2144.36	2137.13	2141.68	29662.0
2015-10-13 05:00:00	ES	Futures	2141.42	2141.68	2137.67	2139.01	20011.0
2015-10-13 06:00:00	ES	Futures	2139.01	2144.63	2138.74	2143.82	20212.0
2015-10-13 07:00:00	ES	Futures	2143.82	2145.16	2140.88	2141.42	25899.0
2015-10-13 08:00:00	ES	Futures	2141.42	2143.82	2137.67	2139.28	39314.0
2015-10-13 09:00:00	ES	Futures	2139.01	2146.77	2137.94	2145.7	212901.0
2015-10-13 10:00:00	ES	Futures	2145.96	2154.53	2144.89	2153.99	242869.0
2015-10-13 11:00:00	ES	Futures	2153.99	2156.4	2148.64	2149.98	172224.0
2015-10-13 12:00:00	ES	Futures	2149.98	2151.58	2143.82	2143.82	100530.0
2015-10-13 13:00:00	ES	Futures	2144.09	2145.43	2140.88	2141.68	123329.0
2015-10-13 14:00:00	ES	Futures	2141.95	2144.63	2139.01	2144.09	103369.0
2015-10-13 15:00:00	ES	Futures	2144.36	2144.36	2133.66	2135.53	256439.0
2015-10-13 16:00:00	ES	Futures	2135.26	2137.94	2131.25	2132.32	87337.0
2015-10-13 18:00:00	ES	Futures	2131.52	2132.32	2130.45	2132.05	6812.0
2015-10-13 19:00:00	ES	Futures	2132.32	2133.39	2131.78	2132.85	3322.0
2015-10-13 20:00:00	ES	Futures	2132.85	2133.66	2130.71	2131.52	6939.0
2015-10-13 21:00:00	ES	Futures	2131.52	2132.32	2129.37	2130.45	10495.0
2015-10-13 22:00:00	ES	Futures	2130.45	2133.92	2129.91	2133.39	5134.0
2015-10-13 23:00:00	ES	Futures	2133.12	2136.06	2133.12	2134.19	6209.0
2015-10-13 00:00:00	NQ	Futures	5182.37	5182.66	5176.14	5178.51	729.0
2015-10-13 01:00:00	NQ	Futures	5179.11	5182.07	5177.62	5180.88	465.0
2015-10-13 02:00:00	NQ	Futures	5180.29	5183.55	5175.55	5183.55	988.0
2015-10-13 03:00:00	NQ	Futures	5183.55	5185.33	5159.24	5162.21	4635.0
2015-10-13 04:00:00	NQ	Futures	5162.21	5164.58	5146.19	5156.57	4404.0
2015-10-13 05:00:00	NQ	Futures	5155.68	5156.87	5148.27	5151.83	2233.0
2015-10-13 06:00:00	NQ	Futures	5151.24	5163.98	5150.64	5161.32	2035.0
2015-10-13 07:00:00	NQ	Futures	5161.61	5165.76	5154.2	5155.98	2472.0
2015-10-13 08:00:00	NQ	Futures	5156.28	5161.32	5148.86	5153.01	7360.0
2015-10-13 09:00:00	NQ	Futures	5153.01	5177.33	5150.05	5173.77	33225.0
2015-10-13 10:00:00	NQ	Futures	5173.77	5204.01	5169.91	5202.53	41355.0
2015-10-13 11:00:00	NQ	Futures	5202.53	5207.27	5184.44	5188.3	26420.0
2015-10-13 12:00:00	NQ	Futures	5188.3	5194.23	5173.77	5174.06	17148.0
2015-10-13 13:00:00	NQ	Futures	5174.36	5178.81	5163.69	5169.32	20072.0
2015-10-13 14:00:00	NQ	Futures	5169.32	5176.44	5158.35	5175.84	18233.0
2015-10-13 15:00:00	NQ	Futures	5175.84	5175.84	5145.9	5150.94	36449.0
2015-10-13 16:00:00	NQ	Futures	5150.94	5158.65	5145.31	5147.08	8381.0
2015-10-13 18:00:00	NQ	Futures	5140.26	5142.64	5137.6	5142.34	960.0
2015-10-13 19:00:00	NQ	Futures	5142.04	5144.71	5140.56	5144.12	571.0
2015-10-13 20:00:00	NQ	Futures	5143.53	5145.9	5134.04	5135.52	1712.0
2015-10-13 21:00:00	NQ	Futures	5136.41	5138.19	5130.18	5132.85	1541.0
2015-10-13 22:00:00	NQ	Futures	5132.85	5142.93	5132.26	5141.15	1101.0
2015-10-13 23:00:00	NQ	Futures	5141.45	5147.68	5141.45	5142.93	1312.0
2015-10-13 00:00:00	YM	Futures	18039.1	18040.1	18017.9	18027.4	518.0
2015-10-13 01:00:00	YM	Futures	18026.4	18037.0	18022.1	18030.6	359.0
2015-10-13 02:00:00	YM	Futures	18028.5	18038.0	18016.8	18038.0	638.0
2015-10-13 03:00:00	YM	Futures	18039.1	18043.3	17972.4	17984.0	3809.0

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

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