PREVIEW / futures_1hour / 2014-04-28

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-04-28.parquet
  size:    48 KB
  rows:    1,536

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-28 00:00:00	ES	Futures	1932.73	1933.25	1932.21	1932.73	1012.0
2014-04-28 01:00:00	ES	Futures	1932.99	1933.77	1932.73	1933.51	1922.0
2014-04-28 02:00:00	ES	Futures	1933.51	1935.07	1932.73	1933.77	7171.0
2014-04-28 03:00:00	ES	Futures	1933.77	1937.41	1933.25	1937.15	27006.0
2014-04-28 04:00:00	ES	Futures	1936.89	1940.0	1936.63	1939.22	17303.0
2014-04-28 05:00:00	ES	Futures	1939.22	1939.48	1937.67	1939.48	11347.0
2014-04-28 06:00:00	ES	Futures	1939.74	1939.74	1936.11	1937.15	16934.0
2014-04-28 07:00:00	ES	Futures	1937.15	1940.0	1936.89	1939.74	22131.0
2014-04-28 08:00:00	ES	Futures	1939.48	1939.48	1934.81	1935.07	39428.0
2014-04-28 09:00:00	ES	Futures	1935.33	1939.22	1930.4	1936.37	244521.0
2014-04-28 10:00:00	ES	Futures	1936.63	1944.16	1935.07	1938.71	278513.0
2014-04-28 11:00:00	ES	Futures	1938.96	1940.78	1927.54	1928.32	252656.0
2014-04-28 12:00:00	ES	Futures	1928.06	1931.43	1927.02	1928.58	165234.0
2014-04-28 13:00:00	ES	Futures	1928.58	1928.58	1915.33	1920.27	335942.0
2014-04-28 14:00:00	ES	Futures	1920.27	1929.36	1917.15	1926.5	210838.0
2014-04-28 15:00:00	ES	Futures	1926.76	1939.74	1926.24	1935.85	347449.0
2014-04-28 16:00:00	ES	Futures	1935.85	1938.71	1935.07	1938.45	55925.0
2014-04-28 17:00:00	ES	Futures	1938.45	1938.71	1938.19	1938.45	2106.0
2014-04-28 18:00:00	ES	Futures	1938.19	1941.04	1937.15	1939.74	6912.0
2014-04-28 19:00:00	ES	Futures	1940.0	1940.52	1938.96	1939.48	2099.0
2014-04-28 20:00:00	ES	Futures	1939.22	1939.74	1938.71	1938.96	2744.0
2014-04-28 21:00:00	ES	Futures	1939.22	1940.0	1938.71	1938.71	2382.0
2014-04-28 22:00:00	ES	Futures	1938.71	1942.34	1938.45	1941.82	6885.0
2014-04-28 23:00:00	ES	Futures	1941.82	1942.08	1940.78	1941.04	2811.0
2014-04-28 00:00:00	NQ	Futures	4111.77	4112.06	4109.73	4110.6	344.0
2014-04-28 01:00:00	NQ	Futures	4110.31	4112.64	4110.31	4112.64	310.0
2014-04-28 02:00:00	NQ	Futures	4112.64	4116.14	4110.02	4112.06	1801.0
2014-04-28 03:00:00	NQ	Futures	4112.93	4125.45	4112.93	4124.87	5609.0
2014-04-28 04:00:00	NQ	Futures	4124.58	4130.99	4124.29	4128.95	6152.0
2014-04-28 05:00:00	NQ	Futures	4129.24	4129.82	4124.87	4129.82	2627.0
2014-04-28 06:00:00	NQ	Futures	4129.82	4130.41	4121.67	4123.42	3784.0
2014-04-28 07:00:00	NQ	Futures	4123.42	4132.44	4122.83	4129.53	5235.0
2014-04-28 08:00:00	NQ	Futures	4129.53	4129.82	4116.14	4116.72	7800.0
2014-04-28 09:00:00	NQ	Futures	4117.01	4130.11	4101.28	4125.16	62649.0
2014-04-28 10:00:00	NQ	Futures	4125.75	4149.92	4120.8	4132.15	66546.0
2014-04-28 11:00:00	NQ	Futures	4132.15	4138.85	4089.05	4091.96	68942.0
2014-04-28 12:00:00	NQ	Futures	4091.96	4098.37	4081.77	4087.01	50712.0
2014-04-28 13:00:00	NQ	Futures	4086.72	4086.72	4054.4	4072.16	66988.0
2014-04-28 14:00:00	NQ	Futures	4072.16	4100.41	4064.3	4092.84	48993.0
2014-04-28 15:00:00	NQ	Futures	4092.84	4129.53	4090.8	4120.5	72374.0
2014-04-28 16:00:00	NQ	Futures	4120.5	4126.04	4119.05	4125.45	3902.0
2014-04-28 17:00:00	NQ	Futures	4125.45	4127.49	4124.87	4126.62	283.0
2014-04-28 18:00:00	NQ	Futures	4125.45	4133.61	4122.54	4131.57	1175.0
2014-04-28 19:00:00	NQ	Futures	4131.28	4131.86	4129.24	4130.11	456.0
2014-04-28 20:00:00	NQ	Futures	4130.11	4130.99	4128.37	4129.53	530.0
2014-04-28 21:00:00	NQ	Futures	4129.24	4131.57	4128.08	4128.08	435.0
2014-04-28 22:00:00	NQ	Futures	4128.08	4136.81	4127.78	4135.36	1047.0
2014-04-28 23:00:00	NQ	Futures	4135.36	4136.23	4132.74	4133.61	566.0
2014-04-28 00:00:00	YM	Futures	16814.5	16817.6	16808.3	16814.5	178.0
2014-04-28 01:00:00	YM	Futures	16813.5	16821.7	16812.5	16817.6	361.0

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

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