PREVIEW / futures_1hour / 2014-08-26

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-08-26.parquet
  size:    47 KB
  rows:    1,540

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-08-26 00:00:00	ES	Futures	2077.35	2078.4	2077.35	2078.4	1135.0
2014-08-26 01:00:00	ES	Futures	2078.4	2078.4	2077.09	2077.61	1691.0
2014-08-26 02:00:00	ES	Futures	2077.35	2078.92	2077.09	2078.92	6284.0
2014-08-26 03:00:00	ES	Futures	2078.66	2079.7	2077.88	2078.92	18447.0
2014-08-26 04:00:00	ES	Futures	2079.18	2080.48	2078.66	2078.92	8048.0
2014-08-26 05:00:00	ES	Futures	2079.18	2079.7	2076.83	2078.14	13047.0
2014-08-26 06:00:00	ES	Futures	2077.88	2082.83	2077.88	2081.52	28436.0
2014-08-26 07:00:00	ES	Futures	2081.78	2083.87	2081.52	2082.57	22770.0
2014-08-26 08:00:00	ES	Futures	2082.83	2083.09	2080.48	2082.05	22406.0
2014-08-26 09:00:00	ES	Futures	2081.78	2084.91	2081.52	2084.13	128416.0
2014-08-26 10:00:00	ES	Futures	2084.13	2087.0	2082.05	2086.74	179619.0
2014-08-26 11:00:00	ES	Futures	2087.0	2087.78	2084.39	2084.91	103378.0
2014-08-26 12:00:00	ES	Futures	2084.91	2085.95	2083.09	2083.35	75706.0
2014-08-26 13:00:00	ES	Futures	2083.35	2084.65	2082.05	2084.13	66008.0
2014-08-26 14:00:00	ES	Futures	2084.39	2084.91	2083.35	2084.39	35066.0
2014-08-26 15:00:00	ES	Futures	2084.65	2084.65	2081.78	2082.57	96965.0
2014-08-26 16:00:00	ES	Futures	2082.31	2083.87	2082.05	2083.87	46329.0
2014-08-26 17:00:00	ES	Futures	2083.87	2083.87	2083.35	2083.61	1088.0
2014-08-26 18:00:00	ES	Futures	2084.13	2084.13	2083.35	2083.35	1958.0
2014-08-26 19:00:00	ES	Futures	2083.61	2083.87	2083.09	2083.61	1175.0
2014-08-26 20:00:00	ES	Futures	2083.35	2084.65	2083.35	2083.87	3760.0
2014-08-26 21:00:00	ES	Futures	2083.87	2084.39	2083.35	2083.61	2550.0
2014-08-26 22:00:00	ES	Futures	2083.87	2084.39	2083.35	2084.39	2051.0
2014-08-26 23:00:00	ES	Futures	2084.39	2084.39	2083.35	2083.61	2446.0
2014-08-26 00:00:00	NQ	Futures	4745.53	4746.99	4745.24	4746.7	147.0
2014-08-26 01:00:00	NQ	Futures	4746.7	4747.57	4744.65	4745.53	525.0
2014-08-26 02:00:00	NQ	Futures	4745.53	4747.57	4744.36	4747.28	840.0
2014-08-26 03:00:00	NQ	Futures	4747.28	4748.74	4744.95	4748.45	2701.0
2014-08-26 04:00:00	NQ	Futures	4748.45	4751.37	4748.16	4749.03	1169.0
2014-08-26 05:00:00	NQ	Futures	4749.03	4750.49	4744.36	4746.41	1937.0
2014-08-26 06:00:00	NQ	Futures	4746.11	4754.88	4746.11	4752.54	3472.0
2014-08-26 07:00:00	NQ	Futures	4752.25	4757.21	4752.25	4755.17	3711.0
2014-08-26 08:00:00	NQ	Futures	4755.46	4756.92	4751.66	4754.29	3545.0
2014-08-26 09:00:00	NQ	Futures	4754.29	4758.38	4745.53	4753.12	28691.0
2014-08-26 10:00:00	NQ	Futures	4752.83	4755.75	4744.36	4754.88	36714.0
2014-08-26 11:00:00	NQ	Futures	4755.17	4758.67	4754.0	4754.58	16721.0
2014-08-26 12:00:00	NQ	Futures	4754.88	4758.38	4752.25	4753.12	11240.0
2014-08-26 13:00:00	NQ	Futures	4752.83	4756.63	4750.79	4756.63	7714.0
2014-08-26 14:00:00	NQ	Futures	4756.63	4760.72	4756.04	4759.84	8453.0
2014-08-26 15:00:00	NQ	Futures	4759.55	4760.42	4754.88	4755.75	13722.0
2014-08-26 16:00:00	NQ	Futures	4755.75	4758.38	4754.88	4757.8	3301.0
2014-08-26 17:00:00	NQ	Futures	4757.8	4758.96	4756.92	4758.38	360.0
2014-08-26 18:00:00	NQ	Futures	4758.09	4758.67	4757.21	4757.8	351.0
2014-08-26 19:00:00	NQ	Futures	4757.8	4758.67	4756.63	4757.8	265.0
2014-08-26 20:00:00	NQ	Futures	4757.5	4759.84	4756.92	4758.96	357.0
2014-08-26 21:00:00	NQ	Futures	4758.38	4759.26	4757.5	4758.09	329.0
2014-08-26 22:00:00	NQ	Futures	4758.09	4759.55	4757.5	4759.26	360.0
2014-08-26 23:00:00	NQ	Futures	4758.96	4759.26	4757.21	4758.09	239.0
2014-08-26 00:00:00	YM	Futures	17634.2	17639.4	17632.1	17637.3	307.0
2014-08-26 01:00:00	YM	Futures	17639.4	17640.4	17631.1	17636.3	490.0

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

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