PREVIEW / futures_1hour / 2015-09-08

all futures 1-hour files

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

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-08 00:00:00	ES	Futures	2058.63	2062.63	2057.03	2061.56	3784.0
2015-09-08 01:00:00	ES	Futures	2061.56	2065.02	2061.03	2063.42	7325.0
2015-09-08 02:00:00	ES	Futures	2063.16	2072.48	2058.37	2072.21	24679.0
2015-09-08 03:00:00	ES	Futures	2072.21	2083.66	2070.88	2081.0	48061.0
2015-09-08 04:00:00	ES	Futures	2081.26	2084.19	2079.4	2082.86	19420.0
2015-09-08 05:00:00	ES	Futures	2083.13	2088.45	2082.59	2086.85	25255.0
2015-09-08 06:00:00	ES	Futures	2086.59	2088.45	2085.52	2086.32	24000.0
2015-09-08 07:00:00	ES	Futures	2086.32	2086.32	2079.13	2081.0	29970.0
2015-09-08 08:00:00	ES	Futures	2081.0	2083.13	2076.74	2080.2	39708.0
2015-09-08 09:00:00	ES	Futures	2080.2	2086.59	2077.54	2078.6	228415.0
2015-09-08 10:00:00	ES	Futures	2078.87	2079.67	2070.35	2076.2	253514.0
2015-09-08 11:00:00	ES	Futures	2075.94	2078.07	2071.94	2073.28	138644.0
2015-09-08 12:00:00	ES	Futures	2073.54	2083.39	2071.94	2077.54	112700.0
2015-09-08 13:00:00	ES	Futures	2077.54	2083.13	2074.07	2082.86	91831.0
2015-09-08 14:00:00	ES	Futures	2083.13	2091.65	2081.53	2089.78	169381.0
2015-09-08 15:00:00	ES	Futures	2089.78	2096.71	2087.12	2095.64	237298.0
2015-09-08 16:00:00	ES	Futures	2095.64	2095.91	2090.85	2093.51	81914.0
2015-09-08 17:00:00	ES	Futures	2093.24	2094.31	2092.71	2093.78	1597.0
2015-09-08 18:00:00	ES	Futures	2094.31	2094.58	2091.65	2092.45	3180.0
2015-09-08 19:00:00	ES	Futures	2092.45	2095.91	2091.91	2095.64	3220.0
2015-09-08 20:00:00	ES	Futures	2095.37	2099.63	2094.31	2099.37	10860.0
2015-09-08 21:00:00	ES	Futures	2099.1	2105.76	2096.44	2102.56	15667.0
2015-09-08 22:00:00	ES	Futures	2102.56	2108.15	2101.5	2107.09	15113.0
2015-09-08 23:00:00	ES	Futures	2106.82	2109.49	2104.69	2108.15	7477.0
2015-09-08 00:00:00	NQ	Futures	4983.46	4991.15	4979.32	4988.19	1392.0
2015-09-08 01:00:00	NQ	Futures	4988.49	4997.95	4987.9	4995.88	1343.0
2015-09-08 02:00:00	NQ	Futures	4994.7	5017.18	4983.16	5016.59	3020.0
2015-09-08 03:00:00	NQ	Futures	5016.88	5051.79	5015.41	5043.8	7181.0
2015-09-08 04:00:00	NQ	Futures	5043.8	5052.08	5039.96	5050.01	2967.0
2015-09-08 05:00:00	NQ	Futures	5050.9	5062.73	5049.72	5058.89	3238.0
2015-09-08 06:00:00	NQ	Futures	5059.48	5062.73	5052.08	5057.11	4138.0
2015-09-08 07:00:00	NQ	Futures	5056.52	5057.11	5040.55	5044.39	3355.0
2015-09-08 08:00:00	NQ	Futures	5044.69	5047.05	5033.45	5039.07	5364.0
2015-09-08 09:00:00	NQ	Futures	5038.77	5077.52	5037.89	5059.77	41134.0
2015-09-08 10:00:00	NQ	Futures	5059.77	5062.73	5029.6	5045.58	37685.0
2015-09-08 11:00:00	NQ	Futures	5045.87	5050.31	5031.67	5034.04	19947.0
2015-09-08 12:00:00	NQ	Futures	5033.74	5057.41	5029.31	5039.07	18159.0
2015-09-08 13:00:00	NQ	Futures	5039.07	5051.79	5021.91	5051.49	18885.0
2015-09-08 14:00:00	NQ	Futures	5051.2	5076.63	5048.83	5069.24	24029.0
2015-09-08 15:00:00	NQ	Futures	5069.24	5094.09	5063.91	5087.87	36162.0
2015-09-08 16:00:00	NQ	Futures	5088.17	5091.13	5079.59	5086.99	8947.0
2015-09-08 17:00:00	NQ	Futures	5086.99	5089.35	5086.39	5089.35	197.0
2015-09-08 18:00:00	NQ	Futures	5088.17	5089.65	5080.77	5081.37	934.0
2015-09-08 19:00:00	NQ	Futures	5081.66	5089.65	5080.48	5089.06	322.0
2015-09-08 20:00:00	NQ	Futures	5089.06	5105.03	5087.28	5103.85	1634.0
2015-09-08 21:00:00	NQ	Futures	5103.55	5118.64	5096.45	5113.31	2759.0
2015-09-08 22:00:00	NQ	Futures	5113.31	5127.21	5111.24	5125.44	2963.0
2015-09-08 23:00:00	NQ	Futures	5126.03	5132.24	5120.11	5129.88	1654.0
2015-09-08 00:00:00	YM	Futures	17062.9	17089.2	17054.5	17085.0	763.0
2015-09-08 01:00:00	YM	Futures	17086.1	17106.1	17075.5	17094.5	1440.0

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

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