PREVIEW / futures_1hour / 2014-07-28

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-07-28.parquet
  size:    46 KB
  rows:    1,519

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-28 00:00:00	ES	Futures	2052.34	2052.86	2052.07	2052.6	1842.0
2014-07-28 01:00:00	ES	Futures	2052.86	2053.12	2051.55	2051.81	2589.0
2014-07-28 02:00:00	ES	Futures	2052.07	2057.03	2052.07	2056.5	13843.0
2014-07-28 03:00:00	ES	Futures	2056.5	2056.5	2051.81	2052.07	32806.0
2014-07-28 04:00:00	ES	Futures	2052.07	2053.9	2051.29	2052.34	20534.0
2014-07-28 05:00:00	ES	Futures	2052.34	2054.68	2052.07	2053.38	12963.0
2014-07-28 06:00:00	ES	Futures	2053.38	2055.46	2052.86	2054.16	12587.0
2014-07-28 07:00:00	ES	Futures	2054.42	2055.46	2052.07	2053.12	17842.0
2014-07-28 08:00:00	ES	Futures	2053.12	2058.33	2053.12	2057.29	32628.0
2014-07-28 09:00:00	ES	Futures	2057.29	2057.55	2047.12	2050.25	215758.0
2014-07-28 10:00:00	ES	Futures	2050.25	2050.51	2044.0	2047.38	277100.0
2014-07-28 11:00:00	ES	Futures	2047.38	2054.42	2046.86	2052.07	184946.0
2014-07-28 12:00:00	ES	Futures	2052.34	2053.38	2050.25	2052.86	70124.0
2014-07-28 13:00:00	ES	Futures	2052.86	2059.89	2051.81	2058.33	146726.0
2014-07-28 14:00:00	ES	Futures	2058.59	2059.63	2055.46	2058.33	103609.0
2014-07-28 15:00:00	ES	Futures	2058.07	2058.59	2055.98	2056.77	130783.0
2014-07-28 16:00:00	ES	Futures	2056.77	2057.03	2054.94	2055.72	53060.0
2014-07-28 17:00:00	ES	Futures	2055.72	2056.24	2055.46	2056.24	1767.0
2014-07-28 18:00:00	ES	Futures	2056.24	2057.29	2055.72	2057.03	3243.0
2014-07-28 19:00:00	ES	Futures	2057.03	2057.29	2056.77	2056.77	714.0
2014-07-28 20:00:00	ES	Futures	2056.77	2057.29	2056.24	2057.03	3319.0
2014-07-28 21:00:00	ES	Futures	2056.77	2057.29	2056.24	2056.24	3912.0
2014-07-28 22:00:00	ES	Futures	2056.24	2056.5	2054.94	2054.94	2876.0
2014-07-28 23:00:00	ES	Futures	2054.94	2055.98	2054.94	2055.46	2081.0
2014-07-28 00:00:00	NQ	Futures	4617.34	4618.5	4615.88	4617.63	352.0
2014-07-28 01:00:00	NQ	Futures	4617.63	4618.21	4615.58	4616.46	491.0
2014-07-28 02:00:00	NQ	Futures	4617.04	4629.31	4616.75	4629.02	1721.0
2014-07-28 03:00:00	NQ	Futures	4628.43	4628.72	4614.12	4615.88	4744.0
2014-07-28 04:00:00	NQ	Futures	4615.29	4620.26	4614.12	4615.88	2630.0
2014-07-28 05:00:00	NQ	Futures	4615.88	4621.72	4615.29	4617.92	1895.0
2014-07-28 06:00:00	NQ	Futures	4617.92	4623.76	4617.63	4620.84	1337.0
2014-07-28 07:00:00	NQ	Futures	4621.13	4623.18	4615.58	4617.92	2313.0
2014-07-28 08:00:00	NQ	Futures	4617.63	4632.23	4617.63	4629.31	4642.0
2014-07-28 09:00:00	NQ	Futures	4629.02	4629.89	4603.32	4611.2	31065.0
2014-07-28 10:00:00	NQ	Futures	4610.91	4611.5	4589.3	4600.69	49760.0
2014-07-28 11:00:00	NQ	Futures	4600.98	4622.59	4599.82	4613.83	32655.0
2014-07-28 12:00:00	NQ	Futures	4613.83	4620.26	4609.16	4618.21	12527.0
2014-07-28 13:00:00	NQ	Futures	4617.92	4637.49	4615.58	4632.23	24138.0
2014-07-28 14:00:00	NQ	Futures	4632.52	4634.27	4624.64	4631.06	14983.0
2014-07-28 15:00:00	NQ	Futures	4631.06	4631.94	4623.76	4625.51	17610.0
2014-07-28 16:00:00	NQ	Futures	4625.22	4627.26	4623.18	4624.64	3790.0
2014-07-28 17:00:00	NQ	Futures	4624.64	4625.22	4623.18	4623.76	340.0
2014-07-28 18:00:00	NQ	Futures	4623.76	4625.8	4622.3	4624.93	415.0
2014-07-28 19:00:00	NQ	Futures	4624.93	4625.22	4624.05	4624.64	151.0
2014-07-28 20:00:00	NQ	Futures	4624.34	4625.51	4623.47	4625.51	473.0
2014-07-28 21:00:00	NQ	Futures	4625.51	4626.39	4624.05	4624.05	458.0
2014-07-28 22:00:00	NQ	Futures	4624.05	4624.05	4618.21	4618.8	799.0
2014-07-28 23:00:00	NQ	Futures	4618.8	4620.55	4618.5	4619.67	419.0
2014-07-28 00:00:00	YM	Futures	17454.2	17459.4	17452.1	17456.3	257.0
2014-07-28 01:00:00	YM	Futures	17457.3	17459.4	17449.0	17452.1	478.0

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

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