PREVIEW / futures_1hour / 2023-05-02

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-05-02.parquet
  size:    69 KB
  rows:    2,082

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-02 00:00:00	ES	Futures	4641.79	4643.17	4640.12	4642.06	5981.0
2023-05-02 01:00:00	ES	Futures	4641.79	4645.67	4641.23	4642.62	5823.0
2023-05-02 02:00:00	ES	Futures	4642.62	4647.33	4640.12	4646.22	7145.0
2023-05-02 03:00:00	ES	Futures	4645.95	4650.11	4639.57	4639.84	18959.0
2023-05-02 04:00:00	ES	Futures	4639.84	4640.12	4635.68	4636.79	14064.0
2023-05-02 05:00:00	ES	Futures	4636.52	4640.95	4634.58	4637.07	11643.0
2023-05-02 06:00:00	ES	Futures	4637.07	4638.18	4632.63	4637.07	10607.0
2023-05-02 07:00:00	ES	Futures	4637.07	4640.12	4634.85	4636.52	10337.0
2023-05-02 08:00:00	ES	Futures	4636.52	4636.52	4630.97	4633.19	19286.0
2023-05-02 09:00:00	ES	Futures	4633.47	4635.13	4620.71	4623.2	170672.0
2023-05-02 10:00:00	ES	Futures	4623.2	4625.7	4568.01	4569.12	481281.0
2023-05-02 11:00:00	ES	Futures	4569.12	4573.0	4554.7	4564.96	346871.0
2023-05-02 12:00:00	ES	Futures	4564.96	4577.72	4561.63	4575.78	147922.0
2023-05-02 13:00:00	ES	Futures	4575.78	4593.8	4573.56	4588.81	140133.0
2023-05-02 14:00:00	ES	Futures	4588.81	4592.69	4577.16	4591.86	163158.0
2023-05-02 15:00:00	ES	Futures	4591.86	4597.41	4585.21	4589.92	264169.0
2023-05-02 16:00:00	ES	Futures	4589.64	4592.14	4584.93	4585.48	83168.0
2023-05-02 18:00:00	ES	Futures	4585.48	4588.26	4583.82	4585.76	5959.0
2023-05-02 19:00:00	ES	Futures	4586.04	4591.31	4584.93	4591.03	4197.0
2023-05-02 20:00:00	ES	Futures	4591.03	4596.02	4588.26	4594.91	7462.0
2023-05-02 21:00:00	ES	Futures	4594.91	4595.75	4591.31	4592.97	6010.0
2023-05-02 22:00:00	ES	Futures	4592.69	4596.3	4592.69	4594.91	4324.0
2023-05-02 23:00:00	ES	Futures	4594.91	4596.58	4593.53	4596.3	4106.0
2023-05-02 00:00:00	NQ	Futures	14978.62	14984.53	14971.58	14976.93	2665.0
2023-05-02 01:00:00	NQ	Futures	14977.49	14995.51	14975.8	14984.53	3014.0
2023-05-02 02:00:00	NQ	Futures	14983.97	15007.9	14980.87	15003.68	3834.0
2023-05-02 03:00:00	NQ	Futures	15003.4	15017.76	14979.47	14989.88	7133.0
2023-05-02 04:00:00	NQ	Futures	14989.32	15001.71	14977.21	14980.31	5914.0
2023-05-02 05:00:00	NQ	Futures	14980.03	15006.21	14976.65	14991.85	5255.0
2023-05-02 06:00:00	NQ	Futures	14991.85	14993.82	14971.58	14987.07	4928.0
2023-05-02 07:00:00	NQ	Futures	14987.63	14996.92	14974.12	14978.34	5609.0
2023-05-02 08:00:00	NQ	Futures	14978.06	14984.81	14959.47	14974.4	10576.0
2023-05-02 09:00:00	NQ	Futures	14974.96	14993.54	14940.05	14965.67	75813.0
2023-05-02 10:00:00	NQ	Futures	14965.95	14979.75	14795.33	14801.24	145745.0
2023-05-02 11:00:00	NQ	Futures	14801.24	14821.8	14764.92	14779.56	111447.0
2023-05-02 12:00:00	NQ	Futures	14779.84	14841.79	14769.15	14835.31	51320.0
2023-05-02 13:00:00	NQ	Futures	14835.31	14890.21	14827.71	14870.5	52478.0
2023-05-02 14:00:00	NQ	Futures	14870.79	14874.16	14829.68	14872.19	53777.0
2023-05-02 15:00:00	NQ	Futures	14872.47	14889.65	14832.49	14848.82	76377.0
2023-05-02 16:00:00	NQ	Futures	14848.82	14856.71	14823.77	14831.37	19792.0
2023-05-02 18:00:00	NQ	Futures	14823.2	14833.34	14817.57	14826.3	2231.0
2023-05-02 19:00:00	NQ	Futures	14826.3	14847.14	14821.23	14845.45	2652.0
2023-05-02 20:00:00	NQ	Futures	14845.73	14860.37	14835.31	14855.02	3533.0
2023-05-02 21:00:00	NQ	Futures	14854.74	14856.71	14835.59	14842.07	3257.0
2023-05-02 22:00:00	NQ	Futures	14841.79	14858.4	14841.79	14852.2	2587.0
2023-05-02 23:00:00	NQ	Futures	14852.48	14856.43	14842.91	14853.33	1791.0
2023-05-02 00:00:00	YM	Futures	37741.9	37750.7	37723.1	37738.5	1036.0
2023-05-02 01:00:00	YM	Futures	37737.4	37759.5	37734.1	37736.3	884.0
2023-05-02 02:00:00	YM	Futures	37735.2	37765.1	37698.8	37756.2	1826.0
2023-05-02 03:00:00	YM	Futures	37756.2	37788.3	37695.4	37699.9	3154.0

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

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