PREVIEW / futures_1hour / 2018-06-29

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-06-29.parquet
  size:    47 KB
  rows:    1,387

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-29 00:00:00	ES	Futures	2974.79	2976.42	2973.7	2974.79	5378.0
2018-06-29 01:00:00	ES	Futures	2974.79	2975.6	2970.43	2974.24	8625.0
2018-06-29 02:00:00	ES	Futures	2974.51	2977.78	2971.52	2976.42	19258.0
2018-06-29 03:00:00	ES	Futures	2976.69	2981.87	2973.97	2981.05	26494.0
2018-06-29 04:00:00	ES	Futures	2980.78	2983.23	2978.6	2981.33	18310.0
2018-06-29 05:00:00	ES	Futures	2981.05	2981.33	2974.79	2975.33	18628.0
2018-06-29 06:00:00	ES	Futures	2975.6	2977.51	2967.7	2971.24	43055.0
2018-06-29 07:00:00	ES	Futures	2971.52	2977.51	2969.61	2976.69	21398.0
2018-06-29 08:00:00	ES	Futures	2976.69	2979.96	2971.52	2971.52	36205.0
2018-06-29 09:00:00	ES	Futures	2971.52	2984.87	2971.52	2982.42	150305.0
2018-06-29 10:00:00	ES	Futures	2982.14	2990.86	2979.96	2989.23	182424.0
2018-06-29 11:00:00	ES	Futures	2989.5	2992.22	2982.42	2984.05	128424.0
2018-06-29 12:00:00	ES	Futures	2984.05	2989.5	2980.51	2983.23	85942.0
2018-06-29 13:00:00	ES	Futures	2983.23	2987.59	2982.96	2984.32	64750.0
2018-06-29 14:00:00	ES	Futures	2984.32	2985.41	2979.42	2984.6	83544.0
2018-06-29 15:00:00	ES	Futures	2984.87	2986.78	2964.98	2965.52	466533.0
2018-06-29 16:00:00	ES	Futures	2965.25	2971.24	2964.98	2965.25	143104.0
2018-06-29 00:00:00	NQ	Futures	8352.05	8363.24	8349.7	8352.35	2487.0
2018-06-29 01:00:00	NQ	Futures	8352.05	8354.12	8334.98	8350.58	3412.0
2018-06-29 02:00:00	NQ	Futures	8350.88	8357.06	8339.39	8352.94	4665.0
2018-06-29 03:00:00	NQ	Futures	8352.64	8372.66	8344.4	8368.54	7460.0
2018-06-29 04:00:00	NQ	Futures	8368.84	8377.67	8363.83	8373.55	4716.0
2018-06-29 05:00:00	NQ	Futures	8373.25	8374.72	8355.88	8357.06	4734.0
2018-06-29 06:00:00	NQ	Futures	8357.06	8362.65	8324.38	8339.98	11547.0
2018-06-29 07:00:00	NQ	Futures	8340.57	8357.35	8334.09	8355.29	6758.0
2018-06-29 08:00:00	NQ	Futures	8355.59	8360.59	8340.57	8340.57	18720.0
2018-06-29 09:00:00	NQ	Futures	8340.87	8377.67	8339.39	8368.25	45958.0
2018-06-29 10:00:00	NQ	Futures	8368.25	8389.45	8348.52	8377.96	57033.0
2018-06-29 11:00:00	NQ	Futures	8377.96	8383.85	8344.1	8352.94	38685.0
2018-06-29 12:00:00	NQ	Futures	8352.94	8369.42	8335.86	8345.87	31776.0
2018-06-29 13:00:00	NQ	Futures	8345.58	8365.3	8342.63	8361.77	37679.0
2018-06-29 14:00:00	NQ	Futures	8362.06	8367.07	8349.99	8364.71	27254.0
2018-06-29 15:00:00	NQ	Futures	8364.42	8369.42	8315.84	8317.61	57718.0
2018-06-29 16:00:00	NQ	Futures	8317.02	8335.57	8316.72	8323.5	13751.0
2018-06-29 00:00:00	YM	Futures	26459.9	26484.9	26454.4	26466.4	1449.0
2018-06-29 01:00:00	YM	Futures	26467.5	26476.2	26421.8	26459.9	2410.0
2018-06-29 02:00:00	YM	Futures	26458.8	26489.2	26431.6	26476.2	3844.0
2018-06-29 03:00:00	YM	Futures	26476.2	26527.3	26458.8	26515.3	5059.0
2018-06-29 04:00:00	YM	Futures	26516.4	26534.9	26489.2	26520.8	3765.0
2018-06-29 05:00:00	YM	Futures	26519.7	26521.9	26469.7	26472.9	3286.0
2018-06-29 06:00:00	YM	Futures	26472.9	26493.6	26390.3	26417.5	8308.0
2018-06-29 07:00:00	YM	Futures	26418.6	26462.1	26401.2	26456.6	4658.0
2018-06-29 08:00:00	YM	Futures	26456.6	26486.0	26425.1	26426.2	8322.0
2018-06-29 09:00:00	YM	Futures	26426.2	26571.9	26425.1	26550.1	24320.0
2018-06-29 10:00:00	YM	Futures	26549.0	26617.5	26541.4	26601.2	28528.0
2018-06-29 11:00:00	YM	Futures	26601.2	26630.6	26541.4	26550.1	20026.0
2018-06-29 12:00:00	YM	Futures	26550.1	26601.2	26533.8	26554.5	15480.0
2018-06-29 13:00:00	YM	Futures	26553.4	26595.8	26552.3	26576.2	11866.0
2018-06-29 14:00:00	YM	Futures	26576.2	26583.8	26514.2	26553.4	11154.0
2018-06-29 15:00:00	YM	Futures	26552.3	26570.8	26369.7	26374.0	34061.0

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

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