PREVIEW / futures_1hour / 2023-08-11

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-08-11.parquet
  size:    55 KB
  rows:    1,611

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-08-11 00:00:00	ES	Futures	4924.73	4925.01	4922.26	4923.91	3579.0
2023-08-11 01:00:00	ES	Futures	4923.64	4929.68	4921.99	4928.85	5299.0
2023-08-11 02:00:00	ES	Futures	4928.85	4931.32	4923.91	4930.22	8321.0
2023-08-11 03:00:00	ES	Futures	4929.95	4935.17	4927.48	4928.58	16358.0
2023-08-11 04:00:00	ES	Futures	4928.85	4929.13	4916.5	4920.89	20646.0
2023-08-11 05:00:00	ES	Futures	4920.89	4926.66	4914.85	4918.42	14696.0
2023-08-11 06:00:00	ES	Futures	4918.42	4926.66	4917.32	4920.89	10541.0
2023-08-11 07:00:00	ES	Futures	4920.62	4926.93	4919.52	4921.17	12699.0
2023-08-11 08:00:00	ES	Futures	4921.17	4925.28	4904.42	4905.52	58265.0
2023-08-11 09:00:00	ES	Futures	4905.24	4913.21	4896.19	4905.52	190543.0
2023-08-11 10:00:00	ES	Futures	4905.52	4933.52	4905.24	4917.87	266737.0
2023-08-11 11:00:00	ES	Futures	4917.87	4921.99	4907.17	4918.15	167949.0
2023-08-11 12:00:00	ES	Futures	4918.15	4925.01	4909.09	4911.28	125595.0
2023-08-11 13:00:00	ES	Futures	4911.56	4921.44	4908.54	4914.03	119255.0
2023-08-11 14:00:00	ES	Futures	4914.3	4928.58	4912.93	4926.66	132820.0
2023-08-11 15:00:00	ES	Futures	4926.38	4927.75	4914.58	4921.44	226443.0
2023-08-11 16:00:00	ES	Futures	4921.71	4926.38	4921.17	4923.91	46820.0
2023-08-11 00:00:00	NQ	Futures	16922.89	16924.56	16910.1	16915.66	2978.0
2023-08-11 01:00:00	NQ	Futures	16915.66	16942.91	16906.48	16937.07	4191.0
2023-08-11 02:00:00	NQ	Futures	16937.07	16945.97	16913.43	16940.41	5036.0
2023-08-11 03:00:00	NQ	Futures	16940.97	16956.82	16926.78	16927.06	8409.0
2023-08-11 04:00:00	NQ	Futures	16927.62	16929.56	16861.42	16879.22	12343.0
2023-08-11 05:00:00	NQ	Futures	16880.06	16906.2	16846.4	16864.48	9449.0
2023-08-11 06:00:00	NQ	Futures	16863.37	16895.63	16859.2	16872.55	6734.0
2023-08-11 07:00:00	NQ	Futures	16872.27	16902.59	16871.44	16881.73	7921.0
2023-08-11 08:00:00	NQ	Futures	16881.17	16895.35	16781.04	16795.23	31672.0
2023-08-11 09:00:00	NQ	Futures	16795.23	16820.26	16745.72	16765.75	81008.0
2023-08-11 10:00:00	NQ	Futures	16767.14	16881.73	16764.63	16800.51	108100.0
2023-08-11 11:00:00	NQ	Futures	16800.51	16818.03	16729.31	16779.65	78424.0
2023-08-11 12:00:00	NQ	Futures	16779.93	16820.54	16745.16	16758.79	52559.0
2023-08-11 13:00:00	NQ	Futures	16759.07	16808.02	16746.83	16782.15	48961.0
2023-08-11 14:00:00	NQ	Futures	16782.43	16841.4	16777.15	16831.38	52285.0
2023-08-11 15:00:00	NQ	Futures	16831.11	16833.33	16777.7	16800.23	66951.0
2023-08-11 16:00:00	NQ	Futures	16800.23	16816.92	16799.96	16803.29	9648.0
2023-08-11 00:00:00	YM	Futures	38618.0	38620.2	38600.4	38609.2	630.0
2023-08-11 01:00:00	YM	Futures	38609.2	38653.0	38599.3	38647.5	792.0
2023-08-11 02:00:00	YM	Futures	38647.5	38666.2	38616.9	38650.8	2122.0
2023-08-11 03:00:00	YM	Futures	38650.8	38696.8	38637.7	38649.7	2613.0
2023-08-11 04:00:00	YM	Futures	38649.7	38654.1	38578.5	38626.7	3574.0
2023-08-11 05:00:00	YM	Futures	38626.7	38658.5	38586.2	38605.9	2817.0
2023-08-11 06:00:00	YM	Futures	38604.8	38662.9	38597.2	38616.9	2305.0
2023-08-11 07:00:00	YM	Futures	38615.8	38651.9	38604.8	38616.9	2051.0
2023-08-11 08:00:00	YM	Futures	38614.7	38643.2	38512.8	38523.8	6694.0
2023-08-11 09:00:00	YM	Futures	38522.7	38602.6	38470.1	38590.6	20245.0
2023-08-11 10:00:00	YM	Futures	38590.6	38816.3	38590.6	38708.9	27471.0
2023-08-11 11:00:00	YM	Futures	38708.9	38727.5	38636.6	38725.3	13309.0
2023-08-11 12:00:00	YM	Futures	38725.3	38754.9	38641.0	38662.9	9405.0
2023-08-11 13:00:00	YM	Futures	38662.9	38718.8	38624.5	38664.0	10152.0
2023-08-11 14:00:00	YM	Futures	38666.2	38770.2	38657.4	38759.3	10018.0
2023-08-11 15:00:00	YM	Futures	38757.1	38771.3	38689.2	38738.5	17266.0

> showing 50 of 1,611 rows — these rows as CSV

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