PREVIEW / futures_1hour / 2014-04-10

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-04-10.parquet
  size:    51 KB
  rows:    1,567

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-10 00:00:00	ES	Futures	1935.33	1937.15	1935.07	1936.37	3450.0
2014-04-10 01:00:00	ES	Futures	1936.37	1937.93	1936.37	1937.41	4704.0
2014-04-10 02:00:00	ES	Futures	1937.15	1938.19	1936.37	1938.19	10799.0
2014-04-10 03:00:00	ES	Futures	1937.93	1939.74	1936.63	1938.71	22670.0
2014-04-10 04:00:00	ES	Futures	1938.71	1939.22	1935.33	1935.85	18996.0
2014-04-10 05:00:00	ES	Futures	1935.59	1935.85	1929.36	1931.43	59314.0
2014-04-10 06:00:00	ES	Futures	1931.43	1934.81	1930.14	1934.29	20847.0
2014-04-10 07:00:00	ES	Futures	1934.55	1937.93	1933.77	1934.55	38248.0
2014-04-10 08:00:00	ES	Futures	1934.55	1936.37	1932.73	1935.85	43763.0
2014-04-10 09:00:00	ES	Futures	1935.85	1938.71	1932.47	1934.55	209006.0
2014-04-10 10:00:00	ES	Futures	1934.55	1936.37	1927.02	1927.02	295105.0
2014-04-10 11:00:00	ES	Futures	1927.02	1927.28	1920.01	1920.79	293219.0
2014-04-10 12:00:00	ES	Futures	1920.53	1921.83	1909.62	1909.88	268850.0
2014-04-10 13:00:00	ES	Futures	1909.88	1912.48	1904.17	1909.88	249102.0
2014-04-10 14:00:00	ES	Futures	1909.88	1912.48	1902.09	1903.13	233979.0
2014-04-10 15:00:00	ES	Futures	1903.13	1903.39	1894.3	1896.64	457282.0
2014-04-10 16:00:00	ES	Futures	1896.38	1901.05	1896.38	1900.01	119043.0
2014-04-10 17:00:00	ES	Futures	1900.27	1900.53	1899.75	1900.01	1930.0
2014-04-10 18:00:00	ES	Futures	1900.27	1900.53	1897.42	1898.72	7086.0
2014-04-10 19:00:00	ES	Futures	1898.72	1898.98	1897.42	1898.72	4165.0
2014-04-10 20:00:00	ES	Futures	1898.72	1901.05	1898.2	1898.46	10421.0
2014-04-10 21:00:00	ES	Futures	1898.46	1900.79	1898.46	1899.49	6985.0
2014-04-10 22:00:00	ES	Futures	1899.49	1901.31	1899.24	1900.01	4071.0
2014-04-10 23:00:00	ES	Futures	1900.27	1900.53	1898.98	1899.49	3814.0
2014-04-10 00:00:00	NQ	Futures	4178.46	4183.12	4178.46	4181.95	521.0
2014-04-10 01:00:00	NQ	Futures	4182.24	4187.78	4182.24	4186.03	1129.0
2014-04-10 02:00:00	NQ	Futures	4185.74	4188.07	4182.83	4188.07	1492.0
2014-04-10 03:00:00	NQ	Futures	4188.07	4193.02	4184.28	4189.23	3970.0
2014-04-10 04:00:00	NQ	Futures	4189.23	4190.69	4184.28	4185.16	3109.0
2014-04-10 05:00:00	NQ	Futures	4185.45	4186.9	4163.02	4167.1	10949.0
2014-04-10 06:00:00	NQ	Futures	4167.1	4176.71	4164.77	4175.25	4330.0
2014-04-10 07:00:00	NQ	Futures	4175.25	4184.57	4175.25	4177.0	6047.0
2014-04-10 08:00:00	NQ	Futures	4177.29	4181.95	4171.47	4180.79	10553.0
2014-04-10 09:00:00	NQ	Futures	4181.08	4187.19	4148.75	4155.45	56493.0
2014-04-10 10:00:00	NQ	Futures	4155.45	4159.24	4127.2	4127.49	81289.0
2014-04-10 11:00:00	NQ	Futures	4127.49	4128.37	4104.78	4108.27	77430.0
2014-04-10 12:00:00	NQ	Futures	4108.27	4111.18	4080.9	4081.48	61304.0
2014-04-10 13:00:00	NQ	Futures	4081.19	4089.63	4066.63	4082.06	52869.0
2014-04-10 14:00:00	NQ	Futures	4082.06	4087.6	4057.6	4064.01	52529.0
2014-04-10 15:00:00	NQ	Futures	4064.01	4068.08	4042.46	4054.11	88536.0
2014-04-10 16:00:00	NQ	Futures	4053.81	4061.97	4053.52	4059.93	10530.0
2014-04-10 17:00:00	NQ	Futures	4060.22	4060.8	4059.06	4060.22	198.0
2014-04-10 18:00:00	NQ	Futures	4059.64	4061.97	4054.11	4056.14	603.0
2014-04-10 19:00:00	NQ	Futures	4056.44	4057.02	4052.07	4055.27	662.0
2014-04-10 20:00:00	NQ	Futures	4054.98	4061.68	4054.11	4055.85	1507.0
2014-04-10 21:00:00	NQ	Futures	4055.56	4060.51	4054.98	4057.02	1278.0
2014-04-10 22:00:00	NQ	Futures	4057.02	4060.51	4056.44	4057.89	750.0
2014-04-10 23:00:00	NQ	Futures	4057.89	4058.47	4054.69	4056.14	629.0
2014-04-10 00:00:00	YM	Futures	16836.1	16851.6	16836.1	16846.4	416.0
2014-04-10 01:00:00	YM	Futures	16846.4	16861.9	16846.4	16858.8	978.0

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

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