PREVIEW / futures_1hour / 2016-01-08

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-01-08.parquet
  size:    46 KB
  rows:    1,326

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-01-08 00:00:00	ES	Futures	2097.81	2100.5	2093.51	2095.93	9496.0
2016-01-08 01:00:00	ES	Futures	2095.93	2100.5	2093.78	2098.89	6824.0
2016-01-08 02:00:00	ES	Futures	2098.89	2105.87	2098.89	2101.57	18453.0
2016-01-08 03:00:00	ES	Futures	2101.3	2106.68	2096.47	2105.6	34714.0
2016-01-08 04:00:00	ES	Futures	2105.34	2106.41	2099.96	2104.26	18542.0
2016-01-08 05:00:00	ES	Futures	2104.26	2104.8	2094.32	2097.54	20820.0
2016-01-08 06:00:00	ES	Futures	2097.27	2097.27	2083.03	2087.87	41521.0
2016-01-08 07:00:00	ES	Futures	2087.87	2096.74	2086.53	2095.12	33955.0
2016-01-08 08:00:00	ES	Futures	2095.12	2111.78	2092.97	2100.23	171122.0
2016-01-08 09:00:00	ES	Futures	2099.96	2102.65	2087.06	2094.86	315552.0
2016-01-08 10:00:00	ES	Futures	2094.86	2095.12	2080.35	2082.76	371071.0
2016-01-08 11:00:00	ES	Futures	2082.76	2086.53	2068.52	2080.61	340329.0
2016-01-08 12:00:00	ES	Futures	2080.61	2088.68	2079.0	2082.49	178807.0
2016-01-08 13:00:00	ES	Futures	2082.76	2085.45	2074.7	2078.2	150320.0
2016-01-08 14:00:00	ES	Futures	2077.93	2082.23	2070.4	2072.28	205995.0
2016-01-08 15:00:00	ES	Futures	2072.28	2075.51	2052.94	2056.97	457988.0
2016-01-08 16:00:00	ES	Futures	2056.97	2061.54	2052.94	2056.43	140976.0
2016-01-08 00:00:00	NQ	Futures	5150.57	5158.29	5139.29	5145.23	2623.0
2016-01-08 01:00:00	NQ	Futures	5145.52	5157.7	5138.99	5153.54	1418.0
2016-01-08 02:00:00	NQ	Futures	5152.95	5173.14	5151.76	5154.73	4444.0
2016-01-08 03:00:00	NQ	Futures	5154.43	5174.62	5141.96	5170.17	6728.0
2016-01-08 04:00:00	NQ	Futures	5169.57	5173.73	5157.1	5168.39	3515.0
2016-01-08 05:00:00	NQ	Futures	5168.39	5169.57	5140.77	5148.79	3358.0
2016-01-08 06:00:00	NQ	Futures	5148.79	5149.38	5117.91	5129.79	6849.0
2016-01-08 07:00:00	NQ	Futures	5129.79	5150.57	5127.11	5146.71	7022.0
2016-01-08 08:00:00	NQ	Futures	5146.71	5190.36	5144.63	5152.35	25972.0
2016-01-08 09:00:00	NQ	Futures	5152.65	5171.95	5132.76	5171.06	67653.0
2016-01-08 10:00:00	NQ	Futures	5170.76	5170.76	5120.28	5125.93	67091.0
2016-01-08 11:00:00	NQ	Futures	5125.93	5136.02	5079.31	5119.69	56811.0
2016-01-08 12:00:00	NQ	Futures	5119.69	5148.49	5117.61	5128.9	40674.0
2016-01-08 13:00:00	NQ	Futures	5128.9	5136.91	5108.7	5119.99	29304.0
2016-01-08 14:00:00	NQ	Futures	5119.99	5126.22	5095.64	5101.58	39683.0
2016-01-08 15:00:00	NQ	Futures	5101.87	5112.56	5055.26	5061.49	64745.0
2016-01-08 16:00:00	NQ	Futures	5061.79	5077.53	5054.66	5065.05	17003.0
2016-01-08 00:00:00	YM	Futures	17638.4	17658.6	17604.3	17621.4	3101.0
2016-01-08 01:00:00	YM	Futures	17623.5	17658.6	17604.3	17643.7	1738.0
2016-01-08 02:00:00	YM	Futures	17646.9	17705.5	17646.9	17665.0	3458.0
2016-01-08 03:00:00	YM	Futures	17665.0	17716.1	17631.0	17704.4	8032.0
2016-01-08 04:00:00	YM	Futures	17703.3	17712.9	17661.8	17690.6	3263.0
2016-01-08 05:00:00	YM	Futures	17690.6	17693.8	17610.7	17637.3	3618.0
2016-01-08 06:00:00	YM	Futures	17635.2	17639.5	17523.4	17561.8	8326.0
2016-01-08 07:00:00	YM	Futures	17561.8	17628.8	17551.1	17616.1	5765.0
2016-01-08 08:00:00	YM	Futures	17615.0	17740.6	17596.9	17651.2	21749.0
2016-01-08 09:00:00	YM	Futures	17651.2	17667.1	17516.0	17596.9	40263.0
2016-01-08 10:00:00	YM	Futures	17594.8	17594.8	17479.8	17496.8	37799.0
2016-01-08 11:00:00	YM	Futures	17497.9	17525.6	17395.7	17504.3	32531.0
2016-01-08 12:00:00	YM	Futures	17505.3	17560.7	17485.1	17516.0	17388.0
2016-01-08 13:00:00	YM	Futures	17516.0	17536.2	17447.9	17471.3	15267.0
2016-01-08 14:00:00	YM	Futures	17472.3	17506.4	17402.1	17423.4	20430.0
2016-01-08 15:00:00	YM	Futures	17422.3	17448.9	17265.8	17298.8	35541.0

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

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