PREVIEW / futures_1hour / 2023-11-21

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-11-21.parquet
  size:    65 KB
  rows:    2,064

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
2023-11-21 00:00:00	ES	Futures	4957.57	4959.2	4955.94	4956.48	4922.0
2023-11-21 01:00:00	ES	Futures	4956.48	4957.84	4953.77	4957.3	5614.0
2023-11-21 02:00:00	ES	Futures	4957.3	4957.57	4950.51	4951.32	8539.0
2023-11-21 03:00:00	ES	Futures	4951.32	4954.04	4949.97	4951.05	12222.0
2023-11-21 04:00:00	ES	Futures	4951.05	4954.04	4948.06	4948.61	14043.0
2023-11-21 05:00:00	ES	Futures	4948.61	4953.77	4947.79	4950.51	9367.0
2023-11-21 06:00:00	ES	Futures	4950.51	4951.6	4947.52	4948.34	11256.0
2023-11-21 07:00:00	ES	Futures	4948.61	4952.68	4945.35	4946.16	18561.0
2023-11-21 08:00:00	ES	Futures	4945.89	4947.79	4940.46	4941.28	40844.0
2023-11-21 09:00:00	ES	Futures	4941.0	4944.26	4937.2	4938.56	144747.0
2023-11-21 10:00:00	ES	Futures	4938.29	4942.36	4929.06	4937.2	173772.0
2023-11-21 11:00:00	ES	Futures	4936.93	4939.65	4931.77	4939.38	93377.0
2023-11-21 12:00:00	ES	Futures	4939.38	4946.98	4937.75	4946.16	69380.0
2023-11-21 13:00:00	ES	Futures	4946.44	4946.71	4936.39	4943.72	93317.0
2023-11-21 14:00:00	ES	Futures	4943.45	4946.44	4938.56	4943.72	97834.0
2023-11-21 15:00:00	ES	Futures	4943.99	4947.52	4939.1	4943.45	157295.0
2023-11-21 16:00:00	ES	Futures	4943.45	4943.99	4927.97	4940.19	64906.0
2023-11-21 18:00:00	ES	Futures	4939.92	4939.92	4934.76	4937.2	6056.0
2023-11-21 19:00:00	ES	Futures	4937.2	4941.0	4937.2	4940.73	8172.0
2023-11-21 20:00:00	ES	Futures	4940.46	4943.72	4939.92	4942.63	5340.0
2023-11-21 21:00:00	ES	Futures	4942.36	4946.71	4941.28	4945.35	5703.0
2023-11-21 22:00:00	ES	Futures	4945.35	4946.44	4942.09	4943.18	3940.0
2023-11-21 23:00:00	ES	Futures	4942.91	4943.18	4941.82	4942.91	2423.0
2023-11-21 00:00:00	NQ	Futures	17698.54	17703.48	17688.92	17692.49	3507.0
2023-11-21 01:00:00	NQ	Futures	17692.49	17694.14	17676.84	17691.12	3980.0
2023-11-21 02:00:00	NQ	Futures	17691.67	17692.77	17665.03	17669.15	5270.0
2023-11-21 03:00:00	NQ	Futures	17669.42	17678.49	17657.89	17671.34	8639.0
2023-11-21 04:00:00	NQ	Futures	17671.07	17679.31	17656.79	17660.91	7348.0
2023-11-21 05:00:00	NQ	Futures	17660.36	17682.06	17656.24	17667.5	5669.0
2023-11-21 06:00:00	NQ	Futures	17667.5	17671.34	17641.68	17645.8	8979.0
2023-11-21 07:00:00	NQ	Futures	17646.63	17660.63	17620.53	17624.38	12217.0
2023-11-21 08:00:00	NQ	Futures	17624.65	17626.03	17582.9	17586.47	25091.0
2023-11-21 09:00:00	NQ	Futures	17587.02	17601.31	17556.81	17562.3	83610.0
2023-11-21 10:00:00	NQ	Futures	17562.58	17582.08	17487.05	17515.06	102213.0
2023-11-21 11:00:00	NQ	Futures	17515.06	17537.03	17497.48	17535.39	59227.0
2023-11-21 12:00:00	NQ	Futures	17535.66	17567.52	17527.7	17563.95	40316.0
2023-11-21 13:00:00	NQ	Futures	17564.23	17565.05	17514.79	17551.32	48465.0
2023-11-21 14:00:00	NQ	Futures	17553.24	17569.72	17532.09	17563.4	47594.0
2023-11-21 15:00:00	NQ	Futures	17563.13	17579.88	17548.84	17565.87	54993.0
2023-11-21 16:00:00	NQ	Futures	17566.15	17605.97	17481.83	17543.9	26896.0
2023-11-21 18:00:00	NQ	Futures	17542.53	17544.45	17515.88	17528.79	4569.0
2023-11-21 19:00:00	NQ	Futures	17528.52	17541.15	17527.7	17540.06	4241.0
2023-11-21 20:00:00	NQ	Futures	17540.33	17548.57	17535.11	17543.63	3727.0
2023-11-21 21:00:00	NQ	Futures	17543.35	17561.2	17538.68	17554.89	4258.0
2023-11-21 22:00:00	NQ	Futures	17555.16	17558.46	17541.7	17546.1	2302.0
2023-11-21 23:00:00	NQ	Futures	17545.55	17547.47	17538.96	17546.92	2119.0
2023-11-21 00:00:00	YM	Futures	38215.1	38224.9	38206.4	38210.8	692.0
2023-11-21 01:00:00	YM	Futures	38210.8	38214.0	38190.2	38212.9	909.0
2023-11-21 02:00:00	YM	Futures	38212.9	38217.3	38170.6	38171.7	1581.0
2023-11-21 03:00:00	YM	Futures	38172.8	38199.9	38165.2	38170.6	2553.0

> showing 50 of 2,064 rows — these rows as CSV

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