PREVIEW / futures_1hour / 2017-08-28

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-08-28.parquet
  size:    51 KB
  rows:    1,538

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-08-28 00:00:00	ES	Futures	2666.97	2667.24	2665.6	2666.97	3217.0
2017-08-28 01:00:00	ES	Futures	2666.97	2667.52	2666.15	2666.97	3234.0
2017-08-28 02:00:00	ES	Futures	2666.97	2667.24	2663.96	2664.24	8831.0
2017-08-28 03:00:00	ES	Futures	2663.96	2665.6	2663.69	2665.06	16462.0
2017-08-28 04:00:00	ES	Futures	2665.06	2669.43	2665.06	2667.52	13872.0
2017-08-28 05:00:00	ES	Futures	2667.24	2670.25	2667.24	2669.43	8985.0
2017-08-28 06:00:00	ES	Futures	2669.43	2670.25	2668.34	2669.43	5708.0
2017-08-28 07:00:00	ES	Futures	2669.43	2672.71	2669.43	2672.16	17029.0
2017-08-28 08:00:00	ES	Futures	2672.16	2675.72	2672.16	2675.72	19409.0
2017-08-28 09:00:00	ES	Futures	2675.44	2677.9	2670.8	2671.62	135343.0
2017-08-28 10:00:00	ES	Futures	2671.62	2673.26	2668.34	2672.71	146174.0
2017-08-28 11:00:00	ES	Futures	2672.71	2673.8	2668.88	2671.07	94671.0
2017-08-28 12:00:00	ES	Futures	2671.34	2671.34	2665.6	2667.52	84073.0
2017-08-28 13:00:00	ES	Futures	2667.52	2669.98	2666.97	2669.7	53092.0
2017-08-28 14:00:00	ES	Futures	2669.7	2670.25	2667.79	2669.16	58272.0
2017-08-28 15:00:00	ES	Futures	2669.43	2671.34	2667.79	2671.34	147627.0
2017-08-28 16:00:00	ES	Futures	2671.34	2672.98	2671.07	2672.44	57850.0
2017-08-28 18:00:00	ES	Futures	2661.23	2661.23	2649.2	2658.22	57570.0
2017-08-28 19:00:00	ES	Futures	2658.22	2660.14	2654.67	2657.95	15510.0
2017-08-28 20:00:00	ES	Futures	2657.95	2659.86	2655.22	2659.59	24381.0
2017-08-28 21:00:00	ES	Futures	2659.32	2660.14	2652.48	2654.4	21387.0
2017-08-28 22:00:00	ES	Futures	2654.12	2657.4	2653.58	2656.58	8881.0
2017-08-28 23:00:00	ES	Futures	2656.58	2657.68	2655.76	2657.13	5172.0
2017-08-28 00:00:00	NQ	Futures	6928.37	6929.27	6923.01	6928.67	514.0
2017-08-28 01:00:00	NQ	Futures	6928.97	6929.56	6924.5	6926.59	851.0
2017-08-28 02:00:00	NQ	Futures	6926.88	6927.48	6913.78	6916.76	1817.0
2017-08-28 03:00:00	NQ	Futures	6916.46	6918.55	6909.32	6917.36	3696.0
2017-08-28 04:00:00	NQ	Futures	6917.06	6930.16	6916.17	6923.91	2828.0
2017-08-28 05:00:00	NQ	Futures	6923.31	6933.14	6922.72	6931.05	1509.0
2017-08-28 06:00:00	NQ	Futures	6930.46	6937.31	6927.48	6934.63	1826.0
2017-08-28 07:00:00	NQ	Futures	6934.03	6941.18	6933.44	6939.09	2777.0
2017-08-28 08:00:00	NQ	Futures	6938.8	6955.17	6938.8	6954.58	6295.0
2017-08-28 09:00:00	NQ	Futures	6954.28	6959.64	6938.2	6942.07	37937.0
2017-08-28 10:00:00	NQ	Futures	6941.77	6974.53	6935.52	6970.95	48710.0
2017-08-28 11:00:00	NQ	Futures	6971.25	6974.53	6958.45	6966.49	22323.0
2017-08-28 12:00:00	NQ	Futures	6966.19	6967.38	6942.37	6950.11	21132.0
2017-08-28 13:00:00	NQ	Futures	6949.81	6961.72	6947.73	6959.64	13473.0
2017-08-28 14:00:00	NQ	Futures	6959.64	6961.72	6950.41	6954.87	11730.0
2017-08-28 15:00:00	NQ	Futures	6954.58	6958.15	6946.83	6956.66	21228.0
2017-08-28 16:00:00	NQ	Futures	6956.66	6965.0	6956.36	6962.32	6036.0
2017-08-28 18:00:00	NQ	Futures	6931.65	6931.95	6893.83	6917.95	10359.0
2017-08-28 19:00:00	NQ	Futures	6917.95	6923.91	6908.42	6919.14	2905.0
2017-08-28 20:00:00	NQ	Futures	6918.85	6927.78	6911.4	6925.4	4154.0
2017-08-28 21:00:00	NQ	Futures	6925.1	6927.78	6904.85	6909.02	3958.0
2017-08-28 22:00:00	NQ	Futures	6908.72	6917.65	6902.47	6912.89	3191.0
2017-08-28 23:00:00	NQ	Futures	6913.19	6917.36	6908.42	6914.38	1624.0
2017-08-28 00:00:00	YM	Futures	23709.3	23710.4	23695.2	23705.0	945.0
2017-08-28 01:00:00	YM	Futures	23706.0	23709.3	23697.3	23703.9	421.0
2017-08-28 02:00:00	YM	Futures	23706.0	23708.2	23682.1	23683.2	1237.0
2017-08-28 03:00:00	YM	Futures	23684.3	23693.0	23674.5	23687.5	2427.0

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

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