PREVIEW / futures_1hour / 2016-06-23

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-06-23.parquet
  size:    58 KB
  rows:    1,675

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-23 00:00:00	ES	Futures	2263.05	2263.59	2262.51	2263.05	1528.0
2016-06-23 01:00:00	ES	Futures	2263.05	2267.93	2262.78	2265.49	7978.0
2016-06-23 02:00:00	ES	Futures	2265.76	2266.58	2262.24	2262.51	14452.0
2016-06-23 03:00:00	ES	Futures	2262.51	2265.76	2261.15	2262.51	32877.0
2016-06-23 04:00:00	ES	Futures	2262.24	2267.39	2262.24	2266.58	22551.0
2016-06-23 05:00:00	ES	Futures	2266.58	2280.14	2266.58	2274.71	71308.0
2016-06-23 06:00:00	ES	Futures	2274.71	2277.97	2274.17	2274.44	37020.0
2016-06-23 07:00:00	ES	Futures	2274.44	2276.07	2270.92	2271.19	31005.0
2016-06-23 08:00:00	ES	Futures	2271.19	2274.71	2271.19	2274.44	29271.0
2016-06-23 09:00:00	ES	Futures	2274.71	2274.98	2266.03	2269.56	177283.0
2016-06-23 10:00:00	ES	Futures	2269.56	2273.36	2267.39	2271.46	208369.0
2016-06-23 11:00:00	ES	Futures	2271.73	2277.42	2271.46	2276.07	118759.0
2016-06-23 12:00:00	ES	Futures	2276.34	2277.69	2272.81	2274.44	77880.0
2016-06-23 13:00:00	ES	Futures	2274.71	2276.07	2272.0	2273.63	60898.0
2016-06-23 14:00:00	ES	Futures	2273.36	2277.15	2272.0	2275.8	76731.0
2016-06-23 15:00:00	ES	Futures	2276.07	2283.39	2273.63	2283.12	180320.0
2016-06-23 16:00:00	ES	Futures	2283.12	2292.34	2281.76	2292.34	118759.0
2016-06-23 18:00:00	ES	Futures	2295.05	2299.12	2288.27	2288.27	46816.0
2016-06-23 19:00:00	ES	Futures	2288.27	2289.08	2264.95	2274.98	110077.0
2016-06-23 20:00:00	ES	Futures	2274.98	2277.42	2260.61	2266.85	72544.0
2016-06-23 21:00:00	ES	Futures	2266.85	2267.39	2223.19	2252.47	215014.0
2016-06-23 22:00:00	ES	Futures	2252.47	2257.36	2196.61	2200.95	253562.0
2016-06-23 23:00:00	ES	Futures	2200.95	2212.88	2172.2	2184.68	210144.0
2016-06-23 00:00:00	NQ	Futures	5263.89	5264.48	5262.7	5263.89	266.0
2016-06-23 01:00:00	NQ	Futures	5263.59	5274.32	5262.99	5268.96	667.0
2016-06-23 02:00:00	NQ	Futures	5268.36	5271.94	5260.01	5261.8	2167.0
2016-06-23 03:00:00	NQ	Futures	5261.8	5271.34	5257.63	5261.21	4635.0
2016-06-23 04:00:00	NQ	Futures	5261.5	5274.32	5260.91	5272.83	2202.0
2016-06-23 05:00:00	NQ	Futures	5272.53	5311.87	5272.23	5296.67	13002.0
2016-06-23 06:00:00	NQ	Futures	5296.67	5302.34	5291.31	5291.91	5464.0
2016-06-23 07:00:00	NQ	Futures	5291.91	5295.78	5282.67	5282.96	3534.0
2016-06-23 08:00:00	NQ	Futures	5283.26	5291.31	5282.96	5291.01	3765.0
2016-06-23 09:00:00	NQ	Futures	5291.31	5291.61	5258.52	5271.34	32881.0
2016-06-23 10:00:00	NQ	Futures	5271.04	5289.82	5268.36	5286.54	33881.0
2016-06-23 11:00:00	NQ	Futures	5286.84	5298.76	5286.54	5296.08	20299.0
2016-06-23 12:00:00	NQ	Futures	5296.38	5300.85	5289.52	5294.29	12625.0
2016-06-23 13:00:00	NQ	Futures	5294.29	5299.65	5288.03	5291.31	9660.0
2016-06-23 14:00:00	NQ	Futures	5291.61	5299.95	5287.73	5296.67	11523.0
2016-06-23 15:00:00	NQ	Futures	5296.38	5316.05	5289.52	5314.86	24089.0
2016-06-23 16:00:00	NQ	Futures	5314.86	5340.19	5310.98	5339.89	9764.0
2016-06-23 18:00:00	NQ	Futures	5344.36	5357.77	5330.06	5332.74	4368.0
2016-06-23 19:00:00	NQ	Futures	5331.25	5334.53	5282.96	5310.68	11438.0
2016-06-23 20:00:00	NQ	Futures	5310.38	5316.94	5279.98	5289.52	3410.0
2016-06-23 21:00:00	NQ	Futures	5290.71	5290.71	5175.67	5249.58	18224.0
2016-06-23 22:00:00	NQ	Futures	5249.28	5261.8	5110.69	5122.61	16729.0
2016-06-23 23:00:00	NQ	Futures	5122.91	5150.63	5056.15	5081.18	17247.0
2016-06-23 00:00:00	YM	Futures	19114.5	19116.6	19110.2	19115.6	251.0
2016-06-23 01:00:00	YM	Futures	19114.5	19147.8	19112.3	19137.1	1204.0
2016-06-23 02:00:00	YM	Futures	19134.9	19141.4	19106.9	19108.0	2260.0
2016-06-23 03:00:00	YM	Futures	19108.0	19140.3	19099.4	19112.3	6343.0

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

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