PREVIEW / futures_1hour / 2023-09-17

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-09-17.parquet
  size:    18 KB
  rows:    403

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-09-17 18:00:00	ES	Futures	4887.51	4892.67	4886.15	4892.12	6249.0
2023-09-17 19:00:00	ES	Futures	4892.12	4895.11	4890.77	4894.3	3741.0
2023-09-17 20:00:00	ES	Futures	4894.3	4895.93	4892.12	4894.3	7729.0
2023-09-17 21:00:00	ES	Futures	4894.3	4894.84	4891.31	4892.4	7716.0
2023-09-17 22:00:00	ES	Futures	4892.12	4894.84	4892.12	4893.21	4720.0
2023-09-17 23:00:00	ES	Futures	4893.48	4895.11	4892.94	4894.84	3124.0
2023-09-17 18:00:00	NQ	Futures	16899.81	16927.83	16896.79	16925.36	4262.0
2023-09-17 19:00:00	NQ	Futures	16925.08	16935.79	16917.12	16933.6	2518.0
2023-09-17 20:00:00	NQ	Futures	16933.87	16941.01	16927.0	16937.17	3904.0
2023-09-17 21:00:00	NQ	Futures	16937.44	16939.64	16914.37	16919.04	5047.0
2023-09-17 22:00:00	NQ	Futures	16918.49	16934.7	16917.94	16926.18	3483.0
2023-09-17 23:00:00	NQ	Futures	16926.73	16933.87	16923.43	16931.67	1648.0
2023-09-17 18:00:00	YM	Futures	37891.8	37928.7	37891.8	37923.3	971.0
2023-09-17 19:00:00	YM	Futures	37923.3	37945.0	37917.9	37941.7	620.0
2023-09-17 20:00:00	YM	Futures	37941.7	37954.8	37929.8	37945.0	1033.0
2023-09-17 21:00:00	YM	Futures	37945.0	37949.3	37923.3	37933.1	687.0
2023-09-17 22:00:00	YM	Futures	37930.9	37941.7	37925.5	37934.1	449.0
2023-09-17 23:00:00	YM	Futures	37934.1	37952.6	37930.9	37950.4	445.0
2023-09-17 18:00:00	CL	Futures	74.71	74.71	74.44	74.48	2057.0
2023-09-17 19:00:00	CL	Futures	74.47	74.51	74.41	74.51	636.0
2023-09-17 20:00:00	CL	Futures	74.5	74.55	74.45	74.53	1184.0
2023-09-17 21:00:00	CL	Futures	74.54	74.71	74.54	74.67	3301.0
2023-09-17 22:00:00	CL	Futures	74.67	74.8	74.67	74.72	1990.0
2023-09-17 23:00:00	CL	Futures	74.72	74.75	74.64	74.74	1286.0
2023-09-17 18:00:00	GC	Futures	2173.3	2173.7	2172.2	2172.4	1263.0
2023-09-17 19:00:00	GC	Futures	2172.4	2172.6	2171.4	2172.3	1232.0
2023-09-17 20:00:00	GC	Futures	2172.3	2173.8	2172.3	2173.8	1669.0
2023-09-17 21:00:00	GC	Futures	2173.9	2176.1	2172.0	2174.1	7016.0
2023-09-17 22:00:00	GC	Futures	2174.1	2177.9	2173.8	2177.1	3486.0
2023-09-17 23:00:00	GC	Futures	2177.2	2178.7	2176.8	2177.9	2783.0
2023-09-17 18:00:00	ZN	Futures	111.148311	111.211788	111.132442	111.195919	4677.0
2023-09-17 19:00:00	ZN	Futures	111.18005	111.211788	111.164181	111.195919	4967.0
2023-09-17 20:00:00	ZN	Futures	111.211788	111.211788	111.132442	111.18005	5488.0
2023-09-17 21:00:00	ZN	Futures	111.164181	111.164181	111.037227	111.037227	9854.0
2023-09-17 22:00:00	ZN	Futures	111.037227	111.068965	111.021357	111.053096	6052.0
2023-09-17 23:00:00	ZN	Futures	111.037227	111.068965	111.037227	111.053096	3955.0

> showing 36 of 403 rows — these rows as CSV

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