PREVIEW / futures_1hour / 2018-05-14

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-05-14.parquet
  size:    53 KB
  rows:    1,669

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-14 00:00:00	ES	Futures	2989.71	2992.16	2989.43	2991.35	3252.0
2018-05-14 01:00:00	ES	Futures	2991.07	2991.35	2989.43	2989.71	3305.0
2018-05-14 02:00:00	ES	Futures	2989.71	2989.98	2986.98	2986.98	6235.0
2018-05-14 03:00:00	ES	Futures	2986.98	2989.71	2985.07	2985.89	13297.0
2018-05-14 04:00:00	ES	Futures	2985.61	2987.52	2985.07	2985.61	9004.0
2018-05-14 05:00:00	ES	Futures	2985.61	2987.8	2985.34	2985.89	6541.0
2018-05-14 06:00:00	ES	Futures	2985.89	2986.43	2983.98	2985.61	7765.0
2018-05-14 07:00:00	ES	Futures	2985.34	2985.61	2983.43	2983.7	9457.0
2018-05-14 08:00:00	ES	Futures	2983.7	2984.25	2982.61	2983.43	13588.0
2018-05-14 09:00:00	ES	Futures	2983.7	2990.8	2983.16	2988.89	112262.0
2018-05-14 10:00:00	ES	Futures	2989.16	2992.44	2985.61	2986.98	118400.0
2018-05-14 11:00:00	ES	Futures	2986.98	2990.8	2983.16	2985.61	86643.0
2018-05-14 12:00:00	ES	Futures	2985.89	2989.71	2980.16	2980.7	77791.0
2018-05-14 13:00:00	ES	Futures	2980.7	2982.34	2976.06	2979.88	95301.0
2018-05-14 14:00:00	ES	Futures	2979.61	2981.52	2973.88	2980.7	97232.0
2018-05-14 15:00:00	ES	Futures	2980.7	2983.43	2974.97	2979.88	146337.0
2018-05-14 16:00:00	ES	Futures	2979.88	2981.52	2974.15	2979.06	71951.0
2018-05-14 18:00:00	ES	Futures	2978.52	2980.97	2977.7	2980.7	3241.0
2018-05-14 19:00:00	ES	Futures	2980.7	2981.25	2978.52	2980.16	1732.0
2018-05-14 20:00:00	ES	Futures	2980.16	2981.52	2977.7	2978.79	3872.0
2018-05-14 21:00:00	ES	Futures	2978.52	2981.25	2977.97	2978.79	4572.0
2018-05-14 22:00:00	ES	Futures	2978.79	2979.06	2975.79	2976.06	4012.0
2018-05-14 23:00:00	ES	Futures	2976.06	2977.7	2975.79	2977.43	2660.0
2018-05-14 00:00:00	NQ	Futures	8261.01	8268.1	8260.71	8267.22	854.0
2018-05-14 01:00:00	NQ	Futures	8266.63	8267.22	8257.76	8258.94	1766.0
2018-05-14 02:00:00	NQ	Futures	8258.94	8259.53	8250.37	8250.96	1876.0
2018-05-14 03:00:00	NQ	Futures	8250.67	8256.87	8243.28	8246.53	3625.0
2018-05-14 04:00:00	NQ	Futures	8246.53	8255.1	8245.94	8250.08	2680.0
2018-05-14 05:00:00	NQ	Futures	8250.37	8260.42	8249.19	8253.33	2120.0
2018-05-14 06:00:00	NQ	Futures	8253.33	8255.1	8245.64	8250.67	2086.0
2018-05-14 07:00:00	NQ	Futures	8250.37	8250.37	8241.8	8243.87	2723.0
2018-05-14 08:00:00	NQ	Futures	8243.87	8245.94	8239.44	8242.69	3880.0
2018-05-14 09:00:00	NQ	Futures	8242.98	8274.31	8242.1	8263.08	40734.0
2018-05-14 10:00:00	NQ	Futures	8263.08	8290.86	8257.76	8274.01	36400.0
2018-05-14 11:00:00	NQ	Futures	8274.01	8287.31	8257.76	8264.26	25444.0
2018-05-14 12:00:00	NQ	Futures	8263.97	8276.67	8251.26	8253.62	26234.0
2018-05-14 13:00:00	NQ	Futures	8253.33	8254.21	8232.93	8247.42	28590.0
2018-05-14 14:00:00	NQ	Futures	8247.42	8251.26	8225.84	8248.89	25737.0
2018-05-14 15:00:00	NQ	Futures	8248.89	8253.03	8227.61	8238.85	28397.0
2018-05-14 16:00:00	NQ	Futures	8239.14	8245.64	8222.3	8238.55	8711.0
2018-05-14 18:00:00	NQ	Futures	8238.25	8245.05	8235.0	8242.39	821.0
2018-05-14 19:00:00	NQ	Futures	8242.98	8243.87	8236.48	8242.1	588.0
2018-05-14 20:00:00	NQ	Futures	8242.1	8247.42	8235.3	8238.85	1294.0
2018-05-14 21:00:00	NQ	Futures	8239.73	8246.53	8236.78	8238.25	3688.0
2018-05-14 22:00:00	NQ	Futures	8238.55	8239.14	8227.02	8227.61	2494.0
2018-05-14 23:00:00	NQ	Futures	8227.61	8232.93	8226.43	8232.05	753.0
2018-05-14 00:00:00	YM	Futures	27070.2	27100.6	27069.1	27096.3	1182.0
2018-05-14 01:00:00	YM	Futures	27096.3	27098.5	27087.6	27088.7	1042.0
2018-05-14 02:00:00	YM	Futures	27088.7	27090.8	27055.0	27059.4	2746.0
2018-05-14 03:00:00	YM	Futures	27059.4	27077.8	27045.2	27052.8	3203.0

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

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