PREVIEW / futures_1hour / 2014-02-20

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-02-20.parquet
  size:    51 KB
  rows:    1,548

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-02-20 00:00:00	ES	Futures	1882.74	1883.0	1881.7	1882.22	5266.0
2014-02-20 01:00:00	ES	Futures	1881.96	1883.77	1880.41	1883.51	7505.0
2014-02-20 02:00:00	ES	Futures	1883.51	1884.55	1880.41	1881.19	16238.0
2014-02-20 03:00:00	ES	Futures	1881.19	1886.62	1880.93	1885.32	41022.0
2014-02-20 04:00:00	ES	Futures	1885.32	1887.39	1884.55	1884.81	25912.0
2014-02-20 05:00:00	ES	Futures	1885.07	1888.94	1884.81	1887.13	21341.0
2014-02-20 06:00:00	ES	Futures	1887.39	1887.39	1885.07	1886.88	17754.0
2014-02-20 07:00:00	ES	Futures	1886.88	1888.17	1881.96	1883.51	33051.0
2014-02-20 08:00:00	ES	Futures	1883.51	1892.82	1882.22	1890.5	68918.0
2014-02-20 09:00:00	ES	Futures	1890.76	1894.64	1886.36	1887.65	240250.0
2014-02-20 10:00:00	ES	Futures	1887.65	1896.96	1884.03	1895.41	317331.0
2014-02-20 11:00:00	ES	Futures	1895.15	1897.74	1893.6	1895.67	137240.0
2014-02-20 12:00:00	ES	Futures	1895.67	1901.36	1895.15	1900.07	128069.0
2014-02-20 13:00:00	ES	Futures	1900.07	1901.36	1899.55	1900.58	60136.0
2014-02-20 14:00:00	ES	Futures	1900.58	1902.39	1898.26	1901.88	142602.0
2014-02-20 15:00:00	ES	Futures	1901.88	1903.95	1900.07	1900.07	167144.0
2014-02-20 16:00:00	ES	Futures	1900.07	1900.84	1898.52	1899.03	93241.0
2014-02-20 17:00:00	ES	Futures	1899.03	1899.55	1898.77	1899.55	1013.0
2014-02-20 18:00:00	ES	Futures	1899.55	1900.07	1898.77	1899.81	4570.0
2014-02-20 19:00:00	ES	Futures	1899.81	1902.91	1899.81	1902.39	7733.0
2014-02-20 20:00:00	ES	Futures	1902.39	1902.65	1901.36	1901.62	2824.0
2014-02-20 21:00:00	ES	Futures	1901.88	1904.98	1901.88	1904.72	7822.0
2014-02-20 22:00:00	ES	Futures	1904.72	1904.98	1903.17	1904.21	4887.0
2014-02-20 23:00:00	ES	Futures	1904.21	1904.98	1903.69	1904.98	2478.0
2014-02-20 00:00:00	NQ	Futures	4237.02	4237.6	4234.7	4235.57	893.0
2014-02-20 01:00:00	NQ	Futures	4235.28	4239.06	4232.37	4238.47	795.0
2014-02-20 02:00:00	NQ	Futures	4238.76	4242.54	4232.66	4234.4	1767.0
2014-02-20 03:00:00	NQ	Futures	4234.11	4245.16	4233.24	4242.54	4329.0
2014-02-20 04:00:00	NQ	Futures	4242.25	4246.9	4241.09	4241.09	2873.0
2014-02-20 05:00:00	NQ	Futures	4241.38	4249.52	4241.09	4245.45	1863.0
2014-02-20 06:00:00	NQ	Futures	4245.45	4245.74	4237.89	4240.22	4104.0
2014-02-20 07:00:00	NQ	Futures	4240.22	4241.38	4230.33	4231.21	7331.0
2014-02-20 08:00:00	NQ	Futures	4231.5	4251.26	4231.21	4246.61	9109.0
2014-02-20 09:00:00	NQ	Futures	4246.9	4261.44	4235.57	4238.47	47031.0
2014-02-20 10:00:00	NQ	Futures	4238.47	4259.69	4232.08	4253.3	56590.0
2014-02-20 11:00:00	NQ	Futures	4253.59	4256.79	4246.9	4253.01	22647.0
2014-02-20 12:00:00	NQ	Futures	4253.01	4266.09	4251.55	4260.57	20087.0
2014-02-20 13:00:00	NQ	Futures	4260.57	4264.93	4259.98	4263.76	13893.0
2014-02-20 14:00:00	NQ	Futures	4263.47	4269.87	4259.11	4267.54	31830.0
2014-02-20 15:00:00	NQ	Futures	4267.54	4275.39	4266.96	4267.25	26998.0
2014-02-20 16:00:00	NQ	Futures	4267.25	4270.74	4265.51	4266.67	5999.0
2014-02-20 17:00:00	NQ	Futures	4267.25	4268.12	4266.38	4268.12	56.0
2014-02-20 18:00:00	NQ	Futures	4269.0	4269.0	4266.38	4268.12	416.0
2014-02-20 19:00:00	NQ	Futures	4268.41	4274.81	4268.41	4272.77	799.0
2014-02-20 20:00:00	NQ	Futures	4272.77	4273.94	4271.03	4271.61	364.0
2014-02-20 21:00:00	NQ	Futures	4271.9	4280.33	4271.9	4279.17	1102.0
2014-02-20 22:00:00	NQ	Futures	4279.17	4279.46	4276.84	4278.3	729.0
2014-02-20 23:00:00	NQ	Futures	4278.59	4280.04	4277.43	4279.46	363.0
2014-02-20 00:00:00	YM	Futures	16368.5	16372.6	16363.4	16366.5	798.0
2014-02-20 01:00:00	YM	Futures	16365.4	16377.7	16355.2	16374.7	885.0

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

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