PREVIEW / futures_1hour / 2018-06-25

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-06-25.parquet
  size:    54 KB
  rows:    1,678

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-06-25 00:00:00	ES	Futures	2995.22	2996.04	2994.68	2995.77	2068.0
2018-06-25 01:00:00	ES	Futures	2995.77	2996.31	2988.41	2990.05	7945.0
2018-06-25 02:00:00	ES	Futures	2990.05	2995.22	2988.41	2988.96	11336.0
2018-06-25 03:00:00	ES	Futures	2988.68	2993.59	2987.59	2991.95	23997.0
2018-06-25 04:00:00	ES	Futures	2991.95	2993.86	2987.87	2988.14	15044.0
2018-06-25 05:00:00	ES	Futures	2988.14	2991.14	2987.05	2990.05	14134.0
2018-06-25 06:00:00	ES	Futures	2989.77	2991.95	2985.41	2988.68	23942.0
2018-06-25 07:00:00	ES	Futures	2988.68	2993.04	2988.14	2992.77	20315.0
2018-06-25 08:00:00	ES	Futures	2992.77	2994.68	2991.41	2992.5	25879.0
2018-06-25 09:00:00	ES	Futures	2992.5	2993.31	2975.06	2975.6	217085.0
2018-06-25 10:00:00	ES	Futures	2975.33	2977.51	2964.71	2970.16	366313.0
2018-06-25 11:00:00	ES	Futures	2970.43	2972.06	2955.17	2960.07	261430.0
2018-06-25 12:00:00	ES	Futures	2959.8	2962.53	2946.72	2961.98	239711.0
2018-06-25 13:00:00	ES	Futures	2961.71	2966.34	2952.72	2961.16	178340.0
2018-06-25 14:00:00	ES	Futures	2960.89	2962.8	2943.18	2948.09	168683.0
2018-06-25 15:00:00	ES	Futures	2948.36	2969.88	2945.09	2964.43	405503.0
2018-06-25 16:00:00	ES	Futures	2964.16	2968.25	2957.62	2967.16	107818.0
2018-06-25 18:00:00	ES	Futures	2966.34	2968.79	2965.52	2967.43	5818.0
2018-06-25 19:00:00	ES	Futures	2967.7	2968.79	2964.16	2964.98	3713.0
2018-06-25 20:00:00	ES	Futures	2965.25	2971.79	2961.98	2969.88	16803.0
2018-06-25 21:00:00	ES	Futures	2969.61	2972.06	2966.07	2966.89	11382.0
2018-06-25 22:00:00	ES	Futures	2966.61	2967.16	2960.89	2963.62	15806.0
2018-06-25 23:00:00	ES	Futures	2964.16	2970.7	2963.89	2969.88	7498.0
2018-06-25 00:00:00	NQ	Futures	8468.64	8474.53	8468.35	8473.06	843.0
2018-06-25 01:00:00	NQ	Futures	8473.06	8475.12	8448.33	8453.33	3017.0
2018-06-25 02:00:00	NQ	Futures	8453.33	8471.0	8452.16	8454.51	3526.0
2018-06-25 03:00:00	NQ	Futures	8454.51	8464.82	8446.86	8452.75	5626.0
2018-06-25 04:00:00	NQ	Futures	8452.45	8458.34	8434.49	8434.79	6327.0
2018-06-25 05:00:00	NQ	Futures	8434.79	8437.73	8423.6	8431.25	6183.0
2018-06-25 06:00:00	NQ	Futures	8431.25	8435.96	8411.53	8423.6	7361.0
2018-06-25 07:00:00	NQ	Futures	8423.6	8437.14	8422.42	8433.02	7217.0
2018-06-25 08:00:00	NQ	Futures	8433.02	8447.45	8429.78	8435.67	9487.0
2018-06-25 09:00:00	NQ	Futures	8435.67	8443.32	8375.02	8382.97	72927.0
2018-06-25 10:00:00	NQ	Futures	8382.67	8395.92	8334.39	8341.16	104857.0
2018-06-25 11:00:00	NQ	Futures	8341.46	8349.7	8297.59	8307.3	69480.0
2018-06-25 12:00:00	NQ	Futures	8307.01	8311.13	8253.42	8287.87	74594.0
2018-06-25 13:00:00	NQ	Futures	8287.58	8302.3	8255.48	8283.45	52912.0
2018-06-25 14:00:00	NQ	Futures	8283.16	8289.64	8238.41	8255.78	42757.0
2018-06-25 15:00:00	NQ	Futures	8255.78	8330.27	8249.89	8314.96	85071.0
2018-06-25 16:00:00	NQ	Futures	8314.96	8333.8	8300.53	8325.56	16385.0
2018-06-25 18:00:00	NQ	Futures	8319.37	8330.86	8319.37	8324.67	1722.0
2018-06-25 19:00:00	NQ	Futures	8324.97	8331.44	8310.54	8317.31	2189.0
2018-06-25 20:00:00	NQ	Futures	8317.61	8337.92	8307.6	8327.91	4645.0
2018-06-25 21:00:00	NQ	Futures	8328.5	8335.27	8311.42	8314.07	3565.0
2018-06-25 22:00:00	NQ	Futures	8314.37	8315.55	8291.4	8304.65	5206.0
2018-06-25 23:00:00	NQ	Futures	8304.65	8329.97	8304.65	8326.15	3081.0
2018-06-25 00:00:00	YM	Futures	26629.5	26634.9	26619.7	26627.3	744.0
2018-06-25 01:00:00	YM	Futures	26626.2	26633.8	26545.8	26556.6	3253.0
2018-06-25 02:00:00	YM	Futures	26557.7	26614.3	26544.7	26552.3	3687.0
2018-06-25 03:00:00	YM	Futures	26552.3	26590.3	26540.3	26580.6	4421.0

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

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