PREVIEW / futures_1hour / 2017-01-09

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-01-09.parquet
  size:    54 KB
  rows:    1,637

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
2017-01-09 00:00:00	ES	Futures	2481.38	2481.65	2480.83	2481.65	1301.0
2017-01-09 01:00:00	ES	Futures	2481.38	2482.47	2481.11	2481.65	2401.0
2017-01-09 02:00:00	ES	Futures	2481.65	2482.47	2481.11	2481.65	3906.0
2017-01-09 03:00:00	ES	Futures	2481.38	2481.38	2478.11	2478.11	13450.0
2017-01-09 04:00:00	ES	Futures	2478.38	2478.92	2477.01	2478.11	7605.0
2017-01-09 05:00:00	ES	Futures	2478.11	2478.11	2476.47	2476.74	5420.0
2017-01-09 06:00:00	ES	Futures	2476.74	2477.01	2474.29	2475.92	9482.0
2017-01-09 07:00:00	ES	Futures	2475.92	2477.01	2474.83	2477.01	10198.0
2017-01-09 08:00:00	ES	Futures	2477.01	2477.29	2474.29	2475.38	15765.0
2017-01-09 09:00:00	ES	Futures	2475.11	2475.65	2469.65	2472.38	184552.0
2017-01-09 10:00:00	ES	Futures	2472.65	2476.2	2470.2	2475.92	161104.0
2017-01-09 11:00:00	ES	Futures	2475.65	2477.01	2472.92	2474.56	101452.0
2017-01-09 12:00:00	ES	Futures	2474.29	2476.47	2472.65	2475.65	64538.0
2017-01-09 13:00:00	ES	Futures	2475.38	2475.92	2472.38	2473.74	69623.0
2017-01-09 14:00:00	ES	Futures	2473.47	2474.01	2469.92	2471.56	105736.0
2017-01-09 15:00:00	ES	Futures	2471.56	2474.01	2470.2	2471.01	162120.0
2017-01-09 16:00:00	ES	Futures	2470.74	2472.38	2470.2	2470.47	83408.0
2017-01-09 18:00:00	ES	Futures	2470.74	2471.56	2467.74	2468.29	8081.0
2017-01-09 19:00:00	ES	Futures	2468.29	2469.1	2467.74	2467.74	2721.0
2017-01-09 20:00:00	ES	Futures	2467.74	2469.38	2467.2	2468.29	4590.0
2017-01-09 21:00:00	ES	Futures	2468.56	2469.38	2467.47	2468.83	3843.0
2017-01-09 22:00:00	ES	Futures	2468.83	2468.83	2465.83	2466.38	6106.0
2017-01-09 23:00:00	ES	Futures	2466.38	2467.2	2465.56	2467.2	3040.0
2017-01-09 00:00:00	NQ	Futures	5982.21	5983.1	5981.31	5982.51	471.0
2017-01-09 01:00:00	NQ	Futures	5982.51	5986.38	5982.21	5984.89	716.0
2017-01-09 02:00:00	NQ	Futures	5984.89	5986.68	5984.3	5984.59	993.0
2017-01-09 03:00:00	NQ	Futures	5984.59	5984.89	5977.14	5977.43	2037.0
2017-01-09 04:00:00	NQ	Futures	5977.73	5978.63	5974.15	5976.54	1448.0
2017-01-09 05:00:00	NQ	Futures	5976.24	5976.24	5973.26	5974.15	998.0
2017-01-09 06:00:00	NQ	Futures	5974.15	5974.45	5969.98	5972.06	1909.0
2017-01-09 07:00:00	NQ	Futures	5972.06	5975.05	5971.17	5974.75	1971.0
2017-01-09 08:00:00	NQ	Futures	5974.45	5976.24	5971.17	5973.56	2368.0
2017-01-09 09:00:00	NQ	Futures	5973.26	5989.67	5971.47	5984.59	32803.0
2017-01-09 10:00:00	NQ	Futures	5984.59	5990.86	5972.06	5985.79	31046.0
2017-01-09 11:00:00	NQ	Futures	5985.49	5994.14	5981.01	5988.77	15117.0
2017-01-09 12:00:00	NQ	Futures	5989.37	5997.12	5986.09	5995.93	10390.0
2017-01-09 13:00:00	NQ	Futures	5996.23	5998.02	5991.46	5993.54	6996.0
2017-01-09 14:00:00	NQ	Futures	5993.54	5994.14	5984.59	5992.05	9296.0
2017-01-09 15:00:00	NQ	Futures	5992.35	6001.6	5990.26	5991.16	17068.0
2017-01-09 16:00:00	NQ	Futures	5991.16	5994.74	5989.37	5991.16	5014.0
2017-01-09 18:00:00	NQ	Futures	5992.65	5996.23	5985.19	5986.38	1845.0
2017-01-09 19:00:00	NQ	Futures	5986.09	5988.47	5984.89	5984.89	675.0
2017-01-09 20:00:00	NQ	Futures	5984.89	5989.67	5982.8	5986.68	740.0
2017-01-09 21:00:00	NQ	Futures	5986.68	5990.26	5985.19	5987.88	678.0
2017-01-09 22:00:00	NQ	Futures	5987.88	5988.17	5979.52	5980.42	1241.0
2017-01-09 23:00:00	NQ	Futures	5980.12	5980.72	5975.05	5979.22	1587.0
2017-01-09 00:00:00	YM	Futures	21603.1	21607.5	21602.0	21607.5	276.0
2017-01-09 01:00:00	YM	Futures	21606.4	21610.7	21602.0	21606.4	462.0
2017-01-09 02:00:00	YM	Futures	21605.3	21608.5	21598.8	21598.8	1197.0
2017-01-09 03:00:00	YM	Futures	21598.8	21598.8	21576.0	21579.2	2503.0

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

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