PREVIEW / futures_1hour / 2023-10-23

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-10-23.parquet
  size:    69 KB
  rows:    2,078

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-10-23 00:00:00	ES	Futures	4622.19	4624.91	4621.92	4624.37	4276.0
2023-10-23 01:00:00	ES	Futures	4624.37	4627.35	4623.28	4625.18	5617.0
2023-10-23 02:00:00	ES	Futures	4625.45	4627.35	4623.01	4624.37	6351.0
2023-10-23 03:00:00	ES	Futures	4624.37	4624.91	4603.19	4604.82	31381.0
2023-10-23 04:00:00	ES	Futures	4604.82	4613.51	4601.83	4606.72	25678.0
2023-10-23 05:00:00	ES	Futures	4606.72	4606.72	4578.75	4580.65	49956.0
2023-10-23 06:00:00	ES	Futures	4580.65	4591.51	4579.83	4590.97	31453.0
2023-10-23 07:00:00	ES	Futures	4591.24	4600.2	4588.52	4594.5	33125.0
2023-10-23 08:00:00	ES	Futures	4594.22	4604.0	4589.34	4595.85	44583.0
2023-10-23 09:00:00	ES	Futures	4595.85	4608.62	4576.57	4607.8	274693.0
2023-10-23 10:00:00	ES	Futures	4607.8	4619.21	4601.56	4616.22	287648.0
2023-10-23 11:00:00	ES	Futures	4616.22	4633.87	4613.78	4631.7	211374.0
2023-10-23 12:00:00	ES	Futures	4631.97	4649.35	4621.38	4649.08	153821.0
2023-10-23 13:00:00	ES	Futures	4649.08	4649.89	4629.8	4633.6	154955.0
2023-10-23 14:00:00	ES	Futures	4633.33	4637.13	4622.47	4630.88	162720.0
2023-10-23 15:00:00	ES	Futures	4631.16	4635.23	4603.73	4606.17	318522.0
2023-10-23 16:00:00	ES	Futures	4605.9	4618.94	4605.9	4617.31	58852.0
2023-10-23 18:00:00	ES	Futures	4616.76	4618.66	4615.13	4617.85	4620.0
2023-10-23 19:00:00	ES	Futures	4617.85	4621.38	4617.85	4620.84	5837.0
2023-10-23 20:00:00	ES	Futures	4620.84	4621.65	4611.88	4615.13	9668.0
2023-10-23 21:00:00	ES	Futures	4615.13	4618.39	4608.07	4610.79	12578.0
2023-10-23 22:00:00	ES	Futures	4610.52	4621.38	4609.43	4618.94	10553.0
2023-10-23 23:00:00	ES	Futures	4618.94	4620.02	4615.95	4617.58	5445.0
2023-10-23 00:00:00	NQ	Futures	16138.99	16151.08	16138.17	16149.16	2452.0
2023-10-23 01:00:00	NQ	Futures	16148.88	16158.49	16142.56	16149.98	3436.0
2023-10-23 02:00:00	NQ	Futures	16149.43	16160.14	16140.09	16148.06	4661.0
2023-10-23 03:00:00	NQ	Futures	16147.78	16155.47	16074.45	16084.34	16048.0
2023-10-23 04:00:00	NQ	Futures	16084.34	16116.75	16070.6	16075.0	14539.0
2023-10-23 05:00:00	NQ	Futures	16075.0	16075.0	15953.05	15967.6	26147.0
2023-10-23 06:00:00	NQ	Futures	15967.88	16015.67	15965.68	16014.3	15329.0
2023-10-23 07:00:00	NQ	Futures	16013.75	16059.07	16001.11	16032.7	17026.0
2023-10-23 08:00:00	NQ	Futures	16032.42	16071.43	16014.57	16046.98	22079.0
2023-10-23 09:00:00	NQ	Futures	16047.26	16087.36	15946.18	16080.49	116973.0
2023-10-23 10:00:00	NQ	Futures	16080.22	16151.9	16052.47	16151.08	110662.0
2023-10-23 11:00:00	NQ	Futures	16151.35	16224.14	16137.89	16214.53	80677.0
2023-10-23 12:00:00	NQ	Futures	16214.53	16316.98	16199.97	16316.43	64433.0
2023-10-23 13:00:00	NQ	Futures	16316.15	16319.17	16238.7	16258.47	63905.0
2023-10-23 14:00:00	NQ	Futures	16258.47	16280.99	16217.27	16237.05	62209.0
2023-10-23 15:00:00	NQ	Futures	16236.77	16260.94	16149.43	16156.85	93200.0
2023-10-23 16:00:00	NQ	Futures	16157.12	16208.48	16155.2	16204.09	15384.0
2023-10-23 18:00:00	NQ	Futures	16198.6	16208.21	16190.9	16200.24	3185.0
2023-10-23 19:00:00	NQ	Futures	16199.97	16219.47	16199.42	16219.2	2829.0
2023-10-23 20:00:00	NQ	Futures	16218.1	16219.47	16178.0	16192.28	5261.0
2023-10-23 21:00:00	NQ	Futures	16193.93	16206.84	16172.23	16182.66	5999.0
2023-10-23 22:00:00	NQ	Futures	16182.66	16224.69	16178.54	16212.88	5142.0
2023-10-23 23:00:00	NQ	Futures	16212.88	16218.37	16202.17	16210.13	2775.0
2023-10-23 00:00:00	YM	Futures	36112.8	36125.8	36107.4	36122.5	853.0
2023-10-23 01:00:00	YM	Futures	36122.5	36144.2	36117.1	36126.9	956.0
2023-10-23 02:00:00	YM	Futures	36128.0	36143.2	36114.9	36123.6	1581.0
2023-10-23 03:00:00	YM	Futures	36123.6	36123.6	35973.9	35975.0	5238.0

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

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