PREVIEW / futures_1hour / 2022-08-31

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-08-31.parquet
  size:    69 KB
  rows:    2,050

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
2022-08-31 00:00:00	ES	Futures	4543.67	4553.02	4543.11	4547.64	9707.0
2022-08-31 01:00:00	ES	Futures	4547.64	4552.46	4540.84	4546.22	8857.0
2022-08-31 02:00:00	ES	Futures	4546.22	4550.19	4539.14	4542.82	11938.0
2022-08-31 03:00:00	ES	Futures	4542.82	4546.51	4524.41	4526.4	25044.0
2022-08-31 04:00:00	ES	Futures	4526.11	4531.78	4516.2	4522.15	25461.0
2022-08-31 05:00:00	ES	Futures	4522.15	4522.15	4508.83	4513.36	26060.0
2022-08-31 06:00:00	ES	Futures	4513.36	4537.16	4510.25	4528.66	28477.0
2022-08-31 07:00:00	ES	Futures	4528.38	4536.03	4523.0	4529.79	22625.0
2022-08-31 08:00:00	ES	Futures	4529.51	4540.56	4526.68	4537.16	50337.0
2022-08-31 09:00:00	ES	Futures	4537.16	4551.61	4516.76	4533.19	286987.0
2022-08-31 10:00:00	ES	Futures	4533.19	4534.61	4509.68	4517.9	358197.0
2022-08-31 11:00:00	ES	Futures	4517.9	4529.51	4500.33	4526.11	246343.0
2022-08-31 12:00:00	ES	Futures	4526.11	4528.66	4506.28	4511.1	130899.0
2022-08-31 13:00:00	ES	Futures	4510.82	4519.03	4493.54	4500.33	147323.0
2022-08-31 14:00:00	ES	Futures	4500.33	4506.57	4483.05	4490.7	193954.0
2022-08-31 15:00:00	ES	Futures	4490.7	4514.21	4481.07	4482.2	550755.0
2022-08-31 16:00:00	ES	Futures	4482.2	4489.0	4479.09	4487.59	88961.0
2022-08-31 18:00:00	ES	Futures	4484.75	4488.15	4466.34	4471.72	17318.0
2022-08-31 19:00:00	ES	Futures	4471.72	4472.01	4452.18	4459.54	18362.0
2022-08-31 20:00:00	ES	Futures	4459.83	4463.23	4446.23	4453.88	23187.0
2022-08-31 21:00:00	ES	Futures	4453.88	4460.39	4452.46	4457.84	13367.0
2022-08-31 22:00:00	ES	Futures	4457.56	4462.38	4454.73	4457.28	11151.0
2022-08-31 23:00:00	ES	Futures	4457.56	4459.26	4448.5	4449.91	9138.0
2022-08-31 00:00:00	NQ	Futures	14392.25	14451.54	14383.86	14407.58	4517.0
2022-08-31 01:00:00	NQ	Futures	14408.15	14433.03	14384.73	14404.97	4375.0
2022-08-31 02:00:00	NQ	Futures	14405.84	14422.04	14378.36	14398.03	5760.0
2022-08-31 03:00:00	NQ	Futures	14396.87	14409.31	14330.06	14344.23	13058.0
2022-08-31 04:00:00	NQ	Futures	14343.94	14369.4	14309.23	14338.45	11974.0
2022-08-31 05:00:00	NQ	Futures	14339.32	14339.32	14299.4	14325.43	11022.0
2022-08-31 06:00:00	NQ	Futures	14325.43	14428.4	14315.89	14395.43	13338.0
2022-08-31 07:00:00	NQ	Futures	14396.01	14411.62	14359.56	14387.33	10003.0
2022-08-31 08:00:00	NQ	Futures	14385.88	14431.87	14370.84	14410.76	20837.0
2022-08-31 09:00:00	NQ	Futures	14410.76	14476.99	14335.55	14410.76	102380.0
2022-08-31 10:00:00	NQ	Futures	14411.34	14424.35	14291.01	14302.29	101718.0
2022-08-31 11:00:00	NQ	Futures	14302.0	14352.04	14231.72	14334.98	75719.0
2022-08-31 12:00:00	NQ	Futures	14335.55	14347.12	14267.87	14282.91	43665.0
2022-08-31 13:00:00	NQ	Futures	14282.91	14311.84	14213.79	14245.89	50127.0
2022-08-31 14:00:00	NQ	Futures	14246.18	14281.76	14203.08	14227.96	55207.0
2022-08-31 15:00:00	NQ	Futures	14228.54	14331.51	14207.42	14210.03	99696.0
2022-08-31 16:00:00	NQ	Futures	14209.45	14242.13	14206.27	14236.92	18032.0
2022-08-31 18:00:00	NQ	Futures	14212.92	14223.33	14122.39	14146.39	11009.0
2022-08-31 19:00:00	NQ	Futures	14146.68	14147.26	14059.91	14089.12	11765.0
2022-08-31 20:00:00	NQ	Futures	14089.12	14098.09	14026.36	14057.6	13729.0
2022-08-31 21:00:00	NQ	Futures	14057.89	14089.7	14053.26	14084.78	9488.0
2022-08-31 22:00:00	NQ	Futures	14084.5	14103.59	14071.19	14080.74	6105.0
2022-08-31 23:00:00	NQ	Futures	14081.6	14086.81	14038.51	14041.69	5382.0
2022-08-31 00:00:00	YM	Futures	36055.1	36109.3	36050.6	36072.0	1555.0
2022-08-31 01:00:00	YM	Futures	36072.0	36102.5	36024.6	36063.0	1517.0
2022-08-31 02:00:00	YM	Futures	36065.2	36092.3	36012.2	36030.3	2320.0
2022-08-31 03:00:00	YM	Futures	36037.0	36056.2	35906.1	35912.9	4125.0

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

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