PREVIEW / futures_1hour / 2016-12-27

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-12-27.parquet
  size:    47 KB
  rows:    1,491

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-27 00:00:00	ES	Futures	2464.47	2465.56	2464.19	2465.56	1149.0
2016-12-27 01:00:00	ES	Futures	2465.29	2465.56	2464.74	2465.01	1071.0
2016-12-27 02:00:00	ES	Futures	2465.01	2465.83	2464.47	2465.01	1427.0
2016-12-27 03:00:00	ES	Futures	2465.01	2465.56	2464.47	2464.47	2951.0
2016-12-27 04:00:00	ES	Futures	2464.74	2465.01	2463.92	2464.19	1611.0
2016-12-27 05:00:00	ES	Futures	2464.47	2464.74	2463.65	2464.19	1985.0
2016-12-27 06:00:00	ES	Futures	2464.19	2467.47	2463.92	2466.92	5939.0
2016-12-27 07:00:00	ES	Futures	2467.2	2467.74	2466.65	2467.47	2120.0
2016-12-27 08:00:00	ES	Futures	2467.2	2468.56	2466.1	2468.29	6706.0
2016-12-27 09:00:00	ES	Futures	2468.01	2475.92	2467.74	2474.83	104856.0
2016-12-27 10:00:00	ES	Futures	2475.11	2476.2	2474.01	2474.29	57053.0
2016-12-27 11:00:00	ES	Futures	2474.29	2474.83	2471.01	2471.83	45510.0
2016-12-27 12:00:00	ES	Futures	2471.83	2472.1	2470.47	2471.83	27148.0
2016-12-27 13:00:00	ES	Futures	2471.83	2473.2	2471.29	2472.38	27051.0
2016-12-27 14:00:00	ES	Futures	2472.38	2473.47	2471.01	2471.83	42799.0
2016-12-27 15:00:00	ES	Futures	2471.56	2472.92	2469.1	2470.2	95617.0
2016-12-27 16:00:00	ES	Futures	2470.2	2470.47	2466.38	2466.38	57305.0
2016-12-27 18:00:00	ES	Futures	2467.2	2468.01	2466.92	2467.74	2658.0
2016-12-27 19:00:00	ES	Futures	2467.74	2468.01	2467.47	2468.01	1718.0
2016-12-27 20:00:00	ES	Futures	2467.74	2469.65	2467.47	2469.65	3725.0
2016-12-27 21:00:00	ES	Futures	2469.65	2469.65	2468.56	2469.1	1467.0
2016-12-27 22:00:00	ES	Futures	2468.83	2469.65	2468.83	2469.1	1268.0
2016-12-27 23:00:00	ES	Futures	2469.1	2469.65	2468.83	2469.1	1216.0
2016-12-27 00:00:00	NQ	Futures	5898.08	5900.17	5898.08	5898.68	209.0
2016-12-27 01:00:00	NQ	Futures	5898.38	5899.57	5897.48	5898.08	154.0
2016-12-27 02:00:00	NQ	Futures	5897.48	5900.17	5896.59	5898.38	500.0
2016-12-27 03:00:00	NQ	Futures	5898.68	5899.57	5895.99	5896.89	566.0
2016-12-27 04:00:00	NQ	Futures	5896.89	5897.48	5895.1	5895.69	202.0
2016-12-27 05:00:00	NQ	Futures	5895.99	5896.59	5895.1	5896.29	318.0
2016-12-27 06:00:00	NQ	Futures	5896.59	5903.15	5895.99	5901.36	758.0
2016-12-27 07:00:00	NQ	Futures	5901.36	5904.64	5901.06	5904.64	618.0
2016-12-27 08:00:00	NQ	Futures	5904.35	5907.33	5902.26	5907.03	919.0
2016-12-27 09:00:00	NQ	Futures	5907.03	5959.83	5904.35	5955.06	33727.0
2016-12-27 10:00:00	NQ	Futures	5955.06	5959.54	5944.92	5947.6	15230.0
2016-12-27 11:00:00	NQ	Futures	5947.6	5949.39	5933.28	5935.07	10838.0
2016-12-27 12:00:00	NQ	Futures	5934.77	5935.97	5929.7	5934.77	6306.0
2016-12-27 13:00:00	NQ	Futures	5935.07	5940.14	5932.09	5935.67	4823.0
2016-12-27 14:00:00	NQ	Futures	5935.37	5939.55	5932.09	5932.69	4358.0
2016-12-27 15:00:00	NQ	Futures	5932.39	5936.56	5923.74	5925.53	11734.0
2016-12-27 16:00:00	NQ	Futures	5925.23	5925.53	5917.77	5919.26	5062.0
2016-12-27 18:00:00	NQ	Futures	5920.16	5923.14	5918.37	5922.54	590.0
2016-12-27 19:00:00	NQ	Futures	5922.25	5926.42	5921.35	5925.83	613.0
2016-12-27 20:00:00	NQ	Futures	5925.53	5931.79	5924.63	5930.3	978.0
2016-12-27 21:00:00	NQ	Futures	5930.0	5930.3	5928.21	5928.81	324.0
2016-12-27 22:00:00	NQ	Futures	5928.81	5930.3	5927.91	5928.51	278.0
2016-12-27 23:00:00	NQ	Futures	5928.51	5930.0	5927.61	5928.21	280.0
2016-12-27 00:00:00	YM	Futures	21551.0	21557.6	21551.0	21557.6	312.0
2016-12-27 01:00:00	YM	Futures	21556.5	21556.5	21552.1	21555.4	246.0
2016-12-27 02:00:00	YM	Futures	21554.3	21559.7	21550.0	21554.3	503.0
2016-12-27 03:00:00	YM	Futures	21554.3	21557.6	21550.0	21551.0	616.0

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

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