PREVIEW / futures_1hour / 2014-05-16

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-05-16.parquet
  size:    42 KB
  rows:    1,282

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-05-16 00:00:00	ES	Futures	1938.45	1940.0	1938.19	1939.22	2698.0
2014-05-16 01:00:00	ES	Futures	1939.22	1939.74	1938.45	1939.48	2792.0
2014-05-16 02:00:00	ES	Futures	1939.22	1940.26	1937.41	1937.41	8348.0
2014-05-16 03:00:00	ES	Futures	1937.41	1939.22	1936.63	1937.67	28130.0
2014-05-16 04:00:00	ES	Futures	1937.67	1940.26	1937.15	1940.0	21735.0
2014-05-16 05:00:00	ES	Futures	1940.0	1940.52	1936.63	1937.15	20685.0
2014-05-16 06:00:00	ES	Futures	1936.89	1937.41	1934.03	1936.37	27600.0
2014-05-16 07:00:00	ES	Futures	1936.11	1939.48	1935.59	1936.63	26898.0
2014-05-16 08:00:00	ES	Futures	1936.89	1940.26	1935.07	1938.45	70641.0
2014-05-16 09:00:00	ES	Futures	1938.45	1943.9	1935.59	1940.26	315392.0
2014-05-16 10:00:00	ES	Futures	1940.26	1941.04	1933.25	1938.71	266151.0
2014-05-16 11:00:00	ES	Futures	1938.45	1942.6	1937.41	1940.78	141861.0
2014-05-16 12:00:00	ES	Futures	1940.78	1942.08	1938.71	1939.22	74308.0
2014-05-16 13:00:00	ES	Futures	1938.96	1940.26	1936.63	1938.45	90675.0
2014-05-16 14:00:00	ES	Futures	1938.45	1945.2	1937.15	1945.2	104428.0
2014-05-16 15:00:00	ES	Futures	1945.2	1948.05	1944.68	1947.53	218509.0
2014-05-16 16:00:00	ES	Futures	1947.79	1948.31	1946.75	1947.79	72516.0
2014-05-16 17:00:00	ES	Futures	1947.79	1948.05	1947.53	1947.79	4617.0
2014-05-16 00:00:00	NQ	Futures	4149.04	4150.5	4147.88	4149.63	780.0
2014-05-16 01:00:00	NQ	Futures	4149.33	4152.83	4147.59	4151.96	723.0
2014-05-16 02:00:00	NQ	Futures	4152.25	4154.29	4145.26	4145.84	1561.0
2014-05-16 03:00:00	NQ	Futures	4145.84	4151.96	4145.26	4149.04	3764.0
2014-05-16 04:00:00	NQ	Futures	4149.04	4155.16	4146.71	4153.99	2159.0
2014-05-16 05:00:00	NQ	Futures	4153.99	4155.45	4144.68	4145.26	2569.0
2014-05-16 06:00:00	NQ	Futures	4145.55	4145.55	4136.81	4142.35	4839.0
2014-05-16 07:00:00	NQ	Futures	4142.05	4150.5	4141.18	4142.35	4736.0
2014-05-16 08:00:00	NQ	Futures	4142.64	4155.16	4140.31	4150.5	11579.0
2014-05-16 09:00:00	NQ	Futures	4150.5	4159.82	4134.48	4151.96	52679.0
2014-05-16 10:00:00	NQ	Futures	4152.25	4155.16	4127.2	4138.56	57309.0
2014-05-16 11:00:00	NQ	Futures	4138.56	4148.75	4135.94	4146.42	26432.0
2014-05-16 12:00:00	NQ	Futures	4146.13	4153.99	4142.93	4143.8	18684.0
2014-05-16 13:00:00	NQ	Futures	4143.8	4151.66	4136.81	4147.88	18011.0
2014-05-16 14:00:00	NQ	Futures	4147.59	4168.26	4144.09	4168.26	23661.0
2014-05-16 15:00:00	NQ	Futures	4167.97	4181.37	4167.68	4177.58	53459.0
2014-05-16 16:00:00	NQ	Futures	4177.87	4178.17	4172.92	4174.09	8162.0
2014-05-16 17:00:00	NQ	Futures	4174.09	4176.13	4174.09	4175.25	357.0
2014-05-16 00:00:00	YM	Futures	16900.0	16910.3	16897.9	16905.1	408.0
2014-05-16 01:00:00	YM	Futures	16905.1	16912.4	16902.1	16909.3	567.0
2014-05-16 02:00:00	YM	Futures	16910.3	16915.4	16893.8	16893.8	1102.0
2014-05-16 03:00:00	YM	Futures	16893.8	16906.2	16885.6	16896.9	3825.0
2014-05-16 04:00:00	YM	Futures	16897.9	16915.4	16891.8	16912.4	2694.0
2014-05-16 05:00:00	YM	Futures	16911.3	16916.5	16886.6	16889.7	2841.0
2014-05-16 06:00:00	YM	Futures	16889.7	16891.8	16866.0	16883.5	4316.0
2014-05-16 07:00:00	YM	Futures	16882.5	16912.4	16880.4	16891.8	3183.0
2014-05-16 08:00:00	YM	Futures	16891.8	16914.4	16879.4	16904.1	5558.0
2014-05-16 09:00:00	YM	Futures	16903.1	16930.9	16886.6	16914.4	22670.0
2014-05-16 10:00:00	YM	Futures	16915.4	16923.7	16870.1	16901.0	22597.0
2014-05-16 11:00:00	YM	Futures	16900.0	16925.7	16891.8	16912.4	12572.0
2014-05-16 12:00:00	YM	Futures	16912.4	16920.6	16890.7	16897.9	7372.0
2014-05-16 13:00:00	YM	Futures	16896.9	16902.1	16880.4	16890.7	7494.0

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

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