PREVIEW / futures_1hour / 2018-12-26

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-12-26.parquet
  size:    46 KB
  rows:    1,310

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-26 00:00:00	ES	Futures	2529.54	2542.85	2525.74	2535.79	16158.0
2018-12-26 01:00:00	ES	Futures	2536.33	2545.83	2536.33	2543.12	9935.0
2018-12-26 02:00:00	ES	Futures	2543.12	2546.92	2535.79	2546.11	8932.0
2018-12-26 03:00:00	ES	Futures	2546.11	2555.88	2543.66	2553.98	14361.0
2018-12-26 04:00:00	ES	Futures	2553.98	2563.49	2548.55	2561.04	11617.0
2018-12-26 05:00:00	ES	Futures	2561.04	2565.39	2552.35	2555.88	11463.0
2018-12-26 06:00:00	ES	Futures	2555.61	2562.67	2555.61	2558.87	9798.0
2018-12-26 07:00:00	ES	Futures	2558.6	2573.54	2556.7	2570.55	21853.0
2018-12-26 08:00:00	ES	Futures	2570.28	2571.09	2558.33	2564.03	28714.0
2018-12-26 09:00:00	ES	Futures	2564.03	2593.09	2559.96	2568.38	216144.0
2018-12-26 10:00:00	ES	Futures	2568.38	2572.18	2548.01	2551.81	221412.0
2018-12-26 11:00:00	ES	Futures	2552.08	2598.52	2551.54	2598.25	196573.0
2018-12-26 12:00:00	ES	Futures	2597.98	2623.51	2596.89	2620.25	202273.0
2018-12-26 13:00:00	ES	Futures	2620.52	2630.57	2600.42	2630.3	146611.0
2018-12-26 14:00:00	ES	Futures	2630.57	2632.74	2614.27	2631.38	166243.0
2018-12-26 15:00:00	ES	Futures	2631.65	2681.63	2627.58	2681.35	375080.0
2018-12-26 16:00:00	ES	Futures	2681.08	2691.67	2678.91	2681.08	133242.0
2018-12-26 18:00:00	ES	Futures	2683.53	2685.43	2673.48	2674.84	16052.0
2018-12-26 19:00:00	ES	Futures	2675.11	2676.74	2667.5	2669.95	21553.0
2018-12-26 20:00:00	ES	Futures	2670.22	2677.28	2669.13	2672.66	14324.0
2018-12-26 21:00:00	ES	Futures	2672.94	2677.28	2672.39	2675.92	8920.0
2018-12-26 22:00:00	ES	Futures	2675.92	2677.28	2673.21	2675.92	7021.0
2018-12-26 23:00:00	ES	Futures	2675.92	2680.0	2674.29	2679.45	7329.0
2018-12-26 00:00:00	NQ	Futures	6845.7	6878.72	6822.62	6853.59	10651.0
2018-12-26 01:00:00	NQ	Futures	6854.76	6883.98	6854.76	6876.38	6409.0
2018-12-26 02:00:00	NQ	Futures	6875.8	6890.12	6858.85	6886.9	6136.0
2018-12-26 03:00:00	NQ	Futures	6887.19	6913.78	6879.01	6906.19	7594.0
2018-12-26 04:00:00	NQ	Futures	6907.06	6936.57	6890.7	6927.22	7847.0
2018-12-26 05:00:00	NQ	Futures	6926.35	6931.61	6897.13	6906.77	7751.0
2018-12-26 06:00:00	NQ	Futures	6906.48	6928.1	6905.31	6919.63	7616.0
2018-12-26 07:00:00	NQ	Futures	6919.34	6970.47	6919.04	6965.5	14707.0
2018-12-26 08:00:00	NQ	Futures	6964.62	6970.47	6939.5	6961.12	14947.0
2018-12-26 09:00:00	NQ	Futures	6960.83	7073.03	6948.26	7003.78	69385.0
2018-12-26 10:00:00	NQ	Futures	7003.78	7026.57	6936.57	6944.46	76192.0
2018-12-26 11:00:00	NQ	Futures	6944.76	7094.36	6938.62	7092.6	65150.0
2018-12-26 12:00:00	NQ	Futures	7092.31	7181.14	7085.3	7169.45	71355.0
2018-12-26 13:00:00	NQ	Futures	7169.45	7201.88	7114.81	7198.67	46935.0
2018-12-26 14:00:00	NQ	Futures	7199.84	7208.02	7153.67	7203.93	49259.0
2018-12-26 15:00:00	NQ	Futures	7203.93	7338.04	7188.15	7336.87	79004.0
2018-12-26 16:00:00	NQ	Futures	7336.58	7374.86	7326.06	7336.0	31420.0
2018-12-26 18:00:00	NQ	Futures	7343.3	7350.9	7312.91	7316.13	5975.0
2018-12-26 19:00:00	NQ	Futures	7316.13	7326.65	7298.31	7305.9	9599.0
2018-12-26 20:00:00	NQ	Futures	7306.19	7323.73	7303.27	7311.75	6432.0
2018-12-26 21:00:00	NQ	Futures	7312.33	7324.31	7307.36	7319.93	4580.0
2018-12-26 22:00:00	NQ	Futures	7319.64	7323.73	7306.78	7311.16	3045.0
2018-12-26 23:00:00	NQ	Futures	7310.58	7319.34	7307.07	7318.76	3284.0
2018-12-26 00:00:00	YM	Futures	23406.8	23533.8	23386.1	23470.8	6983.0
2018-12-26 01:00:00	YM	Futures	23473.0	23543.6	23465.4	23525.1	5562.0
2018-12-26 02:00:00	YM	Futures	23522.9	23577.2	23446.9	23554.4	5796.0
2018-12-26 03:00:00	YM	Futures	23556.6	23646.7	23528.4	23621.7	6592.0

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

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