PREVIEW / futures_1hour / 2023-10-05

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-10-05.parquet
  size:    68 KB
  rows:    2,073

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-10-05 00:00:00	ES	Futures	4671.35	4672.7	4669.17	4669.99	3601.0
2023-10-05 01:00:00	ES	Futures	4670.26	4670.26	4664.83	4667.0	7516.0
2023-10-05 02:00:00	ES	Futures	4667.27	4668.63	4655.87	4658.86	12382.0
2023-10-05 03:00:00	ES	Futures	4658.58	4658.58	4651.52	4656.14	23945.0
2023-10-05 04:00:00	ES	Futures	4655.87	4665.1	4652.34	4652.34	22469.0
2023-10-05 05:00:00	ES	Futures	4652.34	4654.24	4646.09	4650.98	23659.0
2023-10-05 06:00:00	ES	Futures	4651.25	4662.93	4648.81	4661.3	22823.0
2023-10-05 07:00:00	ES	Futures	4661.3	4669.45	4656.14	4668.63	28064.0
2023-10-05 08:00:00	ES	Futures	4668.63	4672.98	4646.91	4655.33	64408.0
2023-10-05 09:00:00	ES	Futures	4655.33	4670.26	4648.81	4657.5	205983.0
2023-10-05 10:00:00	ES	Futures	4657.77	4657.77	4630.07	4633.87	280279.0
2023-10-05 11:00:00	ES	Futures	4633.87	4640.93	4625.18	4634.42	197774.0
2023-10-05 12:00:00	ES	Futures	4634.42	4650.17	4632.51	4641.2	143525.0
2023-10-05 13:00:00	ES	Futures	4641.2	4658.58	4632.51	4657.23	149049.0
2023-10-05 14:00:00	ES	Futures	4657.5	4671.62	4655.05	4667.82	142090.0
2023-10-05 15:00:00	ES	Futures	4667.82	4669.45	4658.31	4661.57	208325.0
2023-10-05 16:00:00	ES	Futures	4661.57	4662.66	4656.14	4658.31	44361.0
2023-10-05 18:00:00	ES	Futures	4657.23	4659.67	4657.23	4658.31	2794.0
2023-10-05 19:00:00	ES	Futures	4658.31	4658.86	4654.78	4655.6	2854.0
2023-10-05 20:00:00	ES	Futures	4655.6	4660.48	4653.97	4659.94	6183.0
2023-10-05 21:00:00	ES	Futures	4660.21	4661.03	4656.14	4659.67	7570.0
2023-10-05 22:00:00	ES	Futures	4659.67	4663.2	4657.77	4662.11	4887.0
2023-10-05 23:00:00	ES	Futures	4662.11	4662.39	4656.68	4658.31	4483.0
2023-10-05 00:00:00	NQ	Futures	16411.46	16417.23	16401.57	16407.07	2663.0
2023-10-05 01:00:00	NQ	Futures	16406.79	16407.34	16382.9	16391.96	4379.0
2023-10-05 02:00:00	NQ	Futures	16392.51	16398.28	16345.82	16363.39	7613.0
2023-10-05 03:00:00	NQ	Futures	16363.12	16363.67	16335.65	16353.51	10312.0
2023-10-05 04:00:00	NQ	Futures	16353.23	16388.94	16336.48	16336.48	12386.0
2023-10-05 05:00:00	NQ	Futures	16336.48	16351.03	16315.88	16340.32	12428.0
2023-10-05 06:00:00	NQ	Futures	16340.05	16392.51	16330.98	16386.19	11859.0
2023-10-05 07:00:00	NQ	Futures	16386.47	16422.45	16362.3	16418.88	15985.0
2023-10-05 08:00:00	NQ	Futures	16418.88	16434.53	16324.94	16359.82	33797.0
2023-10-05 09:00:00	NQ	Futures	16359.82	16399.1	16280.99	16300.5	88578.0
2023-10-05 10:00:00	NQ	Futures	16300.77	16300.77	16168.11	16188.43	119977.0
2023-10-05 11:00:00	NQ	Futures	16188.43	16253.25	16168.93	16223.86	71983.0
2023-10-05 12:00:00	NQ	Futures	16223.86	16295.55	16216.17	16264.24	58856.0
2023-10-05 13:00:00	NQ	Futures	16264.51	16328.24	16228.53	16321.64	57908.0
2023-10-05 14:00:00	NQ	Futures	16321.37	16377.68	16313.95	16368.89	55354.0
2023-10-05 15:00:00	NQ	Futures	16369.16	16375.48	16319.72	16332.63	63809.0
2023-10-05 16:00:00	NQ	Futures	16332.63	16339.5	16315.33	16326.86	11622.0
2023-10-05 18:00:00	NQ	Futures	16319.17	16327.41	16318.35	16323.02	2097.0
2023-10-05 19:00:00	NQ	Futures	16322.47	16326.59	16313.95	16317.25	2202.0
2023-10-05 20:00:00	NQ	Futures	16317.25	16340.87	16309.56	16338.12	5493.0
2023-10-05 21:00:00	NQ	Futures	16338.67	16341.7	16317.52	16332.08	4922.0
2023-10-05 22:00:00	NQ	Futures	16332.36	16346.36	16324.94	16340.6	3440.0
2023-10-05 23:00:00	NQ	Futures	16341.15	16341.7	16320.0	16330.16	3282.0
2023-10-05 00:00:00	YM	Futures	36169.2	36176.8	36150.7	36154.0	475.0
2023-10-05 01:00:00	YM	Futures	36155.1	36156.2	36119.3	36138.8	1030.0
2023-10-05 02:00:00	YM	Futures	36139.9	36144.2	36064.0	36082.4	2582.0
2023-10-05 03:00:00	YM	Futures	36083.5	36083.5	36034.7	36065.0	3965.0

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

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