PREVIEW / futures_1hour / 2014-01-15

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-01-15.parquet
  size:    50 KB
  rows:    1,569

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-01-15 00:00:00	ES	Futures	1896.45	1896.96	1896.19	1896.45	2376.0
2014-01-15 01:00:00	ES	Futures	1896.45	1897.22	1896.45	1896.96	1917.0
2014-01-15 02:00:00	ES	Futures	1897.22	1897.22	1895.93	1896.45	6303.0
2014-01-15 03:00:00	ES	Futures	1896.19	1900.84	1895.41	1899.55	31131.0
2014-01-15 04:00:00	ES	Futures	1899.55	1899.81	1898.26	1898.52	10174.0
2014-01-15 05:00:00	ES	Futures	1898.52	1899.55	1898.0	1899.29	6188.0
2014-01-15 06:00:00	ES	Futures	1899.29	1901.36	1899.29	1900.58	12490.0
2014-01-15 07:00:00	ES	Futures	1900.33	1901.1	1899.55	1899.81	18251.0
2014-01-15 08:00:00	ES	Futures	1899.55	1900.58	1897.74	1900.07	30717.0
2014-01-15 09:00:00	ES	Futures	1899.81	1903.17	1899.55	1902.39	160411.0
2014-01-15 10:00:00	ES	Futures	1902.39	1907.05	1902.14	1905.24	240939.0
2014-01-15 11:00:00	ES	Futures	1905.24	1909.64	1904.46	1906.02	178122.0
2014-01-15 12:00:00	ES	Futures	1906.02	1908.34	1905.24	1906.79	79723.0
2014-01-15 13:00:00	ES	Futures	1906.79	1907.57	1903.95	1904.46	112972.0
2014-01-15 14:00:00	ES	Futures	1904.46	1908.34	1903.43	1907.83	109728.0
2014-01-15 15:00:00	ES	Futures	1908.09	1908.6	1904.46	1906.79	144994.0
2014-01-15 16:00:00	ES	Futures	1906.79	1906.79	1904.72	1905.24	87101.0
2014-01-15 17:00:00	ES	Futures	1905.24	1905.76	1904.98	1905.24	1728.0
2014-01-15 18:00:00	ES	Futures	1905.24	1906.27	1904.46	1906.02	4687.0
2014-01-15 19:00:00	ES	Futures	1906.27	1907.31	1906.02	1906.79	3733.0
2014-01-15 20:00:00	ES	Futures	1907.05	1907.57	1905.5	1906.53	3424.0
2014-01-15 21:00:00	ES	Futures	1906.53	1907.05	1906.27	1906.79	1036.0
2014-01-15 22:00:00	ES	Futures	1906.79	1907.57	1906.53	1907.31	2295.0
2014-01-15 23:00:00	ES	Futures	1907.05	1907.57	1906.79	1907.31	2392.0
2014-01-15 00:00:00	NQ	Futures	4154.18	4155.92	4154.18	4155.34	297.0
2014-01-15 01:00:00	NQ	Futures	4155.05	4156.5	4154.47	4155.92	168.0
2014-01-15 02:00:00	NQ	Futures	4156.21	4156.5	4153.01	4155.34	492.0
2014-01-15 03:00:00	NQ	Futures	4155.63	4168.42	4153.3	4166.09	4222.0
2014-01-15 04:00:00	NQ	Futures	4166.09	4169.29	4165.22	4166.68	1535.0
2014-01-15 05:00:00	NQ	Futures	4166.68	4169.58	4166.38	4169.0	1637.0
2014-01-15 06:00:00	NQ	Futures	4169.29	4172.78	4169.0	4170.45	1937.0
2014-01-15 07:00:00	NQ	Futures	4170.45	4171.62	4168.42	4170.16	2624.0
2014-01-15 08:00:00	NQ	Futures	4170.16	4171.04	4166.38	4170.45	4724.0
2014-01-15 09:00:00	NQ	Futures	4170.45	4182.66	4168.42	4181.5	39327.0
2014-01-15 10:00:00	NQ	Futures	4181.21	4189.93	4178.88	4182.37	38004.0
2014-01-15 11:00:00	NQ	Futures	4182.37	4195.45	4179.76	4187.02	28408.0
2014-01-15 12:00:00	NQ	Futures	4187.31	4193.71	4187.31	4189.06	15108.0
2014-01-15 13:00:00	NQ	Futures	4189.06	4192.84	4183.53	4187.02	20287.0
2014-01-15 14:00:00	NQ	Futures	4186.73	4196.03	4185.28	4195.16	25743.0
2014-01-15 15:00:00	NQ	Futures	4195.16	4197.78	4186.15	4187.6	36939.0
2014-01-15 16:00:00	NQ	Futures	4187.9	4188.19	4182.66	4184.7	10148.0
2014-01-15 17:00:00	NQ	Futures	4184.7	4184.7	4183.83	4183.83	114.0
2014-01-15 18:00:00	NQ	Futures	4184.12	4187.02	4182.95	4186.73	609.0
2014-01-15 19:00:00	NQ	Futures	4187.02	4189.06	4186.44	4188.48	685.0
2014-01-15 20:00:00	NQ	Futures	4188.48	4189.06	4185.28	4187.6	556.0
2014-01-15 21:00:00	NQ	Futures	4187.9	4189.06	4187.6	4188.77	253.0
2014-01-15 22:00:00	NQ	Futures	4189.06	4190.22	4188.19	4189.93	220.0
2014-01-15 23:00:00	NQ	Futures	4189.93	4190.51	4189.06	4189.64	491.0
2014-01-15 00:00:00	YM	Futures	16717.1	16723.3	16717.1	16721.2	398.0
2014-01-15 01:00:00	YM	Futures	16720.2	16728.4	16719.2	16725.3	400.0

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

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