PREVIEW / futures_1hour / 2014-09-01

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-09-01.parquet
  size:    33 KB
  rows:    1,028

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-09-01 00:00:00	ES	Futures	2085.69	2086.21	2085.43	2086.21	879.0
2014-09-01 01:00:00	ES	Futures	2085.95	2086.48	2085.43	2085.95	1416.0
2014-09-01 02:00:00	ES	Futures	2085.95	2086.48	2084.65	2084.91	3846.0
2014-09-01 03:00:00	ES	Futures	2084.91	2085.95	2083.35	2085.43	14907.0
2014-09-01 04:00:00	ES	Futures	2085.43	2085.69	2082.05	2082.57	8955.0
2014-09-01 05:00:00	ES	Futures	2082.57	2084.65	2082.57	2084.39	6455.0
2014-09-01 06:00:00	ES	Futures	2084.39	2086.21	2084.13	2085.43	5596.0
2014-09-01 07:00:00	ES	Futures	2085.43	2085.69	2083.87	2085.17	4896.0
2014-09-01 08:00:00	ES	Futures	2085.43	2085.43	2083.61	2083.87	4474.0
2014-09-01 09:00:00	ES	Futures	2083.87	2084.65	2083.35	2084.65	7677.0
2014-09-01 10:00:00	ES	Futures	2084.65	2084.91	2084.13	2084.91	4985.0
2014-09-01 11:00:00	ES	Futures	2084.91	2085.69	2084.65	2085.17	5433.0
2014-09-01 12:00:00	ES	Futures	2085.17	2086.48	2085.17	2085.95	3576.0
2014-09-01 18:00:00	ES	Futures	2085.43	2085.69	2084.39	2084.65	2372.0
2014-09-01 19:00:00	ES	Futures	2084.65	2085.95	2084.39	2085.69	1325.0
2014-09-01 20:00:00	ES	Futures	2085.69	2086.48	2084.65	2085.43	4449.0
2014-09-01 21:00:00	ES	Futures	2085.43	2087.78	2085.43	2087.52	6092.0
2014-09-01 22:00:00	ES	Futures	2087.78	2088.82	2086.74	2086.74	5876.0
2014-09-01 23:00:00	ES	Futures	2087.0	2088.3	2086.48	2088.04	2211.0
2014-09-01 00:00:00	NQ	Futures	4769.77	4771.52	4769.48	4771.52	284.0
2014-09-01 01:00:00	NQ	Futures	4771.23	4771.23	4769.18	4770.35	329.0
2014-09-01 02:00:00	NQ	Futures	4770.35	4770.94	4766.56	4766.85	597.0
2014-09-01 03:00:00	NQ	Futures	4766.85	4769.48	4763.34	4768.02	1834.0
2014-09-01 04:00:00	NQ	Futures	4768.31	4768.89	4761.01	4763.05	923.0
2014-09-01 05:00:00	NQ	Futures	4763.34	4766.26	4763.05	4764.8	758.0
2014-09-01 06:00:00	NQ	Futures	4765.1	4769.48	4764.51	4767.72	1217.0
2014-09-01 07:00:00	NQ	Futures	4767.72	4768.89	4765.68	4768.89	597.0
2014-09-01 08:00:00	NQ	Futures	4769.18	4769.48	4766.85	4767.43	870.0
2014-09-01 09:00:00	NQ	Futures	4767.43	4768.89	4766.26	4767.72	1311.0
2014-09-01 10:00:00	NQ	Futures	4768.02	4769.18	4766.85	4768.89	1055.0
2014-09-01 11:00:00	NQ	Futures	4769.18	4770.35	4768.89	4769.48	502.0
2014-09-01 12:00:00	NQ	Futures	4769.48	4771.52	4768.6	4770.35	523.0
2014-09-01 18:00:00	NQ	Futures	4768.6	4769.77	4766.56	4767.14	388.0
2014-09-01 19:00:00	NQ	Futures	4767.43	4769.77	4767.14	4768.6	163.0
2014-09-01 20:00:00	NQ	Futures	4769.18	4770.06	4767.43	4768.89	597.0
2014-09-01 21:00:00	NQ	Futures	4768.89	4773.27	4768.89	4772.98	1166.0
2014-09-01 22:00:00	NQ	Futures	4772.69	4775.32	4770.94	4771.52	1152.0
2014-09-01 23:00:00	NQ	Futures	4771.52	4775.32	4770.64	4774.44	514.0
2014-09-01 00:00:00	YM	Futures	17680.7	17682.8	17678.7	17680.7	181.0
2014-09-01 01:00:00	YM	Futures	17680.7	17680.7	17674.5	17677.6	325.0
2014-09-01 02:00:00	YM	Futures	17677.6	17681.8	17668.3	17669.4	958.0
2014-09-01 03:00:00	YM	Futures	17670.4	17675.6	17653.8	17672.5	3342.0
2014-09-01 04:00:00	YM	Futures	17670.4	17673.5	17642.5	17648.7	1481.0
2014-09-01 05:00:00	YM	Futures	17648.7	17663.2	17647.6	17662.1	1057.0
2014-09-01 06:00:00	YM	Futures	17662.1	17678.7	17661.1	17672.5	805.0
2014-09-01 07:00:00	YM	Futures	17672.5	17673.5	17664.2	17672.5	822.0
2014-09-01 08:00:00	YM	Futures	17672.5	17673.5	17661.1	17662.1	643.0
2014-09-01 09:00:00	YM	Futures	17663.2	17670.4	17660.1	17669.4	851.0
2014-09-01 10:00:00	YM	Futures	17669.4	17672.5	17667.3	17671.4	503.0
2014-09-01 11:00:00	YM	Futures	17672.5	17677.6	17671.4	17673.5	670.0

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

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