PREVIEW / futures_1hour / 2014-06-12

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-06-12.parquet
  size:    49 KB
  rows:    1,503

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
2014-06-12 00:00:00	ES	Futures	2019.98	2020.76	2019.46	2019.72	1772.0
2014-06-12 01:00:00	ES	Futures	2019.72	2020.5	2019.72	2020.24	1343.0
2014-06-12 02:00:00	ES	Futures	2019.98	2021.28	2019.72	2019.98	3993.0
2014-06-12 03:00:00	ES	Futures	2019.72	2021.02	2019.2	2020.5	15131.0
2014-06-12 04:00:00	ES	Futures	2020.5	2021.28	2019.98	2021.02	7024.0
2014-06-12 05:00:00	ES	Futures	2020.76	2022.06	2020.5	2021.8	8379.0
2014-06-12 06:00:00	ES	Futures	2021.8	2022.06	2019.2	2019.46	11833.0
2014-06-12 07:00:00	ES	Futures	2019.46	2021.02	2019.2	2019.98	13374.0
2014-06-12 08:00:00	ES	Futures	2019.72	2019.98	2016.61	2016.87	38977.0
2014-06-12 09:00:00	ES	Futures	2016.87	2017.13	2012.97	2014.01	139963.0
2014-06-12 10:00:00	ES	Futures	2013.75	2015.83	2008.56	2010.37	216964.0
2014-06-12 11:00:00	ES	Futures	2010.37	2014.01	2009.6	2011.15	101690.0
2014-06-12 12:00:00	ES	Futures	2010.89	2013.23	2007.78	2009.08	91315.0
2014-06-12 13:00:00	ES	Futures	2009.34	2009.85	2001.81	2003.1	178055.0
2014-06-12 14:00:00	ES	Futures	2003.1	2005.44	2002.06	2003.1	99134.0
2014-06-12 15:00:00	ES	Futures	2002.84	2005.18	1999.21	2003.88	232054.0
2014-06-12 16:00:00	ES	Futures	2003.62	2007.0	2003.36	2006.48	71761.0
2014-06-12 17:00:00	ES	Futures	2006.22	2006.48	2005.44	2005.7	1572.0
2014-06-12 18:00:00	ES	Futures	2005.44	2006.74	2004.14	2004.66	3473.0
2014-06-12 19:00:00	ES	Futures	2004.92	2005.44	2003.1	2003.36	3981.0
2014-06-12 20:00:00	ES	Futures	2003.62	2005.7	2003.62	2005.44	2809.0
2014-06-12 21:00:00	ES	Futures	2005.44	2005.44	2001.81	2002.84	5197.0
2014-06-12 22:00:00	ES	Futures	2002.84	2004.4	2002.32	2003.88	2781.0
2014-06-12 23:00:00	ES	Futures	2003.88	2005.44	2003.62	2004.4	2590.0
2014-06-12 00:00:00	NQ	Futures	4426.87	4428.62	4425.7	4426.29	325.0
2014-06-12 01:00:00	NQ	Futures	4426.58	4427.74	4426.0	4426.29	488.0
2014-06-12 02:00:00	NQ	Futures	4426.29	4428.62	4426.29	4426.58	493.0
2014-06-12 03:00:00	NQ	Futures	4426.29	4428.03	4423.08	4427.16	2201.0
2014-06-12 04:00:00	NQ	Futures	4427.16	4428.91	4425.7	4428.62	1120.0
2014-06-12 05:00:00	NQ	Futures	4428.33	4431.82	4426.29	4430.36	1360.0
2014-06-12 06:00:00	NQ	Futures	4430.66	4430.66	4423.96	4424.54	1787.0
2014-06-12 07:00:00	NQ	Futures	4424.83	4427.74	4424.83	4425.41	1518.0
2014-06-12 08:00:00	NQ	Futures	4425.41	4425.7	4419.3	4419.59	4539.0
2014-06-12 09:00:00	NQ	Futures	4419.88	4420.46	4406.48	4414.06	31054.0
2014-06-12 10:00:00	NQ	Futures	4413.76	4421.05	4397.17	4403.57	43689.0
2014-06-12 11:00:00	NQ	Futures	4403.57	4413.47	4401.24	4406.48	17856.0
2014-06-12 12:00:00	NQ	Futures	4406.78	4409.98	4393.09	4397.75	18397.0
2014-06-12 13:00:00	NQ	Futures	4398.04	4399.2	4378.53	4382.31	34121.0
2014-06-12 14:00:00	NQ	Futures	4382.31	4385.52	4375.32	4379.11	24182.0
2014-06-12 15:00:00	NQ	Futures	4379.11	4386.68	4370.08	4386.39	39706.0
2014-06-12 16:00:00	NQ	Futures	4386.39	4400.37	4386.1	4396.29	14041.0
2014-06-12 17:00:00	NQ	Futures	4396.58	4397.17	4395.42	4397.17	306.0
2014-06-12 18:00:00	NQ	Futures	4395.13	4398.33	4394.84	4394.84	445.0
2014-06-12 19:00:00	NQ	Futures	4395.13	4395.71	4392.8	4393.38	498.0
2014-06-12 20:00:00	NQ	Futures	4393.38	4397.75	4393.38	4396.29	329.0
2014-06-12 21:00:00	NQ	Futures	4396.58	4397.46	4390.76	4392.8	735.0
2014-06-12 22:00:00	NQ	Futures	4393.09	4396.29	4391.63	4395.71	213.0
2014-06-12 23:00:00	NQ	Futures	4395.13	4398.62	4395.13	4397.17	398.0
2014-06-12 00:00:00	YM	Futures	17366.3	17370.4	17365.2	17367.3	13.0
2014-06-12 01:00:00	YM	Futures	17367.3	17370.4	17367.3	17370.4	14.0

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

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