PREVIEW / futures_1hour / 2023-07-25

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-07-25.parquet
  size:    65 KB
  rows:    2,069

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-25 00:00:00	ES	Futures	5032.07	5033.17	5031.52	5032.07	2652.0
2023-07-25 01:00:00	ES	Futures	5032.07	5034.81	5032.07	5034.26	4867.0
2023-07-25 02:00:00	ES	Futures	5034.54	5038.38	5032.07	5038.11	9084.0
2023-07-25 03:00:00	ES	Futures	5038.11	5038.66	5032.07	5034.54	18053.0
2023-07-25 04:00:00	ES	Futures	5034.54	5043.6	5033.17	5040.85	14508.0
2023-07-25 05:00:00	ES	Futures	5040.85	5041.68	5038.66	5039.75	8068.0
2023-07-25 06:00:00	ES	Futures	5039.48	5040.03	5034.54	5037.28	10555.0
2023-07-25 07:00:00	ES	Futures	5037.01	5040.03	5036.74	5038.93	11864.0
2023-07-25 08:00:00	ES	Futures	5038.66	5040.58	5033.17	5033.72	16326.0
2023-07-25 09:00:00	ES	Futures	5033.72	5042.77	5028.23	5039.21	155019.0
2023-07-25 10:00:00	ES	Futures	5039.21	5041.95	5034.54	5036.74	152230.0
2023-07-25 11:00:00	ES	Futures	5036.74	5047.99	5035.91	5045.79	98458.0
2023-07-25 12:00:00	ES	Futures	5045.79	5051.28	5043.6	5051.01	104897.0
2023-07-25 13:00:00	ES	Futures	5051.28	5053.75	5046.89	5050.19	123708.0
2023-07-25 14:00:00	ES	Futures	5050.19	5060.62	5048.81	5050.74	110505.0
2023-07-25 15:00:00	ES	Futures	5050.46	5055.68	5044.97	5045.79	191306.0
2023-07-25 16:00:00	ES	Futures	5045.79	5057.6	5040.03	5055.95	94873.0
2023-07-25 18:00:00	ES	Futures	5056.23	5058.42	5041.13	5044.15	18252.0
2023-07-25 19:00:00	ES	Futures	5044.42	5045.52	5042.5	5045.25	3862.0
2023-07-25 20:00:00	ES	Futures	5045.52	5045.79	5042.5	5043.05	4912.0
2023-07-25 21:00:00	ES	Futures	5043.05	5044.97	5042.23	5044.42	6548.0
2023-07-25 22:00:00	ES	Futures	5044.15	5046.89	5043.05	5046.07	3493.0
2023-07-25 23:00:00	ES	Futures	5046.07	5048.54	5045.52	5046.07	3513.0
2023-07-25 00:00:00	NQ	Futures	17312.83	17315.61	17305.6	17306.99	1477.0
2023-07-25 01:00:00	NQ	Futures	17307.27	17316.44	17305.32	17315.61	2655.0
2023-07-25 02:00:00	NQ	Futures	17315.61	17344.26	17308.94	17341.48	4480.0
2023-07-25 03:00:00	NQ	Futures	17341.75	17348.99	17330.63	17343.98	6765.0
2023-07-25 04:00:00	NQ	Futures	17343.42	17387.92	17339.53	17379.02	9029.0
2023-07-25 05:00:00	NQ	Futures	17378.47	17385.98	17370.68	17378.19	4870.0
2023-07-25 06:00:00	NQ	Futures	17378.47	17381.53	17346.76	17359.83	7106.0
2023-07-25 07:00:00	NQ	Futures	17359.28	17375.41	17358.72	17374.02	6589.0
2023-07-25 08:00:00	NQ	Futures	17374.3	17383.2	17357.89	17361.5	8925.0
2023-07-25 09:00:00	NQ	Futures	17361.22	17432.98	17334.52	17425.47	84085.0
2023-07-25 10:00:00	NQ	Futures	17425.47	17435.76	17359.83	17370.68	89467.0
2023-07-25 11:00:00	NQ	Futures	17370.68	17451.06	17367.9	17432.43	60793.0
2023-07-25 12:00:00	NQ	Futures	17432.43	17463.3	17415.74	17461.91	43006.0
2023-07-25 13:00:00	NQ	Futures	17462.19	17476.93	17446.61	17456.07	40170.0
2023-07-25 14:00:00	NQ	Futures	17455.79	17506.96	17449.11	17453.56	48257.0
2023-07-25 15:00:00	NQ	Futures	17453.84	17488.61	17425.47	17429.92	65884.0
2023-07-25 16:00:00	NQ	Futures	17429.64	17501.12	17366.51	17496.67	45060.0
2023-07-25 18:00:00	NQ	Futures	17500.29	17510.3	17377.63	17404.61	17770.0
2023-07-25 19:00:00	NQ	Futures	17404.89	17407.67	17386.26	17397.1	3981.0
2023-07-25 20:00:00	NQ	Futures	17397.66	17402.94	17390.43	17394.04	2747.0
2023-07-25 21:00:00	NQ	Futures	17394.32	17404.61	17388.76	17401.83	4214.0
2023-07-25 22:00:00	NQ	Futures	17401.27	17408.23	17394.6	17403.78	2791.0
2023-07-25 23:00:00	NQ	Futures	17404.06	17423.25	17402.94	17412.96	3542.0
2023-07-25 00:00:00	YM	Futures	38963.1	38971.8	38962.0	38966.4	493.0
2023-07-25 01:00:00	YM	Futures	38967.4	38982.8	38966.4	38980.6	781.0
2023-07-25 02:00:00	YM	Futures	38981.7	39001.4	38963.1	38999.2	1992.0
2023-07-25 03:00:00	YM	Futures	38999.2	39000.3	38943.3	38960.9	3596.0

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

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