PREVIEW / futures_1hour / 2023-06-21

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-06-21.parquet
  size:    66 KB
  rows:    2,045

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-06-21 00:00:00	ES	Futures	4869.01	4871.2	4868.73	4871.2	2272.0
2023-06-21 01:00:00	ES	Futures	4871.2	4871.48	4865.99	4867.09	5030.0
2023-06-21 02:00:00	ES	Futures	4867.09	4867.91	4860.77	4861.6	10743.0
2023-06-21 03:00:00	ES	Futures	4861.6	4867.91	4857.48	4864.62	19349.0
2023-06-21 04:00:00	ES	Futures	4864.34	4870.66	4863.24	4867.64	12399.0
2023-06-21 05:00:00	ES	Futures	4867.64	4870.93	4864.62	4868.73	9374.0
2023-06-21 06:00:00	ES	Futures	4868.73	4872.58	4867.09	4868.46	8646.0
2023-06-21 07:00:00	ES	Futures	4868.19	4869.01	4863.79	4865.44	10407.0
2023-06-21 08:00:00	ES	Futures	4865.44	4865.44	4853.09	4855.28	36035.0
2023-06-21 09:00:00	ES	Futures	4855.56	4857.2	4841.01	4845.13	166199.0
2023-06-21 10:00:00	ES	Futures	4845.13	4851.71	4835.24	4845.68	248072.0
2023-06-21 11:00:00	ES	Futures	4845.4	4854.46	4836.07	4844.03	185475.0
2023-06-21 12:00:00	ES	Futures	4844.03	4856.38	4843.2	4846.22	123433.0
2023-06-21 13:00:00	ES	Futures	4846.5	4852.81	4840.73	4852.54	102118.0
2023-06-21 14:00:00	ES	Futures	4852.54	4865.17	4851.17	4859.68	125576.0
2023-06-21 15:00:00	ES	Futures	4859.68	4859.68	4838.26	4841.83	254372.0
2023-06-21 16:00:00	ES	Futures	4841.83	4845.4	4840.46	4842.38	52971.0
2023-06-21 18:00:00	ES	Futures	4842.38	4845.4	4839.91	4841.28	5123.0
2023-06-21 19:00:00	ES	Futures	4841.56	4844.58	4841.28	4842.93	2648.0
2023-06-21 20:00:00	ES	Futures	4842.93	4846.22	4841.28	4842.38	5710.0
2023-06-21 21:00:00	ES	Futures	4842.66	4843.48	4838.26	4838.81	5250.0
2023-06-21 22:00:00	ES	Futures	4838.81	4839.36	4833.87	4838.54	7522.0
2023-06-21 23:00:00	ES	Futures	4838.54	4840.73	4836.34	4840.46	4693.0
2023-06-21 00:00:00	NQ	Futures	16971.01	16979.07	16967.95	16977.68	1675.0
2023-06-21 01:00:00	NQ	Futures	16977.68	16983.52	16960.16	16964.61	3241.0
2023-06-21 02:00:00	NQ	Futures	16963.77	16965.17	16937.91	16941.25	6043.0
2023-06-21 03:00:00	NQ	Futures	16940.69	16960.16	16927.06	16941.8	7856.0
2023-06-21 04:00:00	NQ	Futures	16942.08	16976.85	16938.46	16962.38	6457.0
2023-06-21 05:00:00	NQ	Futures	16962.66	16971.56	16946.53	16963.22	4469.0
2023-06-21 06:00:00	NQ	Futures	16962.66	16976.85	16951.81	16958.21	4784.0
2023-06-21 07:00:00	NQ	Futures	16957.66	16962.38	16932.9	16942.64	5469.0
2023-06-21 08:00:00	NQ	Futures	16942.64	16942.64	16894.52	16910.93	20127.0
2023-06-21 09:00:00	NQ	Futures	16911.21	16931.79	16817.48	16829.99	86515.0
2023-06-21 10:00:00	NQ	Futures	16829.44	16840.28	16729.87	16751.84	120123.0
2023-06-21 11:00:00	NQ	Futures	16751.84	16784.66	16690.37	16719.58	84013.0
2023-06-21 12:00:00	NQ	Futures	16719.85	16789.94	16716.52	16756.57	55666.0
2023-06-21 13:00:00	NQ	Futures	16756.57	16793.0	16733.48	16790.5	45176.0
2023-06-21 14:00:00	NQ	Futures	16791.06	16854.47	16779.93	16831.38	58772.0
2023-06-21 15:00:00	NQ	Futures	16831.11	16831.66	16724.86	16738.21	81532.0
2023-06-21 16:00:00	NQ	Futures	16738.49	16756.57	16727.64	16730.14	17224.0
2023-06-21 18:00:00	NQ	Futures	16730.98	16742.66	16714.85	16722.08	3261.0
2023-06-21 19:00:00	NQ	Futures	16722.63	16736.82	16722.36	16733.48	2246.0
2023-06-21 20:00:00	NQ	Futures	16733.76	16752.39	16722.91	16728.75	4036.0
2023-06-21 21:00:00	NQ	Futures	16729.03	16734.59	16710.4	16717.07	3979.0
2023-06-21 22:00:00	NQ	Futures	16717.63	16719.58	16698.16	16717.63	4468.0
2023-06-21 23:00:00	NQ	Futures	16717.35	16722.63	16706.5	16719.85	3462.0
2023-06-21 00:00:00	YM	Futures	37632.0	37646.2	37628.7	37646.2	526.0
2023-06-21 01:00:00	YM	Futures	37646.2	37647.3	37613.4	37626.5	737.0
2023-06-21 02:00:00	YM	Futures	37624.3	37626.5	37580.5	37583.8	2125.0
2023-06-21 03:00:00	YM	Futures	37582.7	37634.2	37556.4	37618.8	3449.0

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

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