PREVIEW / futures_1hour / 2023-03-31

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-03-31.parquet
  size:    57 KB
  rows:    1,648

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-03-31 00:00:00	ES	Futures	4539.44	4541.66	4538.89	4539.44	3990.0
2023-03-31 01:00:00	ES	Futures	4539.44	4539.44	4531.68	4533.34	7992.0
2023-03-31 02:00:00	ES	Futures	4533.34	4535.28	4529.18	4532.23	9497.0
2023-03-31 03:00:00	ES	Futures	4531.95	4535.56	4525.58	4529.18	17275.0
2023-03-31 04:00:00	ES	Futures	4528.9	4530.84	4524.19	4528.07	13655.0
2023-03-31 05:00:00	ES	Futures	4528.35	4536.11	4527.79	4533.34	13027.0
2023-03-31 06:00:00	ES	Futures	4533.62	4535.28	4531.12	4534.73	7955.0
2023-03-31 07:00:00	ES	Futures	4534.73	4537.78	4532.79	4533.34	10917.0
2023-03-31 08:00:00	ES	Futures	4533.06	4546.93	4528.63	4538.61	62170.0
2023-03-31 09:00:00	ES	Futures	4538.61	4550.54	4535.84	4547.21	161260.0
2023-03-31 10:00:00	ES	Futures	4546.93	4556.92	4545.82	4555.53	176391.0
2023-03-31 11:00:00	ES	Futures	4555.25	4566.35	4553.59	4566.07	134268.0
2023-03-31 12:00:00	ES	Futures	4566.07	4572.73	4565.24	4567.18	117840.0
2023-03-31 13:00:00	ES	Futures	4567.46	4568.84	4561.35	4566.07	109681.0
2023-03-31 14:00:00	ES	Futures	4566.35	4572.73	4564.13	4570.51	114754.0
2023-03-31 15:00:00	ES	Futures	4570.51	4594.36	4570.23	4590.75	424238.0
2023-03-31 16:00:00	ES	Futures	4590.48	4595.75	4588.53	4592.42	124372.0
2023-03-31 00:00:00	NQ	Futures	14787.16	14796.17	14784.07	14787.16	3305.0
2023-03-31 01:00:00	NQ	Futures	14786.6	14787.73	14759.01	14765.77	4832.0
2023-03-31 02:00:00	NQ	Futures	14765.48	14773.37	14741.27	14746.9	6657.0
2023-03-31 03:00:00	NQ	Futures	14746.9	14754.22	14731.14	14747.47	9335.0
2023-03-31 04:00:00	NQ	Futures	14747.47	14749.44	14725.5	14730.57	6920.0
2023-03-31 05:00:00	NQ	Futures	14731.14	14748.87	14726.91	14731.98	6867.0
2023-03-31 06:00:00	NQ	Futures	14731.7	14732.82	14719.31	14728.32	5840.0
2023-03-31 07:00:00	NQ	Futures	14728.6	14742.4	14723.53	14724.38	6202.0
2023-03-31 08:00:00	NQ	Futures	14724.38	14784.91	14705.51	14749.44	28699.0
2023-03-31 09:00:00	NQ	Futures	14748.59	14814.19	14731.14	14798.99	68298.0
2023-03-31 10:00:00	NQ	Futures	14799.83	14855.58	14787.45	14839.53	90988.0
2023-03-31 11:00:00	NQ	Futures	14839.81	14883.17	14829.96	14880.92	63011.0
2023-03-31 12:00:00	NQ	Futures	14881.2	14910.48	14874.45	14897.25	52638.0
2023-03-31 13:00:00	NQ	Futures	14897.25	14906.54	14876.14	14898.1	39648.0
2023-03-31 14:00:00	NQ	Futures	14898.38	14924.84	14893.03	14919.49	48788.0
2023-03-31 15:00:00	NQ	Futures	14919.49	14991.57	14918.09	14980.31	126165.0
2023-03-31 16:00:00	NQ	Futures	14979.47	14990.73	14969.61	14987.63	21572.0
2023-03-31 00:00:00	YM	Futures	36587.9	36599.0	36581.3	36583.5	572.0
2023-03-31 01:00:00	YM	Futures	36584.6	36585.7	36530.4	36539.3	1407.0
2023-03-31 02:00:00	YM	Futures	36539.3	36549.2	36520.5	36545.9	2032.0
2023-03-31 03:00:00	YM	Futures	36547.0	36576.9	36485.1	36508.3	4153.0
2023-03-31 04:00:00	YM	Futures	36507.2	36542.6	36478.5	36522.7	2781.0
2023-03-31 05:00:00	YM	Futures	36523.8	36606.7	36516.1	36593.4	2995.0
2023-03-31 06:00:00	YM	Futures	36594.6	36627.7	36581.3	36611.1	2020.0
2023-03-31 07:00:00	YM	Futures	36611.1	36625.5	36591.2	36597.9	2099.0
2023-03-31 08:00:00	YM	Futures	36597.9	36691.8	36585.7	36666.4	8524.0
2023-03-31 09:00:00	YM	Futures	36665.3	36734.9	36626.6	36712.8	16640.0
2023-03-31 10:00:00	YM	Futures	36712.8	36741.6	36671.9	36723.9	14547.0
2023-03-31 11:00:00	YM	Futures	36725.0	36811.2	36712.8	36806.8	12187.0
2023-03-31 12:00:00	YM	Futures	36807.9	36880.8	36805.7	36826.7	12630.0
2023-03-31 13:00:00	YM	Futures	36827.8	36837.7	36767.0	36799.0	7720.0
2023-03-31 14:00:00	YM	Futures	36800.1	36854.3	36775.8	36831.1	8662.0
2023-03-31 15:00:00	YM	Futures	36830.0	37007.9	36830.0	36981.4	22890.0

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

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