PREVIEW / futures_1hour / 2014-03-17

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-03-17.parquet
  size:    49 KB
  rows:    1,497

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-03-17 00:00:00	ES	Futures	1904.43	1904.69	1902.09	1902.61	1773.0
2014-03-17 01:00:00	ES	Futures	1902.61	1903.39	1901.31	1902.87	4813.0
2014-03-17 02:00:00	ES	Futures	1902.61	1904.95	1902.61	1904.95	4963.0
2014-03-17 03:00:00	ES	Futures	1904.95	1908.32	1904.69	1906.51	15140.0
2014-03-17 04:00:00	ES	Futures	1906.51	1915.85	1905.47	1914.82	39479.0
2014-03-17 05:00:00	ES	Futures	1915.07	1917.15	1913.0	1915.07	20571.0
2014-03-17 06:00:00	ES	Futures	1915.07	1916.11	1913.26	1913.52	17735.0
2014-03-17 07:00:00	ES	Futures	1913.26	1915.07	1912.48	1913.78	25046.0
2014-03-17 08:00:00	ES	Futures	1913.78	1915.07	1911.18	1912.48	33799.0
2014-03-17 09:00:00	ES	Futures	1912.48	1924.94	1912.48	1923.64	208764.0
2014-03-17 10:00:00	ES	Futures	1923.38	1927.54	1918.71	1919.75	266136.0
2014-03-17 11:00:00	ES	Futures	1920.01	1923.12	1917.15	1921.83	145266.0
2014-03-17 12:00:00	ES	Futures	1922.09	1925.72	1920.79	1923.38	120991.0
2014-03-17 13:00:00	ES	Futures	1923.12	1924.42	1920.79	1923.12	59978.0
2014-03-17 14:00:00	ES	Futures	1923.12	1926.24	1921.57	1924.42	82232.0
2014-03-17 15:00:00	ES	Futures	1924.42	1925.98	1920.53	1922.61	168085.0
2014-03-17 16:00:00	ES	Futures	1922.87	1923.64	1921.31	1923.38	76646.0
2014-03-17 17:00:00	ES	Futures	1923.38	1923.9	1923.12	1923.64	1952.0
2014-03-17 18:00:00	ES	Futures	1923.38	1924.42	1923.12	1923.9	2759.0
2014-03-17 19:00:00	ES	Futures	1924.16	1924.16	1922.87	1923.12	2093.0
2014-03-17 20:00:00	ES	Futures	1922.87	1923.12	1920.79	1921.57	5482.0
2014-03-17 21:00:00	ES	Futures	1921.31	1921.83	1920.79	1921.05	2381.0
2014-03-17 22:00:00	ES	Futures	1921.05	1924.68	1920.79	1924.16	6154.0
2014-03-17 23:00:00	ES	Futures	1923.9	1925.72	1923.9	1924.42	3532.0
2014-03-17 00:00:00	NQ	Futures	4217.48	4218.06	4212.82	4213.99	397.0
2014-03-17 01:00:00	NQ	Futures	4214.28	4216.9	4212.82	4215.73	943.0
2014-03-17 02:00:00	NQ	Futures	4215.73	4221.27	4215.44	4220.1	972.0
2014-03-17 03:00:00	NQ	Futures	4220.39	4227.67	4220.39	4224.47	1982.0
2014-03-17 04:00:00	NQ	Futures	4224.18	4245.73	4222.43	4245.15	6067.0
2014-03-17 05:00:00	NQ	Futures	4245.44	4252.43	4242.82	4247.48	3504.0
2014-03-17 06:00:00	NQ	Futures	4247.19	4250.39	4243.69	4243.98	2703.0
2014-03-17 07:00:00	NQ	Futures	4243.69	4246.02	4240.78	4241.36	4259.0
2014-03-17 08:00:00	NQ	Futures	4241.36	4243.69	4237.58	4239.03	8957.0
2014-03-17 09:00:00	NQ	Futures	4239.03	4271.65	4239.03	4267.28	47723.0
2014-03-17 10:00:00	NQ	Futures	4266.7	4278.64	4253.59	4260.87	50848.0
2014-03-17 11:00:00	NQ	Futures	4260.87	4268.44	4251.55	4265.24	26716.0
2014-03-17 12:00:00	NQ	Futures	4265.53	4275.14	4261.46	4270.77	23902.0
2014-03-17 13:00:00	NQ	Futures	4270.77	4273.69	4264.66	4269.03	13911.0
2014-03-17 14:00:00	NQ	Futures	4269.32	4274.56	4264.37	4268.44	15023.0
2014-03-17 15:00:00	NQ	Futures	4268.44	4269.9	4253.88	4255.92	38383.0
2014-03-17 16:00:00	NQ	Futures	4255.92	4256.5	4251.26	4256.21	8809.0
2014-03-17 17:00:00	NQ	Futures	4256.21	4257.09	4255.92	4256.5	251.0
2014-03-17 18:00:00	NQ	Futures	4256.21	4258.54	4255.92	4257.96	403.0
2014-03-17 19:00:00	NQ	Futures	4257.67	4258.25	4254.47	4255.05	236.0
2014-03-17 20:00:00	NQ	Futures	4255.05	4255.34	4249.52	4251.26	582.0
2014-03-17 21:00:00	NQ	Futures	4251.55	4252.43	4250.39	4250.97	325.0
2014-03-17 22:00:00	NQ	Futures	4250.68	4258.83	4250.39	4257.67	1013.0
2014-03-17 23:00:00	NQ	Futures	4257.67	4262.04	4257.38	4258.83	493.0
2014-03-17 00:00:00	YM	Futures	16470.5	16472.6	16451.0	16456.1	325.0
2014-03-17 01:00:00	YM	Futures	16456.1	16465.4	16451.0	16461.3	860.0

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

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