PREVIEW / futures_1hour / 2014-03-13

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-03-13.parquet
  size:    51 KB
  rows:    1,548

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-13 00:00:00	ES	Futures	1937.83	1938.61	1937.05	1938.35	2407.0
2014-03-13 01:00:00	ES	Futures	1938.09	1939.38	1935.24	1937.31	7222.0
2014-03-13 02:00:00	ES	Futures	1937.31	1937.57	1934.99	1935.24	6102.0
2014-03-13 03:00:00	ES	Futures	1935.24	1937.05	1933.69	1936.02	11448.0
2014-03-13 04:00:00	ES	Futures	1936.02	1936.28	1932.66	1936.02	29766.0
2014-03-13 05:00:00	ES	Futures	1936.28	1938.61	1935.76	1937.05	19622.0
2014-03-13 06:00:00	ES	Futures	1937.05	1938.61	1935.5	1936.02	17131.0
2014-03-13 07:00:00	ES	Futures	1935.76	1937.05	1934.99	1936.28	14180.0
2014-03-13 08:00:00	ES	Futures	1936.28	1938.09	1934.99	1936.54	31535.0
2014-03-13 09:00:00	ES	Futures	1936.54	1939.9	1934.73	1936.02	150608.0
2014-03-13 10:00:00	ES	Futures	1935.76	1937.05	1928.26	1928.78	208898.0
2014-03-13 11:00:00	ES	Futures	1928.78	1931.11	1924.12	1924.64	218823.0
2014-03-13 12:00:00	ES	Futures	1924.9	1925.93	1915.33	1916.1	271745.0
2014-03-13 13:00:00	ES	Futures	1916.36	1917.4	1909.38	1914.81	295833.0
2014-03-13 14:00:00	ES	Futures	1914.81	1915.59	1908.6	1910.15	179785.0
2014-03-13 15:00:00	ES	Futures	1910.15	1912.48	1905.24	1910.93	280309.0
2014-03-13 16:00:00	ES	Futures	1910.93	1913.26	1909.9	1911.96	69796.0
2014-03-13 17:00:00	ES	Futures	1911.71	1911.96	1911.45	1911.96	1418.0
2014-03-13 18:00:00	ES	Futures	1911.19	1912.48	1910.15	1912.22	4771.0
2014-03-13 19:00:00	ES	Futures	1912.22	1912.74	1910.15	1911.96	3492.0
2014-03-13 20:00:00	ES	Futures	1911.96	1913.78	1911.45	1912.74	6423.0
2014-03-13 21:00:00	ES	Futures	1912.74	1914.81	1912.48	1914.81	6024.0
2014-03-13 22:00:00	ES	Futures	1914.81	1914.81	1913.26	1913.52	3245.0
2014-03-13 23:00:00	ES	Futures	1913.26	1914.03	1911.19	1913.52	5534.0
2014-03-13 00:00:00	NQ	Futures	4323.35	4324.52	4321.32	4324.23	470.0
2014-03-13 01:00:00	NQ	Futures	4323.94	4325.68	4317.25	4321.9	923.0
2014-03-13 02:00:00	NQ	Futures	4321.9	4322.19	4316.96	4318.12	514.0
2014-03-13 03:00:00	NQ	Futures	4318.12	4321.61	4314.92	4319.87	1148.0
2014-03-13 04:00:00	NQ	Futures	4319.58	4321.03	4312.31	4320.74	3787.0
2014-03-13 05:00:00	NQ	Futures	4320.74	4326.55	4320.74	4323.94	2509.0
2014-03-13 06:00:00	NQ	Futures	4324.23	4326.84	4319.28	4320.74	2166.0
2014-03-13 07:00:00	NQ	Futures	4320.45	4322.48	4318.41	4320.16	2692.0
2014-03-13 08:00:00	NQ	Futures	4320.16	4326.55	4318.12	4322.48	6475.0
2014-03-13 09:00:00	NQ	Futures	4322.48	4328.01	4313.47	4321.9	39024.0
2014-03-13 10:00:00	NQ	Futures	4322.19	4326.26	4296.03	4298.06	48401.0
2014-03-13 11:00:00	NQ	Futures	4298.36	4302.72	4283.82	4287.31	44481.0
2014-03-13 12:00:00	NQ	Futures	4287.6	4289.93	4257.66	4260.57	46397.0
2014-03-13 13:00:00	NQ	Futures	4260.28	4260.86	4236.44	4248.94	64745.0
2014-03-13 14:00:00	NQ	Futures	4248.94	4254.17	4238.18	4241.67	40702.0
2014-03-13 15:00:00	NQ	Futures	4241.67	4248.07	4228.01	4247.49	55324.0
2014-03-13 16:00:00	NQ	Futures	4247.49	4254.46	4243.42	4249.52	7709.0
2014-03-13 17:00:00	NQ	Futures	4249.52	4251.55	4249.23	4250.97	195.0
2014-03-13 18:00:00	NQ	Futures	4250.68	4251.85	4246.03	4251.26	407.0
2014-03-13 19:00:00	NQ	Futures	4250.97	4251.85	4246.9	4248.94	401.0
2014-03-13 20:00:00	NQ	Futures	4249.23	4253.88	4248.65	4252.14	306.0
2014-03-13 21:00:00	NQ	Futures	4251.85	4256.5	4250.97	4256.21	466.0
2014-03-13 22:00:00	NQ	Futures	4256.21	4256.79	4252.14	4252.14	327.0
2014-03-13 23:00:00	NQ	Futures	4252.43	4253.3	4248.07	4252.14	552.0
2014-03-13 00:00:00	YM	Futures	16801.1	16803.2	16798.0	16802.2	20.0
2014-03-13 01:00:00	YM	Futures	16802.2	16811.4	16777.4	16798.0	82.0

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

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