PREVIEW / futures_1hour / 2018-04-26

all futures 1-hour files

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

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-04-26 00:00:00	ES	Futures	2890.91	2892.55	2889.82	2890.91	1947.0
2018-04-26 01:00:00	ES	Futures	2890.91	2891.19	2885.18	2886.0	10306.0
2018-04-26 02:00:00	ES	Futures	2886.0	2887.37	2883.0	2883.82	12631.0
2018-04-26 03:00:00	ES	Futures	2883.82	2888.46	2881.36	2884.09	18352.0
2018-04-26 04:00:00	ES	Futures	2884.09	2887.37	2883.82	2886.28	11464.0
2018-04-26 05:00:00	ES	Futures	2886.0	2892.28	2884.64	2891.46	11312.0
2018-04-26 06:00:00	ES	Futures	2891.46	2895.01	2889.55	2894.19	12718.0
2018-04-26 07:00:00	ES	Futures	2893.92	2897.46	2891.73	2895.83	22462.0
2018-04-26 08:00:00	ES	Futures	2895.83	2897.19	2893.37	2896.92	19823.0
2018-04-26 09:00:00	ES	Futures	2896.92	2897.19	2887.91	2895.55	165883.0
2018-04-26 10:00:00	ES	Futures	2895.28	2907.29	2893.37	2906.47	207787.0
2018-04-26 11:00:00	ES	Futures	2906.47	2907.02	2895.01	2899.38	143063.0
2018-04-26 12:00:00	ES	Futures	2899.65	2906.47	2899.1	2904.29	81839.0
2018-04-26 13:00:00	ES	Futures	2904.56	2914.11	2904.29	2913.84	116266.0
2018-04-26 14:00:00	ES	Futures	2913.84	2919.84	2911.66	2918.21	117562.0
2018-04-26 15:00:00	ES	Futures	2918.21	2920.66	2907.84	2910.56	167405.0
2018-04-26 16:00:00	ES	Futures	2910.56	2922.85	2908.65	2917.93	84959.0
2018-04-26 18:00:00	ES	Futures	2920.66	2920.93	2916.84	2918.21	6641.0
2018-04-26 19:00:00	ES	Futures	2918.48	2919.57	2916.3	2916.84	2695.0
2018-04-26 20:00:00	ES	Futures	2916.84	2917.11	2913.57	2914.93	6228.0
2018-04-26 21:00:00	ES	Futures	2915.2	2915.48	2910.02	2910.84	7793.0
2018-04-26 22:00:00	ES	Futures	2910.84	2913.29	2910.02	2912.47	3397.0
2018-04-26 23:00:00	ES	Futures	2912.47	2914.11	2911.38	2913.57	3018.0
2018-04-26 00:00:00	NQ	Futures	7792.89	7797.02	7790.52	7794.36	882.0
2018-04-26 01:00:00	NQ	Futures	7794.36	7796.14	7771.31	7772.2	3336.0
2018-04-26 02:00:00	NQ	Futures	7771.9	7776.04	7760.97	7764.52	3073.0
2018-04-26 03:00:00	NQ	Futures	7764.52	7785.5	7753.88	7767.18	6721.0
2018-04-26 04:00:00	NQ	Futures	7767.18	7776.93	7763.92	7771.02	3916.0
2018-04-26 05:00:00	NQ	Futures	7770.72	7794.66	7767.47	7791.11	4166.0
2018-04-26 06:00:00	NQ	Futures	7790.52	7799.39	7778.7	7795.25	4028.0
2018-04-26 07:00:00	NQ	Futures	7795.25	7805.89	7783.43	7800.28	7221.0
2018-04-26 08:00:00	NQ	Futures	7800.28	7820.08	7794.07	7818.89	10553.0
2018-04-26 09:00:00	NQ	Futures	7818.89	7822.74	7780.47	7812.69	69989.0
2018-04-26 10:00:00	NQ	Futures	7812.69	7855.24	7804.71	7852.88	74022.0
2018-04-26 11:00:00	NQ	Futures	7852.88	7858.79	7822.14	7831.31	48558.0
2018-04-26 12:00:00	NQ	Futures	7831.6	7857.61	7830.42	7845.49	29684.0
2018-04-26 13:00:00	NQ	Futures	7845.49	7878.0	7845.49	7876.52	36172.0
2018-04-26 14:00:00	NQ	Futures	7876.52	7890.71	7868.54	7888.64	27172.0
2018-04-26 15:00:00	NQ	Futures	7888.34	7894.55	7858.79	7867.36	45796.0
2018-04-26 16:00:00	NQ	Futures	7867.07	7978.19	7859.97	7970.21	31552.0
2018-04-26 18:00:00	NQ	Futures	7973.16	7982.91	7964.3	7977.0	4538.0
2018-04-26 19:00:00	NQ	Futures	7977.3	7984.69	7976.71	7978.78	2336.0
2018-04-26 20:00:00	NQ	Futures	7978.78	7980.85	7973.16	7978.78	1936.0
2018-04-26 21:00:00	NQ	Futures	7978.78	7979.66	7956.91	7961.64	2712.0
2018-04-26 22:00:00	NQ	Futures	7961.93	7974.05	7960.16	7969.32	1627.0
2018-04-26 23:00:00	NQ	Futures	7969.02	7970.8	7962.82	7966.36	1312.0
2018-04-26 00:00:00	YM	Futures	26160.1	26173.2	26152.5	26164.5	914.0
2018-04-26 01:00:00	YM	Futures	26165.6	26171.0	26106.9	26124.3	3375.0
2018-04-26 02:00:00	YM	Futures	26123.2	26134.1	26097.1	26111.3	3342.0
2018-04-26 03:00:00	YM	Futures	26111.3	26152.5	26078.7	26109.1	3788.0

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

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