PREVIEW / futures_1hour / 2023-09-18

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-09-18.parquet
  size:    63 KB
  rows:    2,021

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-18 00:00:00	ES	Futures	4894.57	4895.65	4894.02	4894.02	2196.0
2023-09-18 01:00:00	ES	Futures	4894.02	4895.38	4892.12	4893.21	3773.0
2023-09-18 02:00:00	ES	Futures	4892.94	4895.11	4889.68	4891.04	7284.0
2023-09-18 03:00:00	ES	Futures	4891.04	4896.2	4887.51	4894.02	20784.0
2023-09-18 04:00:00	ES	Futures	4894.02	4895.11	4890.77	4891.04	9870.0
2023-09-18 05:00:00	ES	Futures	4891.31	4893.75	4888.87	4890.77	8736.0
2023-09-18 06:00:00	ES	Futures	4890.49	4893.21	4887.78	4891.31	11889.0
2023-09-18 07:00:00	ES	Futures	4891.31	4892.4	4873.93	4877.46	31679.0
2023-09-18 08:00:00	ES	Futures	4877.19	4884.52	4875.29	4882.62	35943.0
2023-09-18 09:00:00	ES	Futures	4882.62	4890.49	4876.92	4882.35	189810.0
2023-09-18 10:00:00	ES	Futures	4882.35	4891.58	4878.82	4889.41	188541.0
2023-09-18 11:00:00	ES	Futures	4889.14	4901.9	4884.79	4900.0	129766.0
2023-09-18 12:00:00	ES	Futures	4900.27	4903.8	4895.93	4898.37	80862.0
2023-09-18 13:00:00	ES	Futures	4898.37	4902.17	4894.84	4896.74	73742.0
2023-09-18 14:00:00	ES	Futures	4896.74	4898.91	4884.25	4888.05	91111.0
2023-09-18 15:00:00	ES	Futures	4888.05	4890.49	4883.98	4889.14	155052.0
2023-09-18 16:00:00	ES	Futures	4889.14	4892.4	4888.87	4890.77	38584.0
2023-09-18 18:00:00	ES	Futures	4891.58	4893.21	4890.49	4892.67	2673.0
2023-09-18 19:00:00	ES	Futures	4892.4	4892.94	4891.31	4892.12	1760.0
2023-09-18 20:00:00	ES	Futures	4892.12	4894.02	4890.49	4891.58	6765.0
2023-09-18 21:00:00	ES	Futures	4891.58	4892.12	4888.05	4888.32	6637.0
2023-09-18 22:00:00	ES	Futures	4888.05	4890.22	4888.05	4889.95	4976.0
2023-09-18 23:00:00	ES	Futures	4889.68	4891.31	4889.14	4889.14	3464.0
2023-09-18 00:00:00	NQ	Futures	16931.67	16937.44	16928.65	16929.2	1253.0
2023-09-18 01:00:00	NQ	Futures	16929.75	16938.27	16924.81	16929.2	2415.0
2023-09-18 02:00:00	NQ	Futures	16929.2	16939.91	16915.74	16924.26	4021.0
2023-09-18 03:00:00	NQ	Futures	16923.98	16950.9	16910.25	16937.17	8621.0
2023-09-18 04:00:00	NQ	Futures	16936.89	16949.8	16928.65	16933.6	4652.0
2023-09-18 05:00:00	NQ	Futures	16933.32	16947.88	16932.5	16933.05	4042.0
2023-09-18 06:00:00	NQ	Futures	16933.32	16942.94	16921.24	16931.12	6596.0
2023-09-18 07:00:00	NQ	Futures	16930.3	16936.07	16842.96	16855.04	15812.0
2023-09-18 08:00:00	NQ	Futures	16854.49	16889.65	16850.1	16879.49	15655.0
2023-09-18 09:00:00	NQ	Futures	16879.49	16957.77	16856.69	16929.75	97155.0
2023-09-18 10:00:00	NQ	Futures	16929.48	16962.71	16880.31	16919.04	96878.0
2023-09-18 11:00:00	NQ	Futures	16918.76	16976.99	16905.58	16972.05	57316.0
2023-09-18 12:00:00	NQ	Futures	16972.32	16986.33	16947.88	16958.59	38131.0
2023-09-18 13:00:00	NQ	Futures	16959.14	16982.21	16946.23	16958.87	31798.0
2023-09-18 14:00:00	NQ	Futures	16959.14	16974.8	16896.24	16913.55	38565.0
2023-09-18 15:00:00	NQ	Futures	16913.82	16937.99	16904.21	16933.6	46611.0
2023-09-18 16:00:00	NQ	Futures	16933.87	16953.37	16932.77	16947.06	11193.0
2023-09-18 18:00:00	NQ	Futures	16945.96	16953.1	16944.31	16948.15	1602.0
2023-09-18 19:00:00	NQ	Futures	16948.43	16950.63	16941.84	16946.23	1657.0
2023-09-18 20:00:00	NQ	Futures	16946.51	16959.96	16939.36	16946.23	3526.0
2023-09-18 21:00:00	NQ	Futures	16946.23	16949.25	16926.73	16927.55	4146.0
2023-09-18 22:00:00	NQ	Futures	16927.55	16936.34	16924.26	16934.15	3253.0
2023-09-18 23:00:00	NQ	Futures	16933.87	16937.44	16927.83	16928.38	1956.0
2023-09-18 00:00:00	YM	Futures	37948.2	37960.2	37946.1	37948.2	382.0
2023-09-18 01:00:00	YM	Futures	37949.3	37955.8	37935.2	37938.5	437.0
2023-09-18 02:00:00	YM	Futures	37939.6	37953.7	37915.7	37923.3	1412.0
2023-09-18 03:00:00	YM	Futures	37922.2	37951.5	37902.7	37941.7	2809.0

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

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