PREVIEW / futures_1hour / 2023-08-27

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-08-27.parquet
  size:    18 KB
  rows:    394

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-27 18:00:00	ES	Futures	4851.17	4858.58	4849.24	4854.46	6532.0
2023-08-27 19:00:00	ES	Futures	4854.73	4856.66	4852.81	4855.01	3981.0
2023-08-27 20:00:00	ES	Futures	4855.01	4855.28	4847.32	4848.97	9292.0
2023-08-27 21:00:00	ES	Futures	4849.24	4855.56	4849.24	4853.09	10698.0
2023-08-27 22:00:00	ES	Futures	4853.09	4855.01	4850.34	4853.91	6088.0
2023-08-27 23:00:00	ES	Futures	4854.19	4854.19	4848.69	4848.69	4992.0
2023-08-27 18:00:00	NQ	Futures	16677.86	16720.97	16672.29	16697.32	5574.0
2023-08-27 19:00:00	NQ	Futures	16697.88	16707.62	16686.76	16699.27	2850.0
2023-08-27 20:00:00	NQ	Futures	16699.27	16701.5	16658.39	16672.85	6017.0
2023-08-27 21:00:00	NQ	Futures	16673.41	16709.28	16673.41	16693.15	5860.0
2023-08-27 22:00:00	NQ	Futures	16693.71	16702.33	16680.08	16695.1	3640.0
2023-08-27 23:00:00	NQ	Futures	16695.38	16696.21	16665.34	16666.17	3190.0
2023-08-27 18:00:00	YM	Futures	37712.0	37733.9	37686.8	37717.4	1088.0
2023-08-27 19:00:00	YM	Futures	37718.5	37730.6	37708.7	37728.4	729.0
2023-08-27 20:00:00	YM	Futures	37728.4	37730.6	37693.3	37701.0	1609.0
2023-08-27 21:00:00	YM	Futures	37704.3	37735.0	37703.2	37728.4	1658.0
2023-08-27 22:00:00	YM	Futures	37729.5	37735.0	37714.1	37731.7	684.0
2023-08-27 23:00:00	YM	Futures	37732.8	37735.0	37701.0	37701.0	941.0
2023-08-27 18:00:00	CL	Futures	65.69	65.91	65.56	65.72	2700.0
2023-08-27 19:00:00	CL	Futures	65.72	65.78	65.69	65.72	737.0
2023-08-27 20:00:00	CL	Futures	65.73	65.76	65.6	65.61	2052.0
2023-08-27 21:00:00	CL	Futures	65.61	65.75	65.37	65.39	4627.0
2023-08-27 22:00:00	CL	Futures	65.38	65.46	65.32	65.43	2397.0
2023-08-27 23:00:00	CL	Futures	65.44	65.46	65.36	65.37	1046.0
2023-08-27 18:00:00	GC	Futures	2171.4	2171.8	2169.5	2169.7	831.0
2023-08-27 19:00:00	GC	Futures	2169.8	2170.9	2168.8	2169.6	1456.0
2023-08-27 20:00:00	GC	Futures	2169.7	2171.6	2169.3	2170.6	1704.0
2023-08-27 21:00:00	GC	Futures	2170.5	2172.7	2170.1	2170.5	3085.0
2023-08-27 22:00:00	GC	Futures	2170.5	2171.4	2170.0	2170.4	1609.0
2023-08-27 23:00:00	GC	Futures	2170.5	2172.3	2170.3	2171.5	2548.0
2023-08-27 18:00:00	ZN	Futures	111.607192	111.670922	111.52753	111.543462	5028.0
2023-08-27 19:00:00	ZN	Futures	111.559395	111.559395	111.4638	111.495665	6391.0
2023-08-27 20:00:00	ZN	Futures	111.495665	111.543462	111.4638	111.479732	8479.0
2023-08-27 21:00:00	ZN	Futures	111.479732	111.511597	111.4638	111.495665	6945.0
2023-08-27 22:00:00	ZN	Futures	111.511597	111.623125	111.495665	111.575327	13954.0
2023-08-27 23:00:00	ZN	Futures	111.575327	111.623125	111.575327	111.607192	4390.0

> showing 36 of 394 rows — these rows as CSV

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