PREVIEW / futures_1hour / 2017-12-29

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-12-29.parquet
  size:    44 KB
  rows:    1,330

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-12-29 00:00:00	ES	Futures	2938.28	2938.82	2938.28	2938.82	2149.0
2017-12-29 01:00:00	ES	Futures	2938.82	2939.1	2938.28	2938.82	1150.0
2017-12-29 02:00:00	ES	Futures	2938.82	2940.46	2938.82	2939.92	3959.0
2017-12-29 03:00:00	ES	Futures	2939.64	2940.46	2938.55	2940.19	8782.0
2017-12-29 04:00:00	ES	Futures	2939.92	2942.1	2939.64	2942.1	7844.0
2017-12-29 05:00:00	ES	Futures	2942.1	2945.66	2941.83	2945.38	14222.0
2017-12-29 06:00:00	ES	Futures	2945.11	2946.75	2944.84	2945.93	12042.0
2017-12-29 07:00:00	ES	Futures	2945.93	2950.03	2945.66	2947.02	23162.0
2017-12-29 08:00:00	ES	Futures	2946.75	2948.12	2944.84	2945.38	15981.0
2017-12-29 09:00:00	ES	Futures	2945.11	2946.48	2937.73	2938.55	124209.0
2017-12-29 10:00:00	ES	Futures	2938.82	2939.1	2933.63	2935.82	93657.0
2017-12-29 11:00:00	ES	Futures	2936.09	2937.73	2933.63	2936.64	68287.0
2017-12-29 12:00:00	ES	Futures	2936.64	2937.46	2934.45	2935.27	41654.0
2017-12-29 13:00:00	ES	Futures	2935.0	2936.09	2931.44	2932.81	52393.0
2017-12-29 14:00:00	ES	Futures	2933.08	2934.45	2932.26	2933.63	44086.0
2017-12-29 15:00:00	ES	Futures	2933.63	2937.18	2923.79	2927.34	328529.0
2017-12-29 16:00:00	ES	Futures	2927.34	2930.62	2916.68	2917.23	190796.0
2017-12-29 00:00:00	NQ	Futures	7648.87	7650.95	7648.87	7650.06	410.0
2017-12-29 01:00:00	NQ	Futures	7650.06	7651.84	7648.87	7651.24	345.0
2017-12-29 02:00:00	NQ	Futures	7651.54	7655.99	7651.54	7651.84	836.0
2017-12-29 03:00:00	NQ	Futures	7652.13	7655.1	7648.57	7653.32	1261.0
2017-12-29 04:00:00	NQ	Futures	7653.32	7657.77	7652.72	7657.77	969.0
2017-12-29 05:00:00	NQ	Futures	7657.47	7662.81	7657.47	7661.62	2686.0
2017-12-29 06:00:00	NQ	Futures	7661.92	7671.41	7660.73	7667.55	3298.0
2017-12-29 07:00:00	NQ	Futures	7667.55	7673.19	7667.26	7670.82	2766.0
2017-12-29 08:00:00	NQ	Futures	7670.82	7672.89	7661.33	7662.22	4562.0
2017-12-29 09:00:00	NQ	Futures	7661.92	7668.44	7637.6	7641.16	30832.0
2017-12-29 10:00:00	NQ	Futures	7641.16	7645.01	7618.02	7623.36	34889.0
2017-12-29 11:00:00	NQ	Futures	7623.36	7629.0	7612.98	7628.7	26894.0
2017-12-29 12:00:00	NQ	Futures	7628.7	7637.3	7626.33	7629.0	13610.0
2017-12-29 13:00:00	NQ	Futures	7628.7	7632.85	7618.91	7621.29	11797.0
2017-12-29 14:00:00	NQ	Futures	7621.29	7626.92	7619.8	7623.96	8859.0
2017-12-29 15:00:00	NQ	Futures	7623.66	7633.74	7600.23	7603.49	37283.0
2017-12-29 16:00:00	NQ	Futures	7603.49	7611.5	7572.94	7575.02	19726.0
2017-12-29 00:00:00	YM	Futures	26989.4	26992.7	26985.1	26989.4	519.0
2017-12-29 01:00:00	YM	Futures	26989.4	26992.7	26987.2	26992.7	218.0
2017-12-29 02:00:00	YM	Futures	26991.6	27000.3	26988.3	26989.4	971.0
2017-12-29 03:00:00	YM	Futures	26990.5	26993.8	26978.5	26984.0	1107.0
2017-12-29 04:00:00	YM	Futures	26984.0	26985.1	26966.6	26985.1	973.0
2017-12-29 05:00:00	YM	Futures	26985.1	27013.3	26985.1	27006.8	2002.0
2017-12-29 06:00:00	YM	Futures	27007.9	27027.5	27006.8	27013.3	1805.0
2017-12-29 07:00:00	YM	Futures	27014.4	27048.1	27014.4	27027.5	2418.0
2017-12-29 08:00:00	YM	Futures	27028.5	27044.8	27027.5	27031.8	1858.0
2017-12-29 09:00:00	YM	Futures	27031.8	27040.5	26966.6	26977.5	12302.0
2017-12-29 10:00:00	YM	Futures	26977.5	26978.5	26927.5	26940.5	9243.0
2017-12-29 11:00:00	YM	Futures	26940.5	26969.8	26923.1	26962.2	6780.0
2017-12-29 12:00:00	YM	Futures	26962.2	26963.3	26940.5	26950.3	3045.0
2017-12-29 13:00:00	YM	Futures	26950.3	26952.5	26919.8	26930.7	3237.0
2017-12-29 14:00:00	YM	Futures	26930.7	26941.6	26926.4	26936.2	2584.0
2017-12-29 15:00:00	YM	Futures	26936.2	26955.7	26870.9	26897.0	13653.0

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

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