PREVIEW / futures_1hour / 2016-12-20

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-12-20.parquet
  size:    51 KB
  rows:    1,600

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-12-20 00:00:00	ES	Futures	2467.47	2468.56	2467.2	2467.47	1924.0
2016-12-20 01:00:00	ES	Futures	2467.47	2468.01	2466.92	2467.47	1591.0
2016-12-20 02:00:00	ES	Futures	2467.74	2468.56	2466.92	2467.47	3248.0
2016-12-20 03:00:00	ES	Futures	2467.47	2471.01	2466.65	2469.1	12348.0
2016-12-20 04:00:00	ES	Futures	2469.1	2469.65	2467.74	2468.56	5347.0
2016-12-20 05:00:00	ES	Futures	2468.56	2470.2	2468.01	2469.1	5519.0
2016-12-20 06:00:00	ES	Futures	2469.1	2470.74	2468.29	2469.65	4269.0
2016-12-20 07:00:00	ES	Futures	2469.92	2473.47	2469.65	2472.92	13953.0
2016-12-20 08:00:00	ES	Futures	2472.65	2474.29	2471.56	2472.38	18295.0
2016-12-20 09:00:00	ES	Futures	2472.1	2476.2	2470.2	2474.56	147131.0
2016-12-20 10:00:00	ES	Futures	2474.56	2475.11	2471.29	2474.83	118453.0
2016-12-20 11:00:00	ES	Futures	2474.83	2475.11	2469.38	2471.29	84674.0
2016-12-20 12:00:00	ES	Futures	2471.01	2473.2	2470.2	2472.65	39298.0
2016-12-20 13:00:00	ES	Futures	2472.65	2474.01	2471.83	2473.47	46687.0
2016-12-20 14:00:00	ES	Futures	2473.47	2473.47	2468.29	2470.2	85837.0
2016-12-20 15:00:00	ES	Futures	2470.2	2474.01	2469.92	2473.47	131669.0
2016-12-20 16:00:00	ES	Futures	2473.47	2474.29	2471.83	2473.47	70874.0
2016-12-20 18:00:00	ES	Futures	2473.74	2474.29	2472.92	2473.2	2902.0
2016-12-20 19:00:00	ES	Futures	2473.2	2473.74	2472.38	2473.47	2350.0
2016-12-20 20:00:00	ES	Futures	2473.47	2474.01	2472.38	2472.65	2373.0
2016-12-20 21:00:00	ES	Futures	2472.38	2473.47	2472.1	2473.2	2159.0
2016-12-20 22:00:00	ES	Futures	2473.2	2473.47	2472.65	2473.47	1485.0
2016-12-20 23:00:00	ES	Futures	2473.2	2473.47	2471.83	2471.83	2064.0
2016-12-20 00:00:00	NQ	Futures	5898.98	5899.87	5896.59	5897.19	413.0
2016-12-20 01:00:00	NQ	Futures	5896.89	5897.48	5894.2	5896.59	322.0
2016-12-20 02:00:00	NQ	Futures	5895.99	5899.27	5894.8	5895.1	462.0
2016-12-20 03:00:00	NQ	Futures	5895.69	5903.75	5893.31	5899.87	1438.0
2016-12-20 04:00:00	NQ	Futures	5899.57	5900.77	5894.2	5897.19	1287.0
2016-12-20 05:00:00	NQ	Futures	5896.89	5900.47	5895.69	5897.19	803.0
2016-12-20 06:00:00	NQ	Futures	5897.48	5901.96	5893.61	5899.27	1381.0
2016-12-20 07:00:00	NQ	Futures	5899.57	5906.43	5898.98	5905.54	2700.0
2016-12-20 08:00:00	NQ	Futures	5905.54	5910.31	5902.85	5908.52	3372.0
2016-12-20 09:00:00	NQ	Futures	5908.52	5922.54	5903.45	5913.59	24792.0
2016-12-20 10:00:00	NQ	Futures	5913.89	5917.47	5903.45	5915.98	18543.0
2016-12-20 11:00:00	NQ	Futures	5916.28	5916.88	5904.64	5909.12	11794.0
2016-12-20 12:00:00	NQ	Futures	5908.82	5914.79	5907.03	5913.59	6187.0
2016-12-20 13:00:00	NQ	Futures	5913.59	5916.88	5909.72	5913.3	7491.0
2016-12-20 14:00:00	NQ	Futures	5913.3	5913.89	5900.77	5905.84	9096.0
2016-12-20 15:00:00	NQ	Futures	5905.54	5913.3	5904.35	5912.4	12080.0
2016-12-20 16:00:00	NQ	Futures	5912.4	5916.28	5909.12	5913.59	4239.0
2016-12-20 18:00:00	NQ	Futures	5913.89	5915.38	5913.0	5914.19	380.0
2016-12-20 19:00:00	NQ	Futures	5914.49	5915.68	5912.1	5915.09	352.0
2016-12-20 20:00:00	NQ	Futures	5915.09	5916.28	5912.7	5913.3	392.0
2016-12-20 21:00:00	NQ	Futures	5913.3	5916.58	5912.4	5915.98	537.0
2016-12-20 22:00:00	NQ	Futures	5915.98	5917.47	5914.79	5916.88	499.0
2016-12-20 23:00:00	NQ	Futures	5917.17	5917.47	5913.3	5913.89	531.0
2016-12-20 00:00:00	YM	Futures	21527.2	21531.5	21522.8	21525.0	744.0
2016-12-20 01:00:00	YM	Futures	21523.9	21527.2	21519.6	21526.1	510.0
2016-12-20 02:00:00	YM	Futures	21525.0	21530.4	21519.6	21522.8	892.0
2016-12-20 03:00:00	YM	Futures	21522.8	21546.7	21516.3	21542.4	2586.0

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

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