PREVIEW / futures_1hour / 2014-05-22

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-05-22.parquet
  size:    47 KB
  rows:    1,545

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-05-22 00:00:00	ES	Futures	1961.82	1963.63	1961.56	1962.59	6909.0
2014-05-22 01:00:00	ES	Futures	1962.59	1962.85	1961.3	1962.34	3255.0
2014-05-22 02:00:00	ES	Futures	1962.08	1962.34	1961.04	1961.56	5886.0
2014-05-22 03:00:00	ES	Futures	1961.3	1961.82	1958.7	1959.22	24978.0
2014-05-22 04:00:00	ES	Futures	1959.48	1960.78	1958.96	1958.96	12033.0
2014-05-22 05:00:00	ES	Futures	1958.96	1960.0	1958.18	1958.7	13380.0
2014-05-22 06:00:00	ES	Futures	1958.7	1960.26	1957.92	1958.7	13414.0
2014-05-22 07:00:00	ES	Futures	1958.7	1959.22	1956.88	1958.18	17480.0
2014-05-22 08:00:00	ES	Futures	1958.44	1960.26	1957.66	1959.22	37681.0
2014-05-22 09:00:00	ES	Futures	1958.96	1962.85	1955.58	1961.3	182993.0
2014-05-22 10:00:00	ES	Futures	1961.3	1964.41	1958.18	1963.63	186008.0
2014-05-22 11:00:00	ES	Futures	1963.37	1967.01	1962.59	1964.93	139324.0
2014-05-22 12:00:00	ES	Futures	1965.19	1965.71	1963.63	1964.15	53266.0
2014-05-22 13:00:00	ES	Futures	1964.15	1967.01	1963.89	1965.97	58047.0
2014-05-22 14:00:00	ES	Futures	1965.97	1967.27	1965.71	1967.27	46733.0
2014-05-22 15:00:00	ES	Futures	1967.01	1967.01	1962.85	1963.37	130574.0
2014-05-22 16:00:00	ES	Futures	1963.11	1963.63	1962.59	1963.37	49934.0
2014-05-22 17:00:00	ES	Futures	1963.37	1963.63	1962.85	1963.37	1180.0
2014-05-22 18:00:00	ES	Futures	1963.37	1963.89	1962.85	1963.63	1559.0
2014-05-22 19:00:00	ES	Futures	1963.63	1963.89	1963.11	1963.63	1030.0
2014-05-22 20:00:00	ES	Futures	1963.63	1963.89	1962.59	1962.85	2947.0
2014-05-22 21:00:00	ES	Futures	1963.11	1964.41	1962.59	1963.89	4059.0
2014-05-22 22:00:00	ES	Futures	1963.89	1965.19	1963.89	1964.93	2291.0
2014-05-22 23:00:00	ES	Futures	1964.93	1965.19	1963.63	1964.15	2288.0
2014-05-22 00:00:00	NQ	Futures	4241.65	4246.02	4241.65	4243.4	799.0
2014-05-22 01:00:00	NQ	Futures	4243.4	4243.98	4240.2	4241.65	510.0
2014-05-22 02:00:00	NQ	Futures	4241.94	4242.53	4239.32	4240.78	857.0
2014-05-22 03:00:00	NQ	Futures	4240.49	4241.07	4233.79	4234.95	3002.0
2014-05-22 04:00:00	NQ	Futures	4235.25	4240.49	4234.08	4236.12	2011.0
2014-05-22 05:00:00	NQ	Futures	4236.41	4240.49	4234.66	4235.25	3357.0
2014-05-22 06:00:00	NQ	Futures	4234.66	4239.03	4233.21	4235.83	1696.0
2014-05-22 07:00:00	NQ	Futures	4235.83	4237.28	4233.5	4236.7	1820.0
2014-05-22 08:00:00	NQ	Futures	4236.41	4240.2	4234.66	4236.99	4429.0
2014-05-22 09:00:00	NQ	Futures	4236.99	4249.52	4232.04	4246.02	34943.0
2014-05-22 10:00:00	NQ	Futures	4246.6	4252.72	4230.29	4250.68	49675.0
2014-05-22 11:00:00	NQ	Futures	4250.68	4258.54	4247.19	4254.47	32044.0
2014-05-22 12:00:00	NQ	Futures	4254.76	4255.34	4248.64	4249.81	12973.0
2014-05-22 13:00:00	NQ	Futures	4250.1	4260.87	4249.22	4258.83	14806.0
2014-05-22 14:00:00	NQ	Futures	4258.83	4263.2	4257.96	4262.62	13459.0
2014-05-22 15:00:00	NQ	Futures	4262.62	4262.62	4250.39	4250.68	29995.0
2014-05-22 16:00:00	NQ	Futures	4250.68	4251.85	4248.64	4250.97	5200.0
2014-05-22 17:00:00	NQ	Futures	4250.97	4251.26	4249.22	4249.52	155.0
2014-05-22 18:00:00	NQ	Futures	4249.81	4250.97	4248.93	4250.97	441.0
2014-05-22 19:00:00	NQ	Futures	4250.97	4251.55	4250.1	4250.68	382.0
2014-05-22 20:00:00	NQ	Futures	4250.68	4251.85	4249.22	4250.68	436.0
2014-05-22 21:00:00	NQ	Futures	4250.97	4252.14	4249.81	4250.39	754.0
2014-05-22 22:00:00	NQ	Futures	4250.68	4254.47	4250.39	4254.47	568.0
2014-05-22 23:00:00	NQ	Futures	4253.88	4254.17	4250.39	4251.55	434.0
2014-05-22 00:00:00	YM	Futures	17037.0	17054.5	17037.0	17046.2	1428.0
2014-05-22 01:00:00	YM	Futures	17046.2	17047.3	17034.9	17043.1	494.0

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

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