PREVIEW / futures_1hour / 2023-07-26

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-07-26.parquet
  size:    67 KB
  rows:    2,046

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-26 00:00:00	ES	Futures	5046.07	5048.26	5045.25	5045.25	2378.0
2023-07-26 01:00:00	ES	Futures	5045.52	5047.44	5045.25	5046.62	4233.0
2023-07-26 02:00:00	ES	Futures	5046.34	5050.46	5045.52	5049.64	6590.0
2023-07-26 03:00:00	ES	Futures	5049.64	5052.66	5046.89	5049.91	16740.0
2023-07-26 04:00:00	ES	Futures	5049.91	5050.19	5042.5	5043.32	13636.0
2023-07-26 05:00:00	ES	Futures	5043.6	5045.79	5038.66	5042.23	12888.0
2023-07-26 06:00:00	ES	Futures	5042.5	5043.05	5035.91	5038.11	15318.0
2023-07-26 07:00:00	ES	Futures	5038.11	5042.5	5036.74	5040.03	15838.0
2023-07-26 08:00:00	ES	Futures	5040.03	5040.03	5033.44	5033.99	26339.0
2023-07-26 09:00:00	ES	Futures	5033.99	5042.23	5033.17	5038.66	153051.0
2023-07-26 10:00:00	ES	Futures	5038.38	5040.58	5030.15	5030.97	129812.0
2023-07-26 11:00:00	ES	Futures	5030.97	5040.3	5029.6	5039.75	102761.0
2023-07-26 12:00:00	ES	Futures	5039.75	5041.95	5029.6	5032.34	67842.0
2023-07-26 13:00:00	ES	Futures	5032.34	5034.81	5030.15	5031.79	51153.0
2023-07-26 14:00:00	ES	Futures	5032.34	5062.81	5026.58	5051.56	246743.0
2023-07-26 15:00:00	ES	Futures	5051.83	5054.03	5022.19	5046.89	327231.0
2023-07-26 16:00:00	ES	Futures	5046.62	5058.97	5042.5	5042.5	75362.0
2023-07-26 18:00:00	ES	Futures	5045.25	5046.62	5041.4	5045.79	6570.0
2023-07-26 19:00:00	ES	Futures	5045.79	5048.81	5045.52	5047.72	2355.0
2023-07-26 20:00:00	ES	Futures	5047.72	5052.11	5044.7	5052.11	6364.0
2023-07-26 21:00:00	ES	Futures	5052.11	5056.23	5051.56	5055.13	8435.0
2023-07-26 22:00:00	ES	Futures	5055.4	5058.97	5054.85	5057.87	8092.0
2023-07-26 23:00:00	ES	Futures	5057.87	5059.52	5057.6	5058.7	3980.0
2023-07-26 00:00:00	NQ	Futures	17412.68	17421.86	17407.67	17409.62	2368.0
2023-07-26 01:00:00	NQ	Futures	17409.34	17411.01	17399.88	17404.33	3544.0
2023-07-26 02:00:00	NQ	Futures	17404.06	17431.87	17400.44	17427.42	3500.0
2023-07-26 03:00:00	NQ	Futures	17426.86	17442.16	17417.96	17424.36	5369.0
2023-07-26 04:00:00	NQ	Futures	17425.19	17428.53	17400.16	17404.33	6074.0
2023-07-26 05:00:00	NQ	Futures	17404.06	17415.46	17392.1	17405.17	5746.0
2023-07-26 06:00:00	NQ	Futures	17406.28	17410.73	17377.63	17386.26	6732.0
2023-07-26 07:00:00	NQ	Futures	17385.98	17407.67	17378.19	17387.37	9320.0
2023-07-26 08:00:00	NQ	Futures	17387.65	17401.0	17362.34	17371.51	15186.0
2023-07-26 09:00:00	NQ	Futures	17371.51	17399.05	17317.56	17384.87	92293.0
2023-07-26 10:00:00	NQ	Futures	17383.75	17393.21	17279.73	17285.85	88232.0
2023-07-26 11:00:00	NQ	Futures	17286.41	17352.05	17260.82	17339.81	67547.0
2023-07-26 12:00:00	NQ	Futures	17339.81	17353.71	17289.74	17301.43	38349.0
2023-07-26 13:00:00	NQ	Futures	17301.43	17317.56	17292.53	17308.1	23872.0
2023-07-26 14:00:00	NQ	Futures	17307.27	17449.39	17282.79	17390.98	126734.0
2023-07-26 15:00:00	NQ	Futures	17391.54	17406.84	17266.1	17369.57	115843.0
2023-07-26 16:00:00	NQ	Futures	17370.12	17478.32	17364.84	17383.2	31065.0
2023-07-26 18:00:00	NQ	Futures	17398.49	17409.62	17390.43	17404.89	3620.0
2023-07-26 19:00:00	NQ	Futures	17404.61	17417.68	17403.22	17415.18	1854.0
2023-07-26 20:00:00	NQ	Futures	17415.18	17435.76	17399.05	17433.82	4279.0
2023-07-26 21:00:00	NQ	Futures	17434.37	17458.85	17433.82	17456.07	5555.0
2023-07-26 22:00:00	NQ	Futures	17456.34	17474.42	17453.01	17465.52	5567.0
2023-07-26 23:00:00	NQ	Futures	17465.24	17475.26	17455.79	17467.19	3480.0
2023-07-26 00:00:00	YM	Futures	38969.6	38983.9	38964.2	38966.4	639.0
2023-07-26 01:00:00	YM	Futures	38967.4	38982.8	38966.4	38976.2	779.0
2023-07-26 02:00:00	YM	Futures	38976.2	38997.0	38967.4	38991.6	1619.0
2023-07-26 03:00:00	YM	Futures	38990.5	39003.6	38965.3	38992.6	2883.0

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

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