PREVIEW / futures_1hour / 2014-07-15

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-07-15.parquet
  size:    48 KB
  rows:    1,543

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-07-15 00:00:00	ES	Futures	2055.72	2056.77	2055.46	2056.5	1150.0
2014-07-15 01:00:00	ES	Futures	2056.24	2056.5	2054.94	2054.94	2976.0
2014-07-15 02:00:00	ES	Futures	2054.94	2055.46	2053.64	2054.94	7217.0
2014-07-15 03:00:00	ES	Futures	2054.68	2055.72	2053.64	2054.42	17894.0
2014-07-15 04:00:00	ES	Futures	2054.42	2054.94	2053.38	2054.42	16990.0
2014-07-15 05:00:00	ES	Futures	2054.16	2054.42	2050.77	2052.07	26590.0
2014-07-15 06:00:00	ES	Futures	2052.34	2052.6	2050.77	2052.07	15389.0
2014-07-15 07:00:00	ES	Futures	2052.07	2057.29	2052.07	2055.72	28754.0
2014-07-15 08:00:00	ES	Futures	2055.72	2058.33	2055.46	2057.03	43091.0
2014-07-15 09:00:00	ES	Futures	2057.03	2060.15	2054.94	2056.5	203494.0
2014-07-15 10:00:00	ES	Futures	2056.24	2058.85	2045.56	2049.47	495375.0
2014-07-15 11:00:00	ES	Futures	2049.21	2052.6	2043.21	2043.73	270278.0
2014-07-15 12:00:00	ES	Futures	2043.73	2049.99	2041.91	2047.9	213179.0
2014-07-15 13:00:00	ES	Futures	2047.64	2052.86	2047.12	2050.51	135960.0
2014-07-15 14:00:00	ES	Futures	2050.51	2054.16	2049.99	2052.86	156711.0
2014-07-15 15:00:00	ES	Futures	2052.86	2053.38	2049.21	2051.55	186264.0
2014-07-15 16:00:00	ES	Futures	2051.55	2052.07	2050.51	2051.81	63570.0
2014-07-15 17:00:00	ES	Futures	2051.81	2052.6	2051.55	2052.34	2739.0
2014-07-15 18:00:00	ES	Futures	2051.55	2051.81	2050.51	2051.55	3135.0
2014-07-15 19:00:00	ES	Futures	2051.81	2052.34	2051.29	2051.55	1411.0
2014-07-15 20:00:00	ES	Futures	2051.81	2052.07	2051.29	2052.07	1218.0
2014-07-15 21:00:00	ES	Futures	2052.07	2052.34	2051.55	2052.34	1079.0
2014-07-15 22:00:00	ES	Futures	2052.34	2052.86	2050.77	2051.03	4063.0
2014-07-15 23:00:00	ES	Futures	2051.29	2051.29	2050.51	2051.29	1180.0
2014-07-15 00:00:00	NQ	Futures	4583.75	4585.51	4583.75	4585.21	142.0
2014-07-15 01:00:00	NQ	Futures	4585.21	4585.21	4582.29	4582.59	228.0
2014-07-15 02:00:00	NQ	Futures	4582.29	4582.88	4578.5	4582.59	1050.0
2014-07-15 03:00:00	NQ	Futures	4582.29	4585.51	4579.96	4581.42	1924.0
2014-07-15 04:00:00	NQ	Futures	4581.71	4584.05	4579.96	4581.71	1911.0
2014-07-15 05:00:00	NQ	Futures	4581.42	4582.29	4576.16	4578.5	2831.0
2014-07-15 06:00:00	NQ	Futures	4578.5	4578.79	4573.83	4577.33	2092.0
2014-07-15 07:00:00	NQ	Futures	4577.33	4587.26	4577.33	4585.51	3602.0
2014-07-15 08:00:00	NQ	Futures	4585.21	4590.18	4584.63	4586.97	4373.0
2014-07-15 09:00:00	NQ	Futures	4587.26	4594.56	4581.13	4586.38	30566.0
2014-07-15 10:00:00	NQ	Futures	4586.38	4590.76	4550.76	4558.35	86684.0
2014-07-15 11:00:00	NQ	Futures	4558.64	4568.86	4536.74	4538.49	53919.0
2014-07-15 12:00:00	NQ	Futures	4538.2	4563.61	4532.07	4556.6	43670.0
2014-07-15 13:00:00	NQ	Futures	4556.89	4569.74	4553.68	4562.73	22929.0
2014-07-15 14:00:00	NQ	Futures	4563.02	4572.66	4560.69	4567.4	34083.0
2014-07-15 15:00:00	NQ	Futures	4567.4	4569.45	4557.47	4565.65	28870.0
2014-07-15 16:00:00	NQ	Futures	4565.94	4577.04	4565.36	4576.16	10357.0
2014-07-15 17:00:00	NQ	Futures	4576.16	4579.37	4575.87	4577.62	767.0
2014-07-15 18:00:00	NQ	Futures	4574.7	4574.99	4570.61	4574.12	856.0
2014-07-15 19:00:00	NQ	Futures	4574.12	4575.58	4573.24	4574.12	345.0
2014-07-15 20:00:00	NQ	Futures	4573.83	4574.99	4572.66	4574.12	263.0
2014-07-15 21:00:00	NQ	Futures	4574.12	4575.29	4573.53	4574.7	234.0
2014-07-15 22:00:00	NQ	Futures	4574.99	4576.16	4572.66	4572.95	888.0
2014-07-15 23:00:00	NQ	Futures	4572.66	4572.95	4571.49	4572.95	227.0
2014-07-15 00:00:00	YM	Futures	17576.3	17583.5	17576.3	17582.5	118.0
2014-07-15 01:00:00	YM	Futures	17581.4	17582.5	17573.2	17573.2	249.0

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

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