PREVIEW / futures_1hour / 2018-11-26

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-11-26.parquet
  size:    54 KB
  rows:    1,679

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-26 00:00:00	ES	Futures	2876.65	2878.56	2875.57	2877.2	4870.0
2018-11-26 01:00:00	ES	Futures	2877.2	2878.01	2875.57	2876.65	2637.0
2018-11-26 02:00:00	ES	Futures	2876.65	2885.09	2876.65	2884.27	15780.0
2018-11-26 03:00:00	ES	Futures	2884.27	2899.23	2884.27	2897.32	31553.0
2018-11-26 04:00:00	ES	Futures	2897.05	2900.59	2896.24	2898.41	14748.0
2018-11-26 05:00:00	ES	Futures	2898.14	2898.14	2893.52	2895.15	11755.0
2018-11-26 06:00:00	ES	Futures	2895.15	2897.05	2891.89	2894.61	12273.0
2018-11-26 07:00:00	ES	Futures	2894.61	2897.6	2891.89	2892.7	18516.0
2018-11-26 08:00:00	ES	Futures	2892.7	2894.33	2888.89	2892.97	24388.0
2018-11-26 09:00:00	ES	Futures	2892.7	2906.03	2889.44	2905.76	199059.0
2018-11-26 10:00:00	ES	Futures	2905.76	2906.84	2896.51	2904.4	208339.0
2018-11-26 11:00:00	ES	Futures	2904.4	2905.21	2892.16	2897.32	134650.0
2018-11-26 12:00:00	ES	Futures	2897.6	2901.95	2885.9	2891.34	105176.0
2018-11-26 13:00:00	ES	Futures	2891.34	2900.86	2888.08	2899.77	83499.0
2018-11-26 14:00:00	ES	Futures	2900.04	2909.29	2898.41	2908.2	116548.0
2018-11-26 15:00:00	ES	Futures	2908.2	2909.84	2903.04	2909.02	188261.0
2018-11-26 16:00:00	ES	Futures	2908.75	2911.74	2894.61	2895.15	102041.0
2018-11-26 18:00:00	ES	Futures	2895.15	2898.41	2892.43	2895.97	11477.0
2018-11-26 19:00:00	ES	Futures	2895.97	2896.24	2890.25	2890.53	12379.0
2018-11-26 20:00:00	ES	Futures	2890.53	2893.79	2888.89	2891.34	10553.0
2018-11-26 21:00:00	ES	Futures	2891.61	2896.78	2891.07	2894.88	6065.0
2018-11-26 22:00:00	ES	Futures	2895.15	2902.49	2894.61	2900.32	8547.0
2018-11-26 23:00:00	ES	Futures	2900.59	2903.58	2900.04	2903.58	4655.0
2018-11-26 00:00:00	NQ	Futures	7713.58	7724.13	7708.59	7713.28	2706.0
2018-11-26 01:00:00	NQ	Futures	7713.58	7716.51	7708.88	7714.16	1557.0
2018-11-26 02:00:00	NQ	Futures	7714.75	7743.2	7714.75	7740.85	7099.0
2018-11-26 03:00:00	NQ	Futures	7740.85	7798.05	7740.56	7788.37	17742.0
2018-11-26 04:00:00	NQ	Futures	7788.08	7808.02	7786.61	7799.81	8880.0
2018-11-26 05:00:00	NQ	Futures	7799.81	7799.81	7786.32	7791.3	5846.0
2018-11-26 06:00:00	NQ	Futures	7791.6	7797.17	7780.16	7789.54	6696.0
2018-11-26 07:00:00	NQ	Futures	7788.96	7794.82	7777.52	7781.04	7344.0
2018-11-26 08:00:00	NQ	Futures	7781.33	7789.84	7767.84	7777.52	12813.0
2018-11-26 09:00:00	NQ	Futures	7777.22	7813.89	7742.03	7813.3	69407.0
2018-11-26 10:00:00	NQ	Futures	7813.01	7820.93	7774.0	7806.26	79624.0
2018-11-26 11:00:00	NQ	Futures	7806.56	7813.3	7764.91	7782.8	60128.0
2018-11-26 12:00:00	NQ	Futures	7782.8	7800.4	7739.09	7766.96	48935.0
2018-11-26 13:00:00	NQ	Futures	7767.25	7803.33	7759.63	7800.1	43977.0
2018-11-26 14:00:00	NQ	Futures	7799.81	7831.49	7796.58	7831.19	39118.0
2018-11-26 15:00:00	NQ	Futures	7831.19	7845.86	7816.82	7843.51	42251.0
2018-11-26 16:00:00	NQ	Futures	7843.22	7856.71	7788.96	7790.13	19981.0
2018-11-26 18:00:00	NQ	Futures	7789.84	7802.45	7783.97	7793.36	4370.0
2018-11-26 19:00:00	NQ	Futures	7793.36	7795.7	7775.76	7776.34	5812.0
2018-11-26 20:00:00	NQ	Futures	7776.05	7784.56	7771.36	7775.17	6039.0
2018-11-26 21:00:00	NQ	Futures	7775.76	7793.94	7774.29	7785.73	3400.0
2018-11-26 22:00:00	NQ	Futures	7786.32	7813.01	7784.26	7805.09	4493.0
2018-11-26 23:00:00	NQ	Futures	7805.97	7823.86	7805.09	7821.81	3741.0
2018-11-26 00:00:00	YM	Futures	26494.6	26507.6	26474.0	26489.2	1388.0
2018-11-26 01:00:00	YM	Futures	26490.3	26499.0	26474.0	26481.6	800.0
2018-11-26 02:00:00	YM	Futures	26482.7	26575.0	26482.7	26562.0	5422.0
2018-11-26 03:00:00	YM	Futures	26562.0	26688.0	26562.0	26666.3	9042.0

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

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