PREVIEW / futures_1hour / 2023-03-24

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-03-24.parquet
  size:    59 KB
  rows:    1,657

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-24 00:00:00	ES	Futures	4417.68	4418.52	4414.63	4416.3	3748.0
2023-03-24 01:00:00	ES	Futures	4416.3	4424.62	4415.74	4419.07	7364.0
2023-03-24 02:00:00	ES	Futures	4419.07	4423.51	4418.24	4422.68	4808.0
2023-03-24 03:00:00	ES	Futures	4422.68	4435.71	4420.18	4430.44	14808.0
2023-03-24 04:00:00	ES	Futures	4430.44	4430.72	4394.66	4406.87	48184.0
2023-03-24 05:00:00	ES	Futures	4407.15	4412.42	4380.24	4382.18	52327.0
2023-03-24 06:00:00	ES	Futures	4382.18	4388.29	4373.03	4381.91	53567.0
2023-03-24 07:00:00	ES	Futures	4381.91	4386.07	4371.37	4374.42	40039.0
2023-03-24 08:00:00	ES	Futures	4374.42	4392.17	4367.76	4388.84	58892.0
2023-03-24 09:00:00	ES	Futures	4388.56	4397.99	4368.32	4393.56	217661.0
2023-03-24 10:00:00	ES	Futures	4393.56	4408.53	4377.75	4392.45	292758.0
2023-03-24 11:00:00	ES	Futures	4392.45	4412.97	4374.42	4410.75	231152.0
2023-03-24 12:00:00	ES	Futures	4410.75	4420.74	4394.39	4412.42	187518.0
2023-03-24 13:00:00	ES	Futures	4412.69	4424.9	4405.48	4415.47	155508.0
2023-03-24 14:00:00	ES	Futures	4415.47	4433.22	4413.8	4427.95	137376.0
2023-03-24 15:00:00	ES	Futures	4427.95	4441.54	4421.01	4440.43	232401.0
2023-03-24 16:00:00	ES	Futures	4440.15	4449.58	4437.65	4449.3	76913.0
2023-03-24 00:00:00	NQ	Futures	14484.78	14487.31	14475.49	14479.71	2017.0
2023-03-24 01:00:00	NQ	Futures	14479.43	14513.49	14478.58	14493.5	3879.0
2023-03-24 02:00:00	NQ	Futures	14493.79	14505.61	14490.13	14498.57	2635.0
2023-03-24 03:00:00	NQ	Futures	14498.85	14550.94	14480.27	14536.86	8577.0
2023-03-24 04:00:00	NQ	Futures	14536.58	14538.83	14441.42	14480.27	18939.0
2023-03-24 05:00:00	NQ	Futures	14480.83	14501.95	14402.0	14411.85	17549.0
2023-03-24 06:00:00	NQ	Futures	14411.85	14438.04	14387.36	14425.65	17752.0
2023-03-24 07:00:00	NQ	Futures	14425.37	14435.22	14380.6	14390.74	14245.0
2023-03-24 08:00:00	NQ	Futures	14389.61	14437.19	14363.15	14425.37	19666.0
2023-03-24 09:00:00	NQ	Futures	14425.37	14465.91	14343.72	14439.45	88220.0
2023-03-24 10:00:00	NQ	Futures	14440.01	14463.38	14366.81	14418.61	102094.0
2023-03-24 11:00:00	NQ	Futures	14418.89	14455.21	14334.43	14446.2	84621.0
2023-03-24 12:00:00	NQ	Futures	14447.33	14477.17	14362.58	14417.2	67364.0
2023-03-24 13:00:00	NQ	Futures	14417.77	14467.04	14394.96	14429.31	55888.0
2023-03-24 14:00:00	NQ	Futures	14429.59	14492.1	14421.71	14472.67	53166.0
2023-03-24 15:00:00	NQ	Futures	14473.23	14523.63	14450.99	14521.94	74139.0
2023-03-24 16:00:00	NQ	Futures	14521.94	14556.01	14514.62	14553.76	17299.0
2023-03-24 00:00:00	YM	Futures	35753.4	35760.0	35733.5	35746.8	563.0
2023-03-24 01:00:00	YM	Futures	35746.8	35799.8	35744.6	35762.3	995.0
2023-03-24 02:00:00	YM	Futures	35764.5	35798.7	35756.7	35795.4	937.0
2023-03-24 03:00:00	YM	Futures	35795.4	35884.9	35782.1	35838.5	2752.0
2023-03-24 04:00:00	YM	Futures	35838.5	35840.7	35541.2	35624.1	8139.0
2023-03-24 05:00:00	YM	Futures	35626.3	35660.6	35428.5	35437.3	7290.0
2023-03-24 06:00:00	YM	Futures	35439.5	35459.4	35344.4	35399.7	8877.0
2023-03-24 07:00:00	YM	Futures	35399.7	35425.1	35326.8	35352.2	5722.0
2023-03-24 08:00:00	YM	Futures	35348.9	35499.2	35309.1	35478.2	7854.0
2023-03-24 09:00:00	YM	Futures	35478.2	35569.9	35359.9	35522.4	29510.0
2023-03-24 10:00:00	YM	Futures	35524.6	35630.7	35401.9	35495.9	28069.0
2023-03-24 11:00:00	YM	Futures	35495.9	35687.1	35379.8	35671.6	21105.0
2023-03-24 12:00:00	YM	Futures	35671.6	35752.3	35575.5	35708.1	18392.0
2023-03-24 13:00:00	YM	Futures	35708.1	35781.0	35646.2	35703.7	13327.0
2023-03-24 14:00:00	YM	Futures	35703.7	35829.7	35693.7	35787.7	11913.0
2023-03-24 15:00:00	YM	Futures	35788.8	35875.0	35726.9	35857.3	15865.0

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

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