PREVIEW / futures_1hour / 2018-10-23

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-10-23.parquet
  size:    56 KB
  rows:    1,712

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-10-23 00:00:00	ES	Futures	2975.39	2976.48	2972.12	2974.03	12544.0
2018-10-23 01:00:00	ES	Futures	2973.76	2977.56	2968.59	2968.59	16095.0
2018-10-23 02:00:00	ES	Futures	2968.86	2969.95	2961.52	2963.69	33843.0
2018-10-23 03:00:00	ES	Futures	2963.42	2971.58	2961.24	2964.51	46832.0
2018-10-23 04:00:00	ES	Futures	2964.51	2966.41	2960.7	2962.88	33032.0
2018-10-23 05:00:00	ES	Futures	2962.6	2962.88	2953.08	2962.06	54099.0
2018-10-23 06:00:00	ES	Futures	2962.33	2966.96	2957.44	2963.42	29864.0
2018-10-23 07:00:00	ES	Futures	2963.15	2965.6	2948.73	2958.25	75426.0
2018-10-23 08:00:00	ES	Futures	2958.25	2960.97	2952.54	2957.44	59733.0
2018-10-23 09:00:00	ES	Futures	2957.44	2963.15	2946.56	2951.45	356517.0
2018-10-23 10:00:00	ES	Futures	2951.45	2954.17	2929.15	2943.29	502169.0
2018-10-23 11:00:00	ES	Futures	2943.29	2956.08	2938.4	2939.21	285649.0
2018-10-23 12:00:00	ES	Futures	2939.21	2964.24	2938.94	2958.52	203758.0
2018-10-23 13:00:00	ES	Futures	2958.25	2977.02	2957.16	2962.33	258031.0
2018-10-23 14:00:00	ES	Futures	2962.06	2994.16	2962.06	2991.16	282656.0
2018-10-23 15:00:00	ES	Futures	2991.16	2997.15	2979.74	2982.73	342165.0
2018-10-23 16:00:00	ES	Futures	2982.46	2989.26	2980.56	2987.63	70683.0
2018-10-23 18:00:00	ES	Futures	2986.81	2988.72	2982.46	2983.28	7464.0
2018-10-23 19:00:00	ES	Futures	2983.55	2989.53	2983.28	2988.17	6406.0
2018-10-23 20:00:00	ES	Futures	2987.9	2987.9	2981.64	2986.27	11345.0
2018-10-23 21:00:00	ES	Futures	2986.27	2986.54	2977.56	2979.74	17533.0
2018-10-23 22:00:00	ES	Futures	2979.74	2983.82	2977.56	2981.92	16178.0
2018-10-23 23:00:00	ES	Futures	2982.19	2991.98	2982.19	2989.53	20605.0
2018-10-23 00:00:00	NQ	Futures	8321.91	8327.48	8309.59	8314.87	3795.0
2018-10-23 01:00:00	NQ	Futures	8315.16	8328.66	8289.06	8289.64	5961.0
2018-10-23 02:00:00	NQ	Futures	8289.64	8293.46	8261.78	8272.63	10630.0
2018-10-23 03:00:00	NQ	Futures	8272.34	8301.96	8267.94	8278.79	13895.0
2018-10-23 04:00:00	NQ	Futures	8278.21	8284.07	8263.54	8271.17	11409.0
2018-10-23 05:00:00	NQ	Futures	8270.58	8276.74	8241.25	8275.27	14998.0
2018-10-23 06:00:00	NQ	Futures	8274.98	8287.59	8253.27	8276.15	12040.0
2018-10-23 07:00:00	NQ	Futures	8275.57	8281.43	8230.69	8255.03	19464.0
2018-10-23 08:00:00	NQ	Futures	8254.74	8264.71	8240.66	8255.91	20631.0
2018-10-23 09:00:00	NQ	Futures	8255.62	8270.58	8213.38	8227.46	118645.0
2018-10-23 10:00:00	NQ	Futures	8227.76	8233.91	8147.09	8201.36	133641.0
2018-10-23 11:00:00	NQ	Futures	8201.06	8252.69	8179.65	8203.12	84252.0
2018-10-23 12:00:00	NQ	Futures	8203.41	8313.7	8201.94	8278.21	81796.0
2018-10-23 13:00:00	NQ	Futures	8277.91	8327.19	8274.1	8283.19	72799.0
2018-10-23 14:00:00	NQ	Futures	8283.48	8392.01	8280.55	8383.8	84111.0
2018-10-23 15:00:00	NQ	Futures	8384.09	8405.21	8353.59	8367.96	77118.0
2018-10-23 16:00:00	NQ	Futures	8367.96	8379.4	8357.99	8379.11	12631.0
2018-10-23 18:00:00	NQ	Futures	8372.65	8376.76	8352.12	8357.99	3048.0
2018-10-23 19:00:00	NQ	Futures	8357.99	8379.4	8357.69	8373.53	2613.0
2018-10-23 20:00:00	NQ	Futures	8372.95	8375.0	8350.95	8364.15	5977.0
2018-10-23 21:00:00	NQ	Futures	8363.85	8364.73	8335.4	8345.08	9640.0
2018-10-23 22:00:00	NQ	Futures	8344.79	8355.93	8335.99	8348.6	6671.0
2018-10-23 23:00:00	NQ	Futures	8348.01	8418.12	8348.01	8394.06	11817.0
2018-10-23 00:00:00	YM	Futures	27282.3	27291.0	27256.2	27270.4	2323.0
2018-10-23 01:00:00	YM	Futures	27270.4	27306.2	27221.5	27223.7	4008.0
2018-10-23 02:00:00	YM	Futures	27222.6	27234.5	27174.8	27193.2	6842.0
2018-10-23 03:00:00	YM	Futures	27194.3	27262.8	27166.1	27203.0	6770.0

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

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