PREVIEW / futures_1hour / 2016-04-04

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-04-04.parquet
  size:    53 KB
  rows:    1,608

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-04-04 00:00:00	ES	Futures	2231.11	2232.19	2230.03	2231.65	4312.0
2016-04-04 01:00:00	ES	Futures	2231.65	2233.0	2228.95	2232.46	8024.0
2016-04-04 02:00:00	ES	Futures	2232.46	2232.73	2228.68	2229.22	12450.0
2016-04-04 03:00:00	ES	Futures	2229.22	2234.35	2226.25	2232.46	46515.0
2016-04-04 04:00:00	ES	Futures	2232.46	2235.43	2231.38	2233.54	32735.0
2016-04-04 05:00:00	ES	Futures	2233.81	2237.05	2233.0	2234.62	25795.0
2016-04-04 06:00:00	ES	Futures	2234.62	2235.97	2233.54	2235.97	19562.0
2016-04-04 07:00:00	ES	Futures	2236.24	2237.05	2234.35	2234.89	24603.0
2016-04-04 08:00:00	ES	Futures	2234.62	2234.89	2231.92	2232.19	47635.0
2016-04-04 09:00:00	ES	Futures	2232.19	2232.19	2225.72	2229.76	217070.0
2016-04-04 10:00:00	ES	Futures	2229.76	2231.65	2222.75	2223.02	232886.0
2016-04-04 11:00:00	ES	Futures	2223.29	2225.72	2221.4	2224.64	144073.0
2016-04-04 12:00:00	ES	Futures	2224.91	2229.22	2224.64	2227.87	88167.0
2016-04-04 13:00:00	ES	Futures	2227.87	2228.14	2221.94	2222.48	70718.0
2016-04-04 14:00:00	ES	Futures	2222.75	2223.56	2218.97	2221.94	100789.0
2016-04-04 15:00:00	ES	Futures	2221.94	2224.1	2218.43	2222.48	204210.0
2016-04-04 16:00:00	ES	Futures	2222.48	2223.29	2220.32	2221.13	55639.0
2016-04-04 18:00:00	ES	Futures	2219.78	2219.78	2216.81	2218.16	9998.0
2016-04-04 19:00:00	ES	Futures	2218.16	2219.78	2217.08	2217.35	4821.0
2016-04-04 20:00:00	ES	Futures	2217.62	2218.7	2214.38	2215.46	10487.0
2016-04-04 21:00:00	ES	Futures	2215.19	2216.54	2212.22	2213.03	11525.0
2016-04-04 22:00:00	ES	Futures	2212.76	2215.19	2212.22	2213.57	8915.0
2016-04-04 23:00:00	ES	Futures	2213.57	2216.54	2212.49	2215.46	5625.0
2016-04-04 00:00:00	NQ	Futures	5391.24	5393.32	5387.37	5393.02	709.0
2016-04-04 01:00:00	NQ	Futures	5392.43	5396.89	5384.4	5395.4	1172.0
2016-04-04 02:00:00	NQ	Futures	5395.11	5396.0	5386.18	5387.97	1309.0
2016-04-04 03:00:00	NQ	Futures	5387.67	5398.97	5378.44	5393.62	4766.0
2016-04-04 04:00:00	NQ	Futures	5393.32	5401.35	5390.64	5397.78	3822.0
2016-04-04 05:00:00	NQ	Futures	5397.49	5407.6	5396.0	5402.84	2798.0
2016-04-04 06:00:00	NQ	Futures	5402.84	5403.73	5396.0	5402.84	2801.0
2016-04-04 07:00:00	NQ	Futures	5402.54	5404.63	5398.38	5398.68	2196.0
2016-04-04 08:00:00	NQ	Futures	5398.68	5399.27	5388.26	5388.26	5443.0
2016-04-04 09:00:00	NQ	Futures	5388.56	5389.45	5366.25	5378.74	32247.0
2016-04-04 10:00:00	NQ	Futures	5378.44	5386.48	5357.02	5358.21	34851.0
2016-04-04 11:00:00	NQ	Futures	5358.21	5365.06	5349.88	5362.97	23623.0
2016-04-04 12:00:00	NQ	Futures	5362.97	5382.61	5361.49	5379.34	14032.0
2016-04-04 13:00:00	NQ	Futures	5379.04	5379.63	5361.49	5362.97	8851.0
2016-04-04 14:00:00	NQ	Futures	5362.97	5363.57	5352.26	5359.7	13914.0
2016-04-04 15:00:00	NQ	Futures	5359.4	5365.35	5350.48	5360.3	22339.0
2016-04-04 16:00:00	NQ	Futures	5360.3	5361.78	5351.96	5355.24	7196.0
2016-04-04 18:00:00	NQ	Futures	5355.24	5357.32	5347.8	5352.86	1740.0
2016-04-04 19:00:00	NQ	Futures	5352.86	5356.13	5350.48	5350.77	567.0
2016-04-04 20:00:00	NQ	Futures	5351.07	5353.45	5340.66	5343.34	1786.0
2016-04-04 21:00:00	NQ	Futures	5343.34	5346.31	5335.6	5336.49	1697.0
2016-04-04 22:00:00	NQ	Futures	5336.2	5342.74	5335.6	5340.06	1100.0
2016-04-04 23:00:00	NQ	Futures	5339.77	5346.91	5337.39	5345.42	795.0
2016-04-04 00:00:00	YM	Futures	18962.0	18973.7	18950.2	18972.7	1756.0
2016-04-04 01:00:00	YM	Futures	18972.7	18976.9	18927.7	18974.8	6524.0
2016-04-04 02:00:00	YM	Futures	18975.9	18975.9	18936.3	18945.9	1627.0
2016-04-04 03:00:00	YM	Futures	18944.8	18974.8	18915.9	18964.1	5180.0

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

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