PREVIEW / futures_1hour / 2023-09-14

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-09-14.parquet
  size:    66 KB
  rows:    2,039

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-14 00:00:00	ES	Futures	4922.54	4923.08	4920.09	4920.37	4893.0
2023-09-14 01:00:00	ES	Futures	4920.37	4925.25	4919.82	4922.27	8717.0
2023-09-14 02:00:00	ES	Futures	4922.0	4923.62	4919.01	4920.37	7889.0
2023-09-14 03:00:00	ES	Futures	4920.09	4920.91	4915.75	4917.65	15731.0
2023-09-14 04:00:00	ES	Futures	4917.38	4920.91	4911.95	4919.01	12794.0
2023-09-14 05:00:00	ES	Futures	4918.74	4923.35	4916.56	4921.72	11571.0
2023-09-14 06:00:00	ES	Futures	4921.45	4928.24	4921.18	4927.15	18771.0
2023-09-14 07:00:00	ES	Futures	4927.15	4929.33	4922.27	4923.35	17346.0
2023-09-14 08:00:00	ES	Futures	4923.08	4933.13	4917.92	4930.41	85658.0
2023-09-14 09:00:00	ES	Futures	4930.14	4939.92	4922.27	4931.77	254798.0
2023-09-14 10:00:00	ES	Futures	4932.04	4939.65	4918.47	4938.02	249424.0
2023-09-14 11:00:00	ES	Futures	4938.29	4943.45	4933.13	4942.63	147555.0
2023-09-14 12:00:00	ES	Futures	4942.63	4951.32	4941.0	4950.78	114384.0
2023-09-14 13:00:00	ES	Futures	4951.05	4951.05	4945.35	4945.62	79557.0
2023-09-14 14:00:00	ES	Futures	4945.62	4950.51	4942.91	4950.24	84113.0
2023-09-14 15:00:00	ES	Futures	4950.24	4955.4	4944.81	4947.79	221478.0
2023-09-14 16:00:00	ES	Futures	4947.79	4955.13	4946.16	4950.78	59387.0
2023-09-14 18:00:00	ES	Futures	4949.42	4951.87	4949.42	4950.51	5260.0
2023-09-14 19:00:00	ES	Futures	4950.51	4952.95	4949.69	4950.51	4617.0
2023-09-14 20:00:00	ES	Futures	4950.51	4954.31	4949.97	4952.41	6192.0
2023-09-14 21:00:00	ES	Futures	4952.41	4954.31	4949.69	4954.31	7744.0
2023-09-14 22:00:00	ES	Futures	4954.31	4957.57	4954.31	4956.48	8304.0
2023-09-14 23:00:00	ES	Futures	4956.48	4959.74	4955.94	4957.84	6336.0
2023-09-14 00:00:00	NQ	Futures	17164.86	17167.06	17151.95	17153.88	3640.0
2023-09-14 01:00:00	NQ	Futures	17153.33	17176.4	17149.21	17163.77	5245.0
2023-09-14 02:00:00	NQ	Futures	17163.49	17170.63	17151.13	17158.0	4272.0
2023-09-14 03:00:00	NQ	Futures	17158.0	17160.47	17135.75	17139.59	8169.0
2023-09-14 04:00:00	NQ	Futures	17139.32	17147.83	17101.97	17136.57	10233.0
2023-09-14 05:00:00	NQ	Futures	17136.3	17148.66	17124.76	17134.38	6529.0
2023-09-14 06:00:00	NQ	Futures	17133.28	17167.61	17133.0	17157.17	8287.0
2023-09-14 07:00:00	NQ	Futures	17157.45	17173.65	17138.22	17147.01	9146.0
2023-09-14 08:00:00	NQ	Futures	17146.74	17180.52	17104.71	17156.9	41941.0
2023-09-14 09:00:00	NQ	Futures	17157.17	17191.51	17069.01	17119.54	115243.0
2023-09-14 10:00:00	NQ	Futures	17119.54	17214.85	17063.24	17197.82	104740.0
2023-09-14 11:00:00	NQ	Futures	17198.37	17243.14	17168.71	17226.11	71074.0
2023-09-14 12:00:00	NQ	Futures	17226.39	17259.07	17195.63	17254.95	51558.0
2023-09-14 13:00:00	NQ	Futures	17254.68	17256.88	17226.11	17227.21	34086.0
2023-09-14 14:00:00	NQ	Futures	17227.21	17237.92	17197.55	17234.35	39150.0
2023-09-14 15:00:00	NQ	Futures	17234.63	17264.84	17210.73	17218.7	65306.0
2023-09-14 16:00:00	NQ	Futures	17218.7	17246.44	17214.3	17223.92	14504.0
2023-09-14 18:00:00	NQ	Futures	17223.64	17231.33	17217.87	17224.74	2673.0
2023-09-14 19:00:00	NQ	Futures	17224.74	17234.9	17220.62	17223.92	2718.0
2023-09-14 20:00:00	NQ	Futures	17224.47	17243.14	17222.54	17234.63	3757.0
2023-09-14 21:00:00	NQ	Futures	17234.35	17240.67	17219.8	17239.57	4449.0
2023-09-14 22:00:00	NQ	Futures	17240.12	17257.15	17240.12	17249.19	5223.0
2023-09-14 23:00:00	NQ	Futures	17249.19	17269.24	17247.26	17259.9	4145.0
2023-09-14 00:00:00	YM	Futures	37958.0	37962.3	37937.4	37941.7	575.0
2023-09-14 01:00:00	YM	Futures	37941.7	37971.0	37938.5	37956.9	1454.0
2023-09-14 02:00:00	YM	Futures	37956.9	37963.4	37926.6	37939.6	2966.0
2023-09-14 03:00:00	YM	Futures	37940.7	37945.0	37901.6	37915.7	5088.0

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

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