PREVIEW / futures_1hour / 2015-09-03

all futures 1-hour files

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

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-03 00:00:00	ES	Futures	2073.81	2075.14	2072.74	2074.07	3131.0
2015-09-03 01:00:00	ES	Futures	2074.34	2076.47	2071.68	2073.01	6555.0
2015-09-03 02:00:00	ES	Futures	2072.74	2076.74	2071.68	2074.61	11553.0
2015-09-03 03:00:00	ES	Futures	2074.61	2083.39	2072.74	2081.53	28402.0
2015-09-03 04:00:00	ES	Futures	2081.53	2083.13	2079.13	2082.59	16065.0
2015-09-03 05:00:00	ES	Futures	2082.86	2085.79	2079.4	2081.0	16513.0
2015-09-03 06:00:00	ES	Futures	2081.0	2083.93	2079.93	2081.0	15875.0
2015-09-03 07:00:00	ES	Futures	2081.0	2083.39	2077.54	2081.26	28896.0
2015-09-03 08:00:00	ES	Futures	2081.26	2096.71	2080.2	2083.66	115974.0
2015-09-03 09:00:00	ES	Futures	2083.66	2091.11	2078.33	2087.12	218113.0
2015-09-03 10:00:00	ES	Futures	2087.39	2100.17	2083.66	2099.9	291568.0
2015-09-03 11:00:00	ES	Futures	2099.9	2101.76	2088.45	2091.11	240565.0
2015-09-03 12:00:00	ES	Futures	2091.11	2092.45	2082.59	2084.72	164978.0
2015-09-03 13:00:00	ES	Futures	2084.72	2084.99	2073.81	2073.81	217749.0
2015-09-03 14:00:00	ES	Futures	2074.07	2084.46	2071.41	2079.67	209304.0
2015-09-03 15:00:00	ES	Futures	2079.93	2082.33	2068.22	2074.34	343805.0
2015-09-03 16:00:00	ES	Futures	2074.61	2076.47	2071.94	2073.28	57895.0
2015-09-03 17:00:00	ES	Futures	2073.28	2073.54	2072.74	2073.28	912.0
2015-09-03 18:00:00	ES	Futures	2073.81	2075.94	2072.48	2075.41	2541.0
2015-09-03 19:00:00	ES	Futures	2075.41	2075.67	2074.61	2075.41	2036.0
2015-09-03 20:00:00	ES	Futures	2075.14	2075.41	2053.31	2062.36	24230.0
2015-09-03 21:00:00	ES	Futures	2062.36	2072.48	2061.83	2067.95	15679.0
2015-09-03 22:00:00	ES	Futures	2067.95	2067.95	2063.16	2063.96	7878.0
2015-09-03 23:00:00	ES	Futures	2063.69	2065.02	2058.1	2059.16	10817.0
2015-09-03 00:00:00	NQ	Futures	5039.66	5044.39	5039.07	5042.91	947.0
2015-09-03 01:00:00	NQ	Futures	5042.62	5050.9	5038.48	5041.73	1933.0
2015-09-03 02:00:00	NQ	Futures	5041.14	5052.08	5037.0	5046.46	1486.0
2015-09-03 03:00:00	NQ	Futures	5046.46	5071.01	5042.32	5066.87	3587.0
2015-09-03 04:00:00	NQ	Futures	5066.58	5071.01	5057.41	5066.28	2559.0
2015-09-03 05:00:00	NQ	Futures	5066.58	5075.45	5056.22	5060.66	2734.0
2015-09-03 06:00:00	NQ	Futures	5060.66	5065.69	5055.63	5058.29	2631.0
2015-09-03 07:00:00	NQ	Futures	5058.29	5063.03	5049.42	5059.77	3778.0
2015-09-03 08:00:00	NQ	Futures	5059.77	5092.61	5056.22	5060.96	18343.0
2015-09-03 09:00:00	NQ	Futures	5061.25	5072.2	5037.0	5047.05	41715.0
2015-09-03 10:00:00	NQ	Futures	5046.76	5080.48	5037.89	5079.3	41283.0
2015-09-03 11:00:00	NQ	Futures	5079.59	5086.69	5048.24	5057.11	32412.0
2015-09-03 12:00:00	NQ	Futures	5056.82	5060.07	5032.86	5039.07	24109.0
2015-09-03 13:00:00	NQ	Futures	5039.07	5039.96	5006.53	5007.12	34810.0
2015-09-03 14:00:00	NQ	Futures	5007.12	5038.77	5000.02	5025.46	36162.0
2015-09-03 15:00:00	NQ	Futures	5025.76	5033.45	4992.63	5006.83	57727.0
2015-09-03 16:00:00	NQ	Futures	5007.12	5013.04	5001.5	5006.53	7665.0
2015-09-03 17:00:00	NQ	Futures	5006.24	5006.53	5005.35	5005.35	129.0
2015-09-03 18:00:00	NQ	Futures	5006.83	5013.63	5005.05	5010.97	366.0
2015-09-03 19:00:00	NQ	Futures	5010.67	5012.74	5008.6	5011.86	270.0
2015-09-03 20:00:00	NQ	Futures	5011.86	5012.15	4945.6	4977.25	6793.0
2015-09-03 21:00:00	NQ	Futures	4976.07	5003.28	4974.29	4991.74	4577.0
2015-09-03 22:00:00	NQ	Futures	4990.56	4990.56	4980.8	4981.69	1127.0
2015-09-03 23:00:00	NQ	Futures	4981.98	4984.35	4965.12	4967.78	2184.0
2015-09-03 00:00:00	YM	Futures	17206.2	17218.8	17197.7	17207.2	709.0
2015-09-03 01:00:00	YM	Futures	17206.2	17228.3	17187.2	17204.1	1698.0

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

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