PREVIEW / futures_1hour / 2023-11-01

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-11-01.parquet
  size:    70 KB
  rows:    2,117

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-01 00:00:00	ES	Futures	4568.15	4569.24	4566.25	4568.15	3240.0
2023-11-01 01:00:00	ES	Futures	4568.43	4568.7	4562.45	4563.27	6623.0
2023-11-01 02:00:00	ES	Futures	4563.0	4574.67	4562.72	4574.13	7220.0
2023-11-01 03:00:00	ES	Futures	4574.13	4574.13	4565.71	4566.25	10178.0
2023-11-01 04:00:00	ES	Futures	4565.98	4570.33	4557.02	4559.46	21865.0
2023-11-01 05:00:00	ES	Futures	4559.46	4565.17	4555.39	4557.56	14456.0
2023-11-01 06:00:00	ES	Futures	4557.84	4561.64	4554.03	4559.19	13898.0
2023-11-01 07:00:00	ES	Futures	4559.46	4561.64	4552.68	4555.66	18202.0
2023-11-01 08:00:00	ES	Futures	4555.93	4581.19	4555.12	4577.39	93845.0
2023-11-01 09:00:00	ES	Futures	4577.12	4592.87	4569.78	4588.25	213747.0
2023-11-01 10:00:00	ES	Futures	4588.79	4614.86	4584.99	4608.07	302321.0
2023-11-01 11:00:00	ES	Futures	4608.07	4611.88	4596.4	4602.1	147867.0
2023-11-01 12:00:00	ES	Futures	4602.1	4602.37	4586.35	4591.51	124861.0
2023-11-01 13:00:00	ES	Futures	4591.24	4598.84	4587.16	4594.77	101829.0
2023-11-01 14:00:00	ES	Futures	4594.77	4613.78	4584.18	4608.89	371322.0
2023-11-01 15:00:00	ES	Futures	4609.16	4632.51	4608.89	4623.55	398803.0
2023-11-01 16:00:00	ES	Futures	4623.55	4625.73	4620.29	4625.45	62446.0
2023-11-01 18:00:00	ES	Futures	4625.73	4628.71	4624.91	4627.35	6165.0
2023-11-01 19:00:00	ES	Futures	4627.35	4635.23	4627.08	4634.14	11527.0
2023-11-01 20:00:00	ES	Futures	4634.14	4637.13	4630.07	4635.5	11337.0
2023-11-01 21:00:00	ES	Futures	4635.77	4638.22	4634.69	4636.59	11940.0
2023-11-01 22:00:00	ES	Futures	4636.59	4636.86	4634.69	4635.23	6064.0
2023-11-01 23:00:00	ES	Futures	4634.96	4636.04	4633.87	4635.5	4483.0
2023-11-01 00:00:00	NQ	Futures	15897.56	15904.43	15892.07	15900.31	1444.0
2023-11-01 01:00:00	NQ	Futures	15900.31	15901.13	15879.98	15882.46	2510.0
2023-11-01 02:00:00	NQ	Futures	15881.91	15922.01	15879.98	15920.91	4042.0
2023-11-01 03:00:00	NQ	Futures	15920.91	15921.73	15887.68	15889.05	5343.0
2023-11-01 04:00:00	NQ	Futures	15889.32	15899.21	15853.62	15863.23	10020.0
2023-11-01 05:00:00	NQ	Futures	15864.05	15879.16	15844.0	15854.44	7077.0
2023-11-01 06:00:00	NQ	Futures	15855.27	15867.9	15839.33	15859.93	6459.0
2023-11-01 07:00:00	NQ	Futures	15860.21	15869.0	15832.47	15843.18	7385.0
2023-11-01 08:00:00	NQ	Futures	15843.45	15947.0	15839.61	15928.6	35525.0
2023-11-01 09:00:00	NQ	Futures	15928.6	16020.06	15894.27	15982.16	88169.0
2023-11-01 10:00:00	NQ	Futures	15985.18	16094.77	15963.48	16064.83	133736.0
2023-11-01 11:00:00	NQ	Futures	16065.38	16087.36	16014.02	16052.47	64230.0
2023-11-01 12:00:00	NQ	Futures	16052.2	16058.24	15998.91	16025.56	50679.0
2023-11-01 13:00:00	NQ	Futures	16025.56	16058.79	16011.82	16046.71	37994.0
2023-11-01 14:00:00	NQ	Futures	16046.71	16124.99	15994.25	16104.93	130882.0
2023-11-01 15:00:00	NQ	Futures	16105.21	16218.37	16104.11	16197.22	112773.0
2023-11-01 16:00:00	NQ	Futures	16196.95	16217.55	16186.24	16217.55	17618.0
2023-11-01 18:00:00	NQ	Futures	16217.55	16231.01	16216.17	16225.24	3618.0
2023-11-01 19:00:00	NQ	Futures	16224.69	16255.73	16223.86	16252.15	5928.0
2023-11-01 20:00:00	NQ	Futures	16252.15	16268.91	16234.85	16257.92	6809.0
2023-11-01 21:00:00	NQ	Futures	16258.2	16279.35	16256.0	16269.73	7037.0
2023-11-01 22:00:00	NQ	Futures	16269.73	16271.66	16262.59	16266.71	2573.0
2023-11-01 23:00:00	NQ	Futures	16266.16	16270.01	16257.92	16266.71	2600.0
2023-11-01 00:00:00	YM	Futures	35881.7	35890.4	35866.5	35881.7	529.0
2023-11-01 01:00:00	YM	Futures	35879.5	35883.9	35844.8	35850.3	624.0
2023-11-01 02:00:00	YM	Futures	35850.3	35925.1	35848.1	35921.9	1426.0
2023-11-01 03:00:00	YM	Futures	35921.9	35921.9	35863.3	35864.4	2330.0

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

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