PREVIEW / futures_1hour / 2023-06-07

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-06-07.parquet
  size:    65 KB
  rows:    1,990

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-06-07 00:00:00	ES	Futures	4763.82	4764.38	4761.05	4762.99	4779.0
2023-06-07 01:00:00	ES	Futures	4762.99	4763.27	4760.22	4761.05	5704.0
2023-06-07 02:00:00	ES	Futures	4761.33	4761.88	4756.89	4758.55	7410.0
2023-06-07 03:00:00	ES	Futures	4758.55	4759.11	4750.79	4752.45	18835.0
2023-06-07 04:00:00	ES	Futures	4752.45	4755.22	4749.95	4754.39	11190.0
2023-06-07 05:00:00	ES	Futures	4754.39	4757.44	4751.9	4754.67	8825.0
2023-06-07 06:00:00	ES	Futures	4754.67	4761.88	4754.67	4761.33	11112.0
2023-06-07 07:00:00	ES	Futures	4761.05	4766.87	4759.94	4766.32	17137.0
2023-06-07 08:00:00	ES	Futures	4766.32	4766.87	4761.05	4762.99	22980.0
2023-06-07 09:00:00	ES	Futures	4763.27	4775.75	4761.33	4772.14	237822.0
2023-06-07 10:00:00	ES	Futures	4771.87	4773.25	4746.63	4753.56	363187.0
2023-06-07 11:00:00	ES	Futures	4753.84	4759.94	4744.13	4745.24	218922.0
2023-06-07 12:00:00	ES	Futures	4745.52	4752.45	4742.47	4744.68	142881.0
2023-06-07 13:00:00	ES	Futures	4744.96	4748.57	4736.36	4743.02	189657.0
2023-06-07 14:00:00	ES	Futures	4743.3	4750.79	4738.31	4746.07	148251.0
2023-06-07 15:00:00	ES	Futures	4745.79	4749.4	4736.64	4742.19	291345.0
2023-06-07 16:00:00	ES	Futures	4742.19	4743.3	4739.97	4740.8	62844.0
2023-06-07 18:00:00	ES	Futures	4740.8	4744.41	4739.69	4739.97	6326.0
2023-06-07 19:00:00	ES	Futures	4740.25	4742.19	4739.69	4741.91	4189.0
2023-06-07 20:00:00	ES	Futures	4741.91	4743.85	4740.52	4743.02	7385.0
2023-06-07 21:00:00	ES	Futures	4742.74	4744.41	4739.14	4742.19	6481.0
2023-06-07 22:00:00	ES	Futures	4742.47	4742.74	4740.52	4740.8	4435.0
2023-06-07 23:00:00	ES	Futures	4740.8	4741.91	4736.36	4737.2	7526.0
2023-06-07 00:00:00	NQ	Futures	16427.49	16428.62	16417.36	16420.74	1905.0
2023-06-07 01:00:00	NQ	Futures	16420.74	16426.93	16414.82	16418.48	2273.0
2023-06-07 02:00:00	NQ	Futures	16418.76	16419.89	16400.18	16407.78	2735.0
2023-06-07 03:00:00	NQ	Futures	16407.5	16410.6	16375.97	16384.41	6196.0
2023-06-07 04:00:00	NQ	Futures	16384.41	16395.4	16371.46	16393.71	4530.0
2023-06-07 05:00:00	NQ	Futures	16393.42	16407.5	16385.26	16399.62	3674.0
2023-06-07 06:00:00	NQ	Futures	16399.34	16428.34	16398.77	16424.68	5930.0
2023-06-07 07:00:00	NQ	Futures	16424.4	16458.74	16423.55	16457.62	9030.0
2023-06-07 08:00:00	NQ	Futures	16457.62	16457.62	16431.43	16440.44	11769.0
2023-06-07 09:00:00	NQ	Futures	16440.44	16527.16	16432.56	16477.89	109203.0
2023-06-07 10:00:00	NQ	Futures	16477.33	16486.06	16271.23	16300.79	150339.0
2023-06-07 11:00:00	NQ	Futures	16301.07	16340.49	16246.17	16252.08	90593.0
2023-06-07 12:00:00	NQ	Futures	16252.08	16281.65	16187.61	16205.91	78980.0
2023-06-07 13:00:00	NQ	Futures	16206.19	16228.72	16150.73	16188.74	75072.0
2023-06-07 14:00:00	NQ	Futures	16188.74	16227.31	16149.6	16187.89	64089.0
2023-06-07 15:00:00	NQ	Futures	16187.33	16197.46	16111.03	16140.59	105364.0
2023-06-07 16:00:00	NQ	Futures	16140.59	16145.94	16122.01	16122.85	16223.0
2023-06-07 18:00:00	NQ	Futures	16122.85	16143.97	16112.43	16119.75	4133.0
2023-06-07 19:00:00	NQ	Futures	16118.63	16140.31	16118.35	16138.62	2317.0
2023-06-07 20:00:00	NQ	Futures	16138.06	16146.78	16134.68	16143.41	3329.0
2023-06-07 21:00:00	NQ	Futures	16143.12	16147.91	16122.29	16135.52	3931.0
2023-06-07 22:00:00	NQ	Futures	16136.08	16136.65	16127.92	16129.61	2260.0
2023-06-07 23:00:00	NQ	Futures	16129.89	16135.52	16109.62	16112.43	3689.0
2023-06-07 00:00:00	YM	Futures	37174.8	37182.6	37150.5	37169.3	893.0
2023-06-07 01:00:00	YM	Futures	37169.3	37170.4	37145.0	37149.4	778.0
2023-06-07 02:00:00	YM	Futures	37150.5	37154.9	37128.4	37132.8	1167.0
2023-06-07 03:00:00	YM	Futures	37132.8	37137.3	37082.0	37091.9	2591.0

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

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