PREVIEW / futures_1hour / 2023-03-23

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-03-23.parquet
  size:    70 KB
  rows:    2,063

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-23 00:00:00	ES	Futures	4424.9	4427.39	4423.23	4426.84	4087.0
2023-03-23 01:00:00	ES	Futures	4426.56	4433.49	4424.06	4430.72	9601.0
2023-03-23 02:00:00	ES	Futures	4430.72	4432.11	4426.28	4428.5	10065.0
2023-03-23 03:00:00	ES	Futures	4428.5	4436.54	4426.84	4434.05	16700.0
2023-03-23 04:00:00	ES	Futures	4434.05	4439.04	4432.38	4435.44	35632.0
2023-03-23 05:00:00	ES	Futures	4435.71	4436.27	4422.95	4426.01	22115.0
2023-03-23 06:00:00	ES	Futures	4426.01	4427.39	4412.42	4423.23	24559.0
2023-03-23 07:00:00	ES	Futures	4422.95	4432.11	4422.12	4428.5	21945.0
2023-03-23 08:00:00	ES	Futures	4428.22	4434.05	4421.29	4425.17	36889.0
2023-03-23 09:00:00	ES	Futures	4425.17	4446.25	4418.24	4443.76	189231.0
2023-03-23 10:00:00	ES	Futures	4443.48	4473.16	4442.65	4471.77	252347.0
2023-03-23 11:00:00	ES	Futures	4471.77	4481.48	4464.56	4467.61	187620.0
2023-03-23 12:00:00	ES	Futures	4467.33	4470.94	4450.69	4453.19	163514.0
2023-03-23 13:00:00	ES	Futures	4453.46	4457.07	4429.33	4431.0	222742.0
2023-03-23 14:00:00	ES	Futures	4431.28	4437.1	4382.46	4402.15	326825.0
2023-03-23 15:00:00	ES	Futures	4402.43	4432.38	4380.52	4410.75	489531.0
2023-03-23 16:00:00	ES	Futures	4410.75	4431.28	4408.81	4423.79	85408.0
2023-03-23 18:00:00	ES	Futures	4425.17	4427.67	4413.52	4416.3	8763.0
2023-03-23 19:00:00	ES	Futures	4416.3	4422.12	4415.47	4420.46	7931.0
2023-03-23 20:00:00	ES	Futures	4420.46	4420.74	4414.08	4416.3	8824.0
2023-03-23 21:00:00	ES	Futures	4416.3	4416.58	4405.48	4413.25	16494.0
2023-03-23 22:00:00	ES	Futures	4413.52	4419.9	4412.42	4415.19	7953.0
2023-03-23 23:00:00	ES	Futures	4415.47	4419.35	4414.36	4417.41	5221.0
2023-03-23 00:00:00	NQ	Futures	14382.01	14385.67	14373.84	14383.98	2081.0
2023-03-23 01:00:00	NQ	Futures	14383.98	14411.01	14374.69	14402.84	4638.0
2023-03-23 02:00:00	NQ	Futures	14402.28	14421.15	14390.17	14409.88	6487.0
2023-03-23 03:00:00	NQ	Futures	14409.6	14437.48	14402.28	14427.9	7940.0
2023-03-23 04:00:00	NQ	Futures	14427.62	14477.74	14424.52	14462.25	14491.0
2023-03-23 05:00:00	NQ	Futures	14462.25	14464.79	14431.28	14454.09	9740.0
2023-03-23 06:00:00	NQ	Futures	14454.09	14460.56	14405.94	14443.39	10546.0
2023-03-23 07:00:00	NQ	Futures	14442.83	14456.9	14429.03	14441.98	9283.0
2023-03-23 08:00:00	NQ	Futures	14441.98	14466.19	14416.08	14441.14	17965.0
2023-03-23 09:00:00	NQ	Futures	14440.29	14524.19	14418.89	14516.59	79189.0
2023-03-23 10:00:00	NQ	Futures	14516.59	14647.51	14512.93	14636.53	112180.0
2023-03-23 11:00:00	NQ	Futures	14636.82	14675.67	14604.72	14627.24	77230.0
2023-03-23 12:00:00	NQ	Futures	14626.96	14644.14	14581.91	14595.43	60039.0
2023-03-23 13:00:00	NQ	Futures	14595.71	14615.42	14513.78	14520.82	79759.0
2023-03-23 14:00:00	NQ	Futures	14520.82	14543.34	14343.72	14420.58	115356.0
2023-03-23 15:00:00	NQ	Futures	14420.86	14542.21	14340.62	14468.73	167007.0
2023-03-23 16:00:00	NQ	Futures	14468.73	14520.25	14445.36	14497.16	21803.0
2023-03-23 18:00:00	NQ	Futures	14496.04	14506.74	14455.49	14468.73	4251.0
2023-03-23 19:00:00	NQ	Futures	14467.88	14492.94	14465.63	14488.44	3789.0
2023-03-23 20:00:00	NQ	Futures	14488.72	14490.13	14467.88	14478.58	3488.0
2023-03-23 21:00:00	NQ	Futures	14477.74	14479.71	14440.57	14469.85	6441.0
2023-03-23 22:00:00	NQ	Futures	14470.42	14495.76	14467.32	14474.92	4349.0
2023-03-23 23:00:00	NQ	Futures	14475.2	14490.41	14471.83	14484.49	2379.0
2023-03-23 00:00:00	YM	Futures	35803.1	35824.2	35791.0	35819.7	676.0
2023-03-23 01:00:00	YM	Futures	35820.8	35860.6	35800.9	35844.0	1328.0
2023-03-23 02:00:00	YM	Futures	35842.9	35845.2	35797.6	35806.5	1676.0
2023-03-23 03:00:00	YM	Futures	35805.4	35867.3	35794.3	35844.0	2742.0

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

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