PREVIEW / futures_1hour / 2015-07-07

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-07-07.parquet
  size:    55 KB
  rows:    1,594

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-07 00:00:00	ES	Futures	2204.54	2206.4	2204.27	2206.13	3279.0
2015-07-07 01:00:00	ES	Futures	2205.87	2211.99	2205.6	2208.53	13084.0
2015-07-07 02:00:00	ES	Futures	2208.53	2211.46	2207.2	2210.13	12987.0
2015-07-07 03:00:00	ES	Futures	2210.13	2213.06	2208.26	2211.46	25796.0
2015-07-07 04:00:00	ES	Futures	2211.46	2211.99	2208.0	2209.59	26878.0
2015-07-07 05:00:00	ES	Futures	2209.59	2210.93	2207.2	2208.8	15206.0
2015-07-07 06:00:00	ES	Futures	2208.53	2208.8	2204.8	2204.8	18149.0
2015-07-07 07:00:00	ES	Futures	2205.07	2205.33	2200.81	2203.2	54678.0
2015-07-07 08:00:00	ES	Futures	2202.94	2204.54	2200.54	2201.34	34620.0
2015-07-07 09:00:00	ES	Futures	2201.61	2201.61	2185.9	2186.96	244916.0
2015-07-07 10:00:00	ES	Futures	2186.96	2187.23	2169.66	2175.78	564709.0
2015-07-07 11:00:00	ES	Futures	2175.78	2183.77	2167.26	2181.37	372816.0
2015-07-07 12:00:00	ES	Futures	2181.37	2193.35	2178.71	2191.49	214542.0
2015-07-07 13:00:00	ES	Futures	2191.49	2197.08	2187.76	2192.82	219102.0
2015-07-07 14:00:00	ES	Futures	2192.82	2207.73	2187.23	2206.93	250724.0
2015-07-07 15:00:00	ES	Futures	2206.93	2210.93	2202.94	2209.06	331290.0
2015-07-07 16:00:00	ES	Futures	2209.33	2211.19	2207.2	2208.0	92922.0
2015-07-07 17:00:00	ES	Futures	2208.26	2209.06	2207.46	2208.53	2748.0
2015-07-07 18:00:00	ES	Futures	2207.73	2208.0	2204.27	2205.6	7414.0
2015-07-07 19:00:00	ES	Futures	2205.87	2205.87	2203.2	2204.0	3764.0
2015-07-07 20:00:00	ES	Futures	2204.27	2204.54	2202.67	2203.2	5402.0
2015-07-07 21:00:00	ES	Futures	2203.2	2203.47	2192.55	2195.22	24320.0
2015-07-07 22:00:00	ES	Futures	2195.48	2198.15	2190.96	2191.76	14242.0
2015-07-07 23:00:00	ES	Futures	2191.76	2192.82	2190.42	2192.29	8109.0
2015-07-07 00:00:00	NQ	Futures	5243.75	5246.12	5242.57	5246.12	322.0
2015-07-07 01:00:00	NQ	Futures	5245.53	5259.14	5244.64	5252.04	2126.0
2015-07-07 02:00:00	NQ	Futures	5252.04	5257.95	5247.3	5254.4	1354.0
2015-07-07 03:00:00	NQ	Futures	5254.4	5262.69	5250.56	5259.14	3342.0
2015-07-07 04:00:00	NQ	Futures	5259.43	5260.32	5250.85	5256.18	3066.0
2015-07-07 05:00:00	NQ	Futures	5256.18	5258.25	5248.49	5250.56	1852.0
2015-07-07 06:00:00	NQ	Futures	5250.26	5250.85	5241.68	5241.98	2643.0
2015-07-07 07:00:00	NQ	Futures	5242.28	5242.28	5230.44	5234.29	11115.0
2015-07-07 08:00:00	NQ	Futures	5234.29	5238.13	5228.97	5234.29	5556.0
2015-07-07 09:00:00	NQ	Futures	5234.59	5234.59	5189.03	5191.4	38786.0
2015-07-07 10:00:00	NQ	Futures	5191.7	5191.7	5136.38	5155.91	79369.0
2015-07-07 11:00:00	NQ	Futures	5156.2	5167.44	5128.4	5160.93	51570.0
2015-07-07 12:00:00	NQ	Futures	5161.23	5190.81	5152.65	5186.37	38526.0
2015-07-07 13:00:00	NQ	Futures	5186.37	5202.94	5177.79	5194.65	38624.0
2015-07-07 14:00:00	NQ	Futures	5195.25	5232.51	5181.05	5231.33	36487.0
2015-07-07 15:00:00	NQ	Futures	5231.63	5237.54	5218.61	5231.04	52058.0
2015-07-07 16:00:00	NQ	Futures	5231.63	5237.25	5228.08	5231.04	9382.0
2015-07-07 17:00:00	NQ	Futures	5231.63	5233.4	5230.74	5233.11	96.0
2015-07-07 18:00:00	NQ	Futures	5232.51	5232.51	5223.05	5226.3	712.0
2015-07-07 19:00:00	NQ	Futures	5226.3	5226.6	5219.8	5221.27	477.0
2015-07-07 20:00:00	NQ	Futures	5221.57	5222.75	5218.32	5218.61	680.0
2015-07-07 21:00:00	NQ	Futures	5219.2	5219.2	5193.77	5200.27	3108.0
2015-07-07 22:00:00	NQ	Futures	5199.98	5207.37	5189.03	5190.22	2137.0
2015-07-07 23:00:00	NQ	Futures	5190.51	5193.77	5188.74	5191.4	1052.0
2015-07-07 00:00:00	YM	Futures	18613.6	18627.3	18611.5	18625.2	418.0
2015-07-07 01:00:00	YM	Futures	18625.2	18666.3	18619.9	18643.1	1760.0

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

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