PREVIEW / futures_1hour / 2018-05-23

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-05-23.parquet
  size:    57 KB
  rows:    1,720

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
2018-05-23 00:00:00	ES	Futures	2968.15	2969.79	2967.88	2969.51	2509.0
2018-05-23 01:00:00	ES	Futures	2969.51	2970.06	2968.69	2969.51	3505.0
2018-05-23 02:00:00	ES	Futures	2969.51	2971.15	2967.6	2967.6	8405.0
2018-05-23 03:00:00	ES	Futures	2967.6	2968.97	2959.41	2959.96	32204.0
2018-05-23 04:00:00	ES	Futures	2959.96	2960.51	2953.41	2955.87	36733.0
2018-05-23 05:00:00	ES	Futures	2955.87	2958.05	2952.32	2954.5	22865.0
2018-05-23 06:00:00	ES	Futures	2954.23	2958.6	2953.68	2957.78	17363.0
2018-05-23 07:00:00	ES	Futures	2957.5	2958.87	2954.23	2956.41	18402.0
2018-05-23 08:00:00	ES	Futures	2956.69	2959.41	2954.23	2957.5	24876.0
2018-05-23 09:00:00	ES	Futures	2957.78	2965.42	2955.59	2963.51	167083.0
2018-05-23 10:00:00	ES	Futures	2963.78	2970.6	2956.69	2959.69	170879.0
2018-05-23 11:00:00	ES	Futures	2959.41	2969.24	2958.87	2961.87	135954.0
2018-05-23 12:00:00	ES	Futures	2961.6	2967.6	2958.87	2966.51	117862.0
2018-05-23 13:00:00	ES	Futures	2966.51	2966.78	2961.33	2964.6	49940.0
2018-05-23 14:00:00	ES	Futures	2964.6	2977.7	2963.78	2976.61	169317.0
2018-05-23 15:00:00	ES	Futures	2976.61	2983.16	2975.24	2983.16	160047.0
2018-05-23 16:00:00	ES	Futures	2983.16	2983.43	2977.7	2980.16	70551.0
2018-05-23 18:00:00	ES	Futures	2979.88	2981.25	2979.34	2980.43	5350.0
2018-05-23 19:00:00	ES	Futures	2980.43	2980.43	2977.97	2978.25	4274.0
2018-05-23 20:00:00	ES	Futures	2978.25	2979.06	2973.88	2976.34	12619.0
2018-05-23 21:00:00	ES	Futures	2976.34	2976.61	2969.51	2969.79	11894.0
2018-05-23 22:00:00	ES	Futures	2969.79	2976.34	2969.79	2976.06	6732.0
2018-05-23 23:00:00	ES	Futures	2976.34	2976.34	2972.79	2973.88	3016.0
2018-05-23 00:00:00	NQ	Futures	8124.77	8135.11	8124.47	8133.64	1443.0
2018-05-23 01:00:00	NQ	Futures	8133.64	8134.52	8128.61	8131.86	1542.0
2018-05-23 02:00:00	NQ	Futures	8131.57	8137.77	8123.59	8123.59	3178.0
2018-05-23 03:00:00	NQ	Futures	8123.88	8128.32	8092.26	8099.06	11556.0
2018-05-23 04:00:00	NQ	Futures	8099.06	8100.54	8079.26	8085.76	9796.0
2018-05-23 05:00:00	NQ	Futures	8086.05	8091.97	8073.64	8080.74	5644.0
2018-05-23 06:00:00	NQ	Futures	8080.44	8092.56	8076.01	8089.31	3599.0
2018-05-23 07:00:00	NQ	Futures	8089.9	8095.22	8081.62	8086.35	3909.0
2018-05-23 08:00:00	NQ	Futures	8086.35	8095.51	8077.78	8089.9	11026.0
2018-05-23 09:00:00	NQ	Futures	8090.19	8133.64	8083.1	8123.59	62191.0
2018-05-23 10:00:00	NQ	Futures	8123.59	8153.73	8108.22	8119.15	61261.0
2018-05-23 11:00:00	NQ	Futures	8119.15	8163.19	8117.09	8142.5	44574.0
2018-05-23 12:00:00	NQ	Futures	8142.5	8172.05	8136.89	8166.44	39763.0
2018-05-23 13:00:00	NQ	Futures	8166.14	8167.62	8145.75	8154.03	18127.0
2018-05-23 14:00:00	NQ	Futures	8154.03	8201.61	8149.59	8201.31	47333.0
2018-05-23 15:00:00	NQ	Futures	8201.02	8228.8	8195.7	8228.5	37333.0
2018-05-23 16:00:00	NQ	Futures	8228.5	8229.39	8215.2	8224.07	8708.0
2018-05-23 18:00:00	NQ	Futures	8223.77	8227.02	8221.41	8225.55	1392.0
2018-05-23 19:00:00	NQ	Futures	8225.55	8225.84	8215.79	8215.79	1668.0
2018-05-23 20:00:00	NQ	Futures	8216.09	8218.16	8201.02	8206.93	4025.0
2018-05-23 21:00:00	NQ	Futures	8206.34	8209.29	8186.54	8187.72	3708.0
2018-05-23 22:00:00	NQ	Futures	8187.42	8209.0	8186.54	8207.52	2627.0
2018-05-23 23:00:00	NQ	Futures	8207.52	8208.41	8197.47	8200.72	1387.0
2018-05-23 00:00:00	YM	Futures	26900.8	26918.2	26900.8	26911.7	1323.0
2018-05-23 01:00:00	YM	Futures	26911.7	26926.9	26906.2	26913.8	1408.0
2018-05-23 02:00:00	YM	Futures	26912.7	26939.9	26898.6	26898.6	3662.0
2018-05-23 03:00:00	YM	Futures	26899.7	26912.7	26809.6	26813.9	8762.0

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

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