PREVIEW / futures_1hour / 2016-03-02

all futures 1-hour files

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

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-02 00:00:00	ES	Futures	2128.71	2133.01	2128.18	2130.33	9191.0
2016-03-02 01:00:00	ES	Futures	2130.59	2132.21	2130.06	2131.13	6042.0
2016-03-02 02:00:00	ES	Futures	2131.13	2131.13	2124.68	2126.29	18579.0
2016-03-02 03:00:00	ES	Futures	2126.29	2128.44	2121.46	2127.1	41925.0
2016-03-02 04:00:00	ES	Futures	2127.1	2127.37	2120.38	2120.65	31867.0
2016-03-02 05:00:00	ES	Futures	2120.65	2122.26	2119.31	2119.58	22150.0
2016-03-02 06:00:00	ES	Futures	2119.58	2122.53	2118.77	2121.46	18446.0
2016-03-02 07:00:00	ES	Futures	2121.73	2123.88	2119.04	2122.26	25458.0
2016-03-02 08:00:00	ES	Futures	2122.26	2124.14	2118.77	2119.85	47519.0
2016-03-02 09:00:00	ES	Futures	2119.58	2122.53	2115.55	2117.96	288522.0
2016-03-02 10:00:00	ES	Futures	2117.96	2124.41	2113.4	2122.0	330951.0
2016-03-02 11:00:00	ES	Futures	2122.0	2126.83	2118.23	2118.77	255496.0
2016-03-02 12:00:00	ES	Futures	2118.5	2123.61	2116.62	2122.8	119052.0
2016-03-02 13:00:00	ES	Futures	2123.07	2126.29	2121.19	2121.19	106609.0
2016-03-02 14:00:00	ES	Futures	2121.46	2128.44	2118.77	2126.29	144547.0
2016-03-02 15:00:00	ES	Futures	2126.56	2133.01	2123.07	2132.21	212043.0
2016-03-02 16:00:00	ES	Futures	2132.47	2133.28	2129.79	2130.59	64069.0
2016-03-02 18:00:00	ES	Futures	2130.06	2130.33	2126.56	2127.64	7128.0
2016-03-02 19:00:00	ES	Futures	2127.64	2130.59	2127.37	2130.59	9538.0
2016-03-02 20:00:00	ES	Futures	2130.33	2134.62	2129.52	2134.09	10894.0
2016-03-02 21:00:00	ES	Futures	2133.82	2134.09	2128.44	2129.79	10735.0
2016-03-02 22:00:00	ES	Futures	2129.52	2133.82	2129.25	2133.28	6112.0
2016-03-02 23:00:00	ES	Futures	2133.55	2135.16	2132.47	2134.89	5169.0
2016-03-02 00:00:00	NQ	Futures	5165.42	5175.81	5164.23	5170.76	1380.0
2016-03-02 01:00:00	NQ	Futures	5170.76	5174.62	5168.98	5172.84	1016.0
2016-03-02 02:00:00	NQ	Futures	5172.84	5172.84	5151.76	5156.81	2302.0
2016-03-02 03:00:00	NQ	Futures	5156.51	5166.01	5144.63	5162.15	4473.0
2016-03-02 04:00:00	NQ	Futures	5161.85	5163.04	5144.63	5144.93	2897.0
2016-03-02 05:00:00	NQ	Futures	5145.23	5149.98	5140.77	5141.66	1723.0
2016-03-02 06:00:00	NQ	Futures	5141.66	5148.2	5138.4	5146.12	2471.0
2016-03-02 07:00:00	NQ	Futures	5146.41	5150.87	5139.29	5146.12	2724.0
2016-03-02 08:00:00	NQ	Futures	5145.82	5152.65	5137.51	5139.88	6011.0
2016-03-02 09:00:00	NQ	Futures	5139.58	5146.12	5119.99	5129.19	44948.0
2016-03-02 10:00:00	NQ	Futures	5129.19	5147.6	5116.72	5133.65	53849.0
2016-03-02 11:00:00	NQ	Futures	5133.05	5142.26	5109.89	5110.78	36925.0
2016-03-02 12:00:00	NQ	Futures	5110.78	5122.66	5106.63	5121.17	18865.0
2016-03-02 13:00:00	NQ	Futures	5121.47	5128.6	5113.75	5114.05	16956.0
2016-03-02 14:00:00	NQ	Futures	5114.05	5136.62	5106.33	5130.08	22499.0
2016-03-02 15:00:00	NQ	Futures	5130.38	5146.71	5119.39	5145.52	32247.0
2016-03-02 16:00:00	NQ	Futures	5145.82	5148.49	5137.21	5139.29	6616.0
2016-03-02 18:00:00	NQ	Futures	5138.99	5139.88	5128.0	5130.97	925.0
2016-03-02 19:00:00	NQ	Futures	5130.68	5143.74	5130.38	5143.74	1445.0
2016-03-02 20:00:00	NQ	Futures	5142.85	5153.54	5140.77	5152.35	1193.0
2016-03-02 21:00:00	NQ	Futures	5152.06	5152.95	5137.8	5140.77	1291.0
2016-03-02 22:00:00	NQ	Futures	5140.77	5152.35	5139.58	5151.16	807.0
2016-03-02 23:00:00	NQ	Futures	5150.87	5155.62	5148.79	5155.03	563.0
2016-03-02 00:00:00	YM	Futures	17964.1	17995.0	17960.9	17979.0	2072.0
2016-03-02 01:00:00	YM	Futures	17978.0	17997.1	17975.8	17989.7	1301.0
2016-03-02 02:00:00	YM	Futures	17990.7	17990.7	17931.1	17949.2	2296.0
2016-03-02 03:00:00	YM	Futures	17948.2	17959.9	17903.5	17950.3	5229.0

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

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