PREVIEW / futures_1hour / 2023-08-20

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-08-20.parquet
  size:    19 KB
  rows:    411

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-20 18:00:00	ES	Futures	4812.18	4817.95	4811.36	4814.38	6973.0
2023-08-20 19:00:00	ES	Futures	4814.38	4816.58	4811.36	4816.3	4605.0
2023-08-20 20:00:00	ES	Futures	4816.3	4820.69	4814.11	4819.05	7411.0
2023-08-20 21:00:00	ES	Futures	4818.77	4818.77	4807.79	4813.56	16210.0
2023-08-20 22:00:00	ES	Futures	4813.28	4819.32	4812.46	4817.68	7345.0
2023-08-20 23:00:00	ES	Futures	4817.68	4818.77	4813.56	4814.66	3662.0
2023-08-20 18:00:00	NQ	Futures	16423.64	16452.01	16411.96	16433.93	5200.0
2023-08-20 19:00:00	NQ	Futures	16434.21	16443.11	16421.42	16442.0	3571.0
2023-08-20 20:00:00	NQ	Futures	16442.0	16460.08	16430.6	16452.01	4516.0
2023-08-20 21:00:00	NQ	Futures	16451.18	16451.18	16392.49	16415.02	9133.0
2023-08-20 22:00:00	NQ	Futures	16415.3	16443.11	16409.46	16435.33	3855.0
2023-08-20 23:00:00	NQ	Futures	16435.05	16441.44	16418.92	16425.31	2195.0
2023-08-20 18:00:00	YM	Futures	37867.5	37888.3	37856.6	37864.2	1073.0
2023-08-20 19:00:00	YM	Futures	37863.1	37879.6	37845.6	37878.5	516.0
2023-08-20 20:00:00	YM	Futures	37877.4	37908.1	37866.4	37898.2	1069.0
2023-08-20 21:00:00	YM	Futures	37896.0	37897.1	37831.4	37873.0	1459.0
2023-08-20 22:00:00	YM	Futures	37873.0	37909.2	37867.5	37900.4	952.0
2023-08-20 23:00:00	YM	Futures	37900.4	37904.8	37871.9	37878.5	390.0
2023-08-20 18:00:00	CL	Futures	66.19	66.23	65.92	66.1	1878.0
2023-08-20 19:00:00	CL	Futures	66.1	66.1	66.03	66.05	576.0
2023-08-20 20:00:00	CL	Futures	66.05	66.1	66.02	66.07	1228.0
2023-08-20 21:00:00	CL	Futures	66.06	66.7	66.05	66.69	7043.0
2023-08-20 22:00:00	CL	Futures	66.69	66.79	66.58	66.74	3708.0
2023-08-20 23:00:00	CL	Futures	66.73	66.74	66.59	66.6	1839.0
2023-08-20 18:00:00	GC	Futures	2142.8	2144.2	2142.6	2143.7	1295.0
2023-08-20 19:00:00	GC	Futures	2143.6	2143.6	2142.2	2143.6	1038.0
2023-08-20 20:00:00	GC	Futures	2143.4	2144.9	2143.4	2143.6	1525.0
2023-08-20 21:00:00	GC	Futures	2143.4	2143.6	2137.5	2138.4	4928.0
2023-08-20 22:00:00	GC	Futures	2138.3	2146.7	2137.4	2146.4	5579.0
2023-08-20 23:00:00	GC	Futures	2146.5	2147.4	2143.8	2145.0	3986.0
2023-08-20 18:00:00	ZN	Futures	111.798382	111.84618	111.71872	111.734652	8011.0
2023-08-20 19:00:00	ZN	Futures	111.750585	111.750585	111.71872	111.750585	2963.0
2023-08-20 20:00:00	ZN	Futures	111.750585	111.798382	111.71872	111.734652	7632.0
2023-08-20 21:00:00	ZN	Futures	111.71872	111.71872	111.59126	111.607192	25640.0
2023-08-20 22:00:00	ZN	Futures	111.607192	111.65499	111.575327	111.639057	7078.0
2023-08-20 23:00:00	ZN	Futures	111.639057	111.65499	111.607192	111.623125	6704.0

> showing 36 of 411 rows — these rows as CSV

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