PREVIEW / futures_1hour / 2018-05-31

all futures 1-hour files

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

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-31 00:00:00	ES	Futures	2971.97	2973.06	2971.7	2972.79	1886.0
2018-05-31 01:00:00	ES	Futures	2972.79	2974.15	2971.15	2971.7	5171.0
2018-05-31 02:00:00	ES	Futures	2971.42	2974.42	2968.97	2974.42	8194.0
2018-05-31 03:00:00	ES	Futures	2974.15	2977.43	2970.06	2976.06	17643.0
2018-05-31 04:00:00	ES	Futures	2976.34	2978.25	2973.61	2976.34	9997.0
2018-05-31 05:00:00	ES	Futures	2976.06	2976.34	2972.79	2974.15	11488.0
2018-05-31 06:00:00	ES	Futures	2974.15	2975.79	2971.15	2973.61	9416.0
2018-05-31 07:00:00	ES	Futures	2973.61	2976.88	2970.88	2976.88	11173.0
2018-05-31 08:00:00	ES	Futures	2976.88	2976.88	2973.06	2974.15	17680.0
2018-05-31 09:00:00	ES	Futures	2974.15	2974.15	2962.42	2964.33	228861.0
2018-05-31 10:00:00	ES	Futures	2964.05	2967.33	2955.05	2957.78	204678.0
2018-05-31 11:00:00	ES	Futures	2958.05	2971.97	2956.41	2966.24	237419.0
2018-05-31 12:00:00	ES	Futures	2966.24	2966.24	2958.32	2962.42	95623.0
2018-05-31 13:00:00	ES	Futures	2962.42	2962.96	2950.68	2951.23	111172.0
2018-05-31 14:00:00	ES	Futures	2951.23	2955.87	2947.13	2955.32	152377.0
2018-05-31 15:00:00	ES	Futures	2955.32	2959.96	2952.05	2952.87	330600.0
2018-05-31 16:00:00	ES	Futures	2952.87	2955.87	2952.59	2955.59	105728.0
2018-05-31 18:00:00	ES	Futures	2955.59	2957.23	2953.96	2955.59	4385.0
2018-05-31 19:00:00	ES	Futures	2955.59	2956.69	2955.32	2956.69	2520.0
2018-05-31 20:00:00	ES	Futures	2956.96	2957.78	2955.59	2957.78	4993.0
2018-05-31 21:00:00	ES	Futures	2957.5	2960.78	2957.5	2959.41	9630.0
2018-05-31 22:00:00	ES	Futures	2959.41	2961.05	2958.87	2959.69	4778.0
2018-05-31 23:00:00	ES	Futures	2959.69	2960.23	2956.41	2956.41	5022.0
2018-05-31 00:00:00	NQ	Futures	8260.42	8263.37	8259.53	8261.9	391.0
2018-05-31 01:00:00	NQ	Futures	8262.49	8271.06	8261.6	8263.67	1169.0
2018-05-31 02:00:00	NQ	Futures	8263.08	8272.54	8256.58	8271.35	2609.0
2018-05-31 03:00:00	NQ	Futures	8271.06	8277.26	8258.05	8275.2	5037.0
2018-05-31 04:00:00	NQ	Futures	8274.6	8279.04	8264.85	8273.42	3906.0
2018-05-31 05:00:00	NQ	Futures	8273.72	8274.31	8263.37	8266.63	3200.0
2018-05-31 06:00:00	NQ	Futures	8266.33	8271.94	8256.58	8266.63	3740.0
2018-05-31 07:00:00	NQ	Futures	8266.33	8269.58	8258.05	8269.58	3728.0
2018-05-31 08:00:00	NQ	Futures	8269.28	8271.06	8260.12	8266.63	6275.0
2018-05-31 09:00:00	NQ	Futures	8266.63	8274.6	8236.48	8266.92	58521.0
2018-05-31 10:00:00	NQ	Futures	8266.63	8274.31	8225.55	8238.85	60296.0
2018-05-31 11:00:00	NQ	Futures	8238.85	8302.68	8235.59	8287.02	65472.0
2018-05-31 12:00:00	NQ	Futures	8286.72	8287.31	8259.83	8278.45	30262.0
2018-05-31 13:00:00	NQ	Futures	8278.45	8279.33	8241.21	8242.98	27749.0
2018-05-31 14:00:00	NQ	Futures	8243.57	8255.99	8229.09	8248.89	34581.0
2018-05-31 15:00:00	NQ	Futures	8249.19	8259.24	8236.78	8246.53	50556.0
2018-05-31 16:00:00	NQ	Futures	8246.53	8255.1	8245.35	8254.8	9941.0
2018-05-31 18:00:00	NQ	Futures	8254.21	8257.46	8248.01	8252.44	1005.0
2018-05-31 19:00:00	NQ	Futures	8251.85	8255.99	8250.37	8255.39	879.0
2018-05-31 20:00:00	NQ	Futures	8255.69	8258.05	8251.55	8258.05	1174.0
2018-05-31 21:00:00	NQ	Futures	8258.05	8266.63	8256.87	8262.49	2160.0
2018-05-31 22:00:00	NQ	Futures	8262.49	8268.4	8260.71	8262.49	1264.0
2018-05-31 23:00:00	NQ	Futures	8262.19	8262.78	8255.1	8255.99	1230.0
2018-05-31 00:00:00	YM	Futures	26777.0	26785.7	26773.7	26781.3	491.0
2018-05-31 01:00:00	YM	Futures	26783.5	26798.7	26768.3	26772.6	1084.0
2018-05-31 02:00:00	YM	Futures	26771.6	26795.5	26754.2	26792.2	2556.0
2018-05-31 03:00:00	YM	Futures	26791.1	26813.9	26752.0	26804.1	5536.0

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

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