PREVIEW / futures_1hour / 2023-03-15

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-03-15.parquet
  size:    73 KB
  rows:    2,087

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-03-15 00:00:00	ES	Futures	4391.61	4392.45	4387.45	4391.06	4784.0
2023-03-15 01:00:00	ES	Futures	4391.06	4391.34	4383.02	4385.79	7684.0
2023-03-15 02:00:00	ES	Futures	4386.07	4395.77	4385.51	4393.28	9777.0
2023-03-15 03:00:00	ES	Futures	4393.56	4394.94	4383.85	4389.39	15159.0
2023-03-15 04:00:00	ES	Futures	4389.39	4392.72	4378.02	4379.41	29802.0
2023-03-15 05:00:00	ES	Futures	4379.41	4380.52	4350.01	4350.84	52459.0
2023-03-15 06:00:00	ES	Futures	4350.84	4354.17	4293.99	4305.36	105889.0
2023-03-15 07:00:00	ES	Futures	4305.36	4320.61	4304.52	4310.63	92839.0
2023-03-15 08:00:00	ES	Futures	4310.63	4326.44	4287.88	4301.47	128104.0
2023-03-15 09:00:00	ES	Futures	4301.47	4337.53	4296.2	4313.12	325139.0
2023-03-15 10:00:00	ES	Futures	4313.12	4333.65	4298.98	4319.78	379818.0
2023-03-15 11:00:00	ES	Futures	4320.06	4334.2	4313.68	4315.34	233803.0
2023-03-15 12:00:00	ES	Futures	4315.34	4321.44	4292.88	4297.87	201460.0
2023-03-15 13:00:00	ES	Futures	4297.87	4329.49	4293.99	4324.22	204195.0
2023-03-15 14:00:00	ES	Futures	4324.22	4358.33	4312.29	4348.9	295665.0
2023-03-15 15:00:00	ES	Futures	4349.18	4358.61	4328.1	4358.61	394943.0
2023-03-15 16:00:00	ES	Futures	4358.61	4361.38	4350.29	4355.0	87451.0
2023-03-15 18:00:00	ES	Futures	4354.17	4361.1	4350.84	4358.89	10653.0
2023-03-15 19:00:00	ES	Futures	4359.16	4361.66	4349.18	4351.67	11777.0
2023-03-15 20:00:00	ES	Futures	4351.4	4375.8	4351.12	4375.53	27802.0
2023-03-15 21:00:00	ES	Futures	4375.25	4379.41	4366.1	4371.64	26920.0
2023-03-15 22:00:00	ES	Futures	4371.92	4376.08	4367.21	4371.37	13898.0
2023-03-15 23:00:00	ES	Futures	4371.37	4372.75	4364.16	4368.04	9790.0
2023-03-15 00:00:00	NQ	Futures	13906.75	13910.69	13888.17	13904.5	2553.0
2023-03-15 01:00:00	NQ	Futures	13904.78	13905.9	13875.78	13887.88	3324.0
2023-03-15 02:00:00	NQ	Futures	13887.32	13929.27	13886.48	13916.04	4904.0
2023-03-15 03:00:00	NQ	Futures	13917.17	13926.46	13882.25	13898.58	5654.0
2023-03-15 04:00:00	NQ	Futures	13898.58	13928.15	13882.53	13885.91	12102.0
2023-03-15 05:00:00	NQ	Futures	13885.35	13889.29	13787.37	13795.25	19392.0
2023-03-15 06:00:00	NQ	Futures	13796.1	13811.58	13623.51	13667.71	32717.0
2023-03-15 07:00:00	NQ	Futures	13667.15	13722.33	13664.61	13693.89	29407.0
2023-03-15 08:00:00	NQ	Futures	13693.89	13761.75	13633.36	13686.29	43362.0
2023-03-15 09:00:00	NQ	Futures	13686.01	13825.66	13658.42	13750.2	95193.0
2023-03-15 10:00:00	NQ	Futures	13750.77	13817.21	13686.01	13774.7	92631.0
2023-03-15 11:00:00	NQ	Futures	13775.54	13865.92	13752.74	13807.64	79432.0
2023-03-15 12:00:00	NQ	Futures	13807.08	13824.82	13721.2	13739.79	58948.0
2023-03-15 13:00:00	NQ	Futures	13739.79	13858.88	13725.43	13838.61	60581.0
2023-03-15 14:00:00	NQ	Futures	13839.18	13953.2	13800.32	13938.56	91752.0
2023-03-15 15:00:00	NQ	Futures	13938.85	13973.48	13852.41	13956.3	102422.0
2023-03-15 16:00:00	NQ	Futures	13956.02	13970.94	13946.45	13961.93	18383.0
2023-03-15 18:00:00	NQ	Futures	13963.62	13992.9	13946.45	13985.58	4923.0
2023-03-15 19:00:00	NQ	Futures	13986.43	13997.69	13956.58	13969.53	4383.0
2023-03-15 20:00:00	NQ	Futures	13968.69	14029.22	13964.75	14023.87	8938.0
2023-03-15 21:00:00	NQ	Futures	14022.47	14035.42	13993.18	14002.76	8811.0
2023-03-15 22:00:00	NQ	Futures	14002.48	14024.16	13987.27	14006.7	5454.0
2023-03-15 23:00:00	NQ	Futures	14006.98	14012.89	13981.08	13999.1	3646.0
2023-03-15 00:00:00	YM	Futures	35817.5	35823.0	35792.1	35812.0	650.0
2023-03-15 01:00:00	YM	Futures	35809.8	35810.9	35755.6	35786.6	1170.0
2023-03-15 02:00:00	YM	Futures	35786.6	35849.6	35782.1	35825.3	1221.0
2023-03-15 03:00:00	YM	Futures	35827.5	35842.9	35761.1	35796.5	2378.0

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

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