PREVIEW / futures_1hour / 2016-06-14

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-06-14.parquet
  size:    54 KB
  rows:    1,646

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-06-14 00:00:00	ES	Futures	2245.42	2247.32	2244.61	2245.69	5871.0
2016-06-14 01:00:00	ES	Futures	2245.97	2247.32	2243.8	2247.05	7411.0
2016-06-14 02:00:00	ES	Futures	2247.32	2247.32	2241.9	2242.71	15914.0
2016-06-14 03:00:00	ES	Futures	2242.44	2245.15	2240.54	2240.54	45102.0
2016-06-14 04:00:00	ES	Futures	2240.81	2242.44	2234.85	2237.83	37662.0
2016-06-14 05:00:00	ES	Futures	2238.1	2239.73	2235.93	2239.46	25492.0
2016-06-14 06:00:00	ES	Futures	2239.46	2242.44	2238.64	2240.27	22256.0
2016-06-14 07:00:00	ES	Futures	2240.27	2241.36	2237.83	2238.1	27216.0
2016-06-14 08:00:00	ES	Futures	2238.37	2240.54	2236.75	2240.0	51729.0
2016-06-14 09:00:00	ES	Futures	2240.0	2248.41	2237.56	2244.88	276493.0
2016-06-14 10:00:00	ES	Futures	2245.15	2247.59	2230.24	2231.05	375251.0
2016-06-14 11:00:00	ES	Futures	2231.32	2235.93	2228.88	2232.14	267661.0
2016-06-14 12:00:00	ES	Futures	2231.86	2241.08	2231.05	2236.75	163100.0
2016-06-14 13:00:00	ES	Futures	2236.75	2237.83	2231.59	2232.14	125542.0
2016-06-14 14:00:00	ES	Futures	2231.86	2238.1	2229.97	2230.51	153483.0
2016-06-14 15:00:00	ES	Futures	2230.78	2243.25	2228.88	2241.63	300589.0
2016-06-14 16:00:00	ES	Futures	2241.63	2242.71	2238.1	2239.73	77316.0
2016-06-14 18:00:00	ES	Futures	2239.46	2240.54	2234.3	2236.47	10191.0
2016-06-14 19:00:00	ES	Futures	2236.47	2237.56	2235.39	2237.29	3611.0
2016-06-14 20:00:00	ES	Futures	2237.29	2239.19	2237.29	2237.83	7090.0
2016-06-14 21:00:00	ES	Futures	2237.83	2242.71	2236.2	2239.46	14586.0
2016-06-14 22:00:00	ES	Futures	2239.73	2242.98	2238.92	2241.08	10480.0
2016-06-14 23:00:00	ES	Futures	2241.36	2242.17	2239.46	2240.27	7044.0
2016-06-14 00:00:00	NQ	Futures	5267.76	5272.23	5266.27	5269.25	931.0
2016-06-14 01:00:00	NQ	Futures	5268.96	5272.23	5264.48	5272.23	555.0
2016-06-14 02:00:00	NQ	Futures	5272.53	5272.83	5259.12	5261.21	1676.0
2016-06-14 03:00:00	NQ	Futures	5260.91	5265.98	5254.35	5254.65	4337.0
2016-06-14 04:00:00	NQ	Futures	5254.35	5259.12	5242.73	5249.58	3958.0
2016-06-14 05:00:00	NQ	Futures	5249.28	5252.26	5245.11	5251.67	2136.0
2016-06-14 06:00:00	NQ	Futures	5251.07	5258.82	5250.77	5254.65	1980.0
2016-06-14 07:00:00	NQ	Futures	5254.65	5256.74	5249.88	5251.07	4390.0
2016-06-14 08:00:00	NQ	Futures	5251.07	5254.65	5246.6	5253.46	5681.0
2016-06-14 09:00:00	NQ	Futures	5253.46	5283.26	5248.69	5277.3	41438.0
2016-06-14 10:00:00	NQ	Futures	5277.3	5284.75	5232.89	5236.17	54946.0
2016-06-14 11:00:00	NQ	Futures	5236.17	5243.62	5226.63	5234.98	36785.0
2016-06-14 12:00:00	NQ	Futures	5234.98	5259.12	5233.49	5250.77	23275.0
2016-06-14 13:00:00	NQ	Futures	5250.48	5254.05	5237.96	5239.15	16490.0
2016-06-14 14:00:00	NQ	Futures	5239.15	5254.65	5236.77	5240.64	19547.0
2016-06-14 15:00:00	NQ	Futures	5240.64	5269.25	5235.57	5266.57	42046.0
2016-06-14 16:00:00	NQ	Futures	5266.27	5271.34	5260.61	5265.68	7398.0
2016-06-14 18:00:00	NQ	Futures	5266.57	5266.57	5253.16	5257.33	909.0
2016-06-14 19:00:00	NQ	Futures	5257.63	5260.01	5255.25	5260.01	368.0
2016-06-14 20:00:00	NQ	Futures	5259.72	5265.08	5259.42	5261.21	641.0
2016-06-14 21:00:00	NQ	Futures	5261.21	5273.13	5256.14	5265.98	1643.0
2016-06-14 22:00:00	NQ	Futures	5266.27	5274.02	5264.48	5269.85	1314.0
2016-06-14 23:00:00	NQ	Futures	5270.15	5272.53	5265.38	5268.96	668.0
2016-06-14 00:00:00	YM	Futures	18995.0	19012.2	18990.7	18999.3	1227.0
2016-06-14 01:00:00	YM	Futures	18999.3	19010.1	18985.3	19010.1	1715.0
2016-06-14 02:00:00	YM	Futures	19012.2	19013.3	18966.0	18972.4	2325.0
2016-06-14 03:00:00	YM	Futures	18971.3	18988.6	18950.9	18950.9	5042.0

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

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