PREVIEW / futures_1hour / 2016-01-19

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-01-19.parquet
  size:    56 KB
  rows:    1,665

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-19 00:00:00	ES	Futures	2028.75	2034.93	2027.14	2034.4	12565.0
2016-01-19 01:00:00	ES	Futures	2034.13	2036.81	2033.86	2035.47	7942.0
2016-01-19 02:00:00	ES	Futures	2035.2	2047.29	2034.93	2044.07	32395.0
2016-01-19 03:00:00	ES	Futures	2044.07	2049.18	2039.23	2042.46	36601.0
2016-01-19 04:00:00	ES	Futures	2042.19	2046.76	2037.62	2043.8	27179.0
2016-01-19 05:00:00	ES	Futures	2044.07	2047.83	2042.73	2045.95	20317.0
2016-01-19 06:00:00	ES	Futures	2046.22	2050.25	2045.68	2049.44	20423.0
2016-01-19 07:00:00	ES	Futures	2049.71	2049.98	2042.99	2044.34	32814.0
2016-01-19 08:00:00	ES	Futures	2044.34	2047.03	2040.58	2042.99	58804.0
2016-01-19 09:00:00	ES	Futures	2042.73	2043.26	2018.54	2026.07	339810.0
2016-01-19 10:00:00	ES	Futures	2026.07	2036.55	2022.57	2022.57	330949.0
2016-01-19 11:00:00	ES	Futures	2022.84	2030.9	2016.39	2024.72	243330.0
2016-01-19 12:00:00	ES	Futures	2024.72	2025.53	2013.44	2017.47	201819.0
2016-01-19 13:00:00	ES	Futures	2017.2	2021.5	2011.56	2013.44	167603.0
2016-01-19 14:00:00	ES	Futures	2013.44	2014.51	1995.16	2000.81	269476.0
2016-01-19 15:00:00	ES	Futures	2000.54	2023.11	1998.66	2015.05	356192.0
2016-01-19 16:00:00	ES	Futures	2015.05	2017.2	2010.75	2012.09	85352.0
2016-01-19 18:00:00	ES	Futures	2011.82	2019.08	2010.75	2016.66	10594.0
2016-01-19 19:00:00	ES	Futures	2016.39	2016.66	2000.54	2007.53	26887.0
2016-01-19 20:00:00	ES	Futures	2007.79	2009.41	1996.24	2001.88	25846.0
2016-01-19 21:00:00	ES	Futures	2002.15	2003.49	1994.36	1995.97	18516.0
2016-01-19 22:00:00	ES	Futures	1995.7	1996.24	1979.85	1984.15	39805.0
2016-01-19 23:00:00	ES	Futures	1984.42	1984.95	1979.85	1980.12	16220.0
2016-01-19 00:00:00	NQ	Futures	4951.03	4968.55	4946.28	4968.26	2566.0
2016-01-19 01:00:00	NQ	Futures	4967.07	4973.6	4966.77	4968.55	1914.0
2016-01-19 02:00:00	NQ	Futures	4967.96	4997.35	4966.47	4992.31	5926.0
2016-01-19 03:00:00	NQ	Futures	4992.31	5007.15	4980.13	4988.74	6844.0
2016-01-19 04:00:00	NQ	Futures	4988.45	4999.73	4973.9	4990.53	4260.0
2016-01-19 05:00:00	NQ	Futures	4990.82	5002.11	4989.04	4997.95	2372.0
2016-01-19 06:00:00	NQ	Futures	4998.25	5007.15	4995.87	5004.18	2872.0
2016-01-19 07:00:00	NQ	Futures	5004.48	5004.48	4989.93	4993.2	3798.0
2016-01-19 08:00:00	NQ	Futures	4993.2	4999.14	4980.13	4987.85	8001.0
2016-01-19 09:00:00	NQ	Futures	4987.56	4988.74	4933.51	4950.14	53003.0
2016-01-19 10:00:00	NQ	Futures	4949.85	4975.38	4939.16	4939.45	55357.0
2016-01-19 11:00:00	NQ	Futures	4939.75	4951.63	4912.73	4934.11	47950.0
2016-01-19 12:00:00	NQ	Futures	4934.11	4936.78	4905.6	4918.96	32992.0
2016-01-19 13:00:00	NQ	Futures	4919.26	4934.11	4902.63	4907.09	27737.0
2016-01-19 14:00:00	NQ	Futures	4907.38	4910.65	4859.28	4875.02	47358.0
2016-01-19 15:00:00	NQ	Futures	4875.02	4938.56	4869.67	4916.59	60041.0
2016-01-19 16:00:00	NQ	Futures	4916.29	4933.81	4906.49	4917.78	14124.0
2016-01-19 18:00:00	NQ	Futures	4918.37	4936.78	4914.81	4929.06	1777.0
2016-01-19 19:00:00	NQ	Futures	4929.06	4929.95	4894.62	4907.38	5979.0
2016-01-19 20:00:00	NQ	Futures	4907.09	4912.43	4877.39	4891.94	5996.0
2016-01-19 21:00:00	NQ	Futures	4891.94	4895.51	4870.86	4875.32	4528.0
2016-01-19 22:00:00	NQ	Futures	4875.02	4875.91	4836.42	4845.92	6480.0
2016-01-19 23:00:00	NQ	Futures	4846.22	4846.51	4831.37	4832.56	4560.0
2016-01-19 00:00:00	YM	Futures	17059.3	17112.6	17046.6	17109.4	3615.0
2016-01-19 01:00:00	YM	Futures	17108.3	17129.6	17107.2	17113.6	1909.0
2016-01-19 02:00:00	YM	Futures	17112.6	17192.4	17108.3	17178.6	6547.0
2016-01-19 03:00:00	YM	Futures	17174.3	17216.9	17138.1	17158.3	9315.0

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

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