PREVIEW / futures_1hour / 2015-06-29

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-06-29.parquet
  size:    53 KB
  rows:    1,574

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-06-29 00:00:00	ES	Futures	2199.74	2200.81	2196.81	2197.35	5981.0
2015-06-29 01:00:00	ES	Futures	2197.61	2201.61	2195.75	2201.07	10858.0
2015-06-29 02:00:00	ES	Futures	2201.07	2206.4	2198.68	2205.07	30295.0
2015-06-29 03:00:00	ES	Futures	2204.8	2211.72	2203.2	2209.33	52355.0
2015-06-29 04:00:00	ES	Futures	2209.33	2214.12	2205.87	2212.52	38044.0
2015-06-29 05:00:00	ES	Futures	2212.26	2212.52	2206.67	2208.53	25968.0
2015-06-29 06:00:00	ES	Futures	2208.26	2208.53	2203.2	2207.2	34053.0
2015-06-29 07:00:00	ES	Futures	2207.46	2210.39	2205.6	2209.59	24075.0
2015-06-29 08:00:00	ES	Futures	2209.59	2210.13	2206.4	2209.06	39400.0
2015-06-29 09:00:00	ES	Futures	2209.06	2218.65	2207.46	2212.79	293622.0
2015-06-29 10:00:00	ES	Futures	2212.79	2217.32	2206.4	2206.93	259770.0
2015-06-29 11:00:00	ES	Futures	2206.93	2207.46	2201.34	2204.27	237519.0
2015-06-29 12:00:00	ES	Futures	2204.0	2205.33	2198.68	2199.74	139074.0
2015-06-29 13:00:00	ES	Futures	2199.74	2200.01	2195.48	2196.81	162488.0
2015-06-29 14:00:00	ES	Futures	2196.81	2197.08	2188.29	2189.89	247873.0
2015-06-29 15:00:00	ES	Futures	2190.16	2191.76	2180.31	2181.64	403779.0
2015-06-29 16:00:00	ES	Futures	2181.9	2187.23	2180.84	2186.43	121920.0
2015-06-29 17:00:00	ES	Futures	2186.7	2187.23	2185.37	2186.16	2763.0
2015-06-29 18:00:00	ES	Futures	2188.03	2188.03	2184.83	2186.96	5761.0
2015-06-29 19:00:00	ES	Futures	2187.23	2188.29	2186.7	2188.03	3718.0
2015-06-29 20:00:00	ES	Futures	2188.03	2189.09	2186.96	2187.5	7082.0
2015-06-29 21:00:00	ES	Futures	2187.76	2189.63	2187.5	2189.36	4919.0
2015-06-29 22:00:00	ES	Futures	2189.36	2189.63	2184.03	2186.16	8909.0
2015-06-29 23:00:00	ES	Futures	2186.16	2189.09	2185.37	2188.83	5811.0
2015-06-29 00:00:00	NQ	Futures	5224.23	5226.3	5217.43	5219.2	836.0
2015-06-29 01:00:00	NQ	Futures	5219.5	5226.3	5214.77	5225.71	1881.0
2015-06-29 02:00:00	NQ	Futures	5225.42	5235.47	5218.02	5233.4	3013.0
2015-06-29 03:00:00	NQ	Futures	5233.11	5246.71	5228.37	5241.39	6777.0
2015-06-29 04:00:00	NQ	Futures	5241.98	5251.74	5233.4	5248.78	5641.0
2015-06-29 05:00:00	NQ	Futures	5248.49	5250.85	5235.47	5238.73	4085.0
2015-06-29 06:00:00	NQ	Futures	5238.43	5239.32	5226.01	5236.66	4023.0
2015-06-29 07:00:00	NQ	Futures	5236.66	5241.68	5230.44	5241.09	3890.0
2015-06-29 08:00:00	NQ	Futures	5241.09	5241.39	5231.04	5238.73	5961.0
2015-06-29 09:00:00	NQ	Futures	5239.02	5266.83	5228.37	5250.85	55269.0
2015-06-29 10:00:00	NQ	Futures	5251.45	5262.69	5234.88	5236.36	38615.0
2015-06-29 11:00:00	NQ	Futures	5236.06	5238.43	5220.09	5227.49	35787.0
2015-06-29 12:00:00	NQ	Futures	5227.49	5232.81	5217.43	5221.57	18803.0
2015-06-29 13:00:00	NQ	Futures	5221.57	5221.57	5206.78	5210.63	21939.0
2015-06-29 14:00:00	NQ	Futures	5210.63	5210.92	5185.19	5189.63	38941.0
2015-06-29 15:00:00	NQ	Futures	5189.33	5194.06	5168.33	5172.47	57857.0
2015-06-29 16:00:00	NQ	Futures	5172.47	5187.55	5170.1	5185.78	11095.0
2015-06-29 17:00:00	NQ	Futures	5186.08	5186.67	5182.82	5182.82	282.0
2015-06-29 18:00:00	NQ	Futures	5189.63	5189.63	5181.64	5188.15	995.0
2015-06-29 19:00:00	NQ	Futures	5187.85	5189.63	5186.37	5187.55	736.0
2015-06-29 20:00:00	NQ	Futures	5188.44	5191.7	5187.26	5189.33	786.0
2015-06-29 21:00:00	NQ	Futures	5189.03	5194.06	5189.03	5191.7	552.0
2015-06-29 22:00:00	NQ	Futures	5191.4	5192.29	5180.16	5186.08	886.0
2015-06-29 23:00:00	NQ	Futures	5186.08	5194.06	5184.3	5192.88	907.0
2015-06-29 00:00:00	YM	Futures	18571.4	18576.7	18548.3	18557.8	999.0
2015-06-29 01:00:00	YM	Futures	18557.8	18582.0	18544.1	18577.8	1671.0

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

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