PREVIEW / futures_1hour / 2023-05-01

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-05-01.parquet
  size:    55 KB
  rows:    1,652

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-01 00:00:00	ES	Futures	4649.83	4650.38	4648.44	4650.11	2480.0
2023-05-01 01:00:00	ES	Futures	4650.11	4653.71	4647.89	4651.22	4698.0
2023-05-01 02:00:00	ES	Futures	4650.94	4655.1	4646.78	4653.71	6272.0
2023-05-01 03:00:00	ES	Futures	4653.71	4653.99	4648.17	4649.83	6110.0
2023-05-01 04:00:00	ES	Futures	4649.55	4649.83	4642.62	4644.56	7211.0
2023-05-01 05:00:00	ES	Futures	4644.56	4649.55	4644.28	4647.89	3812.0
2023-05-01 06:00:00	ES	Futures	4647.61	4649.0	4643.45	4646.5	4481.0
2023-05-01 07:00:00	ES	Futures	4646.78	4647.33	4640.95	4642.06	7431.0
2023-05-01 08:00:00	ES	Futures	4642.06	4646.22	4639.84	4644.84	14438.0
2023-05-01 09:00:00	ES	Futures	4644.84	4656.49	4639.01	4652.88	126712.0
2023-05-01 10:00:00	ES	Futures	4652.33	4660.37	4645.67	4658.98	202363.0
2023-05-01 11:00:00	ES	Futures	4659.26	4661.2	4643.45	4652.05	153206.0
2023-05-01 12:00:00	ES	Futures	4652.05	4666.47	4651.49	4661.48	118242.0
2023-05-01 13:00:00	ES	Futures	4661.48	4663.14	4655.38	4659.81	87642.0
2023-05-01 14:00:00	ES	Futures	4660.09	4660.92	4641.79	4649.0	146143.0
2023-05-01 15:00:00	ES	Futures	4649.0	4650.66	4639.84	4642.62	208744.0
2023-05-01 16:00:00	ES	Futures	4642.62	4647.06	4635.68	4636.79	57350.0
2023-05-01 18:00:00	ES	Futures	4636.79	4638.46	4633.47	4636.79	6523.0
2023-05-01 19:00:00	ES	Futures	4636.52	4638.46	4635.68	4636.24	3355.0
2023-05-01 20:00:00	ES	Futures	4636.24	4639.29	4633.19	4634.58	10536.0
2023-05-01 21:00:00	ES	Futures	4634.58	4641.51	4634.02	4638.46	9623.0
2023-05-01 22:00:00	ES	Futures	4638.46	4639.84	4636.24	4639.84	5697.0
2023-05-01 23:00:00	ES	Futures	4639.84	4642.06	4639.57	4642.06	4114.0
2023-05-01 00:00:00	NQ	Futures	15017.47	15018.6	15010.15	15015.22	1526.0
2023-05-01 01:00:00	NQ	Futures	15015.22	15032.68	15007.62	15023.11	2694.0
2023-05-01 02:00:00	NQ	Futures	15022.82	15057.74	15009.59	15039.15	4186.0
2023-05-01 03:00:00	NQ	Futures	15039.44	15043.38	15016.63	15021.13	3359.0
2023-05-01 04:00:00	NQ	Futures	15021.13	15021.42	14975.24	14993.26	6932.0
2023-05-01 05:00:00	NQ	Futures	14993.26	15017.19	14991.85	14999.17	4142.0
2023-05-01 06:00:00	NQ	Futures	14999.17	15011.28	14981.72	14991.01	3784.0
2023-05-01 07:00:00	NQ	Futures	14991.85	14998.89	14978.34	14984.25	5026.0
2023-05-01 08:00:00	NQ	Futures	14983.69	14988.47	14962.01	14982.56	9780.0
2023-05-01 09:00:00	NQ	Futures	14982.56	15010.44	14962.57	14990.45	61015.0
2023-05-01 10:00:00	NQ	Futures	14990.45	15007.9	14952.72	15004.52	86400.0
2023-05-01 11:00:00	NQ	Futures	15004.8	15014.94	14932.16	14974.4	71048.0
2023-05-01 12:00:00	NQ	Futures	14974.68	15035.78	14971.58	15030.99	49076.0
2023-05-01 13:00:00	NQ	Futures	15030.71	15050.13	15020.29	15034.65	35139.0
2023-05-01 14:00:00	NQ	Futures	15034.93	15038.31	14962.57	14995.8	48117.0
2023-05-01 15:00:00	NQ	Futures	14995.8	15002.83	14962.29	14983.13	57302.0
2023-05-01 16:00:00	NQ	Futures	14982.84	14999.17	14961.16	14966.23	14510.0
2023-05-01 18:00:00	NQ	Futures	14967.36	14972.99	14954.13	14966.8	2325.0
2023-05-01 19:00:00	NQ	Futures	14966.51	14973.27	14959.76	14962.57	1899.0
2023-05-01 20:00:00	NQ	Futures	14962.01	14976.37	14942.3	14952.72	4984.0
2023-05-01 21:00:00	NQ	Futures	14952.72	14985.66	14949.06	14965.39	5292.0
2023-05-01 22:00:00	NQ	Futures	14966.23	14971.58	14956.66	14971.3	2754.0
2023-05-01 23:00:00	NQ	Futures	14971.02	14979.75	14970.17	14978.9	2279.0
2023-05-01 00:00:00	YM	Futures	37810.4	37812.6	37798.2	37808.2	554.0
2023-05-01 01:00:00	YM	Futures	37808.2	37825.9	37792.7	37809.3	1146.0
2023-05-01 02:00:00	YM	Futures	37808.2	37821.4	37779.4	37821.4	1517.0
2023-05-01 03:00:00	YM	Futures	37821.4	37836.9	37797.1	37810.4	1302.0

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

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