PREVIEW / futures_1hour / 2023-02-09

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-02-09.parquet
  size:    69 KB
  rows:    2,085

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-02-09 00:00:00	ES	Futures	4628.89	4637.55	4621.9	4633.36	14923.0
2023-02-09 01:00:00	ES	Futures	4633.36	4637.27	4631.12	4636.16	5119.0
2023-02-09 02:00:00	ES	Futures	4636.44	4639.23	4633.92	4637.27	8195.0
2023-02-09 03:00:00	ES	Futures	4637.27	4656.01	4637.0	4650.98	32804.0
2023-02-09 04:00:00	ES	Futures	4650.98	4661.32	4649.58	4661.04	16995.0
2023-02-09 05:00:00	ES	Futures	4661.32	4664.12	4655.73	4663.84	17708.0
2023-02-09 06:00:00	ES	Futures	4663.84	4664.12	4651.53	4654.61	15418.0
2023-02-09 07:00:00	ES	Futures	4654.33	4655.17	4647.9	4648.46	17378.0
2023-02-09 08:00:00	ES	Futures	4648.46	4659.64	4648.18	4658.8	36878.0
2023-02-09 09:00:00	ES	Futures	4658.8	4660.2	4641.75	4646.22	203637.0
2023-02-09 10:00:00	ES	Futures	4646.5	4654.05	4631.68	4642.59	243100.0
2023-02-09 11:00:00	ES	Futures	4642.59	4642.87	4619.1	4624.41	207835.0
2023-02-09 12:00:00	ES	Futures	4624.41	4632.52	4600.65	4610.15	177375.0
2023-02-09 13:00:00	ES	Futures	4609.87	4614.35	4597.57	4600.93	158017.0
2023-02-09 14:00:00	ES	Futures	4600.93	4604.28	4587.78	4591.42	156439.0
2023-02-09 15:00:00	ES	Futures	4591.42	4591.42	4561.22	4576.6	373763.0
2023-02-09 16:00:00	ES	Futures	4576.88	4583.03	4574.64	4583.03	60491.0
2023-02-09 18:00:00	ES	Futures	4583.31	4583.59	4576.88	4578.84	9981.0
2023-02-09 19:00:00	ES	Futures	4579.12	4579.68	4571.29	4574.64	10048.0
2023-02-09 20:00:00	ES	Futures	4574.92	4578.56	4574.08	4577.72	7440.0
2023-02-09 21:00:00	ES	Futures	4578.0	4578.28	4571.29	4571.29	5787.0
2023-02-09 22:00:00	ES	Futures	4571.57	4571.57	4565.7	4569.05	8783.0
2023-02-09 23:00:00	ES	Futures	4568.77	4570.17	4564.58	4568.21	4903.0
2023-02-09 00:00:00	NQ	Futures	14312.33	14352.73	14287.29	14328.54	7251.0
2023-02-09 01:00:00	NQ	Futures	14327.97	14349.03	14322.85	14343.05	3459.0
2023-02-09 02:00:00	NQ	Futures	14343.62	14356.71	14331.96	14345.61	5093.0
2023-02-09 03:00:00	NQ	Futures	14346.47	14421.86	14344.76	14402.51	14856.0
2023-02-09 04:00:00	NQ	Futures	14403.37	14456.28	14396.54	14456.0	10908.0
2023-02-09 05:00:00	NQ	Futures	14455.71	14475.63	14432.67	14473.64	9832.0
2023-02-09 06:00:00	NQ	Futures	14474.2	14476.48	14420.15	14440.92	9903.0
2023-02-09 07:00:00	NQ	Futures	14440.07	14442.06	14407.35	14408.77	10456.0
2023-02-09 08:00:00	NQ	Futures	14409.06	14471.93	14409.06	14468.23	18283.0
2023-02-09 09:00:00	NQ	Futures	14468.51	14484.73	14377.48	14422.14	80699.0
2023-02-09 10:00:00	NQ	Futures	14422.43	14461.12	14352.44	14398.81	81064.0
2023-02-09 11:00:00	NQ	Futures	14399.38	14400.8	14289.57	14318.02	69912.0
2023-02-09 12:00:00	NQ	Futures	14318.02	14355.85	14224.13	14272.78	58834.0
2023-02-09 13:00:00	NQ	Futures	14272.5	14294.97	14214.18	14228.69	50287.0
2023-02-09 14:00:00	NQ	Futures	14229.26	14243.76	14171.5	14188.0	50453.0
2023-02-09 15:00:00	NQ	Futures	14188.57	14189.43	14072.78	14141.92	93940.0
2023-02-09 16:00:00	NQ	Futures	14141.92	14168.09	14129.97	14167.52	13872.0
2023-02-09 18:00:00	NQ	Futures	14166.38	14169.51	14144.19	14150.45	5417.0
2023-02-09 19:00:00	NQ	Futures	14151.02	14153.58	14114.89	14128.26	5593.0
2023-02-09 20:00:00	NQ	Futures	14128.83	14141.92	14124.56	14137.08	4032.0
2023-02-09 21:00:00	NQ	Futures	14136.79	14140.21	14113.75	14114.89	2583.0
2023-02-09 22:00:00	NQ	Futures	14115.17	14115.17	14090.42	14104.08	4859.0
2023-02-09 23:00:00	NQ	Futures	14103.22	14109.2	14086.15	14098.1	3082.0
2023-02-09 00:00:00	YM	Futures	37971.3	38018.1	37920.1	37993.6	2990.0
2023-02-09 01:00:00	YM	Futures	37991.4	38017.0	37973.5	38007.0	1281.0
2023-02-09 02:00:00	YM	Futures	38009.2	38027.0	37993.6	38011.4	1864.0
2023-02-09 03:00:00	YM	Futures	38010.3	38146.2	38008.1	38111.7	5412.0

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

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