PREVIEW / futures_1hour / 2014-05-02

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-05-02.parquet
  size:    44 KB
  rows:    1,287

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-02 00:00:00	ES	Futures	1951.17	1951.43	1950.13	1950.65	1824.0
2014-05-02 01:00:00	ES	Futures	1950.65	1951.69	1950.39	1951.43	1321.0
2014-05-02 02:00:00	ES	Futures	1951.17	1951.95	1950.39	1951.43	5382.0
2014-05-02 03:00:00	ES	Futures	1951.17	1952.73	1950.65	1952.73	17364.0
2014-05-02 04:00:00	ES	Futures	1952.47	1952.73	1951.69	1952.47	6834.0
2014-05-02 05:00:00	ES	Futures	1952.73	1952.73	1951.69	1952.47	5180.0
2014-05-02 06:00:00	ES	Futures	1952.47	1953.25	1950.91	1951.17	8671.0
2014-05-02 07:00:00	ES	Futures	1951.43	1951.95	1951.17	1951.95	8181.0
2014-05-02 08:00:00	ES	Futures	1951.95	1958.96	1948.05	1948.83	181252.0
2014-05-02 09:00:00	ES	Futures	1948.83	1956.62	1947.53	1954.03	311241.0
2014-05-02 10:00:00	ES	Futures	1953.77	1958.7	1946.5	1948.83	405005.0
2014-05-02 11:00:00	ES	Futures	1949.09	1953.25	1947.27	1951.95	214527.0
2014-05-02 12:00:00	ES	Futures	1952.21	1952.47	1949.87	1951.43	61181.0
2014-05-02 13:00:00	ES	Futures	1951.43	1952.47	1946.75	1947.01	102902.0
2014-05-02 14:00:00	ES	Futures	1946.75	1949.09	1944.42	1947.27	135147.0
2014-05-02 15:00:00	ES	Futures	1947.27	1950.39	1945.46	1947.79	168806.0
2014-05-02 16:00:00	ES	Futures	1947.53	1948.31	1945.98	1946.24	65774.0
2014-05-02 17:00:00	ES	Futures	1946.24	1946.5	1944.94	1944.94	3256.0
2014-05-02 00:00:00	NQ	Futures	4179.91	4180.79	4176.71	4177.29	357.0
2014-05-02 01:00:00	NQ	Futures	4177.58	4180.5	4177.29	4179.91	437.0
2014-05-02 02:00:00	NQ	Futures	4179.62	4180.5	4176.42	4178.17	868.0
2014-05-02 03:00:00	NQ	Futures	4178.46	4181.66	4176.13	4181.37	2630.0
2014-05-02 04:00:00	NQ	Futures	4181.66	4182.53	4179.62	4181.66	902.0
2014-05-02 05:00:00	NQ	Futures	4181.95	4182.24	4179.91	4181.37	493.0
2014-05-02 06:00:00	NQ	Futures	4181.08	4183.7	4178.46	4179.33	1438.0
2014-05-02 07:00:00	NQ	Futures	4179.33	4181.66	4178.75	4181.08	1064.0
2014-05-02 08:00:00	NQ	Futures	4180.79	4198.84	4178.46	4181.66	22541.0
2014-05-02 09:00:00	NQ	Futures	4181.37	4197.97	4167.97	4176.42	62547.0
2014-05-02 10:00:00	NQ	Futures	4176.42	4190.98	4158.07	4164.77	71685.0
2014-05-02 11:00:00	NQ	Futures	4165.06	4185.45	4163.31	4182.24	39717.0
2014-05-02 12:00:00	NQ	Futures	4182.53	4185.16	4175.84	4180.2	12734.0
2014-05-02 13:00:00	NQ	Futures	4180.5	4182.83	4167.1	4167.68	19375.0
2014-05-02 14:00:00	NQ	Futures	4167.39	4175.84	4164.48	4171.76	21849.0
2014-05-02 15:00:00	NQ	Futures	4171.76	4179.91	4167.1	4167.97	31157.0
2014-05-02 16:00:00	NQ	Futures	4167.68	4170.59	4167.1	4169.14	5295.0
2014-05-02 17:00:00	NQ	Futures	4168.56	4169.14	4165.35	4165.35	248.0
2014-05-02 00:00:00	YM	Futures	16983.4	16984.4	16973.1	16976.2	520.0
2014-05-02 01:00:00	YM	Futures	16977.2	16991.7	16977.2	16988.6	653.0
2014-05-02 02:00:00	YM	Futures	16986.5	16992.7	16981.4	16987.5	775.0
2014-05-02 03:00:00	YM	Futures	16987.5	16992.7	16978.3	16990.6	2734.0
2014-05-02 04:00:00	YM	Futures	16991.7	16995.8	16988.6	16993.7	1150.0
2014-05-02 05:00:00	YM	Futures	16994.7	16995.8	16987.5	16992.7	753.0
2014-05-02 06:00:00	YM	Futures	16993.7	16997.8	16982.4	16984.4	1101.0
2014-05-02 07:00:00	YM	Futures	16984.4	16990.6	16983.4	16990.6	1246.0
2014-05-02 08:00:00	YM	Futures	16989.6	17043.1	16955.6	16963.8	18260.0
2014-05-02 09:00:00	YM	Futures	16963.8	17027.7	16959.7	17013.3	27875.0
2014-05-02 10:00:00	YM	Futures	17014.3	17044.2	16940.2	16955.6	38802.0
2014-05-02 11:00:00	YM	Futures	16955.6	16986.5	16942.2	16977.2	19609.0
2014-05-02 12:00:00	YM	Futures	16976.2	16979.3	16960.8	16968.0	6744.0
2014-05-02 13:00:00	YM	Futures	16966.9	16976.2	16927.8	16929.9	9980.0

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

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