PREVIEW / futures_1hour / 2016-06-17

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-06-17.parquet
  size:    46 KB
  rows:    1,338

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-17 00:00:00	ES	Futures	2248.14	2248.68	2246.51	2247.59	4355.0
2016-06-17 01:00:00	ES	Futures	2247.86	2248.95	2247.05	2247.86	4758.0
2016-06-17 02:00:00	ES	Futures	2247.86	2247.86	2242.71	2244.07	16716.0
2016-06-17 03:00:00	ES	Futures	2244.07	2246.78	2240.81	2242.98	50427.0
2016-06-17 04:00:00	ES	Futures	2242.98	2244.88	2240.27	2244.34	30447.0
2016-06-17 05:00:00	ES	Futures	2244.34	2246.24	2242.71	2243.25	20864.0
2016-06-17 06:00:00	ES	Futures	2243.25	2243.53	2241.08	2241.63	17120.0
2016-06-17 07:00:00	ES	Futures	2241.63	2243.25	2239.46	2242.98	33824.0
2016-06-17 08:00:00	ES	Futures	2242.98	2245.42	2242.44	2244.34	42071.0
2016-06-17 09:00:00	ES	Futures	2244.07	2244.34	2236.2	2240.0	342306.0
2016-06-17 10:00:00	ES	Futures	2240.0	2241.9	2230.78	2233.22	294314.0
2016-06-17 11:00:00	ES	Futures	2233.22	2233.76	2227.25	2231.59	223344.0
2016-06-17 12:00:00	ES	Futures	2231.59	2237.29	2231.32	2233.22	114852.0
2016-06-17 13:00:00	ES	Futures	2232.95	2237.83	2230.24	2236.2	126973.0
2016-06-17 14:00:00	ES	Futures	2236.47	2241.36	2233.49	2239.46	149681.0
2016-06-17 15:00:00	ES	Futures	2239.46	2240.27	2234.58	2236.75	203224.0
2016-06-17 16:00:00	ES	Futures	2236.75	2237.56	2232.14	2234.3	87428.0
2016-06-17 00:00:00	NQ	Futures	5275.21	5276.7	5272.23	5275.21	475.0
2016-06-17 01:00:00	NQ	Futures	5274.02	5276.7	5272.83	5274.32	636.0
2016-06-17 02:00:00	NQ	Futures	5273.72	5273.72	5261.8	5265.08	2109.0
2016-06-17 03:00:00	NQ	Futures	5265.08	5272.53	5257.03	5264.78	4666.0
2016-06-17 04:00:00	NQ	Futures	5264.48	5268.66	5257.33	5267.17	2734.0
2016-06-17 05:00:00	NQ	Futures	5266.87	5271.04	5263.29	5264.19	1615.0
2016-06-17 06:00:00	NQ	Futures	5263.59	5265.38	5260.01	5260.61	1742.0
2016-06-17 07:00:00	NQ	Futures	5260.31	5262.99	5255.25	5262.4	3440.0
2016-06-17 08:00:00	NQ	Futures	5262.4	5266.57	5259.12	5259.12	4471.0
2016-06-17 09:00:00	NQ	Futures	5259.12	5259.12	5217.09	5223.65	48622.0
2016-06-17 10:00:00	NQ	Futures	5223.65	5226.04	5196.53	5199.81	43798.0
2016-06-17 11:00:00	NQ	Futures	5199.51	5203.09	5190.27	5196.83	31510.0
2016-06-17 12:00:00	NQ	Futures	5197.13	5211.43	5196.83	5203.38	17956.0
2016-06-17 13:00:00	NQ	Futures	5203.09	5217.69	5196.53	5212.03	18242.0
2016-06-17 14:00:00	NQ	Futures	5211.73	5217.39	5204.28	5210.54	20687.0
2016-06-17 15:00:00	NQ	Futures	5210.54	5212.03	5196.23	5203.38	29006.0
2016-06-17 16:00:00	NQ	Futures	5203.38	5206.66	5194.74	5199.51	8221.0
2016-06-17 00:00:00	YM	Futures	19007.9	19011.2	18997.2	19002.6	598.0
2016-06-17 01:00:00	YM	Futures	19002.6	19010.1	18997.2	19002.6	779.0
2016-06-17 02:00:00	YM	Futures	19001.5	19002.6	18970.3	18980.0	2035.0
2016-06-17 03:00:00	YM	Futures	18980.0	19006.9	18960.6	18978.9	6207.0
2016-06-17 04:00:00	YM	Futures	18977.8	18986.4	18955.2	18984.3	3900.0
2016-06-17 05:00:00	YM	Futures	18983.2	18997.2	18971.3	18975.6	2283.0
2016-06-17 06:00:00	YM	Futures	18974.6	18978.9	18960.6	18967.0	2493.0
2016-06-17 07:00:00	YM	Futures	18966.0	18976.7	18946.6	18973.5	3633.0
2016-06-17 08:00:00	YM	Futures	18974.6	18993.9	18972.4	18985.3	3574.0
2016-06-17 09:00:00	YM	Futures	18985.3	18988.6	18921.8	18948.7	30235.0
2016-06-17 10:00:00	YM	Futures	18947.7	18973.5	18884.2	18893.9	25719.0
2016-06-17 11:00:00	YM	Futures	18893.9	18897.1	18839.0	18873.4	23677.0
2016-06-17 12:00:00	YM	Futures	18873.4	18920.8	18872.3	18894.9	11117.0
2016-06-17 13:00:00	YM	Futures	18894.9	18929.4	18874.5	18917.5	10063.0
2016-06-17 14:00:00	YM	Futures	18917.5	18957.4	18898.2	18948.7	13117.0
2016-06-17 15:00:00	YM	Futures	18947.7	18952.0	18911.1	18915.4	15457.0

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

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