PREVIEW / futures_1hour / 2023-07-24

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-07-24.parquet
  size:    66 KB
  rows:    2,055

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-07-24 00:00:00	ES	Futures	5010.93	5011.75	5009.56	5011.21	2254.0
2023-07-24 01:00:00	ES	Futures	5011.21	5012.3	5008.74	5009.83	4320.0
2023-07-24 02:00:00	ES	Futures	5009.83	5012.3	5007.09	5009.56	8744.0
2023-07-24 03:00:00	ES	Futures	5009.56	5023.01	5009.28	5020.54	29106.0
2023-07-24 04:00:00	ES	Futures	5020.81	5023.28	5016.7	5020.81	15040.0
2023-07-24 05:00:00	ES	Futures	5020.81	5025.75	5020.54	5023.56	12508.0
2023-07-24 06:00:00	ES	Futures	5023.56	5024.38	5020.81	5021.36	9156.0
2023-07-24 07:00:00	ES	Futures	5021.36	5024.66	5018.62	5020.26	11931.0
2023-07-24 08:00:00	ES	Futures	5020.26	5022.19	5016.15	5021.91	17597.0
2023-07-24 09:00:00	ES	Futures	5021.91	5036.19	5016.7	5021.91	216647.0
2023-07-24 10:00:00	ES	Futures	5021.64	5034.81	5018.62	5033.44	189825.0
2023-07-24 11:00:00	ES	Futures	5033.17	5037.28	5027.95	5036.19	126397.0
2023-07-24 12:00:00	ES	Futures	5036.19	5038.66	5030.7	5034.26	78312.0
2023-07-24 13:00:00	ES	Futures	5033.99	5040.03	5030.97	5039.21	68720.0
2023-07-24 14:00:00	ES	Futures	5039.48	5042.77	5029.05	5034.26	95898.0
2023-07-24 15:00:00	ES	Futures	5033.99	5035.91	5024.66	5033.72	186577.0
2023-07-24 16:00:00	ES	Futures	5033.44	5036.46	5031.79	5035.09	44010.0
2023-07-24 18:00:00	ES	Futures	5033.99	5035.36	5033.17	5033.72	2461.0
2023-07-24 19:00:00	ES	Futures	5033.72	5035.91	5032.89	5034.26	2899.0
2023-07-24 20:00:00	ES	Futures	5034.26	5034.81	5030.42	5031.52	5906.0
2023-07-24 21:00:00	ES	Futures	5031.52	5032.62	5028.77	5030.7	8189.0
2023-07-24 22:00:00	ES	Futures	5030.7	5032.07	5029.87	5031.52	2952.0
2023-07-24 23:00:00	ES	Futures	5031.52	5032.07	5030.42	5032.07	2287.0
2023-07-24 00:00:00	NQ	Futures	17295.86	17301.43	17283.63	17299.76	2616.0
2023-07-24 01:00:00	NQ	Futures	17300.04	17306.15	17281.4	17291.97	3124.0
2023-07-24 02:00:00	NQ	Futures	17292.53	17303.93	17274.17	17285.29	5108.0
2023-07-24 03:00:00	NQ	Futures	17284.74	17345.65	17284.46	17340.92	11318.0
2023-07-24 04:00:00	NQ	Futures	17340.92	17348.71	17322.29	17325.07	6865.0
2023-07-24 05:00:00	NQ	Futures	17324.23	17348.99	17323.68	17336.19	4884.0
2023-07-24 06:00:00	NQ	Futures	17335.91	17341.48	17325.62	17327.01	4697.0
2023-07-24 07:00:00	NQ	Futures	17327.57	17343.7	17314.78	17333.69	6837.0
2023-07-24 08:00:00	NQ	Futures	17333.41	17340.09	17313.66	17325.35	8799.0
2023-07-24 09:00:00	NQ	Futures	17325.35	17376.24	17226.05	17250.81	104190.0
2023-07-24 10:00:00	NQ	Futures	17250.53	17348.43	17241.63	17314.5	100016.0
2023-07-24 11:00:00	NQ	Futures	17314.5	17348.15	17264.71	17313.39	72551.0
2023-07-24 12:00:00	NQ	Futures	17313.66	17335.36	17281.12	17300.04	50249.0
2023-07-24 13:00:00	NQ	Futures	17300.04	17345.65	17285.85	17337.86	37946.0
2023-07-24 14:00:00	NQ	Futures	17338.42	17352.88	17287.8	17315.89	39870.0
2023-07-24 15:00:00	NQ	Futures	17316.17	17326.18	17272.22	17315.05	58372.0
2023-07-24 16:00:00	NQ	Futures	17315.05	17327.57	17310.05	17320.89	12746.0
2023-07-24 18:00:00	NQ	Futures	17322.01	17322.84	17310.88	17314.5	1647.0
2023-07-24 19:00:00	NQ	Futures	17314.22	17325.07	17308.38	17318.95	1511.0
2023-07-24 20:00:00	NQ	Futures	17319.23	17324.51	17298.92	17304.49	3193.0
2023-07-24 21:00:00	NQ	Futures	17303.65	17315.33	17299.76	17308.66	3633.0
2023-07-24 22:00:00	NQ	Futures	17308.94	17313.39	17302.82	17307.27	1988.0
2023-07-24 23:00:00	NQ	Futures	17307.27	17314.22	17303.37	17313.11	1594.0
2023-07-24 00:00:00	YM	Futures	38759.3	38764.8	38753.8	38759.3	374.0
2023-07-24 01:00:00	YM	Futures	38759.3	38763.7	38749.4	38757.1	887.0
2023-07-24 02:00:00	YM	Futures	38758.2	38772.4	38740.7	38765.9	2028.0
2023-07-24 03:00:00	YM	Futures	38765.9	38837.1	38761.5	38823.9	5230.0

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

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