PREVIEW / futures_1hour / 2016-12-22

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-12-22.parquet
  size:    49 KB
  rows:    1,584

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-22 00:00:00	ES	Futures	2462.01	2463.38	2460.92	2463.38	2867.0
2016-12-22 01:00:00	ES	Futures	2463.38	2463.38	2462.01	2462.29	2157.0
2016-12-22 02:00:00	ES	Futures	2462.56	2463.92	2462.29	2463.65	3483.0
2016-12-22 03:00:00	ES	Futures	2463.65	2464.74	2463.1	2463.38	8168.0
2016-12-22 04:00:00	ES	Futures	2463.65	2466.38	2463.1	2464.47	8537.0
2016-12-22 05:00:00	ES	Futures	2464.47	2465.01	2463.1	2464.74	5564.0
2016-12-22 06:00:00	ES	Futures	2464.74	2465.01	2463.38	2463.65	4073.0
2016-12-22 07:00:00	ES	Futures	2463.92	2465.56	2463.1	2465.01	6111.0
2016-12-22 08:00:00	ES	Futures	2464.74	2466.92	2464.19	2465.01	16568.0
2016-12-22 09:00:00	ES	Futures	2464.74	2465.83	2459.28	2461.74	124265.0
2016-12-22 10:00:00	ES	Futures	2462.01	2463.65	2460.1	2460.1	113972.0
2016-12-22 11:00:00	ES	Futures	2460.1	2461.74	2456.56	2457.38	109902.0
2016-12-22 12:00:00	ES	Futures	2457.38	2460.38	2457.1	2459.56	58993.0
2016-12-22 13:00:00	ES	Futures	2459.56	2463.65	2459.01	2462.29	53046.0
2016-12-22 14:00:00	ES	Futures	2462.29	2463.38	2460.92	2462.01	49033.0
2016-12-22 15:00:00	ES	Futures	2462.29	2463.1	2458.19	2462.56	177107.0
2016-12-22 16:00:00	ES	Futures	2462.29	2464.74	2462.29	2463.65	67855.0
2016-12-22 18:00:00	ES	Futures	2463.1	2464.74	2462.83	2463.92	2596.0
2016-12-22 19:00:00	ES	Futures	2463.92	2464.19	2463.1	2463.38	1577.0
2016-12-22 20:00:00	ES	Futures	2463.65	2465.83	2463.38	2465.29	3943.0
2016-12-22 21:00:00	ES	Futures	2465.29	2465.29	2464.47	2465.01	1499.0
2016-12-22 22:00:00	ES	Futures	2465.29	2465.56	2464.74	2465.01	1076.0
2016-12-22 23:00:00	ES	Futures	2465.01	2466.1	2464.74	2465.01	1578.0
2016-12-22 00:00:00	NQ	Futures	5896.29	5898.08	5891.52	5897.78	973.0
2016-12-22 01:00:00	NQ	Futures	5897.78	5898.08	5896.29	5896.59	342.0
2016-12-22 02:00:00	NQ	Futures	5897.19	5898.98	5896.29	5898.38	510.0
2016-12-22 03:00:00	NQ	Futures	5898.38	5901.96	5897.48	5897.48	988.0
2016-12-22 04:00:00	NQ	Futures	5897.48	5904.94	5897.19	5899.57	895.0
2016-12-22 05:00:00	NQ	Futures	5899.27	5902.26	5896.29	5901.66	819.0
2016-12-22 06:00:00	NQ	Futures	5901.06	5901.96	5899.87	5900.17	457.0
2016-12-22 07:00:00	NQ	Futures	5900.47	5904.94	5898.38	5902.56	858.0
2016-12-22 08:00:00	NQ	Futures	5902.85	5910.31	5902.85	5906.14	2418.0
2016-12-22 09:00:00	NQ	Futures	5906.43	5910.31	5880.48	5894.5	21859.0
2016-12-22 10:00:00	NQ	Futures	5894.2	5900.77	5885.55	5886.45	15832.0
2016-12-22 11:00:00	NQ	Futures	5886.45	5892.41	5867.35	5872.72	17699.0
2016-12-22 12:00:00	NQ	Futures	5872.72	5879.59	5870.34	5876.3	8226.0
2016-12-22 13:00:00	NQ	Futures	5876.01	5890.03	5874.81	5885.55	7868.0
2016-12-22 14:00:00	NQ	Futures	5885.85	5889.43	5883.17	5885.85	4809.0
2016-12-22 15:00:00	NQ	Futures	5885.85	5890.03	5871.23	5890.03	16721.0
2016-12-22 16:00:00	NQ	Futures	5889.73	5891.22	5886.75	5887.34	4605.0
2016-12-22 18:00:00	NQ	Futures	5887.34	5890.32	5886.75	5886.75	686.0
2016-12-22 19:00:00	NQ	Futures	5886.75	5887.94	5884.06	5885.25	526.0
2016-12-22 20:00:00	NQ	Futures	5885.55	5891.22	5885.25	5890.03	917.0
2016-12-22 21:00:00	NQ	Futures	5889.73	5889.73	5886.15	5887.64	419.0
2016-12-22 22:00:00	NQ	Futures	5887.64	5889.13	5886.75	5887.64	291.0
2016-12-22 23:00:00	NQ	Futures	5887.64	5890.92	5887.64	5888.24	277.0
2016-12-22 00:00:00	YM	Futures	21542.4	21551.0	21534.8	21551.0	673.0
2016-12-22 01:00:00	YM	Futures	21550.0	21552.1	21545.6	21546.7	471.0
2016-12-22 02:00:00	YM	Futures	21547.8	21554.3	21546.7	21551.0	661.0
2016-12-22 03:00:00	YM	Futures	21553.2	21565.1	21551.0	21558.6	1809.0

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

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