PREVIEW / futures_1hour / 2014-03-31

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-03-31.parquet
  size:    48 KB
  rows:    1,514

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-31 00:00:00	ES	Futures	1929.1	1929.62	1928.84	1928.84	1605.0
2014-03-31 01:00:00	ES	Futures	1928.84	1929.88	1927.8	1929.62	3882.0
2014-03-31 02:00:00	ES	Futures	1929.62	1929.88	1927.54	1928.84	6327.0
2014-03-31 03:00:00	ES	Futures	1928.84	1930.4	1928.32	1929.1	14315.0
2014-03-31 04:00:00	ES	Futures	1929.1	1930.14	1928.06	1929.1	12649.0
2014-03-31 05:00:00	ES	Futures	1929.1	1929.88	1927.8	1928.84	11873.0
2014-03-31 06:00:00	ES	Futures	1928.84	1929.62	1926.76	1928.32	13555.0
2014-03-31 07:00:00	ES	Futures	1928.32	1930.4	1927.28	1929.88	13319.0
2014-03-31 08:00:00	ES	Futures	1930.14	1933.77	1929.1	1932.99	39598.0
2014-03-31 09:00:00	ES	Futures	1932.99	1938.19	1931.95	1937.41	254887.0
2014-03-31 10:00:00	ES	Futures	1937.41	1938.96	1934.81	1936.37	245627.0
2014-03-31 11:00:00	ES	Futures	1936.37	1936.63	1931.43	1934.81	158091.0
2014-03-31 12:00:00	ES	Futures	1935.07	1940.26	1934.55	1938.71	151544.0
2014-03-31 13:00:00	ES	Futures	1938.96	1939.48	1933.77	1934.81	98598.0
2014-03-31 14:00:00	ES	Futures	1934.81	1938.71	1934.55	1937.93	100064.0
2014-03-31 15:00:00	ES	Futures	1937.93	1939.48	1935.85	1937.15	274671.0
2014-03-31 16:00:00	ES	Futures	1937.15	1937.67	1934.55	1936.11	131663.0
2014-03-31 17:00:00	ES	Futures	1935.85	1936.37	1935.85	1936.11	2000.0
2014-03-31 18:00:00	ES	Futures	1936.63	1937.41	1936.11	1936.11	4312.0
2014-03-31 19:00:00	ES	Futures	1936.11	1936.63	1935.33	1935.85	3549.0
2014-03-31 20:00:00	ES	Futures	1935.85	1936.37	1934.29	1936.11	7026.0
2014-03-31 21:00:00	ES	Futures	1936.11	1938.96	1936.11	1937.67	9511.0
2014-03-31 22:00:00	ES	Futures	1937.67	1937.93	1936.37	1937.67	2342.0
2014-03-31 23:00:00	ES	Futures	1937.93	1938.19	1937.41	1938.19	1829.0
2014-03-31 00:00:00	NQ	Futures	4168.85	4169.43	4167.68	4168.56	231.0
2014-03-31 01:00:00	NQ	Futures	4168.26	4170.89	4165.64	4170.3	440.0
2014-03-31 02:00:00	NQ	Futures	4169.72	4170.3	4164.19	4166.81	1196.0
2014-03-31 03:00:00	NQ	Futures	4166.52	4171.76	4165.93	4168.56	2490.0
2014-03-31 04:00:00	NQ	Futures	4168.26	4171.76	4164.48	4169.14	3067.0
2014-03-31 05:00:00	NQ	Futures	4168.85	4170.59	4165.06	4168.85	1696.0
2014-03-31 06:00:00	NQ	Futures	4169.14	4170.01	4162.44	4166.81	2396.0
2014-03-31 07:00:00	NQ	Futures	4166.81	4172.92	4164.48	4172.05	2573.0
2014-03-31 08:00:00	NQ	Futures	4172.05	4183.7	4169.43	4182.24	6227.0
2014-03-31 09:00:00	NQ	Futures	4181.95	4198.26	4175.84	4197.68	59017.0
2014-03-31 10:00:00	NQ	Futures	4197.39	4206.71	4189.81	4194.47	58911.0
2014-03-31 11:00:00	NQ	Futures	4194.47	4195.06	4180.5	4191.56	31661.0
2014-03-31 12:00:00	NQ	Futures	4191.56	4199.43	4190.11	4194.77	27285.0
2014-03-31 13:00:00	NQ	Futures	4194.77	4195.93	4177.58	4179.04	17257.0
2014-03-31 14:00:00	NQ	Futures	4179.04	4191.85	4177.87	4187.78	18722.0
2014-03-31 15:00:00	NQ	Futures	4188.07	4190.11	4174.96	4177.58	46928.0
2014-03-31 16:00:00	NQ	Futures	4177.58	4178.17	4169.43	4173.8	10681.0
2014-03-31 17:00:00	NQ	Futures	4173.8	4174.38	4173.51	4173.51	158.0
2014-03-31 18:00:00	NQ	Futures	4174.09	4175.54	4172.92	4173.22	933.0
2014-03-31 19:00:00	NQ	Futures	4173.22	4174.38	4171.18	4172.34	410.0
2014-03-31 20:00:00	NQ	Futures	4172.05	4173.51	4168.56	4173.51	1061.0
2014-03-31 21:00:00	NQ	Futures	4173.51	4179.33	4173.22	4175.84	1418.0
2014-03-31 22:00:00	NQ	Futures	4175.54	4177.58	4174.09	4177.58	304.0
2014-03-31 23:00:00	NQ	Futures	4177.58	4178.75	4176.42	4178.46	297.0
2014-03-31 00:00:00	YM	Futures	16783.6	16786.7	16780.5	16783.6	392.0
2014-03-31 01:00:00	YM	Futures	16784.7	16793.9	16778.5	16792.9	906.0

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

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