PREVIEW / futures_1hour / 2014-06-03

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-06-03.parquet
  size:    48 KB
  rows:    1,512

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-03 00:00:00	ES	Futures	1995.05	1995.83	1994.27	1994.53	1332.0
2014-06-03 01:00:00	ES	Futures	1994.79	1995.31	1994.27	1994.27	2335.0
2014-06-03 02:00:00	ES	Futures	1994.27	1995.31	1994.02	1994.79	4998.0
2014-06-03 03:00:00	ES	Futures	1994.53	1994.79	1993.5	1994.27	10542.0
2014-06-03 04:00:00	ES	Futures	1994.27	1994.53	1993.5	1994.02	9067.0
2014-06-03 05:00:00	ES	Futures	1994.27	1994.53	1992.98	1993.24	6681.0
2014-06-03 06:00:00	ES	Futures	1993.5	1994.02	1992.72	1993.5	8371.0
2014-06-03 07:00:00	ES	Futures	1993.5	1993.5	1990.12	1991.16	28598.0
2014-06-03 08:00:00	ES	Futures	1990.9	1992.46	1990.64	1991.42	20715.0
2014-06-03 09:00:00	ES	Futures	1991.68	1995.31	1990.9	1994.53	170191.0
2014-06-03 10:00:00	ES	Futures	1994.53	1996.61	1991.68	1993.24	169685.0
2014-06-03 11:00:00	ES	Futures	1993.24	1994.02	1990.64	1992.72	129051.0
2014-06-03 12:00:00	ES	Futures	1992.72	1995.57	1992.46	1994.27	64659.0
2014-06-03 13:00:00	ES	Futures	1994.27	1996.09	1994.27	1996.09	50246.0
2014-06-03 14:00:00	ES	Futures	1996.09	1997.39	1995.31	1995.57	69210.0
2014-06-03 15:00:00	ES	Futures	1995.57	1997.13	1994.53	1996.35	109439.0
2014-06-03 16:00:00	ES	Futures	1996.09	1997.39	1995.83	1997.39	55468.0
2014-06-03 17:00:00	ES	Futures	1997.13	1997.91	1997.13	1997.65	3037.0
2014-06-03 18:00:00	ES	Futures	1997.13	1997.39	1995.57	1996.35	5341.0
2014-06-03 19:00:00	ES	Futures	1996.35	1997.13	1996.09	1996.61	1209.0
2014-06-03 20:00:00	ES	Futures	1996.61	1996.87	1995.57	1995.57	2394.0
2014-06-03 21:00:00	ES	Futures	1995.31	1996.09	1995.05	1995.31	2230.0
2014-06-03 22:00:00	ES	Futures	1995.05	1995.57	1994.27	1994.27	2716.0
2014-06-03 23:00:00	ES	Futures	1994.53	1994.79	1994.02	1994.27	1550.0
2014-06-03 00:00:00	NQ	Futures	4340.96	4342.42	4339.79	4340.38	211.0
2014-06-03 01:00:00	NQ	Futures	4340.38	4342.12	4339.79	4340.38	461.0
2014-06-03 02:00:00	NQ	Futures	4340.38	4342.42	4339.21	4340.96	699.0
2014-06-03 03:00:00	NQ	Futures	4340.96	4341.25	4336.88	4339.21	1598.0
2014-06-03 04:00:00	NQ	Futures	4339.21	4339.79	4336.3	4339.5	1370.0
2014-06-03 05:00:00	NQ	Futures	4339.5	4339.79	4332.22	4334.26	2307.0
2014-06-03 06:00:00	NQ	Futures	4334.55	4336.3	4333.39	4334.84	953.0
2014-06-03 07:00:00	NQ	Futures	4334.84	4334.84	4327.56	4329.6	3366.0
2014-06-03 08:00:00	NQ	Futures	4329.89	4331.35	4327.85	4330.18	3767.0
2014-06-03 09:00:00	NQ	Futures	4330.48	4346.49	4326.4	4345.91	43848.0
2014-06-03 10:00:00	NQ	Futures	4345.91	4351.73	4335.72	4339.79	42374.0
2014-06-03 11:00:00	NQ	Futures	4339.5	4341.54	4329.02	4335.43	24901.0
2014-06-03 12:00:00	NQ	Futures	4335.43	4343.87	4334.84	4337.17	13220.0
2014-06-03 13:00:00	NQ	Futures	4337.46	4344.45	4336.88	4342.71	9673.0
2014-06-03 14:00:00	NQ	Futures	4342.71	4346.78	4338.63	4339.5	11232.0
2014-06-03 15:00:00	NQ	Futures	4339.5	4345.91	4336.88	4344.75	16936.0
2014-06-03 16:00:00	NQ	Futures	4344.45	4348.82	4342.71	4348.24	4313.0
2014-06-03 17:00:00	NQ	Futures	4348.24	4350.28	4347.95	4349.99	282.0
2014-06-03 18:00:00	NQ	Futures	4348.24	4348.24	4343.58	4345.91	875.0
2014-06-03 19:00:00	NQ	Futures	4345.62	4347.95	4345.62	4347.37	221.0
2014-06-03 20:00:00	NQ	Futures	4347.07	4347.07	4344.16	4344.16	279.0
2014-06-03 21:00:00	NQ	Futures	4344.16	4345.33	4343.0	4343.58	323.0
2014-06-03 22:00:00	NQ	Futures	4343.58	4343.58	4341.25	4341.54	509.0
2014-06-03 23:00:00	NQ	Futures	4341.83	4342.12	4340.38	4340.67	358.0
2014-06-03 00:00:00	YM	Futures	17216.2	17226.5	17213.1	17215.1	1030.0
2014-06-03 01:00:00	YM	Futures	17215.1	17220.3	17213.1	17215.1	435.0

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

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