PREVIEW / futures_1hour / 2023-08-01

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-08-01.parquet
  size:    68 KB
  rows:    2,065

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-08-01 00:00:00	ES	Futures	5070.23	5071.87	5069.68	5070.5	3194.0
2023-08-01 01:00:00	ES	Futures	5070.23	5071.32	5067.48	5068.58	5036.0
2023-08-01 02:00:00	ES	Futures	5068.58	5068.58	5064.74	5065.56	7179.0
2023-08-01 03:00:00	ES	Futures	5065.56	5066.38	5059.25	5060.89	20159.0
2023-08-01 04:00:00	ES	Futures	5060.89	5061.17	5050.46	5054.85	24740.0
2023-08-01 05:00:00	ES	Futures	5055.13	5055.13	5049.36	5053.21	19303.0
2023-08-01 06:00:00	ES	Futures	5053.48	5059.79	5052.38	5059.52	15861.0
2023-08-01 07:00:00	ES	Futures	5059.52	5060.34	5050.19	5051.01	25570.0
2023-08-01 08:00:00	ES	Futures	5051.01	5052.66	5042.23	5045.79	37102.0
2023-08-01 09:00:00	ES	Futures	5045.79	5057.87	5043.6	5055.95	153648.0
2023-08-01 10:00:00	ES	Futures	5056.23	5061.17	5041.68	5051.01	246694.0
2023-08-01 11:00:00	ES	Futures	5051.01	5052.38	5044.7	5048.54	106475.0
2023-08-01 12:00:00	ES	Futures	5048.81	5051.01	5041.13	5050.46	76243.0
2023-08-01 13:00:00	ES	Futures	5050.74	5052.66	5046.62	5051.83	62534.0
2023-08-01 14:00:00	ES	Futures	5051.83	5057.87	5051.56	5055.13	100988.0
2023-08-01 15:00:00	ES	Futures	5054.85	5058.15	5049.09	5052.11	156315.0
2023-08-01 16:00:00	ES	Futures	5052.11	5052.66	5048.26	5049.09	53612.0
2023-08-01 18:00:00	ES	Futures	5029.05	5037.56	5020.26	5036.74	28105.0
2023-08-01 19:00:00	ES	Futures	5036.46	5037.83	5032.62	5035.91	6764.0
2023-08-01 20:00:00	ES	Futures	5036.19	5040.3	5030.7	5038.66	11019.0
2023-08-01 21:00:00	ES	Futures	5038.93	5043.87	5038.38	5041.4	8614.0
2023-08-01 22:00:00	ES	Futures	5041.4	5041.68	5028.5	5029.32	14372.0
2023-08-01 23:00:00	ES	Futures	5029.6	5031.79	5028.23	5029.6	7866.0
2023-08-01 00:00:00	NQ	Futures	17652.43	17660.77	17650.48	17654.37	1618.0
2023-08-01 01:00:00	NQ	Futures	17654.65	17656.6	17640.75	17643.81	2191.0
2023-08-01 02:00:00	NQ	Futures	17642.97	17643.81	17625.45	17628.51	3181.0
2023-08-01 03:00:00	NQ	Futures	17628.79	17632.12	17596.52	17608.2	8424.0
2023-08-01 04:00:00	NQ	Futures	17608.2	17613.77	17571.49	17592.35	10866.0
2023-08-01 05:00:00	NQ	Futures	17591.24	17594.3	17562.03	17586.23	7502.0
2023-08-01 06:00:00	NQ	Futures	17586.23	17607.37	17582.89	17604.03	6323.0
2023-08-01 07:00:00	NQ	Futures	17604.59	17609.87	17540.62	17543.96	13145.0
2023-08-01 08:00:00	NQ	Futures	17543.68	17562.31	17528.66	17548.13	14994.0
2023-08-01 09:00:00	NQ	Futures	17547.85	17586.79	17538.12	17555.08	71157.0
2023-08-01 10:00:00	NQ	Futures	17558.98	17618.5	17498.06	17597.64	129018.0
2023-08-01 11:00:00	NQ	Futures	17597.91	17610.99	17572.33	17601.81	54996.0
2023-08-01 12:00:00	NQ	Futures	17601.81	17609.6	17553.41	17607.09	41024.0
2023-08-01 13:00:00	NQ	Futures	17607.37	17626.84	17572.6	17609.32	38824.0
2023-08-01 14:00:00	NQ	Futures	17609.6	17629.62	17599.03	17614.6	37062.0
2023-08-01 15:00:00	NQ	Futures	17615.16	17632.68	17592.91	17596.52	47333.0
2023-08-01 16:00:00	NQ	Futures	17596.52	17607.37	17578.17	17587.34	15288.0
2023-08-01 18:00:00	NQ	Futures	17530.05	17531.72	17448.84	17530.05	12557.0
2023-08-01 19:00:00	NQ	Futures	17530.05	17533.67	17509.47	17525.6	3563.0
2023-08-01 20:00:00	NQ	Futures	17525.88	17547.85	17500.85	17539.78	5995.0
2023-08-01 21:00:00	NQ	Futures	17540.62	17566.48	17539.51	17549.24	5068.0
2023-08-01 22:00:00	NQ	Futures	17549.52	17551.47	17495.56	17498.34	7885.0
2023-08-01 23:00:00	NQ	Futures	17498.06	17506.96	17484.44	17497.51	5528.0
2023-08-01 00:00:00	YM	Futures	39103.3	39111.0	39098.9	39105.5	446.0
2023-08-01 01:00:00	YM	Futures	39105.5	39112.1	39089.1	39101.1	713.0
2023-08-01 02:00:00	YM	Futures	39097.8	39101.1	39078.1	39090.1	1252.0
2023-08-01 03:00:00	YM	Futures	39090.1	39098.9	39045.2	39048.5	2183.0

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

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