PREVIEW / futures_1hour / 2023-05-30

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-05-30.parquet
  size:    68 KB
  rows:    2,056

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-05-30 00:00:00	ES	Futures	4684.78	4686.72	4684.5	4685.89	3259.0
2023-05-30 01:00:00	ES	Futures	4685.89	4687.55	4684.22	4686.44	5217.0
2023-05-30 02:00:00	ES	Futures	4686.44	4690.32	4686.16	4689.21	7615.0
2023-05-30 03:00:00	ES	Futures	4689.49	4693.1	4684.5	4691.43	24953.0
2023-05-30 04:00:00	ES	Futures	4691.71	4698.37	4690.05	4696.7	21461.0
2023-05-30 05:00:00	ES	Futures	4696.42	4702.8	4695.87	4700.31	19609.0
2023-05-30 06:00:00	ES	Futures	4700.59	4702.53	4697.81	4698.09	10932.0
2023-05-30 07:00:00	ES	Futures	4698.09	4704.47	4693.93	4701.42	31098.0
2023-05-30 08:00:00	ES	Futures	4701.42	4707.24	4697.81	4700.59	41589.0
2023-05-30 09:00:00	ES	Futures	4700.86	4702.8	4685.33	4688.66	261054.0
2023-05-30 10:00:00	ES	Futures	4688.66	4695.87	4675.35	4680.89	314431.0
2023-05-30 11:00:00	ES	Futures	4680.89	4685.61	4670.08	4681.45	198145.0
2023-05-30 12:00:00	ES	Futures	4681.45	4682.28	4667.86	4679.23	148886.0
2023-05-30 13:00:00	ES	Futures	4679.51	4679.51	4661.48	4662.31	146185.0
2023-05-30 14:00:00	ES	Futures	4662.59	4684.5	4659.54	4675.9	193333.0
2023-05-30 15:00:00	ES	Futures	4675.9	4680.06	4669.24	4676.18	252165.0
2023-05-30 16:00:00	ES	Futures	4676.18	4678.95	4674.79	4674.79	61518.0
2023-05-30 18:00:00	ES	Futures	4673.96	4675.07	4671.19	4674.24	4459.0
2023-05-30 19:00:00	ES	Futures	4674.24	4679.23	4674.24	4677.56	4092.0
2023-05-30 20:00:00	ES	Futures	4677.84	4678.67	4675.35	4676.46	6969.0
2023-05-30 21:00:00	ES	Futures	4676.46	4677.29	4672.02	4672.3	8868.0
2023-05-30 22:00:00	ES	Futures	4672.3	4672.85	4667.03	4667.86	9796.0
2023-05-30 23:00:00	ES	Futures	4668.13	4668.13	4663.42	4665.36	8221.0
2023-05-30 00:00:00	NQ	Futures	16204.78	16216.05	16200.56	16210.41	2350.0
2023-05-30 01:00:00	NQ	Futures	16210.13	16215.2	16201.69	16210.13	3053.0
2023-05-30 02:00:00	NQ	Futures	16210.7	16231.81	16210.13	16222.24	3938.0
2023-05-30 03:00:00	NQ	Futures	16222.52	16257.43	16212.95	16247.3	8924.0
2023-05-30 04:00:00	NQ	Futures	16247.86	16313.46	16243.36	16299.1	16078.0
2023-05-30 05:00:00	NQ	Futures	16298.82	16339.65	16295.16	16326.13	12206.0
2023-05-30 06:00:00	NQ	Futures	16326.7	16338.24	16310.37	16310.37	7816.0
2023-05-30 07:00:00	NQ	Futures	16310.37	16374.84	16310.37	16365.27	18851.0
2023-05-30 08:00:00	NQ	Futures	16365.27	16408.91	16348.38	16359.36	25899.0
2023-05-30 09:00:00	NQ	Futures	16359.64	16397.08	16248.71	16265.88	151682.0
2023-05-30 10:00:00	NQ	Futures	16266.44	16299.67	16217.45	16276.58	132855.0
2023-05-30 11:00:00	NQ	Futures	16276.3	16312.62	16236.88	16281.93	81156.0
2023-05-30 12:00:00	NQ	Futures	16282.21	16287.28	16209.85	16270.39	63426.0
2023-05-30 13:00:00	NQ	Futures	16270.1	16271.23	16154.67	16162.83	67324.0
2023-05-30 14:00:00	NQ	Futures	16163.11	16266.73	16146.22	16244.48	76801.0
2023-05-30 15:00:00	NQ	Futures	16244.2	16250.11	16185.08	16214.36	76012.0
2023-05-30 16:00:00	NQ	Futures	16214.36	16232.66	16211.26	16220.55	15018.0
2023-05-30 18:00:00	NQ	Futures	16214.36	16225.62	16197.75	16223.08	3462.0
2023-05-30 19:00:00	NQ	Futures	16222.52	16250.11	16222.52	16242.51	4265.0
2023-05-30 20:00:00	NQ	Futures	16243.08	16245.33	16228.15	16234.35	3476.0
2023-05-30 21:00:00	NQ	Futures	16234.07	16235.47	16214.08	16215.2	4626.0
2023-05-30 22:00:00	NQ	Futures	16215.48	16218.58	16193.8	16197.46	4831.0
2023-05-30 23:00:00	NQ	Futures	16197.46	16199.72	16184.23	16195.49	3707.0
2023-05-30 00:00:00	YM	Futures	36649.8	36660.9	36647.6	36660.9	480.0
2023-05-30 01:00:00	YM	Futures	36660.9	36674.1	36649.8	36662.0	1002.0
2023-05-30 02:00:00	YM	Futures	36662.0	36689.6	36662.0	36679.7	1195.0
2023-05-30 03:00:00	YM	Futures	36680.8	36688.5	36627.7	36675.2	3375.0

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

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