PREVIEW / futures_1hour / 2015-09-17

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-09-17.parquet
  size:    51 KB
  rows:    1,568

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-09-17 00:00:00	ES	Futures	2124.29	2125.63	2124.02	2125.09	1545.0
2015-09-17 01:00:00	ES	Futures	2125.36	2126.7	2124.56	2125.36	3346.0
2015-09-17 02:00:00	ES	Futures	2125.63	2127.5	2122.42	2124.02	9403.0
2015-09-17 03:00:00	ES	Futures	2124.02	2124.83	2121.08	2122.42	20989.0
2015-09-17 04:00:00	ES	Futures	2122.15	2125.36	2120.28	2123.22	16207.0
2015-09-17 05:00:00	ES	Futures	2123.22	2124.83	2120.54	2121.88	9228.0
2015-09-17 06:00:00	ES	Futures	2121.88	2126.16	2121.62	2124.29	14076.0
2015-09-17 07:00:00	ES	Futures	2124.56	2125.63	2120.81	2121.35	18310.0
2015-09-17 08:00:00	ES	Futures	2121.35	2122.42	2119.47	2121.88	24166.0
2015-09-17 09:00:00	ES	Futures	2121.88	2124.83	2119.74	2123.22	144351.0
2015-09-17 10:00:00	ES	Futures	2122.95	2126.43	2121.35	2125.09	131013.0
2015-09-17 11:00:00	ES	Futures	2124.83	2127.77	2124.29	2125.36	106581.0
2015-09-17 12:00:00	ES	Futures	2125.63	2130.45	2124.29	2129.11	89192.0
2015-09-17 13:00:00	ES	Futures	2129.37	2134.19	2127.5	2130.98	119507.0
2015-09-17 14:00:00	ES	Futures	2130.98	2153.19	2114.93	2145.96	618792.0
2015-09-17 15:00:00	ES	Futures	2145.96	2148.64	2114.39	2118.94	595744.0
2015-09-17 16:00:00	ES	Futures	2118.94	2120.01	2110.64	2115.73	120722.0
2015-09-17 17:00:00	ES	Futures	2115.46	2117.07	2115.46	2116.8	1899.0
2015-09-17 18:00:00	ES	Futures	2115.46	2118.67	2113.32	2117.87	9558.0
2015-09-17 19:00:00	ES	Futures	2117.87	2118.14	2114.93	2115.46	5360.0
2015-09-17 20:00:00	ES	Futures	2115.46	2116.26	2111.45	2115.19	16119.0
2015-09-17 21:00:00	ES	Futures	2115.19	2118.4	2114.39	2117.6	11126.0
2015-09-17 22:00:00	ES	Futures	2117.87	2121.08	2115.73	2119.74	10661.0
2015-09-17 23:00:00	ES	Futures	2119.74	2121.88	2119.47	2120.28	4919.0
2015-09-17 00:00:00	NQ	Futures	5191.56	5194.82	5191.26	5193.93	304.0
2015-09-17 01:00:00	NQ	Futures	5194.23	5198.08	5190.96	5194.82	750.0
2015-09-17 02:00:00	NQ	Futures	5194.52	5197.78	5185.92	5189.78	954.0
2015-09-17 03:00:00	NQ	Futures	5189.48	5193.93	5182.07	5188.0	2545.0
2015-09-17 04:00:00	NQ	Futures	5188.0	5193.93	5182.96	5188.3	1920.0
2015-09-17 05:00:00	NQ	Futures	5188.89	5193.63	5182.96	5185.04	1326.0
2015-09-17 06:00:00	NQ	Futures	5184.74	5195.12	5183.85	5190.37	1762.0
2015-09-17 07:00:00	NQ	Futures	5190.37	5192.45	5182.96	5183.55	2150.0
2015-09-17 08:00:00	NQ	Futures	5183.85	5187.7	5178.81	5184.44	3402.0
2015-09-17 09:00:00	NQ	Futures	5184.44	5189.48	5175.84	5184.44	24551.0
2015-09-17 10:00:00	NQ	Futures	5182.96	5195.12	5180.29	5191.85	18820.0
2015-09-17 11:00:00	NQ	Futures	5191.85	5198.38	5186.22	5190.37	14684.0
2015-09-17 12:00:00	NQ	Futures	5190.37	5202.53	5187.11	5198.97	12454.0
2015-09-17 13:00:00	NQ	Futures	5199.27	5211.13	5194.52	5200.75	16207.0
2015-09-17 14:00:00	NQ	Futures	5201.05	5267.76	5167.25	5251.75	104288.0
2015-09-17 15:00:00	NQ	Futures	5251.75	5260.64	5178.22	5188.3	86480.0
2015-09-17 16:00:00	NQ	Futures	5188.59	5192.15	5167.25	5180.59	13420.0
2015-09-17 17:00:00	NQ	Futures	5180.88	5186.22	5180.88	5184.15	127.0
2015-09-17 18:00:00	NQ	Futures	5183.85	5190.67	5176.14	5188.59	1007.0
2015-09-17 19:00:00	NQ	Futures	5188.0	5188.59	5179.99	5182.66	449.0
2015-09-17 20:00:00	NQ	Futures	5182.66	5184.15	5171.69	5180.88	2138.0
2015-09-17 21:00:00	NQ	Futures	5180.59	5190.08	5178.22	5188.3	1450.0
2015-09-17 22:00:00	NQ	Futures	5187.7	5195.71	5184.44	5191.56	1245.0
2015-09-17 23:00:00	NQ	Futures	5192.45	5196.89	5191.56	5193.63	1038.0
2015-09-17 00:00:00	YM	Futures	17628.1	17639.7	17628.1	17637.6	210.0
2015-09-17 01:00:00	YM	Futures	17637.6	17652.5	17632.3	17639.7	553.0

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

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