PREVIEW / futures_1hour / 2016-02-22

all futures 1-hour files

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

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-02-22 00:00:00	ES	Futures	2069.87	2070.4	2067.98	2068.79	5397.0
2016-02-22 01:00:00	ES	Futures	2068.52	2069.33	2067.18	2067.45	3658.0
2016-02-22 02:00:00	ES	Futures	2067.45	2076.58	2067.18	2076.58	28516.0
2016-02-22 03:00:00	ES	Futures	2076.31	2081.15	2075.24	2075.78	48066.0
2016-02-22 04:00:00	ES	Futures	2076.05	2083.84	2074.7	2083.03	36034.0
2016-02-22 05:00:00	ES	Futures	2083.3	2083.84	2079.81	2081.15	13924.0
2016-02-22 06:00:00	ES	Futures	2080.88	2083.03	2080.08	2081.42	14889.0
2016-02-22 07:00:00	ES	Futures	2081.42	2081.42	2077.12	2079.27	26647.0
2016-02-22 08:00:00	ES	Futures	2079.0	2081.69	2078.2	2081.15	38839.0
2016-02-22 09:00:00	ES	Futures	2081.15	2085.72	2076.58	2084.64	213478.0
2016-02-22 10:00:00	ES	Futures	2084.38	2088.41	2081.69	2082.76	221977.0
2016-02-22 11:00:00	ES	Futures	2082.76	2085.18	2080.61	2084.38	132295.0
2016-02-22 12:00:00	ES	Futures	2084.64	2086.53	2081.69	2082.23	82235.0
2016-02-22 13:00:00	ES	Futures	2082.49	2089.21	2081.96	2088.14	96597.0
2016-02-22 14:00:00	ES	Futures	2088.14	2088.41	2082.23	2084.11	100095.0
2016-02-22 15:00:00	ES	Futures	2084.11	2087.6	2080.88	2087.06	197105.0
2016-02-22 16:00:00	ES	Futures	2087.06	2087.33	2077.66	2078.2	83222.0
2016-02-22 18:00:00	ES	Futures	2078.73	2080.35	2077.39	2077.93	8413.0
2016-02-22 19:00:00	ES	Futures	2078.2	2080.08	2076.85	2077.39	8799.0
2016-02-22 20:00:00	ES	Futures	2077.39	2077.66	2072.55	2073.63	16059.0
2016-02-22 21:00:00	ES	Futures	2073.36	2075.24	2072.82	2074.97	7648.0
2016-02-22 22:00:00	ES	Futures	2074.97	2074.97	2070.67	2071.75	9571.0
2016-02-22 23:00:00	ES	Futures	2071.75	2073.63	2070.94	2072.82	6418.0
2016-02-22 00:00:00	NQ	Futures	4974.79	4975.98	4970.04	4972.12	642.0
2016-02-22 01:00:00	NQ	Futures	4971.52	4973.6	4968.55	4968.85	592.0
2016-02-22 02:00:00	NQ	Futures	4968.85	4992.31	4968.26	4991.71	3075.0
2016-02-22 03:00:00	NQ	Futures	4992.31	5006.86	4989.63	4992.01	5206.0
2016-02-22 04:00:00	NQ	Futures	4992.9	5012.2	4989.63	5010.72	4120.0
2016-02-22 05:00:00	NQ	Futures	5011.01	5011.9	5000.92	5003.29	1459.0
2016-02-22 06:00:00	NQ	Futures	5003.29	5008.04	5000.32	5003.89	1678.0
2016-02-22 07:00:00	NQ	Futures	5003.59	5003.89	4994.09	4998.25	3455.0
2016-02-22 08:00:00	NQ	Futures	4998.54	5003.89	4992.31	4995.87	5033.0
2016-02-22 09:00:00	NQ	Futures	4995.87	5013.69	4984.59	5011.61	33295.0
2016-02-22 10:00:00	NQ	Futures	5011.31	5020.81	4996.17	5001.81	29875.0
2016-02-22 11:00:00	NQ	Futures	5001.81	5019.62	4997.65	5018.73	19726.0
2016-02-22 12:00:00	NQ	Futures	5018.73	5024.67	5008.93	5010.72	13500.0
2016-02-22 13:00:00	NQ	Futures	5011.01	5028.83	5010.12	5024.38	11971.0
2016-02-22 14:00:00	NQ	Futures	5024.38	5025.86	5011.01	5014.58	11278.0
2016-02-22 15:00:00	NQ	Futures	5014.58	5024.08	5003.89	5022.89	24847.0
2016-02-22 16:00:00	NQ	Futures	5022.89	5024.08	4997.06	4997.06	8357.0
2016-02-22 18:00:00	NQ	Futures	4997.06	5004.48	4996.46	4998.84	1170.0
2016-02-22 19:00:00	NQ	Futures	4999.14	5004.78	4995.28	4997.06	1232.0
2016-02-22 20:00:00	NQ	Futures	4997.06	4997.35	4981.32	4983.1	1993.0
2016-02-22 21:00:00	NQ	Futures	4982.21	4987.85	4981.32	4986.96	833.0
2016-02-22 22:00:00	NQ	Futures	4986.07	4986.37	4974.19	4976.87	1731.0
2016-02-22 23:00:00	NQ	Futures	4976.87	4983.1	4975.08	4979.24	1042.0
2016-02-22 00:00:00	YM	Futures	17516.0	17517.1	17499.0	17504.3	785.0
2016-02-22 01:00:00	YM	Futures	17503.2	17509.6	17494.7	17496.8	627.0
2016-02-22 02:00:00	YM	Futures	17495.8	17565.0	17492.6	17565.0	3552.0
2016-02-22 03:00:00	YM	Futures	17566.0	17612.9	17557.5	17572.4	6044.0

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

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