PREVIEW / futures_1hour / 2014-08-29

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-08-29.parquet
  size:    40 KB
  rows:    1,238

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-29 00:00:00	ES	Futures	2083.09	2083.61	2082.57	2083.35	1245.0
2014-08-29 01:00:00	ES	Futures	2083.35	2083.61	2082.83	2083.35	1802.0
2014-08-29 02:00:00	ES	Futures	2083.35	2083.87	2082.57	2083.35	3862.0
2014-08-29 03:00:00	ES	Futures	2083.35	2088.82	2083.09	2087.52	32770.0
2014-08-29 04:00:00	ES	Futures	2087.26	2087.78	2085.95	2087.0	17989.0
2014-08-29 05:00:00	ES	Futures	2086.74	2087.0	2084.13	2085.43	15419.0
2014-08-29 06:00:00	ES	Futures	2085.17	2087.78	2084.91	2086.74	12964.0
2014-08-29 07:00:00	ES	Futures	2086.74	2087.78	2085.43	2085.69	19816.0
2014-08-29 08:00:00	ES	Futures	2085.69	2087.0	2083.09	2083.35	24600.0
2014-08-29 09:00:00	ES	Futures	2083.61	2084.91	2078.92	2080.74	133926.0
2014-08-29 10:00:00	ES	Futures	2080.48	2081.78	2076.83	2081.52	179013.0
2014-08-29 11:00:00	ES	Futures	2081.78	2086.21	2081.52	2085.43	141642.0
2014-08-29 12:00:00	ES	Futures	2085.69	2086.74	2083.09	2084.13	69492.0
2014-08-29 13:00:00	ES	Futures	2084.13	2084.65	2082.57	2083.35	44384.0
2014-08-29 14:00:00	ES	Futures	2083.35	2084.13	2082.05	2083.09	46725.0
2014-08-29 15:00:00	ES	Futures	2082.83	2086.74	2081.78	2086.21	186856.0
2014-08-29 16:00:00	ES	Futures	2086.21	2086.48	2083.09	2083.61	93587.0
2014-08-29 17:00:00	ES	Futures	2083.61	2084.13	2083.35	2083.61	897.0
2014-08-29 00:00:00	NQ	Futures	4758.38	4759.26	4756.92	4759.26	219.0
2014-08-29 01:00:00	NQ	Futures	4759.26	4759.26	4757.21	4758.67	257.0
2014-08-29 02:00:00	NQ	Futures	4758.96	4759.84	4758.09	4759.55	511.0
2014-08-29 03:00:00	NQ	Futures	4759.55	4772.69	4758.38	4769.77	5405.0
2014-08-29 04:00:00	NQ	Futures	4770.06	4770.64	4767.14	4768.31	2910.0
2014-08-29 05:00:00	NQ	Futures	4768.6	4769.18	4761.3	4763.64	2660.0
2014-08-29 06:00:00	NQ	Futures	4763.64	4768.31	4762.18	4766.26	2067.0
2014-08-29 07:00:00	NQ	Futures	4766.26	4768.02	4763.93	4764.8	2855.0
2014-08-29 08:00:00	NQ	Futures	4765.1	4766.56	4757.8	4758.38	4646.0
2014-08-29 09:00:00	NQ	Futures	4758.38	4765.97	4751.66	4754.88	30462.0
2014-08-29 10:00:00	NQ	Futures	4754.58	4760.13	4744.65	4760.13	34763.0
2014-08-29 11:00:00	NQ	Futures	4760.13	4769.77	4760.13	4767.72	24051.0
2014-08-29 12:00:00	NQ	Futures	4768.02	4768.89	4761.01	4764.22	12782.0
2014-08-29 13:00:00	NQ	Futures	4763.93	4765.1	4756.92	4760.72	8944.0
2014-08-29 14:00:00	NQ	Futures	4760.72	4763.64	4759.55	4761.59	7525.0
2014-08-29 15:00:00	NQ	Futures	4761.3	4769.77	4758.67	4769.18	19441.0
2014-08-29 16:00:00	NQ	Futures	4769.18	4769.77	4762.76	4763.93	6282.0
2014-08-29 17:00:00	NQ	Futures	4763.93	4765.1	4763.34	4764.22	139.0
2014-08-29 00:00:00	YM	Futures	17681.8	17686.9	17679.7	17685.9	274.0
2014-08-29 01:00:00	YM	Futures	17685.9	17685.9	17679.7	17683.8	329.0
2014-08-29 02:00:00	YM	Futures	17684.9	17686.9	17678.7	17685.9	523.0
2014-08-29 03:00:00	YM	Futures	17684.9	17725.2	17682.8	17714.9	4749.0
2014-08-29 04:00:00	YM	Futures	17713.8	17717.0	17700.4	17708.7	3226.0
2014-08-29 05:00:00	YM	Futures	17707.6	17707.6	17688.0	17695.2	2469.0
2014-08-29 06:00:00	YM	Futures	17694.2	17711.8	17691.1	17703.5	1917.0
2014-08-29 07:00:00	YM	Futures	17702.5	17711.8	17694.2	17697.3	2781.0
2014-08-29 08:00:00	YM	Futures	17696.3	17703.5	17670.4	17676.6	3211.0
2014-08-29 09:00:00	YM	Futures	17678.7	17686.9	17632.1	17647.6	14337.0
2014-08-29 10:00:00	YM	Futures	17647.6	17647.6	17609.4	17636.3	18296.0
2014-08-29 11:00:00	YM	Futures	17637.3	17678.7	17636.3	17674.5	13287.0
2014-08-29 12:00:00	YM	Futures	17675.6	17682.8	17654.9	17662.1	6310.0
2014-08-29 13:00:00	YM	Futures	17662.1	17665.2	17644.5	17648.7	3844.0

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

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