PREVIEW / futures_1hour / 2024-09-25

all futures 1-hour files

  file:    by_date/futures_1hour/2024/2024-09-25.parquet
  size:    68 KB
  rows:    2,106

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-09-25 00:00:00	ES	Futures	6003.81	6005.63	6002.78	6003.55	2857.0
2024-09-25 01:00:00	ES	Futures	6003.3	6006.15	5996.03	5998.36	7651.0
2024-09-25 02:00:00	ES	Futures	5998.36	5999.66	5993.43	5993.95	9593.0
2024-09-25 03:00:00	ES	Futures	5994.21	6004.59	5994.21	6003.81	10800.0
2024-09-25 04:00:00	ES	Futures	6003.55	6005.37	6000.7	6002.78	8997.0
2024-09-25 05:00:00	ES	Futures	6002.78	6005.63	5999.4	6004.59	6900.0
2024-09-25 06:00:00	ES	Futures	6004.59	6011.6	6004.59	6011.34	10035.0
2024-09-25 07:00:00	ES	Futures	6011.6	6013.16	6006.93	6010.56	11121.0
2024-09-25 08:00:00	ES	Futures	6010.3	6012.12	6007.45	6010.56	13429.0
2024-09-25 09:00:00	ES	Futures	6010.56	6018.87	6008.49	6015.23	131853.0
2024-09-25 10:00:00	ES	Futures	6015.23	6019.65	6005.37	6012.12	147072.0
2024-09-25 11:00:00	ES	Futures	6012.12	6014.2	6002.78	6007.45	106714.0
2024-09-25 12:00:00	ES	Futures	6007.19	6007.97	5998.36	5999.14	91487.0
2024-09-25 13:00:00	ES	Futures	5999.14	6002.78	5987.72	6002.26	117386.0
2024-09-25 14:00:00	ES	Futures	6002.26	6003.3	5988.76	5999.66	81218.0
2024-09-25 15:00:00	ES	Futures	5999.92	6002.26	5992.4	5999.66	133859.0
2024-09-25 16:00:00	ES	Futures	5999.66	6004.85	5998.1	6003.55	50991.0
2024-09-25 18:00:00	ES	Futures	6003.81	6006.15	6000.96	6004.33	3529.0
2024-09-25 19:00:00	ES	Futures	6004.33	6011.34	6003.04	6009.52	5243.0
2024-09-25 20:00:00	ES	Futures	6009.52	6017.31	6009.26	6014.97	10514.0
2024-09-25 21:00:00	ES	Futures	6014.71	6020.16	6013.68	6018.61	6860.0
2024-09-25 22:00:00	ES	Futures	6018.61	6020.68	6017.57	6020.16	5703.0
2024-09-25 23:00:00	ES	Futures	6020.16	6027.95	6020.16	6026.65	8845.0
2024-09-25 00:00:00	NQ	Futures	21006.83	21019.1	21003.18	21007.88	1636.0
2024-09-25 01:00:00	NQ	Futures	21007.62	21018.84	20964.83	20976.31	3887.0
2024-09-25 02:00:00	NQ	Futures	20976.31	20982.31	20945.26	20949.43	4862.0
2024-09-25 03:00:00	NQ	Futures	20949.43	20994.31	20940.04	20985.7	6238.0
2024-09-25 04:00:00	NQ	Futures	20986.74	20993.01	20963.0	20973.44	5657.0
2024-09-25 05:00:00	NQ	Futures	20973.7	20990.4	20956.22	20987.27	4328.0
2024-09-25 06:00:00	NQ	Futures	20986.48	21015.18	20986.22	21009.44	7466.0
2024-09-25 07:00:00	NQ	Futures	21010.23	21020.66	20999.27	21020.14	4373.0
2024-09-25 08:00:00	NQ	Futures	21019.62	21037.88	21003.44	21028.75	7788.0
2024-09-25 09:00:00	NQ	Futures	21028.75	21117.2	21017.01	21115.11	57761.0
2024-09-25 10:00:00	NQ	Futures	21114.59	21155.81	21086.93	21112.5	64186.0
2024-09-25 11:00:00	NQ	Futures	21112.5	21129.2	21059.8	21088.76	51015.0
2024-09-25 12:00:00	NQ	Futures	21088.5	21098.41	21050.15	21059.28	33330.0
2024-09-25 13:00:00	NQ	Futures	21059.54	21084.85	21014.4	21082.5	43690.0
2024-09-25 14:00:00	NQ	Futures	21081.19	21088.5	21024.31	21071.28	29647.0
2024-09-25 15:00:00	NQ	Futures	21071.54	21081.72	21054.32	21076.24	33413.0
2024-09-25 16:00:00	NQ	Futures	21076.5	21128.68	21069.45	21125.55	17963.0
2024-09-25 18:00:00	NQ	Futures	21125.55	21139.38	21115.11	21130.77	2687.0
2024-09-25 19:00:00	NQ	Futures	21131.81	21169.38	21125.03	21162.34	3849.0
2024-09-25 20:00:00	NQ	Futures	21161.82	21202.26	21161.03	21182.69	6204.0
2024-09-25 21:00:00	NQ	Futures	21183.21	21209.04	21172.25	21204.08	3883.0
2024-09-25 22:00:00	NQ	Futures	21204.34	21219.48	21196.26	21213.48	3612.0
2024-09-25 23:00:00	NQ	Futures	21213.22	21259.66	21213.22	21252.35	4155.0
2024-09-25 00:00:00	YM	Futures	44242.4	44248.6	44230.9	44233.0	281.0
2024-09-25 01:00:00	YM	Futures	44232.0	44247.6	44192.4	44210.1	854.0
2024-09-25 02:00:00	YM	Futures	44209.1	44220.5	44192.4	44193.5	1007.0
2024-09-25 03:00:00	YM	Futures	44196.6	44271.5	44196.6	44268.4	1263.0

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

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