PREVIEW / futures_1hour / 2023-10-06

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-10-06.parquet
  size:    57 KB
  rows:    1,658

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-06 00:00:00	ES	Futures	4658.31	4659.13	4655.33	4656.14	3581.0
2023-10-06 01:00:00	ES	Futures	4656.14	4656.41	4651.52	4652.07	6176.0
2023-10-06 02:00:00	ES	Futures	4651.79	4656.68	4650.98	4655.05	7729.0
2023-10-06 03:00:00	ES	Futures	4655.05	4664.83	4652.61	4664.01	18074.0
2023-10-06 04:00:00	ES	Futures	4664.01	4667.27	4659.67	4660.76	16048.0
2023-10-06 05:00:00	ES	Futures	4661.03	4667.82	4660.21	4667.27	11869.0
2023-10-06 06:00:00	ES	Futures	4667.55	4676.51	4666.19	4672.16	18632.0
2023-10-06 07:00:00	ES	Futures	4672.16	4674.06	4664.01	4664.29	19322.0
2023-10-06 08:00:00	ES	Futures	4664.01	4669.17	4608.07	4617.04	196182.0
2023-10-06 09:00:00	ES	Futures	4617.04	4644.73	4613.23	4632.51	377263.0
2023-10-06 10:00:00	ES	Futures	4632.79	4659.4	4618.12	4653.42	349589.0
2023-10-06 11:00:00	ES	Futures	4653.7	4709.64	4653.15	4709.64	297138.0
2023-10-06 12:00:00	ES	Futures	4709.37	4713.71	4695.79	4702.85	181278.0
2023-10-06 13:00:00	ES	Futures	4702.85	4720.23	4700.95	4718.87	145478.0
2023-10-06 14:00:00	ES	Futures	4719.14	4734.35	4714.25	4729.46	145919.0
2023-10-06 15:00:00	ES	Futures	4729.46	4732.18	4714.8	4716.43	237137.0
2023-10-06 16:00:00	ES	Futures	4716.43	4721.31	4713.98	4719.96	64000.0
2023-10-06 00:00:00	NQ	Futures	16329.61	16335.93	16320.27	16323.57	3390.0
2023-10-06 01:00:00	NQ	Futures	16323.02	16324.12	16301.05	16302.69	4073.0
2023-10-06 02:00:00	NQ	Futures	16302.97	16326.59	16299.95	16321.92	5495.0
2023-10-06 03:00:00	NQ	Futures	16321.92	16360.1	16315.6	16355.7	10898.0
2023-10-06 04:00:00	NQ	Futures	16355.7	16363.39	16326.86	16333.18	8188.0
2023-10-06 05:00:00	NQ	Futures	16333.73	16359.27	16333.18	16356.53	5793.0
2023-10-06 06:00:00	NQ	Futures	16356.8	16394.16	16351.31	16376.58	9591.0
2023-10-06 07:00:00	NQ	Futures	16377.13	16387.56	16339.5	16342.79	12169.0
2023-10-06 08:00:00	NQ	Futures	16342.52	16369.16	16106.31	16132.95	78635.0
2023-10-06 09:00:00	NQ	Futures	16132.13	16261.22	16117.84	16218.65	137197.0
2023-10-06 10:00:00	NQ	Futures	16219.2	16371.36	16157.95	16352.68	135222.0
2023-10-06 11:00:00	NQ	Futures	16353.51	16533.14	16349.66	16532.59	125501.0
2023-10-06 12:00:00	NQ	Futures	16532.31	16559.78	16501.0	16532.86	70074.0
2023-10-06 13:00:00	NQ	Futures	16532.59	16588.07	16522.15	16585.32	54179.0
2023-10-06 14:00:00	NQ	Futures	16585.32	16640.8	16569.39	16628.17	53652.0
2023-10-06 15:00:00	NQ	Futures	16628.44	16655.91	16599.88	16604.27	74549.0
2023-10-06 16:00:00	NQ	Futures	16604.27	16634.21	16598.23	16633.11	16444.0
2023-10-06 00:00:00	YM	Futures	36116.0	36119.3	36087.8	36092.2	868.0
2023-10-06 01:00:00	YM	Futures	36092.2	36093.2	36060.7	36067.2	1246.0
2023-10-06 02:00:00	YM	Futures	36066.1	36097.6	36062.9	36086.7	2426.0
2023-10-06 03:00:00	YM	Futures	36087.8	36143.2	36068.3	36138.8	3661.0
2023-10-06 04:00:00	YM	Futures	36139.9	36172.4	36131.2	36136.6	3545.0
2023-10-06 05:00:00	YM	Futures	36136.6	36178.9	36129.0	36176.8	2706.0
2023-10-06 06:00:00	YM	Futures	36176.8	36243.0	36168.1	36211.5	3577.0
2023-10-06 07:00:00	YM	Futures	36212.6	36214.7	36167.0	36167.0	2886.0
2023-10-06 08:00:00	YM	Futures	36167.0	36197.4	35840.5	35895.8	27750.0
2023-10-06 09:00:00	YM	Futures	35894.7	36092.2	35870.9	35962.0	50621.0
2023-10-06 10:00:00	YM	Futures	35963.1	36128.0	35832.9	36065.0	42461.0
2023-10-06 11:00:00	YM	Futures	36066.1	36509.8	36061.8	36502.2	34258.0
2023-10-06 12:00:00	YM	Futures	36501.1	36522.8	36369.9	36393.7	20086.0
2023-10-06 13:00:00	YM	Futures	36393.7	36517.4	36379.6	36505.5	12805.0
2023-10-06 14:00:00	YM	Futures	36505.5	36618.3	36468.6	36584.7	13459.0
2023-10-06 15:00:00	YM	Futures	36584.7	36587.9	36440.4	36452.3	17088.0

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

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