PREVIEW / futures_1hour / 2018-07-05

all futures 1-hour files

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

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-07-05 00:00:00	ES	Futures	2960.07	2961.71	2958.98	2959.8	4119.0
2018-07-05 01:00:00	ES	Futures	2960.07	2963.07	2957.35	2962.53	7800.0
2018-07-05 02:00:00	ES	Futures	2962.25	2963.34	2958.44	2961.71	8519.0
2018-07-05 03:00:00	ES	Futures	2961.71	2971.24	2961.44	2969.61	20921.0
2018-07-05 04:00:00	ES	Futures	2969.34	2971.79	2967.7	2969.07	12131.0
2018-07-05 05:00:00	ES	Futures	2969.07	2976.97	2967.98	2974.24	19115.0
2018-07-05 06:00:00	ES	Futures	2974.24	2975.06	2972.61	2975.06	10784.0
2018-07-05 07:00:00	ES	Futures	2974.79	2981.33	2974.24	2980.78	21844.0
2018-07-05 08:00:00	ES	Futures	2980.51	2981.6	2976.69	2977.51	20865.0
2018-07-05 09:00:00	ES	Futures	2977.51	2978.6	2970.16	2970.43	132186.0
2018-07-05 10:00:00	ES	Futures	2970.43	2974.79	2961.16	2963.07	147267.0
2018-07-05 11:00:00	ES	Futures	2963.07	2976.15	2961.16	2973.97	111043.0
2018-07-05 12:00:00	ES	Futures	2974.24	2981.05	2973.7	2979.69	80295.0
2018-07-05 13:00:00	ES	Futures	2979.69	2983.23	2976.97	2979.15	57738.0
2018-07-05 14:00:00	ES	Futures	2979.15	2983.51	2969.88	2978.6	109398.0
2018-07-05 15:00:00	ES	Futures	2978.33	2985.69	2978.06	2985.14	183113.0
2018-07-05 16:00:00	ES	Futures	2985.14	2985.96	2983.51	2984.6	54495.0
2018-07-05 18:00:00	ES	Futures	2982.96	2983.23	2979.96	2980.24	5804.0
2018-07-05 19:00:00	ES	Futures	2980.24	2980.78	2978.33	2978.87	4147.0
2018-07-05 20:00:00	ES	Futures	2978.87	2985.14	2978.87	2984.05	10712.0
2018-07-05 21:00:00	ES	Futures	2984.05	2986.23	2981.05	2985.14	14131.0
2018-07-05 22:00:00	ES	Futures	2985.14	2985.14	2982.69	2983.23	8755.0
2018-07-05 23:00:00	ES	Futures	2983.23	2985.69	2981.33	2985.41	5433.0
2018-07-05 00:00:00	NQ	Futures	8273.74	8281.1	8271.38	8277.27	2157.0
2018-07-05 01:00:00	NQ	Futures	8277.27	8287.87	8267.56	8284.63	2739.0
2018-07-05 02:00:00	NQ	Futures	8284.34	8286.99	8272.56	8279.33	2839.0
2018-07-05 03:00:00	NQ	Futures	8279.33	8310.25	8279.04	8305.83	7602.0
2018-07-05 04:00:00	NQ	Futures	8305.83	8312.01	8300.53	8306.12	4323.0
2018-07-05 05:00:00	NQ	Futures	8306.12	8330.27	8302.59	8321.14	5683.0
2018-07-05 06:00:00	NQ	Futures	8321.14	8327.62	8318.2	8326.44	3484.0
2018-07-05 07:00:00	NQ	Futures	8326.44	8346.46	8324.08	8345.28	6341.0
2018-07-05 08:00:00	NQ	Futures	8345.28	8355.0	8336.74	8341.46	11142.0
2018-07-05 09:00:00	NQ	Futures	8341.46	8361.18	8333.21	8334.68	50806.0
2018-07-05 10:00:00	NQ	Futures	8334.98	8347.34	8293.46	8302.59	53791.0
2018-07-05 11:00:00	NQ	Futures	8302.3	8353.23	8297.59	8347.93	37501.0
2018-07-05 12:00:00	NQ	Futures	8348.23	8378.85	8347.64	8373.84	27104.0
2018-07-05 13:00:00	NQ	Futures	8373.84	8382.67	8361.77	8368.25	18592.0
2018-07-05 14:00:00	NQ	Futures	8367.95	8382.08	8340.28	8378.26	36243.0
2018-07-05 15:00:00	NQ	Futures	8378.26	8393.27	8371.49	8386.8	44263.0
2018-07-05 16:00:00	NQ	Futures	8386.8	8394.45	8385.03	8391.8	5706.0
2018-07-05 18:00:00	NQ	Futures	8383.56	8385.62	8374.72	8375.31	1959.0
2018-07-05 19:00:00	NQ	Futures	8375.02	8375.31	8364.13	8365.3	2419.0
2018-07-05 20:00:00	NQ	Futures	8365.01	8386.8	8362.95	8380.61	4512.0
2018-07-05 21:00:00	NQ	Futures	8381.2	8384.44	8368.25	8379.73	3959.0
2018-07-05 22:00:00	NQ	Futures	8379.44	8382.67	8370.6	8377.08	3210.0
2018-07-05 23:00:00	NQ	Futures	8377.37	8389.74	8370.6	8388.86	2240.0
2018-07-05 00:00:00	YM	Futures	26244.6	26263.1	26234.8	26250.1	1721.0
2018-07-05 01:00:00	YM	Futures	26251.2	26285.9	26222.9	26277.2	2703.0
2018-07-05 02:00:00	YM	Futures	26277.2	26289.2	26244.6	26278.3	2711.0
2018-07-05 03:00:00	YM	Futures	26277.2	26370.7	26276.2	26345.7	5389.0

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

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