PREVIEW / futures_1hour / 2025-07-01

all futures 1-hour files

  file:    by_date/futures_1hour/2025/2025-07-01.parquet
  size:    65 KB
  rows:    2,043

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
2025-07-01 00:00:00	ES	Futures	6293.84	6295.61	6290.32	6291.07	4461.0
2025-07-01 01:00:00	ES	Futures	6291.07	6293.09	6288.3	6290.32	5226.0
2025-07-01 02:00:00	ES	Futures	6290.07	6291.33	6287.04	6290.32	7624.0
2025-07-01 03:00:00	ES	Futures	6290.32	6297.37	6284.78	6290.57	14310.0
2025-07-01 04:00:00	ES	Futures	6290.57	6293.84	6285.28	6290.82	13057.0
2025-07-01 05:00:00	ES	Futures	6290.57	6291.33	6283.01	6287.8	10648.0
2025-07-01 06:00:00	ES	Futures	6288.05	6290.07	6285.28	6288.3	6606.0
2025-07-01 07:00:00	ES	Futures	6288.3	6290.32	6284.02	6287.55	11912.0
2025-07-01 08:00:00	ES	Futures	6287.55	6289.06	6273.95	6281.0	30279.0
2025-07-01 09:00:00	ES	Futures	6281.0	6296.36	6278.48	6290.82	116174.0
2025-07-01 10:00:00	ES	Futures	6290.82	6299.89	6279.99	6284.27	202351.0
2025-07-01 11:00:00	ES	Futures	6284.02	6294.6	6274.2	6288.81	189215.0
2025-07-01 12:00:00	ES	Futures	6288.81	6301.15	6286.54	6290.32	136573.0
2025-07-01 13:00:00	ES	Futures	6290.32	6308.45	6289.31	6305.68	103481.0
2025-07-01 14:00:00	ES	Futures	6305.93	6307.19	6299.13	6299.89	78169.0
2025-07-01 15:00:00	ES	Futures	6299.64	6307.7	6286.79	6295.86	256595.0
2025-07-01 16:00:00	ES	Futures	6295.86	6296.87	6290.82	6295.1	44297.0
2025-07-01 18:00:00	ES	Futures	6294.6	6300.9	6291.83	6300.65	4965.0
2025-07-01 19:00:00	ES	Futures	6300.9	6301.9	6297.37	6298.88	2582.0
2025-07-01 20:00:00	ES	Futures	6298.88	6301.9	6298.38	6300.14	3499.0
2025-07-01 21:00:00	ES	Futures	6300.14	6300.65	6294.35	6294.6	3555.0
2025-07-01 22:00:00	ES	Futures	6294.6	6305.93	6291.83	6305.68	5828.0
2025-07-01 23:00:00	ES	Futures	6305.93	6307.7	6304.93	6306.19	3567.0
2025-07-01 00:00:00	NQ	Futures	23072.22	23077.26	23053.05	23056.33	2489.0
2025-07-01 01:00:00	NQ	Futures	23056.58	23060.87	23036.15	23040.44	3746.0
2025-07-01 02:00:00	NQ	Futures	23040.44	23046.24	23026.07	23039.43	3421.0
2025-07-01 03:00:00	NQ	Futures	23039.94	23064.9	23021.53	23041.7	6057.0
2025-07-01 04:00:00	NQ	Futures	23042.96	23057.34	23016.99	23045.48	6068.0
2025-07-01 05:00:00	NQ	Futures	23044.22	23048.51	23011.44	23029.6	5509.0
2025-07-01 06:00:00	NQ	Futures	23029.6	23038.93	23023.8	23037.42	2471.0
2025-07-01 07:00:00	NQ	Futures	23036.66	23047.5	23007.41	23024.81	6027.0
2025-07-01 08:00:00	NQ	Futures	23024.55	23032.37	22953.94	22992.78	13938.0
2025-07-01 09:00:00	NQ	Futures	22992.53	23033.13	22978.41	23013.71	48272.0
2025-07-01 10:00:00	NQ	Futures	23008.67	23047.25	22871.99	22885.6	85861.0
2025-07-01 11:00:00	NQ	Futures	22885.1	22915.87	22791.29	22856.6	82529.0
2025-07-01 12:00:00	NQ	Futures	22857.11	22937.55	22828.86	22898.47	50847.0
2025-07-01 13:00:00	NQ	Futures	22898.97	22960.5	22898.97	22940.58	35931.0
2025-07-01 14:00:00	NQ	Futures	22940.58	22951.67	22898.72	22900.23	29607.0
2025-07-01 15:00:00	NQ	Futures	22899.98	22943.35	22844.5	22890.4	68242.0
2025-07-01 16:00:00	NQ	Futures	22890.65	22895.94	22868.71	22889.39	12429.0
2025-07-01 18:00:00	NQ	Futures	22892.16	22920.91	22880.56	22920.15	3580.0
2025-07-01 19:00:00	NQ	Futures	22919.9	22926.96	22899.98	22906.28	2707.0
2025-07-01 20:00:00	NQ	Futures	22907.54	22920.91	22903.0	22910.82	2431.0
2025-07-01 21:00:00	NQ	Futures	22911.07	22916.12	22886.11	22887.62	2761.0
2025-07-01 22:00:00	NQ	Futures	22887.12	22937.81	22873.0	22937.81	5112.0
2025-07-01 23:00:00	NQ	Futures	22937.81	22944.11	22929.99	22937.55	2744.0
2025-07-01 00:00:00	YM	Futures	45306.7	45329.2	45287.3	45291.4	440.0
2025-07-01 01:00:00	YM	Futures	45291.4	45321.0	45282.2	45301.6	683.0
2025-07-01 02:00:00	YM	Futures	45301.6	45313.9	45281.2	45303.6	845.0
2025-07-01 03:00:00	YM	Futures	45303.6	45358.8	45278.1	45315.9	1333.0

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

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