PREVIEW / futures_1hour / 2018-11-19

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-11-19.parquet
  size:    56 KB
  rows:    1,717

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-11-19 00:00:00	ES	Futures	2973.48	2974.84	2972.94	2974.84	2190.0
2018-11-19 01:00:00	ES	Futures	2974.57	2977.02	2973.76	2976.2	2811.0
2018-11-19 02:00:00	ES	Futures	2975.93	2980.01	2973.48	2979.47	8658.0
2018-11-19 03:00:00	ES	Futures	2979.47	2989.8	2979.2	2986.27	30061.0
2018-11-19 04:00:00	ES	Futures	2986.0	2986.54	2979.47	2981.64	18304.0
2018-11-19 05:00:00	ES	Futures	2981.64	2983.28	2976.48	2978.92	15352.0
2018-11-19 06:00:00	ES	Futures	2979.2	2981.64	2972.4	2973.21	13137.0
2018-11-19 07:00:00	ES	Futures	2973.48	2974.84	2970.49	2973.76	14443.0
2018-11-19 08:00:00	ES	Futures	2974.03	2978.65	2970.76	2972.12	23512.0
2018-11-19 09:00:00	ES	Futures	2972.4	2975.39	2961.79	2966.14	204592.0
2018-11-19 10:00:00	ES	Futures	2966.14	2966.68	2944.65	2955.8	282819.0
2018-11-19 11:00:00	ES	Futures	2956.08	2958.25	2928.33	2933.23	257788.0
2018-11-19 12:00:00	ES	Futures	2933.23	2935.95	2922.89	2933.5	222609.0
2018-11-19 13:00:00	ES	Futures	2933.5	2935.95	2919.9	2924.52	176574.0
2018-11-19 14:00:00	ES	Futures	2924.52	2935.13	2917.45	2932.68	229732.0
2018-11-19 15:00:00	ES	Futures	2932.68	2941.39	2920.17	2929.42	300233.0
2018-11-19 16:00:00	ES	Futures	2929.69	2935.13	2928.88	2934.59	90826.0
2018-11-19 18:00:00	ES	Futures	2933.5	2934.04	2926.7	2928.88	11222.0
2018-11-19 19:00:00	ES	Futures	2928.6	2931.32	2924.8	2927.24	12261.0
2018-11-19 20:00:00	ES	Futures	2927.24	2931.32	2923.16	2927.79	12421.0
2018-11-19 21:00:00	ES	Futures	2927.79	2928.88	2923.44	2926.43	8616.0
2018-11-19 22:00:00	ES	Futures	2926.43	2926.7	2920.17	2924.25	7194.0
2018-11-19 23:00:00	ES	Futures	2924.25	2925.61	2921.8	2923.71	5002.0
2018-11-19 00:00:00	NQ	Futures	8062.62	8067.61	8061.15	8065.85	1177.0
2018-11-19 01:00:00	NQ	Futures	8065.55	8072.3	8062.03	8068.19	1462.0
2018-11-19 02:00:00	NQ	Futures	8067.61	8089.02	8060.86	8086.08	4619.0
2018-11-19 03:00:00	NQ	Futures	8085.79	8135.95	8085.5	8122.16	13478.0
2018-11-19 04:00:00	NQ	Futures	8121.87	8123.92	8089.31	8096.64	10505.0
2018-11-19 05:00:00	NQ	Futures	8096.64	8103.98	8078.16	8085.5	7817.0
2018-11-19 06:00:00	NQ	Futures	8085.79	8093.42	8052.35	8057.34	7676.0
2018-11-19 07:00:00	NQ	Futures	8057.63	8067.9	8045.9	8059.1	7440.0
2018-11-19 08:00:00	NQ	Futures	8058.81	8069.37	8029.47	8035.63	19083.0
2018-11-19 09:00:00	NQ	Futures	8035.63	8042.38	7952.33	7971.69	81622.0
2018-11-19 10:00:00	NQ	Futures	7971.4	7973.16	7888.68	7937.37	116218.0
2018-11-19 11:00:00	NQ	Futures	7937.37	7946.76	7836.18	7855.25	95683.0
2018-11-19 12:00:00	NQ	Futures	7855.25	7863.75	7825.03	7840.29	74896.0
2018-11-19 13:00:00	NQ	Futures	7840.29	7860.82	7799.81	7815.36	77256.0
2018-11-19 14:00:00	NQ	Futures	7815.65	7847.91	7791.3	7837.94	91760.0
2018-11-19 15:00:00	NQ	Futures	7837.35	7867.86	7781.33	7805.38	92461.0
2018-11-19 16:00:00	NQ	Futures	7805.68	7831.49	7804.21	7830.9	17978.0
2018-11-19 18:00:00	NQ	Futures	7823.86	7825.62	7796.0	7807.14	5320.0
2018-11-19 19:00:00	NQ	Futures	7806.26	7816.24	7798.34	7803.33	5352.0
2018-11-19 20:00:00	NQ	Futures	7803.04	7818.0	7784.56	7808.32	10617.0
2018-11-19 21:00:00	NQ	Futures	7808.32	7812.13	7795.41	7803.92	3989.0
2018-11-19 22:00:00	NQ	Futures	7803.62	7803.92	7781.33	7794.53	3949.0
2018-11-19 23:00:00	NQ	Futures	7794.53	7798.93	7787.2	7793.36	1974.0
2018-11-19 00:00:00	YM	Futures	27561.6	27576.8	27557.2	27572.4	772.0
2018-11-19 01:00:00	YM	Futures	27572.4	27595.2	27567.0	27589.8	888.0
2018-11-19 02:00:00	YM	Futures	27589.8	27622.4	27565.9	27613.7	2936.0
2018-11-19 03:00:00	YM	Futures	27613.7	27697.4	27613.7	27665.9	6875.0

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

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