PREVIEW / futures_1hour / 2023-03-06

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-03-06.parquet
  size:    64 KB
  rows:    2,010

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-06 00:00:00	ES	Futures	4534.94	4536.9	4533.54	4536.06	3971.0
2023-03-06 01:00:00	ES	Futures	4535.78	4537.46	4533.54	4537.46	4571.0
2023-03-06 02:00:00	ES	Futures	4537.46	4538.85	4531.58	4534.38	10340.0
2023-03-06 03:00:00	ES	Futures	4534.66	4538.29	4527.67	4534.38	22331.0
2023-03-06 04:00:00	ES	Futures	4534.38	4534.94	4526.55	4528.51	22196.0
2023-03-06 05:00:00	ES	Futures	4528.51	4532.42	4525.15	4530.74	15716.0
2023-03-06 06:00:00	ES	Futures	4531.02	4533.54	4522.36	4523.75	22166.0
2023-03-06 07:00:00	ES	Futures	4523.47	4531.86	4523.2	4531.86	21692.0
2023-03-06 08:00:00	ES	Futures	4531.58	4545.28	4529.07	4539.69	47425.0
2023-03-06 09:00:00	ES	Futures	4539.69	4548.08	4535.5	4546.68	192357.0
2023-03-06 10:00:00	ES	Futures	4546.68	4564.86	4540.53	4556.47	252163.0
2023-03-06 11:00:00	ES	Futures	4556.47	4565.98	4551.99	4558.43	136652.0
2023-03-06 12:00:00	ES	Futures	4558.15	4565.14	4544.72	4547.52	125405.0
2023-03-06 13:00:00	ES	Futures	4547.52	4548.36	4533.54	4536.62	138567.0
2023-03-06 14:00:00	ES	Futures	4536.62	4542.21	4533.26	4534.94	129401.0
2023-03-06 15:00:00	ES	Futures	4534.94	4538.29	4527.39	4532.14	219449.0
2023-03-06 16:00:00	ES	Futures	4532.14	4535.22	4531.58	4533.82	43747.0
2023-03-06 18:00:00	ES	Futures	4533.82	4536.06	4531.02	4534.94	5373.0
2023-03-06 19:00:00	ES	Futures	4534.66	4537.73	4533.54	4535.5	6407.0
2023-03-06 20:00:00	ES	Futures	4535.5	4542.77	4533.26	4542.49	9009.0
2023-03-06 21:00:00	ES	Futures	4542.49	4545.0	4538.57	4539.41	10798.0
2023-03-06 22:00:00	ES	Futures	4539.41	4542.49	4539.13	4542.21	5437.0
2023-03-06 23:00:00	ES	Futures	4542.21	4543.89	4541.09	4542.21	3619.0
2023-03-06 00:00:00	NQ	Futures	14044.05	14053.44	14038.93	14045.47	2048.0
2023-03-06 01:00:00	NQ	Futures	14046.04	14059.41	14037.51	14059.41	2130.0
2023-03-06 02:00:00	NQ	Futures	14059.13	14064.25	14028.4	14046.04	6970.0
2023-03-06 03:00:00	NQ	Futures	14046.61	14056.0	14007.35	14042.34	10415.0
2023-03-06 04:00:00	NQ	Futures	14042.91	14048.03	14001.38	14008.2	8546.0
2023-03-06 05:00:00	NQ	Futures	14007.92	14031.53	14001.66	14028.4	5908.0
2023-03-06 06:00:00	NQ	Futures	14029.26	14042.63	13991.99	13998.53	8184.0
2023-03-06 07:00:00	NQ	Futures	13998.81	14030.68	13998.25	14030.68	7172.0
2023-03-06 08:00:00	NQ	Futures	14030.39	14090.71	14023.85	14074.49	20384.0
2023-03-06 09:00:00	NQ	Futures	14074.49	14106.92	14050.88	14091.56	84268.0
2023-03-06 10:00:00	NQ	Futures	14090.71	14195.12	14063.39	14173.49	89383.0
2023-03-06 11:00:00	NQ	Futures	14173.78	14209.06	14155.29	14179.18	64970.0
2023-03-06 12:00:00	NQ	Futures	14179.47	14188.86	14092.7	14107.49	54937.0
2023-03-06 13:00:00	NQ	Futures	14107.78	14118.59	14059.13	14067.66	55102.0
2023-03-06 14:00:00	NQ	Futures	14067.95	14087.86	14041.2	14049.17	56503.0
2023-03-06 15:00:00	NQ	Futures	14049.45	14062.83	14013.32	14024.13	80200.0
2023-03-06 16:00:00	NQ	Futures	14024.42	14028.4	14015.6	14021.29	11361.0
2023-03-06 18:00:00	NQ	Futures	14020.15	14036.37	14011.05	14031.82	3314.0
2023-03-06 19:00:00	NQ	Futures	14031.82	14039.78	14024.7	14032.1	3915.0
2023-03-06 20:00:00	NQ	Futures	14032.1	14066.81	14022.43	14065.96	5220.0
2023-03-06 21:00:00	NQ	Futures	14066.52	14078.19	14055.14	14058.56	5040.0
2023-03-06 22:00:00	NQ	Futures	14058.56	14073.64	14054.58	14071.08	2480.0
2023-03-06 23:00:00	NQ	Futures	14071.65	14080.75	14067.09	14073.92	2389.0
2023-03-06 00:00:00	YM	Futures	37236.0	37246.0	37228.2	37242.6	396.0
2023-03-06 01:00:00	YM	Futures	37242.6	37252.7	37222.6	37242.6	590.0
2023-03-06 02:00:00	YM	Futures	37244.9	37253.8	37208.1	37223.7	1652.0
2023-03-06 03:00:00	YM	Futures	37224.8	37264.9	37195.8	37237.1	2668.0

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

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