PREVIEW / futures_1hour / 2014-05-12

all futures 1-hour files

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

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-12 00:00:00	ES	Futures	1949.35	1950.13	1948.57	1950.13	2245.0
2014-05-12 01:00:00	ES	Futures	1950.13	1950.65	1949.35	1949.35	3475.0
2014-05-12 02:00:00	ES	Futures	1949.61	1950.39	1948.31	1948.83	7006.0
2014-05-12 03:00:00	ES	Futures	1949.09	1949.87	1948.05	1949.35	17505.0
2014-05-12 04:00:00	ES	Futures	1949.35	1950.13	1948.57	1948.83	11574.0
2014-05-12 05:00:00	ES	Futures	1948.83	1950.91	1948.57	1950.39	10099.0
2014-05-12 06:00:00	ES	Futures	1950.65	1954.29	1949.61	1954.29	21488.0
2014-05-12 07:00:00	ES	Futures	1954.03	1954.29	1952.47	1952.47	12906.0
2014-05-12 08:00:00	ES	Futures	1952.73	1953.51	1951.95	1953.25	12790.0
2014-05-12 09:00:00	ES	Futures	1953.51	1961.3	1952.73	1960.52	259225.0
2014-05-12 10:00:00	ES	Futures	1960.78	1962.85	1959.74	1960.26	215591.0
2014-05-12 11:00:00	ES	Futures	1960.26	1962.85	1960.0	1961.56	94062.0
2014-05-12 12:00:00	ES	Futures	1961.56	1964.15	1961.3	1961.56	86555.0
2014-05-12 13:00:00	ES	Futures	1961.3	1963.89	1961.04	1963.37	52231.0
2014-05-12 14:00:00	ES	Futures	1963.37	1965.19	1962.08	1964.93	70905.0
2014-05-12 15:00:00	ES	Futures	1964.67	1966.23	1963.63	1965.19	194735.0
2014-05-12 16:00:00	ES	Futures	1965.19	1967.01	1964.93	1966.75	80405.0
2014-05-12 17:00:00	ES	Futures	1966.49	1967.27	1966.49	1967.01	3951.0
2014-05-12 18:00:00	ES	Futures	1966.75	1967.01	1965.45	1966.75	4977.0
2014-05-12 19:00:00	ES	Futures	1966.49	1967.53	1966.49	1967.27	2620.0
2014-05-12 20:00:00	ES	Futures	1967.27	1968.05	1966.49	1967.79	5066.0
2014-05-12 21:00:00	ES	Futures	1967.53	1968.31	1967.27	1967.53	5729.0
2014-05-12 22:00:00	ES	Futures	1967.27	1967.53	1966.49	1967.01	2436.0
2014-05-12 23:00:00	ES	Futures	1966.75	1967.53	1966.75	1967.53	1474.0
2014-05-12 00:00:00	NQ	Futures	4141.76	4143.22	4140.6	4142.93	347.0
2014-05-12 01:00:00	NQ	Futures	4142.93	4144.97	4141.76	4142.05	517.0
2014-05-12 02:00:00	NQ	Futures	4142.05	4144.09	4139.43	4141.18	1005.0
2014-05-12 03:00:00	NQ	Futures	4141.18	4144.97	4138.56	4143.8	2857.0
2014-05-12 04:00:00	NQ	Futures	4143.51	4144.68	4141.18	4142.05	1760.0
2014-05-12 05:00:00	NQ	Futures	4142.05	4144.97	4139.72	4144.97	2062.0
2014-05-12 06:00:00	NQ	Futures	4144.97	4157.78	4142.93	4157.78	4417.0
2014-05-12 07:00:00	NQ	Futures	4157.78	4158.36	4154.58	4154.87	2989.0
2014-05-12 08:00:00	NQ	Futures	4155.16	4157.2	4152.54	4156.03	3310.0
2014-05-12 09:00:00	NQ	Futures	4156.32	4184.57	4155.16	4184.57	61998.0
2014-05-12 10:00:00	NQ	Futures	4184.57	4194.47	4180.2	4190.4	47174.0
2014-05-12 11:00:00	NQ	Futures	4190.4	4193.6	4186.61	4189.81	22103.0
2014-05-12 12:00:00	NQ	Futures	4189.81	4198.84	4189.23	4191.27	20602.0
2014-05-12 13:00:00	NQ	Futures	4190.98	4195.35	4189.81	4194.47	8953.0
2014-05-12 14:00:00	NQ	Futures	4194.47	4201.75	4190.4	4201.17	17924.0
2014-05-12 15:00:00	NQ	Futures	4201.17	4205.54	4199.43	4202.92	36884.0
2014-05-12 16:00:00	NQ	Futures	4202.92	4206.41	4201.75	4206.41	6303.0
2014-05-12 17:00:00	NQ	Futures	4206.12	4209.33	4206.12	4207.58	1091.0
2014-05-12 18:00:00	NQ	Futures	4207.0	4210.2	4202.34	4206.71	1537.0
2014-05-12 19:00:00	NQ	Futures	4206.41	4208.45	4206.12	4208.16	402.0
2014-05-12 20:00:00	NQ	Futures	4208.45	4209.04	4205.83	4208.74	790.0
2014-05-12 21:00:00	NQ	Futures	4208.45	4209.91	4206.71	4207.0	492.0
2014-05-12 22:00:00	NQ	Futures	4207.0	4207.87	4205.54	4206.71	382.0
2014-05-12 23:00:00	NQ	Futures	4206.71	4207.87	4206.41	4207.87	255.0
2014-05-12 00:00:00	YM	Futures	17047.3	17053.4	17043.1	17051.4	343.0
2014-05-12 01:00:00	YM	Futures	17050.4	17057.6	17045.2	17049.3	1176.0

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

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