PREVIEW / futures_1hour / 2014-04-08

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-04-08.parquet
  size:    50 KB
  rows:    1,558

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-04-08 00:00:00	ES	Futures	1913.26	1913.78	1912.22	1913.26	2725.0
2014-04-08 01:00:00	ES	Futures	1913.26	1914.04	1912.74	1912.74	4949.0
2014-04-08 02:00:00	ES	Futures	1912.74	1914.82	1911.96	1914.3	14411.0
2014-04-08 03:00:00	ES	Futures	1914.04	1914.56	1911.18	1912.48	24051.0
2014-04-08 04:00:00	ES	Futures	1912.48	1913.0	1910.4	1910.4	16640.0
2014-04-08 05:00:00	ES	Futures	1910.66	1911.44	1908.32	1908.84	23672.0
2014-04-08 06:00:00	ES	Futures	1909.1	1909.62	1905.47	1906.51	30080.0
2014-04-08 07:00:00	ES	Futures	1906.25	1907.8	1904.17	1905.99	35095.0
2014-04-08 08:00:00	ES	Futures	1905.99	1911.18	1905.99	1909.88	47068.0
2014-04-08 09:00:00	ES	Futures	1910.14	1913.78	1906.51	1908.32	261939.0
2014-04-08 10:00:00	ES	Futures	1908.06	1913.0	1901.57	1911.44	415806.0
2014-04-08 11:00:00	ES	Futures	1911.7	1918.19	1911.7	1916.11	296507.0
2014-04-08 12:00:00	ES	Futures	1916.37	1917.93	1913.78	1913.78	138452.0
2014-04-08 13:00:00	ES	Futures	1914.04	1920.53	1913.78	1919.23	118706.0
2014-04-08 14:00:00	ES	Futures	1918.97	1919.49	1912.22	1915.33	147180.0
2014-04-08 15:00:00	ES	Futures	1915.07	1918.97	1912.74	1917.15	179549.0
2014-04-08 16:00:00	ES	Futures	1917.15	1917.93	1915.59	1916.37	67088.0
2014-04-08 17:00:00	ES	Futures	1916.37	1916.63	1916.11	1916.11	2262.0
2014-04-08 18:00:00	ES	Futures	1916.37	1916.89	1916.11	1916.63	2310.0
2014-04-08 19:00:00	ES	Futures	1916.89	1917.41	1916.63	1917.15	2832.0
2014-04-08 20:00:00	ES	Futures	1917.41	1918.45	1915.59	1916.11	7185.0
2014-04-08 21:00:00	ES	Futures	1916.11	1917.93	1915.07	1917.15	5502.0
2014-04-08 22:00:00	ES	Futures	1917.41	1917.67	1915.85	1916.63	2799.0
2014-04-08 23:00:00	ES	Futures	1916.37	1918.19	1915.59	1916.11	3635.0
2014-04-08 00:00:00	NQ	Futures	4084.68	4085.27	4081.19	4084.1	517.0
2014-04-08 01:00:00	NQ	Futures	4084.39	4086.14	4082.65	4083.81	670.0
2014-04-08 02:00:00	NQ	Futures	4083.52	4088.76	4082.06	4088.18	1426.0
2014-04-08 03:00:00	NQ	Futures	4087.89	4089.34	4078.86	4084.97	3634.0
2014-04-08 04:00:00	NQ	Futures	4084.68	4087.01	4082.06	4082.06	2801.0
2014-04-08 05:00:00	NQ	Futures	4082.06	4085.27	4077.4	4077.99	3588.0
2014-04-08 06:00:00	NQ	Futures	4078.28	4080.9	4071.0	4073.33	5427.0
2014-04-08 07:00:00	NQ	Futures	4073.03	4078.28	4068.96	4073.03	5972.0
2014-04-08 08:00:00	NQ	Futures	4073.33	4089.34	4073.33	4084.1	10537.0
2014-04-08 09:00:00	NQ	Futures	4084.1	4100.7	4069.25	4081.19	89558.0
2014-04-08 10:00:00	NQ	Futures	4081.19	4109.15	4066.05	4103.61	93172.0
2014-04-08 11:00:00	NQ	Futures	4103.61	4119.05	4098.66	4107.69	60985.0
2014-04-08 12:00:00	NQ	Futures	4107.69	4117.88	4102.74	4108.86	22768.0
2014-04-08 13:00:00	NQ	Futures	4108.86	4117.01	4105.36	4114.97	24032.0
2014-04-08 14:00:00	NQ	Futures	4114.68	4116.43	4097.79	4107.98	31490.0
2014-04-08 15:00:00	NQ	Futures	4107.69	4119.05	4103.61	4113.81	33709.0
2014-04-08 16:00:00	NQ	Futures	4114.39	4114.97	4109.73	4110.31	4664.0
2014-04-08 17:00:00	NQ	Futures	4110.89	4110.89	4110.02	4110.31	168.0
2014-04-08 18:00:00	NQ	Futures	4110.6	4111.77	4110.31	4110.89	281.0
2014-04-08 19:00:00	NQ	Futures	4111.18	4113.22	4110.89	4112.64	212.0
2014-04-08 20:00:00	NQ	Futures	4112.64	4115.55	4109.15	4110.02	802.0
2014-04-08 21:00:00	NQ	Futures	4110.02	4112.93	4107.69	4112.06	668.0
2014-04-08 22:00:00	NQ	Futures	4112.35	4112.93	4109.73	4110.6	264.0
2014-04-08 23:00:00	NQ	Futures	4110.89	4114.68	4110.02	4110.6	426.0
2014-04-08 00:00:00	YM	Futures	16690.9	16693.0	16682.7	16686.8	408.0
2014-04-08 01:00:00	YM	Futures	16686.8	16696.1	16685.8	16687.8	417.0

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

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