PREVIEW / futures_1hour / 2016-01-27

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-01-27.parquet
  size:    54 KB
  rows:    1,611

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-27 00:00:00	ES	Futures	2023.38	2030.1	2019.62	2027.41	13984.0
2016-01-27 01:00:00	ES	Futures	2027.41	2031.17	2026.07	2030.1	8085.0
2016-01-27 02:00:00	ES	Futures	2029.83	2031.44	2023.92	2026.87	16467.0
2016-01-27 03:00:00	ES	Futures	2027.14	2031.17	2020.42	2024.45	39254.0
2016-01-27 04:00:00	ES	Futures	2024.45	2027.68	2020.69	2022.84	20912.0
2016-01-27 05:00:00	ES	Futures	2023.11	2029.02	2020.96	2026.87	19035.0
2016-01-27 06:00:00	ES	Futures	2026.6	2028.22	2022.04	2024.72	18555.0
2016-01-27 07:00:00	ES	Futures	2024.99	2030.1	2023.65	2029.29	22129.0
2016-01-27 08:00:00	ES	Futures	2029.29	2034.93	2027.14	2033.05	50099.0
2016-01-27 09:00:00	ES	Futures	2033.32	2036.01	2028.75	2031.71	178877.0
2016-01-27 10:00:00	ES	Futures	2031.44	2032.78	2020.42	2027.68	288255.0
2016-01-27 11:00:00	ES	Futures	2027.68	2049.44	2025.26	2047.03	226231.0
2016-01-27 12:00:00	ES	Futures	2046.76	2052.94	2044.07	2044.34	136149.0
2016-01-27 13:00:00	ES	Futures	2044.07	2047.83	2040.58	2046.49	113883.0
2016-01-27 14:00:00	ES	Futures	2046.49	2052.4	2017.74	2020.42	383623.0
2016-01-27 15:00:00	ES	Futures	2020.69	2020.69	2004.03	2015.59	414795.0
2016-01-27 16:00:00	ES	Futures	2015.86	2019.62	2013.71	2018.54	71065.0
2016-01-27 18:00:00	ES	Futures	2020.69	2023.11	2012.09	2012.63	15210.0
2016-01-27 19:00:00	ES	Futures	2012.9	2013.97	2005.91	2011.56	23408.0
2016-01-27 20:00:00	ES	Futures	2011.56	2026.87	2011.56	2026.6	26940.0
2016-01-27 21:00:00	ES	Futures	2026.87	2030.9	2022.57	2024.19	16268.0
2016-01-27 22:00:00	ES	Futures	2023.92	2024.72	2018.27	2019.62	9514.0
2016-01-27 23:00:00	ES	Futures	2019.62	2022.84	2016.93	2022.3	7429.0
2016-01-27 00:00:00	NQ	Futures	4976.57	4993.2	4966.18	4987.26	3343.0
2016-01-27 01:00:00	NQ	Futures	4987.26	4998.25	4983.99	4994.39	1409.0
2016-01-27 02:00:00	NQ	Futures	4994.68	5000.03	4978.94	4984.59	3748.0
2016-01-27 03:00:00	NQ	Futures	4983.99	4991.42	4963.5	4973.6	7641.0
2016-01-27 04:00:00	NQ	Futures	4973.6	4981.62	4961.72	4968.26	3819.0
2016-01-27 05:00:00	NQ	Futures	4968.55	4981.62	4963.8	4976.57	3809.0
2016-01-27 06:00:00	NQ	Futures	4976.27	4978.35	4964.1	4970.93	2903.0
2016-01-27 07:00:00	NQ	Futures	4971.22	4989.04	4967.07	4987.56	4202.0
2016-01-27 08:00:00	NQ	Futures	4987.85	5001.51	4982.21	4996.46	6616.0
2016-01-27 09:00:00	NQ	Futures	4996.76	5001.21	4968.55	4971.22	36630.0
2016-01-27 10:00:00	NQ	Futures	4971.82	4973.6	4931.44	4951.03	58904.0
2016-01-27 11:00:00	NQ	Futures	4951.03	4994.98	4943.91	4990.23	36866.0
2016-01-27 12:00:00	NQ	Futures	4989.93	5010.72	4985.77	4986.07	28219.0
2016-01-27 13:00:00	NQ	Futures	4986.66	4994.68	4969.74	4983.7	23516.0
2016-01-27 14:00:00	NQ	Futures	4984.88	5000.03	4907.09	4912.43	84008.0
2016-01-27 15:00:00	NQ	Futures	4912.43	4913.03	4872.05	4892.83	71625.0
2016-01-27 16:00:00	NQ	Futures	4892.83	4921.34	4884.82	4921.04	12841.0
2016-01-27 18:00:00	NQ	Futures	4929.36	4942.13	4912.73	4914.81	3601.0
2016-01-27 19:00:00	NQ	Futures	4914.51	4920.15	4900.55	4915.1	4984.0
2016-01-27 20:00:00	NQ	Futures	4914.81	4956.67	4913.92	4956.08	5559.0
2016-01-27 21:00:00	NQ	Futures	4956.38	4965.58	4941.23	4944.8	4481.0
2016-01-27 22:00:00	NQ	Futures	4944.2	4948.66	4933.22	4935.59	1989.0
2016-01-27 23:00:00	NQ	Futures	4935.59	4940.05	4922.23	4939.75	2616.0
2016-01-27 00:00:00	YM	Futures	17005.0	17063.6	16973.1	17041.2	3829.0
2016-01-27 01:00:00	YM	Futures	17040.2	17072.1	17027.4	17065.7	2159.0
2016-01-27 02:00:00	YM	Futures	17063.6	17077.4	17016.7	17044.4	3670.0
2016-01-27 03:00:00	YM	Futures	17042.3	17073.2	16982.7	17023.1	6838.0

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

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