PREVIEW / futures_1hour / 2014-10-09

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-10-09.parquet
  size:    54 KB
  rows:    1,621

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-09 00:00:00	ES	Futures	2058.02	2059.06	2057.23	2058.8	3590.0
2014-10-09 01:00:00	ES	Futures	2058.8	2059.06	2055.92	2055.92	5654.0
2014-10-09 02:00:00	ES	Futures	2056.18	2057.49	2054.61	2057.49	14256.0
2014-10-09 03:00:00	ES	Futures	2057.49	2061.68	2054.87	2061.42	47386.0
2014-10-09 04:00:00	ES	Futures	2061.42	2062.73	2059.59	2060.64	33953.0
2014-10-09 05:00:00	ES	Futures	2060.37	2061.95	2059.85	2061.42	29532.0
2014-10-09 06:00:00	ES	Futures	2061.42	2061.95	2056.97	2057.23	39720.0
2014-10-09 07:00:00	ES	Futures	2057.49	2057.75	2047.28	2048.85	111341.0
2014-10-09 08:00:00	ES	Futures	2048.58	2054.87	2047.54	2051.99	83890.0
2014-10-09 09:00:00	ES	Futures	2051.73	2054.61	2043.08	2045.44	315145.0
2014-10-09 10:00:00	ES	Futures	2045.18	2049.63	2038.37	2043.61	366139.0
2014-10-09 11:00:00	ES	Futures	2043.87	2046.75	2025.53	2029.2	458331.0
2014-10-09 12:00:00	ES	Futures	2029.46	2031.3	2018.98	2025.27	352046.0
2014-10-09 13:00:00	ES	Futures	2025.01	2028.41	2014.53	2021.08	343254.0
2014-10-09 14:00:00	ES	Futures	2020.82	2020.82	2012.17	2014.53	302780.0
2014-10-09 15:00:00	ES	Futures	2014.53	2024.75	2012.17	2012.96	402683.0
2014-10-09 16:00:00	ES	Futures	2013.22	2020.55	2006.93	2010.08	139662.0
2014-10-09 17:00:00	ES	Futures	2010.08	2010.6	2007.98	2009.03	5043.0
2014-10-09 18:00:00	ES	Futures	2008.77	2011.12	2007.72	2008.5	10788.0
2014-10-09 19:00:00	ES	Futures	2008.5	2010.6	2005.88	2009.29	14560.0
2014-10-09 20:00:00	ES	Futures	2009.29	2015.84	2008.77	2013.74	16572.0
2014-10-09 21:00:00	ES	Futures	2013.74	2016.62	2012.17	2016.1	8434.0
2014-10-09 22:00:00	ES	Futures	2016.1	2016.1	2014.27	2014.53	5223.0
2014-10-09 23:00:00	ES	Futures	2014.53	2015.05	2011.39	2011.65	6931.0
2014-10-09 00:00:00	NQ	Futures	4735.27	4737.61	4733.21	4736.44	497.0
2014-10-09 01:00:00	NQ	Futures	4736.14	4737.32	4729.99	4730.87	928.0
2014-10-09 02:00:00	NQ	Futures	4730.87	4732.04	4724.72	4732.04	1498.0
2014-10-09 03:00:00	NQ	Futures	4732.04	4742.88	4725.89	4742.3	5999.0
2014-10-09 04:00:00	NQ	Futures	4741.71	4744.06	4736.73	4738.78	4244.0
2014-10-09 05:00:00	NQ	Futures	4738.49	4741.42	4736.73	4739.95	3698.0
2014-10-09 06:00:00	NQ	Futures	4739.95	4741.42	4731.46	4732.04	4027.0
2014-10-09 07:00:00	NQ	Futures	4731.75	4732.92	4704.79	4710.36	15220.0
2014-10-09 08:00:00	NQ	Futures	4710.65	4726.18	4707.72	4720.03	14249.0
2014-10-09 09:00:00	NQ	Futures	4719.74	4728.23	4703.03	4709.77	64312.0
2014-10-09 10:00:00	NQ	Futures	4709.19	4717.98	4693.66	4714.46	76810.0
2014-10-09 11:00:00	NQ	Futures	4714.46	4726.48	4674.61	4682.82	95240.0
2014-10-09 12:00:00	NQ	Futures	4682.82	4687.8	4654.4	4665.53	75727.0
2014-10-09 13:00:00	NQ	Futures	4665.53	4674.32	4641.5	4654.4	75958.0
2014-10-09 14:00:00	NQ	Futures	4654.4	4659.67	4636.23	4645.9	63197.0
2014-10-09 15:00:00	NQ	Futures	4645.61	4669.63	4640.33	4643.85	70449.0
2014-10-09 16:00:00	NQ	Futures	4643.85	4660.26	4625.97	4630.96	17140.0
2014-10-09 17:00:00	NQ	Futures	4630.96	4631.25	4627.15	4628.9	392.0
2014-10-09 18:00:00	NQ	Futures	4627.15	4633.3	4626.85	4627.73	1586.0
2014-10-09 19:00:00	NQ	Futures	4627.73	4631.54	4619.24	4627.73	2745.0
2014-10-09 20:00:00	NQ	Futures	4627.44	4642.97	4626.56	4638.28	2895.0
2014-10-09 21:00:00	NQ	Futures	4637.99	4645.9	4633.89	4643.85	1262.0
2014-10-09 22:00:00	NQ	Futures	4643.85	4644.14	4638.87	4639.75	790.0
2014-10-09 23:00:00	NQ	Futures	4639.75	4640.62	4631.25	4632.13	898.0
2014-10-09 00:00:00	YM	Futures	17593.8	17598.0	17585.5	17595.9	460.0
2014-10-09 01:00:00	YM	Futures	17595.9	17598.0	17575.1	17577.2	704.0

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

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