PREVIEW / futures_1hour / 2014-10-10

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-10-10.parquet
  size:    44 KB
  rows:    1,293

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-10-10 00:00:00	ES	Futures	2011.65	2013.22	2010.34	2011.91	5283.0
2014-10-10 01:00:00	ES	Futures	2011.65	2012.96	2010.34	2012.96	6441.0
2014-10-10 02:00:00	ES	Futures	2012.96	2016.89	2012.7	2016.62	16585.0
2014-10-10 03:00:00	ES	Futures	2016.89	2020.29	2015.58	2018.46	39895.0
2014-10-10 04:00:00	ES	Futures	2018.72	2018.98	2012.7	2014.27	37639.0
2014-10-10 05:00:00	ES	Futures	2014.27	2014.53	2007.46	2007.72	56886.0
2014-10-10 06:00:00	ES	Futures	2007.98	2008.24	2002.74	2007.98	45846.0
2014-10-10 07:00:00	ES	Futures	2007.98	2011.12	2005.62	2009.55	53492.0
2014-10-10 08:00:00	ES	Futures	2009.81	2018.72	2006.15	2016.89	125204.0
2014-10-10 09:00:00	ES	Futures	2016.89	2023.7	2007.46	2017.67	420898.0
2014-10-10 10:00:00	ES	Futures	2017.67	2018.72	1997.76	2006.93	676764.0
2014-10-10 11:00:00	ES	Futures	2006.93	2011.65	2000.91	2007.19	314156.0
2014-10-10 12:00:00	ES	Futures	2007.19	2022.39	2006.93	2015.32	321578.0
2014-10-10 13:00:00	ES	Futures	2015.32	2016.62	2007.46	2012.96	172182.0
2014-10-10 14:00:00	ES	Futures	2013.22	2015.84	2004.84	2005.62	146373.0
2014-10-10 15:00:00	ES	Futures	2005.62	2006.67	1990.43	1990.69	398359.0
2014-10-10 16:00:00	ES	Futures	1990.69	1993.05	1983.88	1984.93	161634.0
2014-10-10 17:00:00	ES	Futures	1984.66	1985.97	1984.14	1984.93	5249.0
2014-10-10 00:00:00	NQ	Futures	4631.83	4637.11	4629.78	4633.3	723.0
2014-10-10 01:00:00	NQ	Futures	4633.01	4635.06	4628.61	4633.89	1798.0
2014-10-10 02:00:00	NQ	Futures	4634.18	4643.26	4633.89	4642.68	3253.0
2014-10-10 03:00:00	NQ	Futures	4642.38	4649.41	4637.69	4640.04	9441.0
2014-10-10 04:00:00	NQ	Futures	4640.04	4642.09	4620.11	4624.22	8596.0
2014-10-10 05:00:00	NQ	Futures	4623.92	4623.92	4608.69	4609.86	8783.0
2014-10-10 06:00:00	NQ	Futures	4610.44	4612.79	4598.72	4611.03	7857.0
2014-10-10 07:00:00	NQ	Futures	4611.32	4617.48	4606.64	4615.43	6906.0
2014-10-10 08:00:00	NQ	Futures	4615.13	4631.25	4603.41	4628.03	21203.0
2014-10-10 09:00:00	NQ	Futures	4628.32	4643.85	4600.78	4620.7	96987.0
2014-10-10 10:00:00	NQ	Futures	4620.7	4622.75	4560.93	4588.76	157145.0
2014-10-10 11:00:00	NQ	Futures	4588.47	4601.65	4576.75	4586.42	65738.0
2014-10-10 12:00:00	NQ	Futures	4586.71	4618.65	4585.83	4601.07	71142.0
2014-10-10 13:00:00	NQ	Futures	4600.78	4604.29	4578.8	4589.64	47977.0
2014-10-10 14:00:00	NQ	Futures	4589.93	4598.14	4569.13	4572.06	45038.0
2014-10-10 15:00:00	NQ	Futures	4572.06	4573.82	4527.52	4528.11	91652.0
2014-10-10 16:00:00	NQ	Futures	4528.4	4533.38	4513.46	4514.93	20634.0
2014-10-10 17:00:00	NQ	Futures	4515.51	4518.44	4514.34	4514.34	488.0
2014-10-10 00:00:00	YM	Futures	17223.7	17235.1	17213.3	17222.6	1024.0
2014-10-10 01:00:00	YM	Futures	17221.6	17233.0	17211.2	17232.0	1027.0
2014-10-10 02:00:00	YM	Futures	17232.0	17260.1	17225.8	17259.0	2353.0
2014-10-10 03:00:00	YM	Futures	17258.0	17287.1	17250.7	17274.6	7328.0
2014-10-10 04:00:00	YM	Futures	17274.6	17274.6	17219.5	17234.1	6241.0
2014-10-10 05:00:00	YM	Futures	17233.0	17233.0	17169.6	17172.7	9867.0
2014-10-10 06:00:00	YM	Futures	17172.7	17189.4	17133.2	17187.3	7878.0
2014-10-10 07:00:00	YM	Futures	17187.3	17210.2	17170.6	17200.8	5491.0
2014-10-10 08:00:00	YM	Futures	17200.8	17266.3	17177.9	17253.8	14129.0
2014-10-10 09:00:00	YM	Futures	17253.8	17339.1	17203.9	17295.4	43158.0
2014-10-10 10:00:00	YM	Futures	17296.5	17307.9	17188.3	17250.7	55250.0
2014-10-10 11:00:00	YM	Futures	17250.7	17279.8	17195.6	17235.1	29410.0
2014-10-10 12:00:00	YM	Futures	17236.2	17345.3	17235.1	17290.2	35107.0
2014-10-10 13:00:00	YM	Futures	17289.2	17297.5	17239.3	17278.8	19126.0

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

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