PREVIEW / futures_1hour / 2023-11-27

all futures 1-hour files

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

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-27 00:00:00	ES	Futures	4948.06	4949.15	4944.53	4944.53	6678.0
2023-11-27 01:00:00	ES	Futures	4944.81	4948.88	4944.81	4947.52	6812.0
2023-11-27 02:00:00	ES	Futures	4947.79	4952.95	4947.52	4952.41	11115.0
2023-11-27 03:00:00	ES	Futures	4952.68	4956.21	4951.05	4954.04	17352.0
2023-11-27 04:00:00	ES	Futures	4953.77	4954.04	4947.25	4948.06	10873.0
2023-11-27 05:00:00	ES	Futures	4948.06	4958.38	4948.06	4958.38	14452.0
2023-11-27 06:00:00	ES	Futures	4958.38	4958.93	4952.41	4954.31	10674.0
2023-11-27 07:00:00	ES	Futures	4954.31	4958.11	4953.5	4954.58	12230.0
2023-11-27 08:00:00	ES	Futures	4954.85	4958.38	4953.22	4954.58	22189.0
2023-11-27 09:00:00	ES	Futures	4954.58	4961.1	4948.34	4953.22	150386.0
2023-11-27 10:00:00	ES	Futures	4953.22	4961.1	4950.24	4956.21	154091.0
2023-11-27 11:00:00	ES	Futures	4956.48	4963.27	4949.97	4958.93	123233.0
2023-11-27 12:00:00	ES	Futures	4959.2	4961.37	4956.21	4960.56	71247.0
2023-11-27 13:00:00	ES	Futures	4960.83	4964.09	4958.11	4960.01	72174.0
2023-11-27 14:00:00	ES	Futures	4960.29	4961.91	4948.88	4954.58	104072.0
2023-11-27 15:00:00	ES	Futures	4954.58	4961.91	4951.87	4953.5	175199.0
2023-11-27 16:00:00	ES	Futures	4953.5	4955.4	4951.6	4954.85	46548.0
2023-11-27 18:00:00	ES	Futures	4954.85	4957.57	4954.85	4957.57	5133.0
2023-11-27 19:00:00	ES	Futures	4957.57	4957.57	4952.68	4955.13	7997.0
2023-11-27 20:00:00	ES	Futures	4955.13	4956.48	4952.95	4955.67	7652.0
2023-11-27 21:00:00	ES	Futures	4955.94	4958.38	4955.94	4957.03	5201.0
2023-11-27 22:00:00	ES	Futures	4956.75	4957.3	4954.04	4954.04	5332.0
2023-11-27 23:00:00	ES	Futures	4954.04	4954.85	4953.22	4954.04	3405.0
2023-11-27 00:00:00	NQ	Futures	17520.55	17527.42	17512.31	17513.96	3387.0
2023-11-27 01:00:00	NQ	Futures	17513.96	17532.36	17513.96	17529.89	2944.0
2023-11-27 02:00:00	NQ	Futures	17530.17	17564.78	17530.17	17560.93	6716.0
2023-11-27 03:00:00	NQ	Futures	17561.2	17577.68	17555.99	17573.02	7247.0
2023-11-27 04:00:00	NQ	Futures	17573.29	17578.51	17546.37	17550.22	7117.0
2023-11-27 05:00:00	NQ	Futures	17550.77	17591.42	17549.67	17589.22	7728.0
2023-11-27 06:00:00	NQ	Futures	17588.67	17592.79	17572.47	17582.08	5454.0
2023-11-27 07:00:00	NQ	Futures	17581.53	17598.83	17575.76	17583.45	8151.0
2023-11-27 08:00:00	NQ	Futures	17583.73	17602.4	17574.66	17578.78	12520.0
2023-11-27 09:00:00	NQ	Futures	17578.78	17619.71	17545.82	17587.3	76381.0
2023-11-27 10:00:00	NQ	Futures	17587.57	17635.09	17576.86	17623.83	82284.0
2023-11-27 11:00:00	NQ	Futures	17623.28	17651.02	17585.37	17638.11	60528.0
2023-11-27 12:00:00	NQ	Futures	17638.11	17661.46	17630.97	17658.16	34196.0
2023-11-27 13:00:00	NQ	Futures	17658.71	17676.56	17627.4	17637.01	42889.0
2023-11-27 14:00:00	NQ	Futures	17637.29	17642.23	17576.04	17606.25	43592.0
2023-11-27 15:00:00	NQ	Futures	17606.52	17630.69	17577.41	17586.75	57565.0
2023-11-27 16:00:00	NQ	Futures	17586.75	17589.77	17581.53	17583.73	12051.0
2023-11-27 18:00:00	NQ	Futures	17584.28	17593.34	17581.8	17588.95	2909.0
2023-11-27 19:00:00	NQ	Futures	17589.22	17590.04	17563.68	17583.18	5517.0
2023-11-27 20:00:00	NQ	Futures	17583.18	17589.49	17572.19	17585.65	3943.0
2023-11-27 21:00:00	NQ	Futures	17585.65	17593.89	17585.37	17586.47	2643.0
2023-11-27 22:00:00	NQ	Futures	17586.2	17588.12	17571.37	17572.47	3019.0
2023-11-27 23:00:00	NQ	Futures	17572.47	17576.86	17568.62	17575.49	1881.0
2023-11-27 00:00:00	YM	Futures	38344.2	38349.6	38324.7	38324.7	717.0
2023-11-27 01:00:00	YM	Futures	38325.8	38352.9	38323.6	38346.4	939.0
2023-11-27 02:00:00	YM	Futures	38346.4	38380.0	38346.4	38378.9	1709.0
2023-11-27 03:00:00	YM	Futures	38377.8	38403.9	38365.9	38378.9	2060.0

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

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