PREVIEW / futures_1hour / 2014-08-28

all futures 1-hour files

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

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-28 00:00:00	ES	Futures	2081.0	2081.52	2081.0	2081.26	546.0
2014-08-28 01:00:00	ES	Futures	2081.26	2081.26	2079.96	2080.22	2888.0
2014-08-28 02:00:00	ES	Futures	2080.48	2081.26	2079.96	2080.22	5923.0
2014-08-28 03:00:00	ES	Futures	2079.96	2081.26	2078.66	2079.18	23419.0
2014-08-28 04:00:00	ES	Futures	2079.18	2079.7	2077.88	2079.18	17653.0
2014-08-28 05:00:00	ES	Futures	2079.18	2079.7	2073.18	2074.23	30839.0
2014-08-28 06:00:00	ES	Futures	2074.23	2075.27	2071.88	2073.71	42304.0
2014-08-28 07:00:00	ES	Futures	2073.97	2077.88	2073.44	2074.49	44301.0
2014-08-28 08:00:00	ES	Futures	2074.75	2077.35	2073.71	2074.49	34008.0
2014-08-28 09:00:00	ES	Futures	2074.75	2077.61	2072.4	2077.09	186675.0
2014-08-28 10:00:00	ES	Futures	2076.83	2079.18	2073.71	2078.4	197647.0
2014-08-28 11:00:00	ES	Futures	2078.4	2079.44	2076.83	2078.66	118462.0
2014-08-28 12:00:00	ES	Futures	2078.66	2081.78	2078.14	2081.0	81155.0
2014-08-28 13:00:00	ES	Futures	2080.74	2081.52	2079.7	2080.74	46381.0
2014-08-28 14:00:00	ES	Futures	2080.74	2081.52	2079.44	2079.7	50888.0
2014-08-28 15:00:00	ES	Futures	2079.7	2081.26	2078.4	2080.48	114452.0
2014-08-28 16:00:00	ES	Futures	2080.74	2083.61	2080.22	2083.35	66570.0
2014-08-28 17:00:00	ES	Futures	2083.35	2084.39	2083.35	2084.39	5782.0
2014-08-28 18:00:00	ES	Futures	2084.13	2084.13	2082.83	2083.35	2972.0
2014-08-28 19:00:00	ES	Futures	2083.09	2083.35	2082.83	2083.09	814.0
2014-08-28 20:00:00	ES	Futures	2082.83	2084.39	2082.83	2083.35	4564.0
2014-08-28 21:00:00	ES	Futures	2083.61	2083.87	2083.09	2083.09	2281.0
2014-08-28 22:00:00	ES	Futures	2083.09	2083.35	2082.57	2082.83	1881.0
2014-08-28 23:00:00	ES	Futures	2083.09	2083.35	2082.31	2083.09	1494.0
2014-08-28 00:00:00	NQ	Futures	4755.17	4756.04	4755.17	4755.75	104.0
2014-08-28 01:00:00	NQ	Futures	4755.75	4755.75	4753.71	4754.0	507.0
2014-08-28 02:00:00	NQ	Futures	4754.58	4756.34	4753.12	4753.42	544.0
2014-08-28 03:00:00	NQ	Futures	4754.0	4755.75	4749.62	4750.2	3399.0
2014-08-28 04:00:00	NQ	Futures	4750.2	4750.79	4747.57	4749.62	2679.0
2014-08-28 05:00:00	NQ	Futures	4749.62	4751.08	4737.65	4739.4	5056.0
2014-08-28 06:00:00	NQ	Futures	4739.4	4742.9	4735.89	4739.98	8542.0
2014-08-28 07:00:00	NQ	Futures	4739.98	4749.03	4739.4	4743.49	6704.0
2014-08-28 08:00:00	NQ	Futures	4743.49	4747.57	4740.27	4742.61	6019.0
2014-08-28 09:00:00	NQ	Futures	4742.32	4747.57	4735.89	4745.24	31842.0
2014-08-28 10:00:00	NQ	Futures	4745.24	4750.79	4739.11	4748.16	30999.0
2014-08-28 11:00:00	NQ	Futures	4748.45	4750.49	4745.82	4747.87	16093.0
2014-08-28 12:00:00	NQ	Futures	4747.87	4756.92	4746.41	4753.71	12714.0
2014-08-28 13:00:00	NQ	Futures	4753.71	4754.58	4749.62	4752.54	8086.0
2014-08-28 14:00:00	NQ	Futures	4752.25	4754.88	4749.91	4750.2	8565.0
2014-08-28 15:00:00	NQ	Futures	4750.2	4754.88	4747.28	4750.49	17503.0
2014-08-28 16:00:00	NQ	Futures	4750.79	4758.96	4750.2	4758.67	4645.0
2014-08-28 17:00:00	NQ	Futures	4758.38	4761.3	4758.38	4760.72	424.0
2014-08-28 18:00:00	NQ	Futures	4760.42	4760.72	4757.8	4758.67	400.0
2014-08-28 19:00:00	NQ	Futures	4758.96	4758.96	4757.8	4758.38	95.0
2014-08-28 20:00:00	NQ	Futures	4758.67	4760.42	4757.8	4758.96	331.0
2014-08-28 21:00:00	NQ	Futures	4758.67	4760.13	4758.09	4758.67	421.0
2014-08-28 22:00:00	NQ	Futures	4758.67	4758.96	4757.21	4758.09	241.0
2014-08-28 23:00:00	NQ	Futures	4757.8	4758.09	4756.63	4758.09	263.0
2014-08-28 00:00:00	YM	Futures	17681.8	17685.9	17681.8	17682.8	176.0
2014-08-28 01:00:00	YM	Futures	17682.8	17684.9	17673.5	17674.5	514.0

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

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