PREVIEW / futures_1hour / 2023-01-09

all futures 1-hour files

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

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-01-09 00:00:00	ES	Futures	4395.14	4395.69	4392.34	4393.74	5138.0
2023-01-09 01:00:00	ES	Futures	4393.74	4394.58	4390.66	4392.06	4291.0
2023-01-09 02:00:00	ES	Futures	4392.06	4392.62	4381.43	4383.67	13276.0
2023-01-09 03:00:00	ES	Futures	4383.39	4387.59	4380.32	4383.67	20665.0
2023-01-09 04:00:00	ES	Futures	4383.95	4399.33	4383.39	4394.86	18964.0
2023-01-09 05:00:00	ES	Futures	4394.86	4400.45	4393.18	4397.65	16522.0
2023-01-09 06:00:00	ES	Futures	4397.65	4399.33	4392.34	4393.74	12367.0
2023-01-09 07:00:00	ES	Futures	4393.46	4402.41	4392.62	4397.37	21558.0
2023-01-09 08:00:00	ES	Futures	4397.37	4404.92	4390.94	4398.21	45983.0
2023-01-09 09:00:00	ES	Futures	4398.21	4420.58	4393.74	4420.02	220328.0
2023-01-09 10:00:00	ES	Futures	4419.74	4438.47	4415.27	4431.48	254745.0
2023-01-09 11:00:00	ES	Futures	4431.48	4443.79	4431.48	4440.15	177893.0
2023-01-09 12:00:00	ES	Futures	4440.15	4440.15	4422.82	4428.13	127883.0
2023-01-09 13:00:00	ES	Futures	4428.13	4429.81	4400.17	4406.88	176188.0
2023-01-09 14:00:00	ES	Futures	4407.16	4414.15	4387.59	4389.54	186191.0
2023-01-09 15:00:00	ES	Futures	4389.82	4392.9	4375.0	4377.24	253854.0
2023-01-09 16:00:00	ES	Futures	4376.96	4378.36	4372.77	4376.96	47183.0
2023-01-09 18:00:00	ES	Futures	4378.08	4378.64	4371.09	4374.16	5918.0
2023-01-09 19:00:00	ES	Futures	4374.44	4375.56	4364.94	4368.85	10676.0
2023-01-09 20:00:00	ES	Futures	4369.13	4375.84	4368.57	4375.28	8598.0
2023-01-09 21:00:00	ES	Futures	4375.28	4375.84	4359.07	4364.94	13699.0
2023-01-09 22:00:00	ES	Futures	4365.22	4368.01	4359.63	4363.54	8737.0
2023-01-09 23:00:00	ES	Futures	4363.26	4365.5	4363.26	4364.94	2966.0
2023-01-09 00:00:00	NQ	Futures	12715.46	12716.6	12699.81	12707.5	2403.0
2023-01-09 01:00:00	NQ	Futures	12708.35	12709.77	12690.43	12698.96	2740.0
2023-01-09 02:00:00	NQ	Futures	12699.53	12709.2	12658.85	12667.67	7131.0
2023-01-09 03:00:00	NQ	Futures	12666.53	12690.14	12654.58	12663.97	10963.0
2023-01-09 04:00:00	NQ	Futures	12663.4	12730.82	12661.12	12705.79	10362.0
2023-01-09 05:00:00	NQ	Futures	12706.36	12720.3	12689.86	12700.38	7994.0
2023-01-09 06:00:00	NQ	Futures	12701.52	12710.91	12678.19	12689.29	6038.0
2023-01-09 07:00:00	NQ	Futures	12688.72	12729.12	12686.16	12712.33	7551.0
2023-01-09 08:00:00	NQ	Futures	12712.33	12742.2	12684.45	12716.88	17458.0
2023-01-09 09:00:00	NQ	Futures	12716.88	12872.5	12711.76	12871.36	101565.0
2023-01-09 10:00:00	NQ	Futures	12871.36	12931.96	12836.37	12898.96	102085.0
2023-01-09 11:00:00	NQ	Futures	12899.25	12956.43	12897.82	12939.07	61439.0
2023-01-09 12:00:00	NQ	Futures	12939.07	12943.06	12894.41	12921.44	49158.0
2023-01-09 13:00:00	NQ	Futures	12921.44	12935.66	12818.16	12839.22	61806.0
2023-01-09 14:00:00	NQ	Futures	12839.5	12869.09	12768.38	12775.49	65710.0
2023-01-09 15:00:00	NQ	Futures	12775.77	12789.43	12699.53	12731.68	88701.0
2023-01-09 16:00:00	NQ	Futures	12731.39	12735.38	12712.9	12727.98	12844.0
2023-01-09 18:00:00	NQ	Futures	12727.98	12730.54	12706.64	12715.46	3373.0
2023-01-09 19:00:00	NQ	Futures	12716.03	12718.31	12680.18	12693.27	4698.0
2023-01-09 20:00:00	NQ	Futures	12692.7	12721.44	12691.85	12716.03	3940.0
2023-01-09 21:00:00	NQ	Futures	12716.88	12720.3	12659.99	12679.62	5159.0
2023-01-09 22:00:00	NQ	Futures	12679.62	12693.84	12665.68	12680.75	3754.0
2023-01-09 23:00:00	NQ	Futures	12679.9	12687.3	12676.77	12683.03	1726.0
2023-01-09 00:00:00	YM	Futures	37730.7	37734.0	37712.8	37718.4	744.0
2023-01-09 01:00:00	YM	Futures	37718.4	37726.2	37699.5	37699.5	677.0
2023-01-09 02:00:00	YM	Futures	37700.6	37701.7	37633.7	37641.5	1738.0
2023-01-09 03:00:00	YM	Futures	37641.5	37667.1	37618.1	37649.3	2220.0

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

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