PREVIEW / futures_1hour / 2014-03-28

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-03-28.parquet
  size:    42 KB
  rows:    1,252

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-28 00:00:00	ES	Futures	1915.59	1916.37	1914.82	1916.11	2544.0
2014-03-28 01:00:00	ES	Futures	1916.11	1916.37	1915.33	1916.11	3811.0
2014-03-28 02:00:00	ES	Futures	1915.85	1916.37	1914.04	1914.82	2892.0
2014-03-28 03:00:00	ES	Futures	1914.82	1916.37	1914.3	1916.11	6764.0
2014-03-28 04:00:00	ES	Futures	1916.11	1918.71	1915.07	1917.67	19700.0
2014-03-28 05:00:00	ES	Futures	1917.67	1918.97	1917.41	1918.19	14588.0
2014-03-28 06:00:00	ES	Futures	1918.19	1918.97	1916.63	1916.89	16503.0
2014-03-28 07:00:00	ES	Futures	1917.15	1918.19	1915.07	1917.67	19162.0
2014-03-28 08:00:00	ES	Futures	1917.93	1919.23	1915.07	1916.89	26537.0
2014-03-28 09:00:00	ES	Futures	1916.63	1927.54	1915.85	1926.76	265051.0
2014-03-28 10:00:00	ES	Futures	1926.5	1931.43	1926.24	1930.66	267265.0
2014-03-28 11:00:00	ES	Futures	1930.4	1930.91	1924.94	1927.8	159815.0
2014-03-28 12:00:00	ES	Futures	1927.8	1929.1	1925.98	1926.5	83902.0
2014-03-28 13:00:00	ES	Futures	1926.5	1927.02	1922.09	1923.12	123497.0
2014-03-28 14:00:00	ES	Futures	1923.38	1923.38	1916.37	1920.27	203125.0
2014-03-28 15:00:00	ES	Futures	1920.27	1921.31	1917.15	1921.05	162767.0
2014-03-28 16:00:00	ES	Futures	1920.79	1922.35	1919.75	1921.57	93483.0
2014-03-28 17:00:00	ES	Futures	1921.83	1921.83	1921.31	1921.57	2006.0
2014-03-28 00:00:00	NQ	Futures	4147.01	4149.33	4145.26	4148.46	499.0
2014-03-28 01:00:00	NQ	Futures	4147.88	4149.33	4147.3	4149.33	468.0
2014-03-28 02:00:00	NQ	Futures	4149.33	4149.92	4144.68	4146.13	416.0
2014-03-28 03:00:00	NQ	Futures	4146.42	4151.96	4144.68	4151.66	1268.0
2014-03-28 04:00:00	NQ	Futures	4151.08	4158.65	4148.75	4156.62	2772.0
2014-03-28 05:00:00	NQ	Futures	4156.91	4161.86	4155.74	4160.98	2953.0
2014-03-28 06:00:00	NQ	Futures	4160.98	4162.15	4154.87	4156.32	3406.0
2014-03-28 07:00:00	NQ	Futures	4156.32	4158.36	4151.66	4157.78	3976.0
2014-03-28 08:00:00	NQ	Futures	4157.78	4162.44	4151.66	4156.32	6851.0
2014-03-28 09:00:00	NQ	Futures	4156.32	4185.45	4147.3	4179.91	68510.0
2014-03-28 10:00:00	NQ	Futures	4179.91	4195.06	4179.04	4191.85	51568.0
2014-03-28 11:00:00	NQ	Futures	4191.56	4191.85	4176.42	4183.12	30853.0
2014-03-28 12:00:00	NQ	Futures	4183.12	4186.9	4172.92	4176.42	22048.0
2014-03-28 13:00:00	NQ	Futures	4176.13	4177.0	4161.86	4163.9	27962.0
2014-03-28 14:00:00	NQ	Futures	4163.6	4163.6	4137.1	4147.01	45697.0
2014-03-28 15:00:00	NQ	Futures	4147.01	4152.54	4140.31	4149.04	34166.0
2014-03-28 16:00:00	NQ	Futures	4149.33	4153.12	4146.71	4151.66	6047.0
2014-03-28 17:00:00	NQ	Futures	4151.08	4151.66	4150.79	4151.66	153.0
2014-03-28 00:00:00	YM	Futures	16687.8	16692.0	16679.6	16688.9	226.0
2014-03-28 01:00:00	YM	Futures	16690.9	16694.0	16683.7	16689.9	462.0
2014-03-28 02:00:00	YM	Futures	16690.9	16692.0	16673.4	16679.6	515.0
2014-03-28 03:00:00	YM	Futures	16681.7	16694.0	16676.5	16692.0	519.0
2014-03-28 04:00:00	YM	Futures	16692.0	16708.4	16682.7	16703.3	2682.0
2014-03-28 05:00:00	YM	Futures	16702.3	16715.7	16699.2	16709.5	2202.0
2014-03-28 06:00:00	YM	Futures	16709.5	16715.7	16695.1	16702.3	2099.0
2014-03-28 07:00:00	YM	Futures	16701.2	16706.4	16683.7	16702.3	2623.0
2014-03-28 08:00:00	YM	Futures	16703.3	16713.6	16684.8	16698.1	2906.0
2014-03-28 09:00:00	YM	Futures	16698.1	16804.2	16688.9	16802.2	31293.0
2014-03-28 10:00:00	YM	Futures	16802.2	16828.9	16781.6	16818.6	26745.0
2014-03-28 11:00:00	YM	Futures	16818.6	16820.7	16770.2	16792.9	14468.0
2014-03-28 12:00:00	YM	Futures	16791.9	16804.2	16773.3	16779.5	9809.0
2014-03-28 13:00:00	YM	Futures	16779.5	16782.6	16739.3	16745.5	13893.0

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

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