PREVIEW / futures_1hour / 2016-03-23

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-03-23.parquet
  size:    53 KB
  rows:    1,600

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
2016-03-23 00:00:00	ES	Futures	2203.58	2204.93	2202.77	2204.12	3088.0
2016-03-23 01:00:00	ES	Futures	2204.12	2204.39	2200.61	2202.5	6524.0
2016-03-23 02:00:00	ES	Futures	2202.5	2204.12	2201.15	2202.5	5826.0
2016-03-23 03:00:00	ES	Futures	2202.5	2204.93	2202.23	2203.85	10900.0
2016-03-23 04:00:00	ES	Futures	2204.12	2208.71	2203.31	2206.55	27850.0
2016-03-23 05:00:00	ES	Futures	2206.55	2208.17	2204.66	2205.74	15561.0
2016-03-23 06:00:00	ES	Futures	2205.74	2206.82	2204.66	2204.93	14009.0
2016-03-23 07:00:00	ES	Futures	2205.2	2207.9	2204.66	2207.09	12528.0
2016-03-23 08:00:00	ES	Futures	2207.09	2208.17	2203.31	2203.85	30146.0
2016-03-23 09:00:00	ES	Futures	2203.85	2203.85	2194.94	2196.29	247373.0
2016-03-23 10:00:00	ES	Futures	2196.56	2201.42	2193.86	2196.29	288609.0
2016-03-23 11:00:00	ES	Futures	2196.29	2198.45	2190.89	2193.05	215834.0
2016-03-23 12:00:00	ES	Futures	2192.78	2198.45	2192.24	2196.83	134896.0
2016-03-23 13:00:00	ES	Futures	2196.56	2197.91	2193.86	2195.75	80163.0
2016-03-23 14:00:00	ES	Futures	2195.75	2198.72	2188.46	2189.27	146040.0
2016-03-23 15:00:00	ES	Futures	2189.27	2192.24	2187.11	2189.81	226920.0
2016-03-23 16:00:00	ES	Futures	2189.81	2192.51	2189.0	2190.35	62399.0
2016-03-23 18:00:00	ES	Futures	2190.08	2190.35	2188.73	2189.81	3627.0
2016-03-23 19:00:00	ES	Futures	2189.81	2190.35	2188.73	2190.08	3259.0
2016-03-23 20:00:00	ES	Futures	2190.35	2190.35	2186.57	2188.46	6982.0
2016-03-23 21:00:00	ES	Futures	2188.46	2189.27	2186.84	2189.0	5855.0
2016-03-23 22:00:00	ES	Futures	2189.0	2190.89	2187.38	2187.38	10192.0
2016-03-23 23:00:00	ES	Futures	2187.65	2187.92	2185.76	2186.3	8886.0
2016-03-23 00:00:00	NQ	Futures	5271.33	5273.71	5267.76	5271.33	356.0
2016-03-23 01:00:00	NQ	Futures	5270.44	5270.74	5262.71	5268.06	716.0
2016-03-23 02:00:00	NQ	Futures	5267.76	5271.93	5263.9	5266.87	425.0
2016-03-23 03:00:00	NQ	Futures	5268.36	5275.8	5267.76	5271.63	2019.0
2016-03-23 04:00:00	NQ	Futures	5271.93	5285.62	5270.74	5278.47	4290.0
2016-03-23 05:00:00	NQ	Futures	5277.88	5282.34	5274.01	5276.39	1862.0
2016-03-23 06:00:00	NQ	Futures	5276.39	5279.07	5274.01	5275.2	1578.0
2016-03-23 07:00:00	NQ	Futures	5275.8	5282.94	5274.31	5280.56	1696.0
2016-03-23 08:00:00	NQ	Futures	5280.85	5283.83	5274.01	5274.9	3192.0
2016-03-23 09:00:00	NQ	Futures	5274.61	5274.61	5244.26	5249.61	36248.0
2016-03-23 10:00:00	NQ	Futures	5249.91	5261.81	5240.09	5243.37	39809.0
2016-03-23 11:00:00	NQ	Futures	5243.37	5248.42	5227.89	5233.25	33494.0
2016-03-23 12:00:00	NQ	Futures	5233.25	5245.75	5230.57	5241.58	17680.0
2016-03-23 13:00:00	NQ	Futures	5240.99	5246.64	5236.82	5242.18	9088.0
2016-03-23 14:00:00	NQ	Futures	5242.18	5250.8	5224.62	5226.7	18267.0
2016-03-23 15:00:00	NQ	Futures	5227.0	5231.17	5216.59	5229.08	31375.0
2016-03-23 16:00:00	NQ	Futures	5228.79	5235.63	5227.6	5230.57	6190.0
2016-03-23 18:00:00	NQ	Futures	5230.57	5231.17	5224.92	5227.6	337.0
2016-03-23 19:00:00	NQ	Futures	5228.49	5230.57	5225.81	5229.08	282.0
2016-03-23 20:00:00	NQ	Futures	5229.38	5230.27	5218.67	5223.13	890.0
2016-03-23 21:00:00	NQ	Futures	5223.13	5226.7	5219.27	5226.41	536.0
2016-03-23 22:00:00	NQ	Futures	5226.11	5232.06	5223.43	5224.32	935.0
2016-03-23 23:00:00	NQ	Futures	5224.03	5224.62	5218.08	5219.56	681.0
2016-03-23 00:00:00	YM	Futures	18709.3	18727.5	18700.8	18721.1	1993.0
2016-03-23 01:00:00	YM	Futures	18722.2	18724.3	18671.9	18702.9	6301.0
2016-03-23 02:00:00	YM	Futures	18702.9	18722.2	18690.1	18704.0	3407.0
2016-03-23 03:00:00	YM	Futures	18706.1	18722.2	18702.9	18714.7	1711.0

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

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