PREVIEW / futures_1hour / 2014-08-27

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-08-27.parquet
  size:    46 KB
  rows:    1,499

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-27 00:00:00	ES	Futures	2083.35	2083.61	2082.83	2083.09	2270.0
2014-08-27 01:00:00	ES	Futures	2083.35	2084.39	2083.35	2083.87	2412.0
2014-08-27 02:00:00	ES	Futures	2083.87	2084.13	2083.35	2083.61	4961.0
2014-08-27 03:00:00	ES	Futures	2083.61	2085.43	2083.09	2083.61	16382.0
2014-08-27 04:00:00	ES	Futures	2083.35	2084.91	2083.09	2084.39	9816.0
2014-08-27 05:00:00	ES	Futures	2084.39	2085.43	2084.13	2084.39	9237.0
2014-08-27 06:00:00	ES	Futures	2084.39	2084.91	2083.87	2084.65	8889.0
2014-08-27 07:00:00	ES	Futures	2084.65	2085.43	2083.35	2083.35	10560.0
2014-08-27 08:00:00	ES	Futures	2083.35	2084.39	2081.78	2082.31	15709.0
2014-08-27 09:00:00	ES	Futures	2082.31	2084.91	2080.48	2081.0	133848.0
2014-08-27 10:00:00	ES	Futures	2080.74	2083.09	2079.44	2082.83	128902.0
2014-08-27 11:00:00	ES	Futures	2082.83	2084.39	2081.78	2083.09	92873.0
2014-08-27 12:00:00	ES	Futures	2083.09	2083.35	2081.0	2082.83	39082.0
2014-08-27 13:00:00	ES	Futures	2082.83	2082.83	2082.05	2082.57	22753.0
2014-08-27 14:00:00	ES	Futures	2082.31	2082.83	2078.92	2079.18	57904.0
2014-08-27 15:00:00	ES	Futures	2078.92	2082.31	2078.14	2081.52	117286.0
2014-08-27 16:00:00	ES	Futures	2081.78	2082.31	2081.52	2081.78	69065.0
2014-08-27 17:00:00	ES	Futures	2081.52	2081.78	2081.26	2081.78	2004.0
2014-08-27 18:00:00	ES	Futures	2081.52	2081.52	2081.0	2081.26	1757.0
2014-08-27 19:00:00	ES	Futures	2081.26	2081.78	2081.0	2081.52	988.0
2014-08-27 20:00:00	ES	Futures	2081.52	2081.78	2080.74	2081.0	2735.0
2014-08-27 21:00:00	ES	Futures	2081.26	2082.31	2081.26	2081.78	2422.0
2014-08-27 22:00:00	ES	Futures	2081.78	2082.05	2081.26	2081.26	874.0
2014-08-27 23:00:00	ES	Futures	2081.52	2081.78	2081.0	2081.26	1611.0
2014-08-27 00:00:00	NQ	Futures	4758.09	4758.09	4756.04	4757.5	232.0
2014-08-27 01:00:00	NQ	Futures	4757.5	4760.42	4757.5	4759.55	430.0
2014-08-27 02:00:00	NQ	Futures	4759.84	4759.84	4758.38	4758.67	544.0
2014-08-27 03:00:00	NQ	Futures	4758.96	4762.18	4756.34	4757.21	2495.0
2014-08-27 04:00:00	NQ	Futures	4756.92	4761.59	4756.63	4760.42	1370.0
2014-08-27 05:00:00	NQ	Futures	4760.72	4761.88	4759.55	4759.84	1376.0
2014-08-27 06:00:00	NQ	Futures	4759.84	4760.72	4758.09	4759.55	982.0
2014-08-27 07:00:00	NQ	Futures	4759.26	4760.72	4757.21	4757.21	1376.0
2014-08-27 08:00:00	NQ	Futures	4757.21	4759.26	4754.29	4755.46	2145.0
2014-08-27 09:00:00	NQ	Futures	4755.46	4759.55	4746.41	4747.87	26026.0
2014-08-27 10:00:00	NQ	Futures	4747.57	4757.8	4746.41	4757.5	24808.0
2014-08-27 11:00:00	NQ	Futures	4757.5	4761.88	4754.29	4759.26	16852.0
2014-08-27 12:00:00	NQ	Futures	4759.26	4760.42	4756.04	4758.67	7952.0
2014-08-27 13:00:00	NQ	Futures	4758.38	4760.42	4756.92	4759.26	5624.0
2014-08-27 14:00:00	NQ	Futures	4759.26	4762.18	4752.25	4752.25	9103.0
2014-08-27 15:00:00	NQ	Futures	4752.25	4757.21	4748.74	4756.63	20443.0
2014-08-27 16:00:00	NQ	Futures	4756.63	4758.38	4756.34	4757.21	4253.0
2014-08-27 17:00:00	NQ	Futures	4757.21	4757.21	4755.46	4756.63	298.0
2014-08-27 18:00:00	NQ	Futures	4755.75	4756.04	4754.58	4755.46	262.0
2014-08-27 19:00:00	NQ	Futures	4755.46	4756.34	4754.88	4755.75	101.0
2014-08-27 20:00:00	NQ	Futures	4756.04	4756.04	4754.88	4755.75	439.0
2014-08-27 21:00:00	NQ	Futures	4755.75	4757.8	4755.46	4757.21	461.0
2014-08-27 22:00:00	NQ	Futures	4756.92	4757.8	4756.34	4756.34	170.0
2014-08-27 23:00:00	NQ	Futures	4756.63	4756.92	4755.17	4755.17	339.0
2014-08-27 00:00:00	YM	Futures	17692.1	17692.1	17675.6	17688.0	1457.0
2014-08-27 01:00:00	YM	Futures	17689.0	17699.4	17689.0	17697.3	725.0

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

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