PREVIEW / futures_1hour / 2014-04-15

all futures 1-hour files

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

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-15 00:00:00	ES	Futures	1895.86	1896.38	1895.6	1896.12	2492.0
2014-04-15 01:00:00	ES	Futures	1895.86	1896.38	1895.08	1895.86	3748.0
2014-04-15 02:00:00	ES	Futures	1895.86	1897.42	1895.08	1895.86	8186.0
2014-04-15 03:00:00	ES	Futures	1895.6	1897.16	1893.78	1895.34	29062.0
2014-04-15 04:00:00	ES	Futures	1895.6	1895.6	1892.74	1893.78	20732.0
2014-04-15 05:00:00	ES	Futures	1893.78	1895.08	1892.22	1894.3	17428.0
2014-04-15 06:00:00	ES	Futures	1894.3	1897.42	1893.78	1896.12	19840.0
2014-04-15 07:00:00	ES	Futures	1896.12	1900.01	1895.08	1899.49	37659.0
2014-04-15 08:00:00	ES	Futures	1899.49	1901.57	1897.42	1899.24	60892.0
2014-04-15 09:00:00	ES	Futures	1898.98	1908.32	1896.38	1906.25	283759.0
2014-04-15 10:00:00	ES	Futures	1905.99	1907.8	1890.41	1892.22	476201.0
2014-04-15 11:00:00	ES	Futures	1892.22	1896.38	1884.95	1887.03	399402.0
2014-04-15 12:00:00	ES	Futures	1887.03	1887.03	1880.54	1880.8	247915.0
2014-04-15 13:00:00	ES	Futures	1880.8	1894.82	1879.24	1894.04	260763.0
2014-04-15 14:00:00	ES	Futures	1894.04	1905.73	1893.52	1902.35	295747.0
2014-04-15 15:00:00	ES	Futures	1902.61	1908.84	1899.75	1907.54	284388.0
2014-04-15 16:00:00	ES	Futures	1907.8	1914.56	1907.54	1914.3	130839.0
2014-04-15 17:00:00	ES	Futures	1914.3	1915.33	1914.04	1914.3	4565.0
2014-04-15 18:00:00	ES	Futures	1914.04	1914.56	1912.48	1912.74	6347.0
2014-04-15 19:00:00	ES	Futures	1912.48	1913.0	1911.96	1912.22	3318.0
2014-04-15 20:00:00	ES	Futures	1912.22	1913.78	1911.7	1912.74	6401.0
2014-04-15 21:00:00	ES	Futures	1912.74	1915.33	1911.96	1915.33	7075.0
2014-04-15 22:00:00	ES	Futures	1915.33	1917.41	1914.82	1916.63	10472.0
2014-04-15 23:00:00	ES	Futures	1916.89	1917.15	1916.37	1916.63	2345.0
2014-04-15 00:00:00	NQ	Futures	4044.49	4046.82	4044.2	4045.08	710.0
2014-04-15 01:00:00	NQ	Futures	4045.08	4045.66	4042.17	4044.2	749.0
2014-04-15 02:00:00	NQ	Futures	4044.2	4048.86	4042.46	4044.49	1294.0
2014-04-15 03:00:00	NQ	Futures	4044.49	4048.86	4039.84	4044.49	5186.0
2014-04-15 04:00:00	NQ	Futures	4044.79	4045.08	4037.21	4040.71	3420.0
2014-04-15 05:00:00	NQ	Futures	4040.42	4043.62	4036.63	4041.58	1973.0
2014-04-15 06:00:00	NQ	Futures	4041.29	4050.03	4040.71	4046.82	3691.0
2014-04-15 07:00:00	NQ	Futures	4046.82	4055.85	4044.79	4055.27	5207.0
2014-04-15 08:00:00	NQ	Futures	4054.98	4060.51	4047.41	4053.52	13970.0
2014-04-15 09:00:00	NQ	Futures	4053.23	4075.36	4043.33	4061.09	63639.0
2014-04-15 10:00:00	NQ	Futures	4060.8	4068.38	4002.85	4007.51	119853.0
2014-04-15 11:00:00	NQ	Futures	4007.22	4019.74	3985.67	3991.2	99390.0
2014-04-15 12:00:00	NQ	Futures	3991.2	3994.7	3968.19	3969.36	57694.0
2014-04-15 13:00:00	NQ	Futures	3969.36	4015.37	3966.16	4012.17	62339.0
2014-04-15 14:00:00	NQ	Futures	4012.17	4052.07	4009.84	4041.58	64909.0
2014-04-15 15:00:00	NQ	Futures	4041.29	4060.51	4031.39	4051.19	68632.0
2014-04-15 16:00:00	NQ	Futures	4051.19	4078.28	4048.57	4076.24	19835.0
2014-04-15 17:00:00	NQ	Futures	4076.53	4078.28	4075.36	4076.82	475.0
2014-04-15 18:00:00	NQ	Futures	4074.49	4075.66	4072.45	4072.74	1139.0
2014-04-15 19:00:00	NQ	Futures	4072.45	4073.62	4071.87	4072.45	625.0
2014-04-15 20:00:00	NQ	Futures	4072.45	4076.24	4071.87	4074.49	1122.0
2014-04-15 21:00:00	NQ	Futures	4073.62	4082.06	4073.03	4081.77	1734.0
2014-04-15 22:00:00	NQ	Futures	4081.77	4087.6	4080.9	4085.85	2690.0
2014-04-15 23:00:00	NQ	Futures	4085.85	4086.72	4082.65	4083.81	556.0
2014-04-15 00:00:00	YM	Futures	16579.7	16584.9	16577.6	16580.7	216.0
2014-04-15 01:00:00	YM	Futures	16579.7	16582.8	16572.5	16578.7	369.0

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

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