PREVIEW / futures_1hour / 2015-07-03

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-07-03.parquet
  size:    30 KB
  rows:    829

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
2015-07-03 00:00:00	ES	Futures	2203.74	2204.54	2203.47	2204.54	814.0
2015-07-03 01:00:00	ES	Futures	2204.8	2206.4	2204.27	2205.07	2265.0
2015-07-03 02:00:00	ES	Futures	2205.07	2205.33	2203.47	2205.07	4638.0
2015-07-03 03:00:00	ES	Futures	2205.07	2205.87	2201.61	2202.94	14778.0
2015-07-03 04:00:00	ES	Futures	2202.94	2203.2	2199.74	2202.67	10196.0
2015-07-03 05:00:00	ES	Futures	2202.41	2204.27	2201.34	2202.67	6145.0
2015-07-03 06:00:00	ES	Futures	2202.41	2203.2	2201.61	2202.14	4538.0
2015-07-03 07:00:00	ES	Futures	2202.41	2203.47	2201.61	2202.14	3521.0
2015-07-03 08:00:00	ES	Futures	2202.14	2203.74	2200.54	2202.94	9370.0
2015-07-03 09:00:00	ES	Futures	2202.67	2202.94	2197.88	2199.48	12778.0
2015-07-03 10:00:00	ES	Futures	2199.48	2201.34	2197.35	2200.81	12944.0
2015-07-03 11:00:00	ES	Futures	2200.81	2202.41	2198.15	2198.68	14085.0
2015-07-03 12:00:00	ES	Futures	2198.41	2201.34	2197.88	2201.07	9320.0
2015-07-03 13:00:00	ES	Futures	2201.34	2201.34	2201.34	2201.34	1.0
2015-07-03 00:00:00	NQ	Futures	5239.32	5243.46	5239.02	5243.46	319.0
2015-07-03 01:00:00	NQ	Futures	5243.16	5248.49	5241.09	5241.68	519.0
2015-07-03 02:00:00	NQ	Futures	5242.57	5244.05	5239.61	5243.75	595.0
2015-07-03 03:00:00	NQ	Futures	5243.46	5246.71	5235.47	5240.5	1925.0
2015-07-03 04:00:00	NQ	Futures	5240.5	5241.39	5231.92	5236.95	1537.0
2015-07-03 05:00:00	NQ	Futures	5236.66	5244.35	5234.88	5238.13	1226.0
2015-07-03 06:00:00	NQ	Futures	5238.43	5240.5	5236.36	5238.13	705.0
2015-07-03 07:00:00	NQ	Futures	5238.43	5240.21	5236.66	5236.95	468.0
2015-07-03 08:00:00	NQ	Futures	5237.54	5240.5	5234.29	5236.95	1720.0
2015-07-03 09:00:00	NQ	Futures	5236.66	5237.84	5223.35	5226.3	2835.0
2015-07-03 10:00:00	NQ	Futures	5226.6	5229.56	5220.09	5227.19	3342.0
2015-07-03 11:00:00	NQ	Futures	5227.19	5235.18	5220.09	5223.05	2943.0
2015-07-03 12:00:00	NQ	Futures	5223.05	5227.78	5222.75	5226.89	1326.0
2015-07-03 00:00:00	YM	Futures	18592.5	18600.9	18589.4	18599.9	124.0
2015-07-03 01:00:00	YM	Futures	18602.0	18615.7	18596.7	18600.9	521.0
2015-07-03 02:00:00	YM	Futures	18602.0	18603.1	18588.3	18602.0	526.0
2015-07-03 03:00:00	YM	Futures	18602.0	18608.3	18575.7	18589.4	1619.0
2015-07-03 04:00:00	YM	Futures	18588.3	18588.3	18562.0	18574.6	1395.0
2015-07-03 05:00:00	YM	Futures	18575.7	18598.8	18567.2	18582.0	996.0
2015-07-03 06:00:00	YM	Futures	18582.0	18589.4	18566.2	18577.8	1087.0
2015-07-03 07:00:00	YM	Futures	18576.7	18584.1	18571.4	18573.6	562.0
2015-07-03 08:00:00	YM	Futures	18574.6	18588.3	18564.1	18583.0	1245.0
2015-07-03 09:00:00	YM	Futures	18580.9	18580.9	18531.4	18554.6	2954.0
2015-07-03 10:00:00	YM	Futures	18554.6	18573.6	18543.0	18569.3	2371.0
2015-07-03 11:00:00	YM	Futures	18568.3	18582.0	18547.2	18553.5	2262.0
2015-07-03 12:00:00	YM	Futures	18552.5	18575.7	18549.3	18562.0	1082.0
2015-07-03 00:00:00	CL	Futures	84.51	84.57	84.44	84.5	706.0
2015-07-03 01:00:00	CL	Futures	84.48	84.51	84.29	84.37	896.0
2015-07-03 02:00:00	CL	Futures	84.38	84.5	84.32	84.38	1147.0
2015-07-03 03:00:00	CL	Futures	84.39	84.47	84.14	84.32	3187.0
2015-07-03 04:00:00	CL	Futures	84.32	84.37	84.19	84.35	2424.0
2015-07-03 05:00:00	CL	Futures	84.35	84.38	84.22	84.25	1543.0
2015-07-03 06:00:00	CL	Futures	84.26	84.35	84.22	84.29	1133.0
2015-07-03 07:00:00	CL	Futures	84.29	84.29	84.17	84.19	1099.0
2015-07-03 08:00:00	CL	Futures	84.19	84.5	84.08	84.48	5057.0
2015-07-03 09:00:00	CL	Futures	84.48	84.6	84.16	84.2	6383.0

> showing 50 of 829 rows — these rows as CSV

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