PREVIEW / futures_1hour / 2018-12-20

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-12-20.parquet
  size:    58 KB
  rows:    1,768

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-20 00:00:00	ES	Futures	2695.21	2704.44	2693.03	2702.81	19948.0
2018-12-20 01:00:00	ES	Futures	2702.81	2704.44	2697.65	2704.44	10963.0
2018-12-20 02:00:00	ES	Futures	2704.44	2712.59	2701.45	2706.61	23687.0
2018-12-20 03:00:00	ES	Futures	2706.88	2709.33	2700.37	2707.7	42266.0
2018-12-20 04:00:00	ES	Futures	2707.43	2717.48	2704.44	2716.66	28075.0
2018-12-20 05:00:00	ES	Futures	2716.39	2722.36	2712.59	2718.02	30302.0
2018-12-20 06:00:00	ES	Futures	2718.29	2729.7	2717.75	2728.61	33595.0
2018-12-20 07:00:00	ES	Futures	2728.34	2735.4	2723.99	2728.88	39103.0
2018-12-20 08:00:00	ES	Futures	2728.88	2728.88	2713.13	2713.67	51287.0
2018-12-20 09:00:00	ES	Futures	2713.67	2719.92	2698.74	2715.3	371141.0
2018-12-20 10:00:00	ES	Futures	2715.57	2728.88	2709.87	2717.48	383604.0
2018-12-20 11:00:00	ES	Futures	2717.48	2719.1	2675.92	2685.7	427925.0
2018-12-20 12:00:00	ES	Futures	2685.7	2702.54	2677.01	2692.22	327884.0
2018-12-20 13:00:00	ES	Futures	2692.49	2693.03	2673.48	2675.92	249022.0
2018-12-20 14:00:00	ES	Futures	2675.92	2705.25	2652.29	2688.42	511707.0
2018-12-20 15:00:00	ES	Futures	2688.14	2700.91	2668.32	2678.91	519757.0
2018-12-20 16:00:00	ES	Futures	2678.91	2702.81	2675.92	2702.54	162967.0
2018-12-20 18:00:00	ES	Futures	2699.55	2706.88	2696.83	2696.83	14653.0
2018-12-20 19:00:00	ES	Futures	2696.56	2698.19	2690.86	2695.48	15547.0
2018-12-20 20:00:00	ES	Futures	2695.48	2701.72	2690.86	2691.95	11564.0
2018-12-20 21:00:00	ES	Futures	2691.67	2696.83	2690.05	2695.48	8521.0
2018-12-20 22:00:00	ES	Futures	2695.21	2700.64	2691.13	2696.83	7947.0
2018-12-20 23:00:00	ES	Futures	2696.56	2700.09	2691.4	2691.95	6907.0
2018-12-20 00:00:00	NQ	Futures	7358.2	7386.55	7351.19	7381.29	7854.0
2018-12-20 01:00:00	NQ	Futures	7380.99	7385.38	7366.09	7384.5	4448.0
2018-12-20 02:00:00	NQ	Futures	7384.5	7403.2	7365.8	7384.79	9320.0
2018-12-20 03:00:00	NQ	Futures	7385.09	7394.44	7366.09	7391.22	14043.0
2018-12-20 04:00:00	NQ	Futures	7390.93	7422.49	7377.78	7418.69	9150.0
2018-12-20 05:00:00	NQ	Futures	7418.4	7434.76	7407.0	7425.7	9562.0
2018-12-20 06:00:00	NQ	Futures	7425.12	7457.26	7424.24	7455.21	9711.0
2018-12-20 07:00:00	NQ	Futures	7455.21	7469.53	7441.48	7459.3	11316.0
2018-12-20 08:00:00	NQ	Futures	7459.89	7460.47	7395.6	7399.11	19392.0
2018-12-20 09:00:00	NQ	Futures	7399.11	7458.13	7385.38	7450.54	109971.0
2018-12-20 10:00:00	NQ	Futures	7449.66	7485.31	7401.16	7418.98	111764.0
2018-12-20 11:00:00	NQ	Futures	7418.69	7421.61	7264.12	7314.67	138663.0
2018-12-20 12:00:00	NQ	Futures	7314.67	7364.05	7278.73	7342.13	107285.0
2018-12-20 13:00:00	NQ	Futures	7342.13	7345.64	7282.23	7290.42	75976.0
2018-12-20 14:00:00	NQ	Futures	7290.12	7383.92	7222.92	7342.13	138604.0
2018-12-20 15:00:00	NQ	Futures	7341.55	7378.95	7287.2	7319.34	121204.0
2018-12-20 16:00:00	NQ	Futures	7319.93	7397.07	7309.41	7389.76	29706.0
2018-12-20 18:00:00	NQ	Futures	7392.39	7402.32	7371.94	7373.4	3662.0
2018-12-20 19:00:00	NQ	Futures	7373.11	7381.29	7357.62	7368.72	3737.0
2018-12-20 20:00:00	NQ	Futures	7369.02	7387.72	7352.65	7356.74	4290.0
2018-12-20 21:00:00	NQ	Futures	7355.87	7377.2	7349.15	7369.31	3626.0
2018-12-20 22:00:00	NQ	Futures	7369.31	7388.01	7357.33	7373.11	4592.0
2018-12-20 23:00:00	NQ	Futures	7372.52	7384.79	7353.82	7357.91	4102.0
2018-12-20 00:00:00	YM	Futures	25060.3	25155.8	25034.2	25141.7	4636.0
2018-12-20 01:00:00	YM	Futures	25140.6	25158.0	25087.4	25152.6	2586.0
2018-12-20 02:00:00	YM	Futures	25151.5	25241.6	25136.3	25185.1	4774.0
2018-12-20 03:00:00	YM	Futures	25183.0	25223.1	25124.3	25200.3	9087.0

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

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