PREVIEW / futures_1hour / 2014-04-07

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-04-07.parquet
  size:    49 KB
  rows:    1,532

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-07 00:00:00	ES	Futures	1930.4	1930.66	1929.1	1929.1	2335.0
2014-04-07 01:00:00	ES	Futures	1929.1	1929.36	1927.8	1928.06	5766.0
2014-04-07 02:00:00	ES	Futures	1928.06	1928.58	1923.38	1925.46	28578.0
2014-04-07 03:00:00	ES	Futures	1925.46	1927.02	1922.61	1923.12	35929.0
2014-04-07 04:00:00	ES	Futures	1923.12	1925.72	1923.12	1924.16	20669.0
2014-04-07 05:00:00	ES	Futures	1924.16	1927.54	1923.9	1925.2	16816.0
2014-04-07 06:00:00	ES	Futures	1924.94	1926.5	1923.64	1925.2	20967.0
2014-04-07 07:00:00	ES	Futures	1925.46	1925.72	1921.83	1924.16	32641.0
2014-04-07 08:00:00	ES	Futures	1924.16	1927.28	1923.64	1925.98	43387.0
2014-04-07 09:00:00	ES	Futures	1926.24	1927.28	1918.71	1926.76	321715.0
2014-04-07 10:00:00	ES	Futures	1926.76	1929.36	1917.93	1919.49	369328.0
2014-04-07 11:00:00	ES	Futures	1919.75	1922.61	1914.04	1914.04	233351.0
2014-04-07 12:00:00	ES	Futures	1914.04	1915.85	1909.88	1913.78	234982.0
2014-04-07 13:00:00	ES	Futures	1913.78	1914.04	1907.28	1908.06	191623.0
2014-04-07 14:00:00	ES	Futures	1908.32	1915.07	1905.47	1913.0	220908.0
2014-04-07 15:00:00	ES	Futures	1913.26	1917.41	1908.84	1909.1	263455.0
2014-04-07 16:00:00	ES	Futures	1909.36	1910.4	1908.58	1910.14	95263.0
2014-04-07 17:00:00	ES	Futures	1910.4	1910.92	1910.14	1910.66	3083.0
2014-04-07 18:00:00	ES	Futures	1911.18	1912.48	1910.92	1912.48	4217.0
2014-04-07 19:00:00	ES	Futures	1912.48	1912.74	1911.96	1912.22	2476.0
2014-04-07 20:00:00	ES	Futures	1912.48	1912.74	1910.4	1911.44	5474.0
2014-04-07 21:00:00	ES	Futures	1911.18	1913.26	1910.92	1913.0	4796.0
2014-04-07 22:00:00	ES	Futures	1913.0	1913.78	1911.96	1913.52	3921.0
2014-04-07 23:00:00	ES	Futures	1913.52	1914.3	1912.74	1913.26	4216.0
2014-04-07 00:00:00	NQ	Futures	4114.39	4115.26	4111.48	4112.06	350.0
2014-04-07 01:00:00	NQ	Futures	4112.06	4112.06	4107.69	4107.98	901.0
2014-04-07 02:00:00	NQ	Futures	4107.98	4109.44	4093.71	4098.66	4002.0
2014-04-07 03:00:00	NQ	Futures	4099.24	4102.74	4086.43	4087.89	8041.0
2014-04-07 04:00:00	NQ	Futures	4087.6	4094.59	4087.3	4090.22	3341.0
2014-04-07 05:00:00	NQ	Futures	4090.51	4098.95	4089.63	4089.93	3441.0
2014-04-07 06:00:00	NQ	Futures	4089.93	4095.17	4088.47	4093.13	2766.0
2014-04-07 07:00:00	NQ	Futures	4093.42	4093.42	4083.52	4087.89	6411.0
2014-04-07 08:00:00	NQ	Futures	4087.89	4095.17	4085.56	4091.09	13169.0
2014-04-07 09:00:00	NQ	Futures	4091.09	4113.81	4075.95	4113.81	88526.0
2014-04-07 10:00:00	NQ	Futures	4113.81	4126.91	4088.76	4097.5	108892.0
2014-04-07 11:00:00	NQ	Futures	4097.79	4109.44	4079.15	4080.02	54851.0
2014-04-07 12:00:00	NQ	Futures	4079.44	4087.89	4066.05	4079.15	52221.0
2014-04-07 13:00:00	NQ	Futures	4079.15	4081.19	4057.89	4060.51	38751.0
2014-04-07 14:00:00	NQ	Futures	4060.8	4084.97	4047.41	4078.28	53310.0
2014-04-07 15:00:00	NQ	Futures	4077.99	4101.28	4074.49	4076.53	58152.0
2014-04-07 16:00:00	NQ	Futures	4076.24	4078.57	4073.91	4077.4	7302.0
2014-04-07 17:00:00	NQ	Futures	4077.4	4078.28	4077.11	4077.69	443.0
2014-04-07 18:00:00	NQ	Futures	4079.15	4082.35	4078.28	4082.06	806.0
2014-04-07 19:00:00	NQ	Futures	4081.77	4082.35	4080.9	4081.19	652.0
2014-04-07 20:00:00	NQ	Futures	4081.48	4082.35	4077.11	4079.73	619.0
2014-04-07 21:00:00	NQ	Futures	4079.15	4082.94	4077.99	4082.65	1095.0
2014-04-07 22:00:00	NQ	Futures	4082.65	4084.68	4080.61	4084.1	719.0
2014-04-07 23:00:00	NQ	Futures	4084.1	4087.01	4083.23	4084.97	1184.0
2014-04-07 00:00:00	YM	Futures	16833.1	16835.1	16824.8	16824.8	800.0
2014-04-07 01:00:00	YM	Futures	16824.8	16825.8	16816.6	16816.6	527.0

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

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