PREVIEW / futures_1hour / 2020-04-01

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-04-01.parquet
  size:    63 KB
  rows:    1,859

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
2020-04-01 00:00:00	ES	Futures	2774.88	2777.9	2763.08	2772.13	11502.0
2020-04-01 01:00:00	ES	Futures	2772.41	2775.43	2729.87	2743.32	33652.0
2020-04-01 02:00:00	ES	Futures	2743.32	2746.34	2718.07	2742.22	41424.0
2020-04-01 03:00:00	ES	Futures	2742.22	2757.31	2722.74	2737.83	60540.0
2020-04-01 04:00:00	ES	Futures	2737.83	2741.95	2719.45	2735.36	35152.0
2020-04-01 05:00:00	ES	Futures	2735.36	2748.53	2728.78	2741.12	26914.0
2020-04-01 06:00:00	ES	Futures	2740.85	2750.73	2726.31	2731.79	28048.0
2020-04-01 07:00:00	ES	Futures	2732.07	2734.81	2719.99	2724.93	35033.0
2020-04-01 08:00:00	ES	Futures	2725.21	2733.17	2708.19	2722.19	69696.0
2020-04-01 09:00:00	ES	Futures	2722.74	2737.56	2710.66	2726.85	198741.0
2020-04-01 10:00:00	ES	Futures	2727.13	2746.61	2718.62	2741.67	210827.0
2020-04-01 11:00:00	ES	Futures	2741.4	2754.85	2719.99	2725.21	186582.0
2020-04-01 12:00:00	ES	Futures	2725.21	2725.48	2693.1	2697.77	181252.0
2020-04-01 13:00:00	ES	Futures	2697.77	2718.9	2694.47	2716.15	173942.0
2020-04-01 14:00:00	ES	Futures	2715.88	2725.21	2692.0	2692.83	157018.0
2020-04-01 15:00:00	ES	Futures	2692.55	2709.29	2671.97	2696.39	362416.0
2020-04-01 16:00:00	ES	Futures	2696.39	2698.86	2685.97	2696.94	74102.0
2020-04-01 18:00:00	ES	Futures	2699.14	2716.43	2696.39	2700.24	17898.0
2020-04-01 19:00:00	ES	Futures	2700.24	2713.68	2696.39	2712.31	12018.0
2020-04-01 20:00:00	ES	Futures	2712.31	2718.9	2709.29	2711.76	14474.0
2020-04-01 21:00:00	ES	Futures	2711.76	2714.51	2698.32	2708.19	19067.0
2020-04-01 22:00:00	ES	Futures	2708.19	2730.97	2708.19	2726.03	14790.0
2020-04-01 23:00:00	ES	Futures	2726.03	2733.17	2723.29	2724.39	10194.0
2020-04-01 00:00:00	NQ	Futures	8788.31	8799.45	8756.03	8783.45	3773.0
2020-04-01 01:00:00	NQ	Futures	8784.31	8791.45	8653.48	8687.76	8837.0
2020-04-01 02:00:00	NQ	Futures	8686.33	8691.47	8600.35	8681.48	13895.0
2020-04-01 03:00:00	NQ	Futures	8682.62	8722.32	8632.92	8684.9	13680.0
2020-04-01 04:00:00	NQ	Futures	8686.33	8704.9	8619.49	8660.91	10165.0
2020-04-01 05:00:00	NQ	Futures	8661.2	8701.76	8644.06	8679.19	6603.0
2020-04-01 06:00:00	NQ	Futures	8678.33	8707.47	8637.2	8655.77	6476.0
2020-04-01 07:00:00	NQ	Futures	8653.77	8676.91	8632.63	8650.06	8345.0
2020-04-01 08:00:00	NQ	Futures	8648.91	8674.05	8596.93	8645.49	14333.0
2020-04-01 09:00:00	NQ	Futures	8646.06	8720.04	8630.92	8662.05	40657.0
2020-04-01 10:00:00	NQ	Futures	8663.19	8749.46	8642.63	8733.18	48046.0
2020-04-01 11:00:00	NQ	Futures	8732.61	8778.31	8664.05	8680.62	42361.0
2020-04-01 12:00:00	NQ	Futures	8679.48	8681.19	8568.08	8581.5	35950.0
2020-04-01 13:00:00	NQ	Futures	8581.22	8621.78	8572.93	8612.92	37755.0
2020-04-01 14:00:00	NQ	Futures	8612.64	8634.92	8525.8	8529.52	30346.0
2020-04-01 15:00:00	NQ	Futures	8529.8	8564.36	8459.82	8532.09	53811.0
2020-04-01 16:00:00	NQ	Futures	8531.51	8536.08	8493.52	8527.52	9004.0
2020-04-01 18:00:00	NQ	Futures	8538.94	8587.79	8523.8	8540.66	4079.0
2020-04-01 19:00:00	NQ	Futures	8539.51	8578.07	8530.37	8576.36	2898.0
2020-04-01 20:00:00	NQ	Futures	8577.22	8592.93	8560.94	8569.5	3415.0
2020-04-01 21:00:00	NQ	Futures	8569.79	8583.5	8523.23	8559.51	6178.0
2020-04-01 22:00:00	NQ	Futures	8562.36	8617.21	8560.08	8601.21	4316.0
2020-04-01 23:00:00	NQ	Futures	8602.92	8624.63	8595.21	8598.35	3239.0
2020-04-01 00:00:00	YM	Futures	23436.5	23465.0	23337.9	23424.5	2006.0
2020-04-01 01:00:00	YM	Futures	23422.3	23447.5	23043.3	23172.5	4203.0
2020-04-01 02:00:00	YM	Futures	23169.3	23191.2	22957.9	23166.0	5948.0
2020-04-01 03:00:00	YM	Futures	23167.1	23283.2	22996.2	23115.6	10252.0

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

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