PREVIEW / futures_1hour / 2014-08-08

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-08-08.parquet
  size:    44 KB
  rows:    1,271

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-08-08 00:00:00	ES	Futures	1975.98	1975.98	1974.15	1975.98	7213.0
2014-08-08 01:00:00	ES	Futures	1975.71	1977.8	1973.63	1974.93	12295.0
2014-08-08 02:00:00	ES	Futures	1974.93	1975.98	1972.85	1974.67	19505.0
2014-08-08 03:00:00	ES	Futures	1974.67	1977.02	1970.5	1971.28	59279.0
2014-08-08 04:00:00	ES	Futures	1971.02	1979.62	1971.02	1977.54	49994.0
2014-08-08 05:00:00	ES	Futures	1977.54	1979.36	1976.24	1977.8	32221.0
2014-08-08 06:00:00	ES	Futures	1977.8	1983.27	1977.8	1981.97	34878.0
2014-08-08 07:00:00	ES	Futures	1982.23	1991.61	1981.19	1989.27	96731.0
2014-08-08 08:00:00	ES	Futures	1989.01	1995.0	1989.01	1991.87	85726.0
2014-08-08 09:00:00	ES	Futures	1991.87	1992.65	1985.1	1988.22	237377.0
2014-08-08 10:00:00	ES	Futures	1988.22	1994.48	1984.58	1992.13	262910.0
2014-08-08 11:00:00	ES	Futures	1992.13	1996.3	1990.57	1995.52	160519.0
2014-08-08 12:00:00	ES	Futures	1995.26	1996.04	1991.61	1993.44	67244.0
2014-08-08 13:00:00	ES	Futures	1993.44	2005.42	1992.65	2004.12	204428.0
2014-08-08 14:00:00	ES	Futures	2004.38	2006.47	2002.82	2003.86	119347.0
2014-08-08 15:00:00	ES	Futures	2003.86	2010.12	2002.3	2008.55	219845.0
2014-08-08 16:00:00	ES	Futures	2008.55	2008.55	2004.9	2005.69	114675.0
2014-08-08 17:00:00	ES	Futures	2005.69	2005.69	2004.9	2004.9	3285.0
2014-08-08 00:00:00	NQ	Futures	4480.97	4481.26	4477.46	4480.38	1184.0
2014-08-08 01:00:00	NQ	Futures	4479.8	4484.47	4476.59	4478.92	1785.0
2014-08-08 02:00:00	NQ	Futures	4478.34	4482.13	4473.96	4477.75	3067.0
2014-08-08 03:00:00	NQ	Futures	4477.46	4484.18	4469.58	4471.62	8873.0
2014-08-08 04:00:00	NQ	Futures	4471.91	4488.27	4470.74	4483.89	8666.0
2014-08-08 05:00:00	NQ	Futures	4483.89	4489.43	4481.84	4487.68	5786.0
2014-08-08 06:00:00	NQ	Futures	4487.39	4497.32	4487.39	4494.69	6450.0
2014-08-08 07:00:00	NQ	Futures	4494.69	4514.84	4492.35	4510.46	12603.0
2014-08-08 08:00:00	NQ	Futures	4510.46	4521.56	4510.17	4514.55	12780.0
2014-08-08 09:00:00	NQ	Futures	4514.55	4515.42	4497.61	4507.25	49256.0
2014-08-08 10:00:00	NQ	Futures	4506.66	4515.13	4490.31	4509.29	52369.0
2014-08-08 11:00:00	NQ	Futures	4509.29	4517.47	4506.08	4513.67	27379.0
2014-08-08 12:00:00	NQ	Futures	4513.67	4516.01	4504.03	4508.71	12683.0
2014-08-08 13:00:00	NQ	Futures	4508.41	4537.32	4506.95	4533.82	32394.0
2014-08-08 14:00:00	NQ	Futures	4534.11	4539.37	4531.48	4535.28	17723.0
2014-08-08 15:00:00	NQ	Futures	4534.99	4539.95	4529.44	4534.4	35783.0
2014-08-08 16:00:00	NQ	Futures	4534.7	4534.7	4524.48	4526.23	11881.0
2014-08-08 17:00:00	NQ	Futures	4525.94	4526.23	4525.06	4525.35	103.0
2014-08-08 00:00:00	YM	Futures	16806.6	16808.7	16796.2	16808.7	1244.0
2014-08-08 01:00:00	YM	Futures	16806.6	16821.1	16793.1	16801.4	2222.0
2014-08-08 02:00:00	YM	Futures	16800.4	16811.8	16785.9	16800.4	2591.0
2014-08-08 03:00:00	YM	Futures	16800.4	16821.1	16767.3	16775.5	9926.0
2014-08-08 04:00:00	YM	Futures	16774.5	16836.6	16773.5	16822.1	7370.0
2014-08-08 05:00:00	YM	Futures	16823.1	16834.5	16812.8	16829.3	5394.0
2014-08-08 06:00:00	YM	Futures	16828.3	16861.4	16828.3	16853.1	5084.0
2014-08-08 07:00:00	YM	Futures	16853.1	16915.2	16844.9	16898.7	10916.0
2014-08-08 08:00:00	YM	Futures	16898.7	16938.0	16896.6	16914.2	7089.0
2014-08-08 09:00:00	YM	Futures	16914.2	16924.5	16872.8	16896.6	22879.0
2014-08-08 10:00:00	YM	Futures	16896.6	16951.4	16873.8	16928.7	24287.0
2014-08-08 11:00:00	YM	Futures	16927.6	16969.0	16918.3	16961.8	14820.0
2014-08-08 12:00:00	YM	Futures	16960.7	16966.9	16934.9	16944.2	6038.0
2014-08-08 13:00:00	YM	Futures	16944.2	17049.7	16939.0	17035.2	21879.0

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

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