PREVIEW / futures_1hour / 2023-05-29

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-05-29.parquet
  size:    49 KB
  rows:    1,521

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-29 00:00:00	ES	Futures	4683.94	4686.99	4683.39	4686.99	3337.0
2023-05-29 01:00:00	ES	Futures	4686.99	4689.77	4684.5	4689.49	5327.0
2023-05-29 02:00:00	ES	Futures	4689.49	4695.32	4687.55	4694.48	8128.0
2023-05-29 03:00:00	ES	Futures	4694.76	4695.59	4688.38	4689.21	10015.0
2023-05-29 04:00:00	ES	Futures	4688.94	4693.1	4688.94	4689.77	4753.0
2023-05-29 05:00:00	ES	Futures	4689.49	4691.16	4683.39	4686.16	8080.0
2023-05-29 06:00:00	ES	Futures	4686.16	4689.21	4683.67	4684.5	5325.0
2023-05-29 07:00:00	ES	Futures	4684.78	4686.44	4683.11	4685.05	4291.0
2023-05-29 08:00:00	ES	Futures	4685.05	4686.72	4682.0	4683.94	6849.0
2023-05-29 09:00:00	ES	Futures	4684.22	4685.89	4682.0	4683.39	10385.0
2023-05-29 10:00:00	ES	Futures	4683.39	4688.1	4682.83	4686.16	7862.0
2023-05-29 11:00:00	ES	Futures	4686.44	4689.77	4685.61	4687.55	7495.0
2023-05-29 12:00:00	ES	Futures	4687.83	4688.94	4686.72	4686.99	4807.0
2023-05-29 18:00:00	ES	Futures	4686.16	4692.54	4685.33	4688.66	6251.0
2023-05-29 19:00:00	ES	Futures	4688.66	4690.05	4682.83	4684.22	4069.0
2023-05-29 20:00:00	ES	Futures	4683.94	4687.83	4683.39	4686.16	6351.0
2023-05-29 21:00:00	ES	Futures	4686.16	4688.1	4685.33	4686.44	4614.0
2023-05-29 22:00:00	ES	Futures	4686.72	4687.27	4684.22	4685.33	2913.0
2023-05-29 23:00:00	ES	Futures	4685.33	4685.89	4682.56	4684.78	4185.0
2023-05-29 00:00:00	NQ	Futures	16209.85	16213.51	16198.59	16211.82	2877.0
2023-05-29 01:00:00	NQ	Futures	16211.54	16226.46	16202.81	16226.46	3122.0
2023-05-29 02:00:00	NQ	Futures	16226.46	16251.52	16220.83	16246.74	5358.0
2023-05-29 03:00:00	NQ	Futures	16247.02	16253.77	16219.14	16220.55	5317.0
2023-05-29 04:00:00	NQ	Futures	16220.55	16230.97	16215.76	16216.05	2997.0
2023-05-29 05:00:00	NQ	Futures	16216.33	16220.83	16203.09	16213.79	3472.0
2023-05-29 06:00:00	NQ	Futures	16213.51	16239.41	16206.75	16208.73	4360.0
2023-05-29 07:00:00	NQ	Futures	16209.85	16213.23	16192.4	16195.21	4023.0
2023-05-29 08:00:00	NQ	Futures	16195.49	16211.26	16180.85	16188.17	5712.0
2023-05-29 09:00:00	NQ	Futures	16188.74	16198.03	16181.41	16186.76	6303.0
2023-05-29 10:00:00	NQ	Futures	16187.05	16205.63	16187.05	16199.43	6469.0
2023-05-29 11:00:00	NQ	Futures	16199.43	16203.09	16190.99	16193.8	4990.0
2023-05-29 12:00:00	NQ	Futures	16194.08	16231.25	16190.14	16222.8	4535.0
2023-05-29 18:00:00	NQ	Futures	16216.89	16228.15	16208.16	16215.48	3435.0
2023-05-29 19:00:00	NQ	Futures	16215.48	16223.08	16195.77	16201.97	2694.0
2023-05-29 20:00:00	NQ	Futures	16201.97	16211.82	16199.15	16203.66	2939.0
2023-05-29 21:00:00	NQ	Futures	16203.66	16210.7	16198.87	16201.12	2339.0
2023-05-29 22:00:00	NQ	Futures	16200.84	16203.94	16193.24	16200.0	2210.0
2023-05-29 23:00:00	NQ	Futures	16199.72	16207.04	16196.34	16204.5	2407.0
2023-05-29 00:00:00	YM	Futures	36657.6	36681.9	36653.1	36681.9	325.0
2023-05-29 01:00:00	YM	Futures	36681.9	36692.9	36669.7	36688.5	539.0
2023-05-29 02:00:00	YM	Futures	36690.7	36749.3	36676.3	36740.5	1483.0
2023-05-29 03:00:00	YM	Futures	36739.3	36769.2	36702.9	36708.4	1618.0
2023-05-29 04:00:00	YM	Futures	36709.5	36739.3	36707.3	36720.6	815.0
2023-05-29 05:00:00	YM	Futures	36718.3	36730.5	36670.8	36681.9	1152.0
2023-05-29 06:00:00	YM	Futures	36680.8	36686.3	36659.8	36664.2	1083.0
2023-05-29 07:00:00	YM	Futures	36665.3	36712.8	36656.4	36705.1	1036.0
2023-05-29 08:00:00	YM	Futures	36700.7	36711.7	36652.0	36676.3	1417.0
2023-05-29 09:00:00	YM	Futures	36677.4	36697.3	36652.0	36660.9	1705.0
2023-05-29 10:00:00	YM	Futures	36664.2	36725.0	36660.9	36706.2	2624.0
2023-05-29 11:00:00	YM	Futures	36707.3	36752.6	36698.4	36737.1	2560.0

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

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