PREVIEW / futures_1hour / 2018-12-06

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-12-06.parquet
  size:    57 KB
  rows:    1,740

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-12-06 00:00:00	ES	Futures	2903.04	2906.57	2900.04	2905.48	9824.0
2018-12-06 01:00:00	ES	Futures	2905.48	2908.2	2897.32	2902.49	8910.0
2018-12-06 02:00:00	ES	Futures	2902.49	2919.63	2901.95	2915.55	32441.0
2018-12-06 03:00:00	ES	Futures	2915.55	2916.91	2904.4	2906.84	46709.0
2018-12-06 04:00:00	ES	Futures	2906.57	2907.39	2886.45	2887.81	49440.0
2018-12-06 05:00:00	ES	Futures	2887.81	2892.7	2884.54	2889.44	45182.0
2018-12-06 06:00:00	ES	Futures	2889.44	2897.6	2885.63	2890.53	40090.0
2018-12-06 07:00:00	ES	Futures	2890.53	2898.68	2890.25	2894.33	41512.0
2018-12-06 08:00:00	ES	Futures	2894.33	2903.04	2894.33	2895.42	60028.0
2018-12-06 09:00:00	ES	Futures	2895.42	2904.12	2876.11	2881.28	419033.0
2018-12-06 10:00:00	ES	Futures	2881.28	2892.7	2869.85	2872.03	460416.0
2018-12-06 11:00:00	ES	Futures	2871.76	2880.46	2851.9	2878.56	430187.0
2018-12-06 12:00:00	ES	Futures	2878.56	2902.76	2873.39	2897.87	309203.0
2018-12-06 13:00:00	ES	Futures	2897.87	2904.67	2876.93	2903.58	228062.0
2018-12-06 14:00:00	ES	Futures	2903.58	2909.02	2881.82	2901.95	290314.0
2018-12-06 15:00:00	ES	Futures	2902.22	2934.59	2897.05	2934.04	447474.0
2018-12-06 16:00:00	ES	Futures	2934.04	2936.76	2926.97	2932.14	107107.0
2018-12-06 18:00:00	ES	Futures	2931.32	2934.59	2928.33	2932.96	8762.0
2018-12-06 19:00:00	ES	Futures	2932.96	2936.22	2925.88	2928.88	14091.0
2018-12-06 20:00:00	ES	Futures	2928.6	2931.87	2919.9	2920.99	13792.0
2018-12-06 21:00:00	ES	Futures	2920.99	2925.34	2919.08	2924.25	8996.0
2018-12-06 22:00:00	ES	Futures	2923.98	2926.16	2922.08	2924.25	5261.0
2018-12-06 23:00:00	ES	Futures	2924.25	2925.61	2922.35	2925.07	3392.0
2018-12-06 00:00:00	NQ	Futures	7854.95	7867.57	7845.57	7859.35	5993.0
2018-12-06 01:00:00	NQ	Futures	7859.35	7867.57	7827.97	7845.86	5346.0
2018-12-06 02:00:00	NQ	Futures	7845.86	7904.23	7845.57	7890.74	14029.0
2018-12-06 03:00:00	NQ	Futures	7890.74	7896.9	7861.41	7862.29	13244.0
2018-12-06 04:00:00	NQ	Futures	7862.29	7862.58	7785.14	7790.42	14832.0
2018-12-06 05:00:00	NQ	Futures	7790.72	7811.54	7778.98	7796.29	14721.0
2018-12-06 06:00:00	NQ	Futures	7796.58	7825.03	7788.66	7810.08	11063.0
2018-12-06 07:00:00	NQ	Futures	7810.08	7840.29	7809.49	7829.43	12537.0
2018-12-06 08:00:00	NQ	Futures	7829.43	7857.89	7828.26	7830.02	19161.0
2018-12-06 09:00:00	NQ	Futures	7830.31	7897.48	7794.82	7826.79	126029.0
2018-12-06 10:00:00	NQ	Futures	7827.09	7888.39	7815.36	7831.19	131652.0
2018-12-06 11:00:00	NQ	Futures	7830.61	7894.26	7782.8	7893.08	124253.0
2018-12-06 12:00:00	NQ	Futures	7892.79	7977.26	7869.03	7958.79	105367.0
2018-12-06 13:00:00	NQ	Futures	7958.2	7971.69	7888.39	7969.05	74709.0
2018-12-06 14:00:00	NQ	Futures	7968.47	7983.13	7893.08	7952.63	93137.0
2018-12-06 15:00:00	NQ	Futures	7952.33	8029.47	7931.21	8029.47	117627.0
2018-12-06 16:00:00	NQ	Futures	8029.18	8041.79	8002.49	8027.71	19342.0
2018-12-06 18:00:00	NQ	Futures	8019.8	8035.63	8013.93	8033.29	3860.0
2018-12-06 19:00:00	NQ	Futures	8032.99	8044.43	8009.24	8018.62	8273.0
2018-12-06 20:00:00	NQ	Futures	8018.62	8030.65	7990.17	7993.4	11157.0
2018-12-06 21:00:00	NQ	Futures	7993.98	8009.82	7988.41	8006.01	4367.0
2018-12-06 22:00:00	NQ	Futures	8006.3	8012.76	7999.56	8006.89	2966.0
2018-12-06 23:00:00	NQ	Futures	8006.6	8012.46	7999.56	8010.12	2276.0
2018-12-06 00:00:00	YM	Futures	26848.8	26878.1	26820.6	26872.7	2683.0
2018-12-06 01:00:00	YM	Futures	26871.6	26897.7	26804.3	26856.4	3626.0
2018-12-06 02:00:00	YM	Futures	26857.5	27003.1	26839.0	26964.0	9590.0
2018-12-06 03:00:00	YM	Futures	26964.0	26972.7	26848.8	26870.5	11816.0

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

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