PREVIEW / futures_1hour / 2017-01-10

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-01-10.parquet
  size:    52 KB
  rows:    1,609

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-10 00:00:00	ES	Futures	2467.2	2467.47	2466.1	2466.65	1815.0
2017-01-10 01:00:00	ES	Futures	2466.92	2468.56	2465.29	2468.56	3786.0
2017-01-10 02:00:00	ES	Futures	2468.56	2470.47	2468.29	2469.92	5064.0
2017-01-10 03:00:00	ES	Futures	2469.92	2472.38	2468.29	2469.1	20160.0
2017-01-10 04:00:00	ES	Futures	2469.38	2471.01	2469.1	2470.74	7895.0
2017-01-10 05:00:00	ES	Futures	2470.74	2472.92	2470.2	2472.38	10963.0
2017-01-10 06:00:00	ES	Futures	2472.38	2472.65	2471.29	2471.56	7487.0
2017-01-10 07:00:00	ES	Futures	2471.29	2472.38	2470.47	2470.74	8776.0
2017-01-10 08:00:00	ES	Futures	2470.74	2472.1	2469.92	2470.74	16100.0
2017-01-10 09:00:00	ES	Futures	2470.47	2471.56	2465.29	2468.01	183955.0
2017-01-10 10:00:00	ES	Futures	2468.29	2474.01	2467.74	2472.38	169231.0
2017-01-10 11:00:00	ES	Futures	2472.65	2479.47	2472.38	2478.11	155060.0
2017-01-10 12:00:00	ES	Futures	2477.83	2481.11	2477.83	2478.38	97025.0
2017-01-10 13:00:00	ES	Futures	2478.38	2478.92	2471.29	2472.1	110684.0
2017-01-10 14:00:00	ES	Futures	2472.1	2473.47	2469.38	2471.56	156381.0
2017-01-10 15:00:00	ES	Futures	2471.56	2475.92	2469.38	2469.92	235141.0
2017-01-10 16:00:00	ES	Futures	2469.92	2471.56	2469.38	2470.2	81928.0
2017-01-10 18:00:00	ES	Futures	2469.92	2471.01	2468.83	2470.47	4568.0
2017-01-10 19:00:00	ES	Futures	2470.47	2471.83	2469.38	2470.47	5041.0
2017-01-10 20:00:00	ES	Futures	2470.47	2471.01	2465.56	2466.65	11996.0
2017-01-10 21:00:00	ES	Futures	2466.65	2468.83	2466.1	2468.29	5226.0
2017-01-10 22:00:00	ES	Futures	2468.29	2469.1	2467.2	2468.01	2912.0
2017-01-10 23:00:00	ES	Futures	2468.29	2468.29	2466.38	2466.38	2373.0
2017-01-10 00:00:00	NQ	Futures	5979.22	5981.01	5977.43	5980.72	604.0
2017-01-10 01:00:00	NQ	Futures	5980.72	5986.09	5977.73	5985.49	921.0
2017-01-10 02:00:00	NQ	Futures	5986.09	5990.86	5984.59	5989.07	790.0
2017-01-10 03:00:00	NQ	Futures	5988.77	5995.04	5986.38	5989.37	1874.0
2017-01-10 04:00:00	NQ	Futures	5989.37	5994.14	5989.37	5993.54	927.0
2017-01-10 05:00:00	NQ	Futures	5993.54	5997.42	5992.65	5996.53	1344.0
2017-01-10 06:00:00	NQ	Futures	5996.23	5996.53	5993.25	5993.54	784.0
2017-01-10 07:00:00	NQ	Futures	5993.25	5997.42	5992.65	5993.54	1033.0
2017-01-10 08:00:00	NQ	Futures	5993.84	5995.04	5990.56	5991.75	2699.0
2017-01-10 09:00:00	NQ	Futures	5992.05	5999.81	5979.52	5988.77	32321.0
2017-01-10 10:00:00	NQ	Futures	5989.07	6000.4	5984.0	5998.02	21157.0
2017-01-10 11:00:00	NQ	Futures	5997.72	6021.59	5997.12	6016.51	26153.0
2017-01-10 12:00:00	NQ	Futures	6016.81	6022.48	6013.83	6014.13	9881.0
2017-01-10 13:00:00	NQ	Futures	6014.13	6019.2	6002.49	6003.98	11115.0
2017-01-10 14:00:00	NQ	Futures	6003.69	6010.85	5999.81	6006.07	15360.0
2017-01-10 15:00:00	NQ	Futures	6006.07	6015.02	6003.39	6004.58	15542.0
2017-01-10 16:00:00	NQ	Futures	6004.28	6006.67	6002.19	6006.37	4277.0
2017-01-10 18:00:00	NQ	Futures	6005.48	6006.07	6002.79	6004.58	703.0
2017-01-10 19:00:00	NQ	Futures	6004.58	6008.16	6002.49	6005.77	1115.0
2017-01-10 20:00:00	NQ	Futures	6005.77	6006.07	5994.74	5997.12	1666.0
2017-01-10 21:00:00	NQ	Futures	5996.83	6002.79	5996.23	6001.9	877.0
2017-01-10 22:00:00	NQ	Futures	6002.19	6003.98	6000.11	6001.9	596.0
2017-01-10 23:00:00	NQ	Futures	6001.6	6002.79	5998.91	5999.21	480.0
2017-01-10 00:00:00	YM	Futures	21476.2	21479.4	21469.7	21472.9	454.0
2017-01-10 01:00:00	YM	Futures	21474.0	21489.2	21464.3	21488.1	974.0
2017-01-10 02:00:00	YM	Futures	21488.1	21505.5	21488.1	21503.3	1225.0
2017-01-10 03:00:00	YM	Futures	21502.2	21521.8	21489.2	21497.9	2784.0

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

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