PREVIEW / futures_1hour / 2024-06-06

all futures 1-hour files

  file:    by_date/futures_1hour/2024/2024-06-06.parquet
  size:    64 KB
  rows:    2,023

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
2024-06-06 00:00:00	ES	Futures	5698.55	5698.55	5696.69	5697.49	1978.0
2024-06-06 01:00:00	ES	Futures	5697.76	5697.76	5693.25	5694.04	5550.0
2024-06-06 02:00:00	ES	Futures	5694.31	5695.37	5691.12	5695.1	8298.0
2024-06-06 03:00:00	ES	Futures	5695.1	5696.69	5691.39	5694.57	11797.0
2024-06-06 04:00:00	ES	Futures	5694.57	5698.29	5692.45	5692.72	11933.0
2024-06-06 05:00:00	ES	Futures	5692.72	5695.1	5690.59	5692.45	8641.0
2024-06-06 06:00:00	ES	Futures	5692.45	5694.84	5692.18	5694.31	5618.0
2024-06-06 07:00:00	ES	Futures	5694.31	5696.43	5693.51	5695.9	8813.0
2024-06-06 08:00:00	ES	Futures	5695.9	5700.14	5686.35	5694.31	45839.0
2024-06-06 09:00:00	ES	Futures	5694.31	5702.0	5690.33	5690.59	167116.0
2024-06-06 10:00:00	ES	Futures	5690.86	5699.61	5690.59	5691.65	176312.0
2024-06-06 11:00:00	ES	Futures	5691.92	5695.1	5687.41	5688.21	110379.0
2024-06-06 12:00:00	ES	Futures	5688.21	5689.8	5678.65	5680.78	124110.0
2024-06-06 13:00:00	ES	Futures	5680.78	5691.65	5679.19	5688.47	100510.0
2024-06-06 14:00:00	ES	Futures	5688.74	5692.72	5672.29	5690.86	145523.0
2024-06-06 15:00:00	ES	Futures	5690.86	5694.31	5686.61	5693.51	177027.0
2024-06-06 16:00:00	ES	Futures	5693.78	5693.78	5687.41	5691.39	37927.0
2024-06-06 18:00:00	ES	Futures	5690.06	5693.25	5689.27	5692.72	2982.0
2024-06-06 19:00:00	ES	Futures	5692.45	5693.51	5691.39	5692.45	1907.0
2024-06-06 20:00:00	ES	Futures	5692.45	5693.78	5691.12	5693.51	3515.0
2024-06-06 21:00:00	ES	Futures	5693.78	5696.16	5692.72	5695.37	4153.0
2024-06-06 22:00:00	ES	Futures	5695.1	5697.49	5694.57	5696.96	3280.0
2024-06-06 23:00:00	ES	Futures	5696.96	5697.23	5694.84	5695.1	2543.0
2024-06-06 00:00:00	NQ	Futures	20436.77	20438.11	20428.21	20436.77	1780.0
2024-06-06 01:00:00	NQ	Futures	20437.04	20437.31	20417.78	20422.06	2765.0
2024-06-06 02:00:00	NQ	Futures	20421.26	20428.48	20409.22	20426.88	4427.0
2024-06-06 03:00:00	NQ	Futures	20427.41	20441.32	20415.37	20429.82	6122.0
2024-06-06 04:00:00	NQ	Futures	20430.35	20446.67	20424.47	20427.41	6253.0
2024-06-06 05:00:00	NQ	Futures	20427.41	20440.52	20407.88	20417.51	5145.0
2024-06-06 06:00:00	NQ	Futures	20417.51	20434.1	20415.64	20426.61	3722.0
2024-06-06 07:00:00	NQ	Futures	20427.14	20438.65	20423.4	20434.9	4336.0
2024-06-06 08:00:00	NQ	Futures	20434.63	20463.52	20391.3	20430.09	23562.0
2024-06-06 09:00:00	NQ	Futures	20429.82	20454.16	20364.81	20366.42	84304.0
2024-06-06 10:00:00	NQ	Futures	20366.42	20444.26	20364.81	20418.05	84847.0
2024-06-06 11:00:00	NQ	Futures	20418.85	20432.76	20385.95	20397.98	48022.0
2024-06-06 12:00:00	NQ	Futures	20398.25	20412.7	20368.02	20391.3	46100.0
2024-06-06 13:00:00	NQ	Futures	20390.76	20427.14	20382.74	20407.61	41267.0
2024-06-06 14:00:00	NQ	Futures	20407.61	20413.5	20348.76	20400.93	55478.0
2024-06-06 15:00:00	NQ	Futures	20400.93	20410.56	20373.91	20400.66	60025.0
2024-06-06 16:00:00	NQ	Futures	20400.66	20406.01	20377.92	20404.14	13663.0
2024-06-06 18:00:00	NQ	Futures	20398.79	20416.44	20393.17	20414.84	2281.0
2024-06-06 19:00:00	NQ	Futures	20415.1	20416.17	20407.61	20410.56	1426.0
2024-06-06 20:00:00	NQ	Futures	20410.82	20417.24	20402.53	20414.3	2206.0
2024-06-06 21:00:00	NQ	Futures	20415.1	20423.13	20408.95	20417.78	2277.0
2024-06-06 22:00:00	NQ	Futures	20417.51	20424.47	20414.57	20423.4	1728.0
2024-06-06 23:00:00	NQ	Futures	20423.4	20426.34	20415.1	20418.31	1424.0
2024-06-06 00:00:00	YM	Futures	41292.8	41293.9	41274.7	41277.9	571.0
2024-06-06 01:00:00	YM	Futures	41276.9	41277.9	41262.0	41266.2	914.0
2024-06-06 02:00:00	YM	Futures	41266.2	41277.9	41251.4	41264.1	1518.0
2024-06-06 03:00:00	YM	Futures	41263.1	41279.0	41236.5	41251.4	1493.0

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

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