PREVIEW / futures_1hour / 2018-10-17

all futures 1-hour files

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

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-17 00:00:00	ES	Futures	3065.15	3065.15	3063.79	3064.33	3151.0
2018-10-17 01:00:00	ES	Futures	3064.6	3065.15	3061.61	3064.33	8171.0
2018-10-17 02:00:00	ES	Futures	3064.33	3072.22	3064.06	3070.59	22593.0
2018-10-17 03:00:00	ES	Futures	3070.59	3072.76	3065.42	3065.96	26899.0
2018-10-17 04:00:00	ES	Futures	3065.96	3065.96	3060.52	3061.61	23805.0
2018-10-17 05:00:00	ES	Futures	3061.88	3061.88	3055.63	3057.8	23878.0
2018-10-17 06:00:00	ES	Futures	3057.8	3058.35	3054.0	3058.08	26299.0
2018-10-17 07:00:00	ES	Futures	3058.08	3060.25	3052.64	3053.72	28860.0
2018-10-17 08:00:00	ES	Futures	3053.45	3055.9	3050.73	3055.08	36572.0
2018-10-17 09:00:00	ES	Futures	3055.08	3060.52	3045.29	3045.56	235672.0
2018-10-17 10:00:00	ES	Futures	3045.29	3049.37	3028.16	3034.96	349658.0
2018-10-17 11:00:00	ES	Futures	3034.96	3057.8	3030.33	3057.53	229546.0
2018-10-17 12:00:00	ES	Futures	3057.53	3065.69	3054.54	3062.16	171905.0
2018-10-17 13:00:00	ES	Futures	3062.16	3067.32	3060.25	3063.24	121663.0
2018-10-17 14:00:00	ES	Futures	3063.52	3065.42	3045.84	3062.16	200224.0
2018-10-17 15:00:00	ES	Futures	3062.16	3063.24	3048.56	3059.71	272342.0
2018-10-17 16:00:00	ES	Futures	3059.44	3065.69	3058.89	3064.06	67075.0
2018-10-17 18:00:00	ES	Futures	3060.8	3062.43	3056.44	3057.8	8934.0
2018-10-17 19:00:00	ES	Futures	3057.8	3058.08	3053.72	3054.54	6531.0
2018-10-17 20:00:00	ES	Futures	3054.27	3056.99	3053.45	3055.63	10038.0
2018-10-17 21:00:00	ES	Futures	3055.9	3057.26	3051.82	3053.18	11201.0
2018-10-17 22:00:00	ES	Futures	3053.18	3053.45	3049.64	3052.64	10034.0
2018-10-17 23:00:00	ES	Futures	3052.91	3054.0	3050.73	3052.64	3964.0
2018-10-17 00:00:00	NQ	Futures	8614.93	8616.1	8609.06	8612.0	2131.0
2018-10-17 01:00:00	NQ	Futures	8612.29	8619.04	8601.73	8612.58	4624.0
2018-10-17 02:00:00	NQ	Futures	8612.0	8645.14	8610.24	8640.15	9301.0
2018-10-17 03:00:00	NQ	Futures	8639.86	8645.14	8620.5	8623.44	10216.0
2018-10-17 04:00:00	NQ	Futures	8623.73	8623.73	8606.72	8609.36	8864.0
2018-10-17 05:00:00	NQ	Futures	8608.48	8609.65	8592.64	8600.26	8305.0
2018-10-17 06:00:00	NQ	Futures	8600.56	8609.36	8587.06	8605.54	8867.0
2018-10-17 07:00:00	NQ	Futures	8605.25	8612.88	8582.96	8585.6	8594.0
2018-10-17 08:00:00	NQ	Futures	8585.31	8593.52	8573.57	8587.06	14780.0
2018-10-17 09:00:00	NQ	Futures	8587.06	8605.84	8521.66	8526.94	98527.0
2018-10-17 10:00:00	NQ	Futures	8526.94	8538.96	8472.67	8497.31	131474.0
2018-10-17 11:00:00	NQ	Futures	8497.9	8557.44	8483.23	8549.81	85021.0
2018-10-17 12:00:00	NQ	Futures	8550.11	8572.4	8528.99	8556.27	59955.0
2018-10-17 13:00:00	NQ	Futures	8556.56	8592.05	8549.23	8558.61	45193.0
2018-10-17 14:00:00	NQ	Futures	8558.61	8575.63	8502.88	8564.48	72800.0
2018-10-17 15:00:00	NQ	Futures	8565.07	8570.35	8532.51	8560.96	62464.0
2018-10-17 16:00:00	NQ	Futures	8561.25	8585.31	8559.2	8582.08	10364.0
2018-10-17 18:00:00	NQ	Futures	8573.87	8575.92	8554.51	8560.37	2939.0
2018-10-17 19:00:00	NQ	Futures	8560.67	8560.96	8539.55	8543.95	3633.0
2018-10-17 20:00:00	NQ	Futures	8543.95	8554.51	8540.43	8549.52	4860.0
2018-10-17 21:00:00	NQ	Futures	8549.52	8555.09	8535.73	8538.96	4888.0
2018-10-17 22:00:00	NQ	Futures	8539.84	8540.43	8526.94	8537.79	5790.0
2018-10-17 23:00:00	NQ	Futures	8538.08	8543.07	8531.92	8537.2	1786.0
2018-10-17 00:00:00	YM	Futures	27989.6	27990.7	27974.4	27982.0	1098.0
2018-10-17 01:00:00	YM	Futures	27983.1	27989.6	27946.2	27983.1	2909.0
2018-10-17 02:00:00	YM	Futures	27983.1	28080.9	27979.9	28063.5	5397.0
2018-10-17 03:00:00	YM	Futures	28061.4	28074.4	27988.6	27997.3	6838.0

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

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