PREVIEW / futures_1hour / 2014-07-16

all futures 1-hour files

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

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-16 00:00:00	ES	Futures	2051.03	2051.29	2050.51	2051.29	927.0
2014-07-16 01:00:00	ES	Futures	2051.29	2052.07	2051.03	2051.55	1229.0
2014-07-16 02:00:00	ES	Futures	2051.55	2052.86	2051.29	2051.81	4261.0
2014-07-16 03:00:00	ES	Futures	2051.81	2053.64	2051.55	2053.64	17278.0
2014-07-16 04:00:00	ES	Futures	2053.38	2057.81	2053.12	2057.81	32908.0
2014-07-16 05:00:00	ES	Futures	2057.55	2058.07	2056.5	2057.55	12483.0
2014-07-16 06:00:00	ES	Futures	2057.29	2058.59	2056.77	2058.33	10849.0
2014-07-16 07:00:00	ES	Futures	2058.33	2059.63	2058.07	2058.33	18982.0
2014-07-16 08:00:00	ES	Futures	2058.59	2061.72	2058.07	2060.41	42600.0
2014-07-16 09:00:00	ES	Futures	2060.41	2061.98	2056.24	2058.07	209816.0
2014-07-16 10:00:00	ES	Futures	2058.33	2059.89	2053.9	2054.94	236961.0
2014-07-16 11:00:00	ES	Futures	2054.68	2057.03	2052.86	2055.2	172141.0
2014-07-16 12:00:00	ES	Futures	2055.2	2059.37	2054.68	2058.33	117730.0
2014-07-16 13:00:00	ES	Futures	2058.33	2059.63	2057.81	2059.37	77166.0
2014-07-16 14:00:00	ES	Futures	2059.37	2060.67	2058.07	2058.33	103618.0
2014-07-16 15:00:00	ES	Futures	2058.07	2059.63	2057.55	2058.85	164171.0
2014-07-16 16:00:00	ES	Futures	2058.59	2059.37	2055.72	2055.98	73966.0
2014-07-16 17:00:00	ES	Futures	2055.72	2056.24	2054.94	2055.2	4386.0
2014-07-16 18:00:00	ES	Futures	2054.94	2056.24	2054.68	2054.94	4793.0
2014-07-16 19:00:00	ES	Futures	2055.2	2055.72	2054.94	2055.46	1430.0
2014-07-16 20:00:00	ES	Futures	2055.46	2056.5	2055.46	2055.98	2536.0
2014-07-16 21:00:00	ES	Futures	2055.98	2056.24	2054.94	2055.98	3612.0
2014-07-16 22:00:00	ES	Futures	2055.98	2055.98	2054.16	2054.68	3598.0
2014-07-16 23:00:00	ES	Futures	2054.68	2055.2	2053.12	2053.9	3901.0
2014-07-16 00:00:00	NQ	Futures	4572.66	4573.53	4571.49	4573.53	157.0
2014-07-16 01:00:00	NQ	Futures	4573.24	4574.99	4572.66	4574.12	234.0
2014-07-16 02:00:00	NQ	Futures	4574.12	4578.5	4572.95	4574.99	990.0
2014-07-16 03:00:00	NQ	Futures	4574.99	4580.25	4574.7	4577.91	2932.0
2014-07-16 04:00:00	NQ	Futures	4578.21	4589.3	4577.33	4588.43	4660.0
2014-07-16 05:00:00	NQ	Futures	4588.72	4590.18	4586.97	4589.01	2327.0
2014-07-16 06:00:00	NQ	Futures	4589.3	4593.98	4588.13	4592.81	2949.0
2014-07-16 07:00:00	NQ	Futures	4592.81	4597.48	4591.64	4594.27	4240.0
2014-07-16 08:00:00	NQ	Futures	4594.27	4602.15	4592.81	4599.52	7090.0
2014-07-16 09:00:00	NQ	Futures	4599.82	4603.32	4589.01	4598.65	41245.0
2014-07-16 10:00:00	NQ	Futures	4598.36	4602.15	4583.75	4585.51	42189.0
2014-07-16 11:00:00	NQ	Futures	4585.51	4593.39	4578.5	4583.75	23967.0
2014-07-16 12:00:00	NQ	Futures	4583.75	4597.48	4582.88	4593.39	15671.0
2014-07-16 13:00:00	NQ	Futures	4593.39	4597.48	4590.47	4593.68	19098.0
2014-07-16 14:00:00	NQ	Futures	4593.39	4596.9	4591.05	4591.35	14384.0
2014-07-16 15:00:00	NQ	Futures	4591.64	4593.68	4582.88	4583.46	24005.0
2014-07-16 16:00:00	NQ	Futures	4583.46	4585.8	4578.79	4579.08	5486.0
2014-07-16 17:00:00	NQ	Futures	4579.08	4580.83	4577.62	4577.62	842.0
2014-07-16 18:00:00	NQ	Futures	4577.62	4579.08	4575.58	4576.16	1137.0
2014-07-16 19:00:00	NQ	Futures	4576.16	4577.91	4575.58	4577.91	250.0
2014-07-16 20:00:00	NQ	Futures	4577.91	4580.54	4577.62	4579.37	490.0
2014-07-16 21:00:00	NQ	Futures	4579.37	4579.96	4576.45	4578.79	296.0
2014-07-16 22:00:00	NQ	Futures	4578.5	4578.79	4574.7	4574.99	531.0
2014-07-16 23:00:00	NQ	Futures	4574.99	4575.87	4572.07	4573.53	693.0
2014-07-16 00:00:00	YM	Futures	17582.5	17583.5	17577.3	17582.5	256.0
2014-07-16 01:00:00	YM	Futures	17583.5	17588.7	17581.4	17586.6	271.0

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

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