PREVIEW / futures_1hour / 2014-10-14

all futures 1-hour files

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

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-14 00:00:00	ES	Futures	1966.07	1966.33	1963.45	1963.71	4078.0
2014-10-14 01:00:00	ES	Futures	1963.71	1965.54	1961.09	1963.71	7950.0
2014-10-14 02:00:00	ES	Futures	1963.97	1965.8	1960.83	1963.71	17945.0
2014-10-14 03:00:00	ES	Futures	1963.71	1967.11	1962.66	1964.76	48423.0
2014-10-14 04:00:00	ES	Futures	1964.49	1965.28	1958.21	1958.47	42563.0
2014-10-14 05:00:00	ES	Futures	1958.73	1959.25	1954.01	1956.9	60945.0
2014-10-14 06:00:00	ES	Futures	1956.63	1962.66	1956.11	1961.09	38409.0
2014-10-14 07:00:00	ES	Futures	1961.09	1963.45	1955.85	1963.45	63117.0
2014-10-14 08:00:00	ES	Futures	1963.45	1971.04	1962.66	1966.85	117079.0
2014-10-14 09:00:00	ES	Futures	1966.59	1974.97	1960.04	1962.66	443058.0
2014-10-14 10:00:00	ES	Futures	1962.4	1974.19	1958.99	1969.47	576521.0
2014-10-14 11:00:00	ES	Futures	1969.21	1982.05	1968.16	1980.21	354061.0
2014-10-14 12:00:00	ES	Futures	1980.21	1983.36	1971.83	1975.23	233866.0
2014-10-14 13:00:00	ES	Futures	1975.5	1979.69	1968.16	1973.14	197974.0
2014-10-14 14:00:00	ES	Futures	1973.14	1975.76	1962.4	1965.54	255176.0
2014-10-14 15:00:00	ES	Futures	1965.28	1968.16	1954.28	1961.61	480802.0
2014-10-14 16:00:00	ES	Futures	1961.61	1967.9	1961.35	1967.9	92469.0
2014-10-14 17:00:00	ES	Futures	1967.9	1968.16	1967.11	1967.38	2858.0
2014-10-14 18:00:00	ES	Futures	1968.16	1971.57	1967.9	1969.73	7997.0
2014-10-14 19:00:00	ES	Futures	1969.73	1973.4	1969.73	1971.57	6253.0
2014-10-14 20:00:00	ES	Futures	1971.83	1972.61	1966.59	1967.38	9544.0
2014-10-14 21:00:00	ES	Futures	1967.11	1967.9	1959.25	1962.92	24923.0
2014-10-14 22:00:00	ES	Futures	1963.18	1965.54	1960.3	1963.18	8046.0
2014-10-14 23:00:00	ES	Futures	1963.18	1965.8	1963.18	1963.45	5755.0
2014-10-14 00:00:00	NQ	Futures	4478.3	4479.18	4473.03	4473.03	762.0
2014-10-14 01:00:00	NQ	Futures	4473.61	4477.71	4467.46	4473.9	1052.0
2014-10-14 02:00:00	NQ	Futures	4473.9	4478.89	4466.58	4473.9	1409.0
2014-10-14 03:00:00	NQ	Futures	4473.03	4480.64	4468.34	4475.08	6298.0
2014-10-14 04:00:00	NQ	Futures	4474.78	4476.25	4458.67	4459.84	4200.0
2014-10-14 05:00:00	NQ	Futures	4459.55	4463.94	4450.46	4456.91	7092.0
2014-10-14 06:00:00	NQ	Futures	4456.91	4469.51	4455.74	4465.99	4756.0
2014-10-14 07:00:00	NQ	Futures	4466.29	4470.97	4453.39	4470.68	5668.0
2014-10-14 08:00:00	NQ	Futures	4470.97	4493.24	4468.04	4484.75	17653.0
2014-10-14 09:00:00	NQ	Futures	4484.45	4501.45	4452.51	4460.72	85853.0
2014-10-14 10:00:00	NQ	Futures	4460.72	4496.76	4446.95	4484.75	135748.0
2014-10-14 11:00:00	NQ	Futures	4484.75	4513.75	4479.47	4507.89	67575.0
2014-10-14 12:00:00	NQ	Futures	4507.89	4515.51	4485.62	4492.66	43239.0
2014-10-14 13:00:00	NQ	Futures	4492.66	4503.2	4470.97	4483.57	43541.0
2014-10-14 14:00:00	NQ	Futures	4483.87	4492.07	4456.03	4467.46	54458.0
2014-10-14 15:00:00	NQ	Futures	4467.75	4481.52	4445.48	4458.67	94867.0
2014-10-14 16:00:00	NQ	Futures	4458.38	4475.37	4457.5	4474.78	18585.0
2014-10-14 17:00:00	NQ	Futures	4474.78	4476.83	4473.32	4476.54	651.0
2014-10-14 18:00:00	NQ	Futures	4481.52	4487.68	4478.89	4483.28	1565.0
2014-10-14 19:00:00	NQ	Futures	4483.57	4490.61	4482.99	4486.5	618.0
2014-10-14 20:00:00	NQ	Futures	4486.8	4488.85	4475.96	4477.13	1146.0
2014-10-14 21:00:00	NQ	Futures	4476.83	4478.59	4458.08	4463.94	2553.0
2014-10-14 22:00:00	NQ	Futures	4465.99	4471.27	4458.67	4467.17	1361.0
2014-10-14 23:00:00	NQ	Futures	4466.87	4473.03	4466.29	4468.63	476.0
2014-10-14 00:00:00	YM	Futures	16956.5	16958.5	16937.7	16940.9	770.0
2014-10-14 01:00:00	YM	Futures	16939.8	16948.1	16912.8	16939.8	1996.0

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

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