PREVIEW / futures_1hour / 2014-01-16

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-01-16.parquet
  size:    49 KB
  rows:    1,581

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-16 00:00:00	ES	Futures	1907.05	1907.05	1905.5	1906.27	3849.0
2014-01-16 01:00:00	ES	Futures	1906.53	1906.79	1905.24	1905.24	3105.0
2014-01-16 02:00:00	ES	Futures	1905.5	1905.5	1903.69	1904.21	7029.0
2014-01-16 03:00:00	ES	Futures	1904.21	1904.72	1901.88	1902.39	23871.0
2014-01-16 04:00:00	ES	Futures	1902.14	1903.69	1902.14	1903.43	13277.0
2014-01-16 05:00:00	ES	Futures	1903.17	1903.95	1902.39	1903.95	7811.0
2014-01-16 06:00:00	ES	Futures	1903.95	1903.95	1902.14	1902.65	9168.0
2014-01-16 07:00:00	ES	Futures	1902.91	1904.21	1901.1	1902.14	24950.0
2014-01-16 08:00:00	ES	Futures	1902.14	1902.14	1900.33	1901.62	36105.0
2014-01-16 09:00:00	ES	Futures	1901.36	1904.72	1899.81	1902.91	157652.0
2014-01-16 10:00:00	ES	Futures	1902.91	1904.46	1898.26	1899.29	154337.0
2014-01-16 11:00:00	ES	Futures	1899.29	1903.43	1898.0	1902.65	118546.0
2014-01-16 12:00:00	ES	Futures	1902.65	1902.91	1900.07	1902.65	50271.0
2014-01-16 13:00:00	ES	Futures	1902.39	1904.72	1901.1	1902.39	58806.0
2014-01-16 14:00:00	ES	Futures	1902.39	1903.69	1901.36	1902.91	56816.0
2014-01-16 15:00:00	ES	Futures	1902.91	1904.21	1900.33	1903.95	120532.0
2014-01-16 16:00:00	ES	Futures	1903.69	1904.21	1899.55	1900.58	86549.0
2014-01-16 17:00:00	ES	Futures	1900.58	1901.36	1900.58	1900.84	1155.0
2014-01-16 18:00:00	ES	Futures	1901.62	1901.62	1899.29	1899.81	4035.0
2014-01-16 19:00:00	ES	Futures	1899.55	1900.84	1899.55	1900.84	1443.0
2014-01-16 20:00:00	ES	Futures	1900.84	1901.36	1899.55	1900.07	2887.0
2014-01-16 21:00:00	ES	Futures	1900.07	1900.33	1899.03	1899.81	2170.0
2014-01-16 22:00:00	ES	Futures	1900.07	1901.62	1899.81	1901.36	4082.0
2014-01-16 23:00:00	ES	Futures	1901.62	1902.14	1901.36	1902.14	1704.0
2014-01-16 00:00:00	NQ	Futures	4189.64	4189.64	4186.15	4187.6	527.0
2014-01-16 01:00:00	NQ	Futures	4187.9	4188.48	4185.86	4186.44	183.0
2014-01-16 02:00:00	NQ	Futures	4186.15	4187.02	4182.66	4184.7	662.0
2014-01-16 03:00:00	NQ	Futures	4185.28	4186.73	4182.08	4183.53	2792.0
2014-01-16 04:00:00	NQ	Futures	4183.83	4187.31	4183.53	4185.86	1147.0
2014-01-16 05:00:00	NQ	Futures	4185.86	4187.6	4184.41	4187.02	1178.0
2014-01-16 06:00:00	NQ	Futures	4187.31	4187.31	4182.08	4183.83	1033.0
2014-01-16 07:00:00	NQ	Futures	4183.83	4187.9	4180.92	4182.08	2905.0
2014-01-16 08:00:00	NQ	Futures	4182.37	4182.95	4179.17	4181.21	4174.0
2014-01-16 09:00:00	NQ	Futures	4181.5	4191.67	4178.88	4186.73	32008.0
2014-01-16 10:00:00	NQ	Futures	4187.02	4194.0	4180.63	4182.37	28350.0
2014-01-16 11:00:00	NQ	Futures	4182.66	4190.51	4179.47	4189.64	18101.0
2014-01-16 12:00:00	NQ	Futures	4189.64	4190.51	4181.79	4190.22	12261.0
2014-01-16 13:00:00	NQ	Futures	4190.22	4195.45	4187.6	4189.64	9889.0
2014-01-16 14:00:00	NQ	Futures	4189.64	4193.13	4186.15	4191.09	10872.0
2014-01-16 15:00:00	NQ	Futures	4190.8	4191.96	4182.95	4191.09	22691.0
2014-01-16 16:00:00	NQ	Futures	4191.09	4194.58	4179.76	4181.79	10338.0
2014-01-16 17:00:00	NQ	Futures	4182.08	4183.53	4182.08	4182.95	137.0
2014-01-16 18:00:00	NQ	Futures	4182.66	4183.24	4176.27	4178.3	928.0
2014-01-16 19:00:00	NQ	Futures	4178.59	4180.34	4178.59	4180.05	468.0
2014-01-16 20:00:00	NQ	Futures	4179.76	4180.34	4177.14	4178.59	610.0
2014-01-16 21:00:00	NQ	Futures	4178.3	4179.76	4177.43	4179.47	631.0
2014-01-16 22:00:00	NQ	Futures	4179.76	4183.83	4179.17	4183.83	850.0
2014-01-16 23:00:00	NQ	Futures	4183.53	4185.28	4183.53	4184.99	175.0
2014-01-16 00:00:00	YM	Futures	16837.1	16838.1	16827.9	16834.0	363.0
2014-01-16 01:00:00	YM	Futures	16835.1	16838.1	16824.8	16824.8	286.0

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

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