PREVIEW / futures_1hour / 2023-06-06

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-06-06.parquet
  size:    65 KB
  rows:    2,005

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-06 00:00:00	ES	Futures	4749.95	4753.56	4749.4	4750.51	5300.0
2023-06-06 01:00:00	ES	Futures	4750.79	4753.28	4748.01	4748.01	6121.0
2023-06-06 02:00:00	ES	Futures	4748.01	4749.68	4743.3	4743.85	10816.0
2023-06-06 03:00:00	ES	Futures	4743.85	4753.84	4743.58	4750.51	25043.0
2023-06-06 04:00:00	ES	Futures	4750.51	4753.28	4743.02	4744.13	15608.0
2023-06-06 05:00:00	ES	Futures	4744.41	4746.9	4741.36	4744.68	11919.0
2023-06-06 06:00:00	ES	Futures	4744.68	4746.63	4742.74	4745.52	12811.0
2023-06-06 07:00:00	ES	Futures	4745.52	4748.57	4744.13	4746.35	12874.0
2023-06-06 08:00:00	ES	Futures	4746.63	4749.4	4742.74	4745.52	19798.0
2023-06-06 09:00:00	ES	Futures	4745.79	4748.84	4735.53	4742.19	186317.0
2023-06-06 10:00:00	ES	Futures	4742.47	4762.99	4741.36	4759.11	235426.0
2023-06-06 11:00:00	ES	Futures	4759.11	4761.33	4745.24	4759.66	176145.0
2023-06-06 12:00:00	ES	Futures	4759.66	4763.54	4743.85	4746.07	140823.0
2023-06-06 13:00:00	ES	Futures	4746.35	4756.61	4742.19	4745.24	162639.0
2023-06-06 14:00:00	ES	Futures	4745.52	4755.78	4742.19	4754.95	119227.0
2023-06-06 15:00:00	ES	Futures	4754.95	4764.65	4752.17	4759.11	237775.0
2023-06-06 16:00:00	ES	Futures	4758.83	4762.71	4758.27	4761.88	70813.0
2023-06-06 18:00:00	ES	Futures	4761.88	4761.88	4757.44	4759.11	4065.0
2023-06-06 19:00:00	ES	Futures	4759.11	4764.1	4758.83	4763.27	5341.0
2023-06-06 20:00:00	ES	Futures	4763.27	4765.49	4761.88	4762.44	7273.0
2023-06-06 21:00:00	ES	Futures	4762.71	4763.54	4757.17	4760.22	11346.0
2023-06-06 22:00:00	ES	Futures	4759.94	4761.33	4757.72	4760.77	4688.0
2023-06-06 23:00:00	ES	Futures	4761.05	4764.65	4759.94	4763.82	4972.0
2023-06-06 00:00:00	NQ	Futures	16430.03	16443.82	16427.21	16429.74	2663.0
2023-06-06 01:00:00	NQ	Futures	16430.03	16442.41	16419.61	16421.3	3427.0
2023-06-06 02:00:00	NQ	Futures	16421.3	16429.18	16405.81	16410.32	4018.0
2023-06-06 03:00:00	NQ	Futures	16410.04	16459.59	16409.47	16438.47	8663.0
2023-06-06 04:00:00	NQ	Futures	16439.32	16453.68	16413.98	16422.14	6097.0
2023-06-06 05:00:00	NQ	Futures	16422.42	16433.69	16415.1	16417.64	3615.0
2023-06-06 06:00:00	NQ	Futures	16417.92	16422.71	16402.15	16419.33	5418.0
2023-06-06 07:00:00	NQ	Futures	16419.61	16436.22	16412.85	16424.96	5683.0
2023-06-06 08:00:00	NQ	Futures	16425.52	16434.25	16402.15	16410.88	9698.0
2023-06-06 09:00:00	NQ	Futures	16410.88	16425.8	16335.14	16381.32	94882.0
2023-06-06 10:00:00	NQ	Futures	16381.6	16450.3	16359.07	16433.69	93239.0
2023-06-06 11:00:00	NQ	Futures	16433.69	16461.0	16375.12	16455.37	71262.0
2023-06-06 12:00:00	NQ	Futures	16455.37	16469.44	16361.33	16367.24	61526.0
2023-06-06 13:00:00	NQ	Futures	16367.24	16420.74	16364.71	16388.64	57337.0
2023-06-06 14:00:00	NQ	Futures	16389.2	16429.74	16380.47	16426.08	43429.0
2023-06-06 15:00:00	NQ	Futures	16426.37	16446.07	16397.93	16424.4	66184.0
2023-06-06 16:00:00	NQ	Futures	16424.68	16440.16	16417.92	16436.5	10731.0
2023-06-06 18:00:00	NQ	Futures	16436.5	16439.6	16414.26	16418.76	2759.0
2023-06-06 19:00:00	NQ	Futures	16418.76	16441.01	16415.67	16437.63	2482.0
2023-06-06 20:00:00	NQ	Futures	16437.07	16444.39	16428.62	16433.69	3835.0
2023-06-06 21:00:00	NQ	Futures	16433.97	16436.5	16412.57	16418.76	5291.0
2023-06-06 22:00:00	NQ	Futures	16418.76	16420.45	16407.22	16419.89	2325.0
2023-06-06 23:00:00	NQ	Futures	16419.61	16429.18	16415.1	16427.21	1959.0
2023-06-06 00:00:00	YM	Futures	37157.2	37177.0	37151.6	37161.6	1009.0
2023-06-06 01:00:00	YM	Futures	37161.6	37178.2	37145.0	37145.0	1025.0
2023-06-06 02:00:00	YM	Futures	37147.2	37153.8	37107.4	37109.6	2227.0
2023-06-06 03:00:00	YM	Futures	37109.6	37163.8	37108.5	37157.2	4738.0

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

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