PREVIEW / futures_1hour / 2014-02-26

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-02-26.parquet
  size:    50 KB
  rows:    1,553

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-02-26 00:00:00	ES	Futures	1915.33	1915.84	1914.81	1915.33	4074.0
2014-02-26 01:00:00	ES	Futures	1915.07	1916.62	1914.55	1916.1	4402.0
2014-02-26 02:00:00	ES	Futures	1916.36	1916.88	1915.33	1916.62	7353.0
2014-02-26 03:00:00	ES	Futures	1916.62	1917.4	1914.03	1914.29	25514.0
2014-02-26 04:00:00	ES	Futures	1914.03	1915.07	1912.48	1913.52	18935.0
2014-02-26 05:00:00	ES	Futures	1913.26	1914.81	1913.26	1914.29	9478.0
2014-02-26 06:00:00	ES	Futures	1914.29	1914.81	1913.26	1913.26	13239.0
2014-02-26 07:00:00	ES	Futures	1913.52	1914.29	1911.45	1913.26	20816.0
2014-02-26 08:00:00	ES	Futures	1913.0	1913.52	1911.45	1912.22	22138.0
2014-02-26 09:00:00	ES	Futures	1912.22	1912.74	1903.95	1904.98	201092.0
2014-02-26 10:00:00	ES	Futures	1905.24	1915.07	1904.98	1911.45	288912.0
2014-02-26 11:00:00	ES	Futures	1911.45	1914.81	1909.9	1911.45	121324.0
2014-02-26 12:00:00	ES	Futures	1911.45	1914.29	1911.19	1912.74	77763.0
2014-02-26 13:00:00	ES	Futures	1912.48	1914.03	1909.64	1910.41	94591.0
2014-02-26 14:00:00	ES	Futures	1910.41	1911.45	1901.62	1906.02	219328.0
2014-02-26 15:00:00	ES	Futures	1906.02	1908.09	1901.88	1907.05	226953.0
2014-02-26 16:00:00	ES	Futures	1907.05	1907.31	1904.98	1906.53	63193.0
2014-02-26 17:00:00	ES	Futures	1906.53	1908.86	1906.53	1908.09	5036.0
2014-02-26 18:00:00	ES	Futures	1907.57	1908.34	1906.27	1907.05	4033.0
2014-02-26 19:00:00	ES	Futures	1907.05	1908.09	1905.76	1907.31	4961.0
2014-02-26 20:00:00	ES	Futures	1907.57	1909.9	1906.27	1909.64	6144.0
2014-02-26 21:00:00	ES	Futures	1909.38	1910.67	1909.12	1909.38	6078.0
2014-02-26 22:00:00	ES	Futures	1909.38	1910.93	1908.34	1910.41	3876.0
2014-02-26 23:00:00	ES	Futures	1910.41	1910.67	1909.12	1909.38	2067.0
2014-02-26 00:00:00	NQ	Futures	4298.06	4299.23	4296.9	4298.06	371.0
2014-02-26 01:00:00	NQ	Futures	4297.77	4300.68	4296.03	4299.81	508.0
2014-02-26 02:00:00	NQ	Futures	4299.81	4301.55	4297.77	4300.97	683.0
2014-02-26 03:00:00	NQ	Futures	4300.97	4302.13	4295.16	4295.74	2445.0
2014-02-26 04:00:00	NQ	Futures	4296.03	4298.06	4293.41	4295.16	1804.0
2014-02-26 05:00:00	NQ	Futures	4295.16	4299.52	4295.16	4296.03	1415.0
2014-02-26 06:00:00	NQ	Futures	4296.32	4298.06	4294.29	4294.87	1070.0
2014-02-26 07:00:00	NQ	Futures	4294.58	4296.9	4291.09	4294.58	1997.0
2014-02-26 08:00:00	NQ	Futures	4294.87	4297.19	4292.25	4293.7	3516.0
2014-02-26 09:00:00	NQ	Futures	4293.99	4298.65	4276.84	4279.75	36202.0
2014-02-26 10:00:00	NQ	Futures	4279.75	4303.01	4279.75	4293.99	52745.0
2014-02-26 11:00:00	NQ	Futures	4294.29	4304.75	4293.41	4296.61	24470.0
2014-02-26 12:00:00	NQ	Futures	4296.9	4301.84	4294.58	4297.19	16090.0
2014-02-26 13:00:00	NQ	Futures	4297.19	4297.48	4286.15	4287.31	17345.0
2014-02-26 14:00:00	NQ	Futures	4287.02	4288.76	4258.53	4271.61	50472.0
2014-02-26 15:00:00	NQ	Futures	4271.32	4275.39	4262.02	4275.1	48760.0
2014-02-26 16:00:00	NQ	Futures	4275.1	4277.14	4271.32	4276.84	5880.0
2014-02-26 17:00:00	NQ	Futures	4276.84	4280.91	4276.84	4280.91	482.0
2014-02-26 18:00:00	NQ	Futures	4279.17	4280.62	4276.55	4278.88	453.0
2014-02-26 19:00:00	NQ	Futures	4279.17	4280.62	4275.39	4279.17	537.0
2014-02-26 20:00:00	NQ	Futures	4279.17	4284.69	4277.43	4284.11	829.0
2014-02-26 21:00:00	NQ	Futures	4283.82	4286.44	4283.53	4284.11	585.0
2014-02-26 22:00:00	NQ	Futures	4284.11	4288.18	4281.2	4286.44	634.0
2014-02-26 23:00:00	NQ	Futures	4286.73	4286.73	4283.82	4283.82	436.0
2014-02-26 00:00:00	YM	Futures	16632.0	16640.2	16630.0	16634.1	621.0
2014-02-26 01:00:00	YM	Futures	16633.1	16646.4	16629.0	16644.3	376.0

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

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