PREVIEW / futures_1hour / 2023-06-23

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-06-23.parquet
  size:    56 KB
  rows:    1,643

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-06-23 00:00:00	ES	Futures	4837.99	4839.09	4831.95	4834.97	8339.0
2023-06-23 01:00:00	ES	Futures	4835.24	4839.64	4832.5	4838.54	8301.0
2023-06-23 02:00:00	ES	Futures	4838.54	4839.64	4833.87	4838.54	7185.0
2023-06-23 03:00:00	ES	Futures	4838.54	4845.13	4827.28	4834.42	34669.0
2023-06-23 04:00:00	ES	Futures	4834.42	4838.81	4830.85	4832.22	18862.0
2023-06-23 05:00:00	ES	Futures	4832.22	4836.62	4831.4	4836.07	12866.0
2023-06-23 06:00:00	ES	Futures	4835.79	4836.07	4830.3	4832.22	10550.0
2023-06-23 07:00:00	ES	Futures	4831.95	4839.64	4831.68	4834.97	16778.0
2023-06-23 08:00:00	ES	Futures	4835.24	4835.52	4816.58	4819.05	54170.0
2023-06-23 09:00:00	ES	Futures	4819.05	4823.71	4813.83	4821.79	211576.0
2023-06-23 10:00:00	ES	Futures	4821.52	4831.13	4818.22	4823.44	195150.0
2023-06-23 11:00:00	ES	Futures	4823.44	4828.11	4815.48	4826.73	133242.0
2023-06-23 12:00:00	ES	Futures	4826.73	4837.99	4824.81	4834.42	115430.0
2023-06-23 13:00:00	ES	Futures	4834.42	4840.19	4830.3	4834.97	81427.0
2023-06-23 14:00:00	ES	Futures	4834.97	4835.79	4816.03	4816.85	145533.0
2023-06-23 15:00:00	ES	Futures	4817.13	4828.93	4811.09	4820.69	287566.0
2023-06-23 16:00:00	ES	Futures	4820.69	4822.62	4813.01	4818.77	78072.0
2023-06-23 00:00:00	NQ	Futures	16861.98	16865.32	16830.27	16839.73	4715.0
2023-06-23 01:00:00	NQ	Futures	16840.01	16864.76	16825.82	16855.03	5802.0
2023-06-23 02:00:00	NQ	Futures	16855.3	16860.03	16837.22	16856.42	3836.0
2023-06-23 03:00:00	NQ	Futures	16855.86	16883.67	16811.36	16844.18	12794.0
2023-06-23 04:00:00	NQ	Futures	16844.18	16854.75	16788.83	16798.56	10706.0
2023-06-23 05:00:00	NQ	Futures	16798.29	16826.38	16797.17	16821.09	6261.0
2023-06-23 06:00:00	NQ	Futures	16820.26	16823.04	16794.67	16809.13	5519.0
2023-06-23 07:00:00	NQ	Futures	16810.52	16850.02	16809.69	16826.93	8942.0
2023-06-23 08:00:00	NQ	Futures	16827.21	16831.38	16709.01	16733.76	25701.0
2023-06-23 09:00:00	NQ	Futures	16733.76	16785.49	16671.46	16710.4	97371.0
2023-06-23 10:00:00	NQ	Futures	16710.95	16781.6	16687.31	16742.66	93756.0
2023-06-23 11:00:00	NQ	Futures	16742.66	16765.47	16695.66	16750.45	60917.0
2023-06-23 12:00:00	NQ	Futures	16750.73	16829.44	16750.17	16821.09	53727.0
2023-06-23 13:00:00	NQ	Futures	16821.65	16860.59	16808.02	16828.05	41837.0
2023-06-23 14:00:00	NQ	Futures	16828.32	16836.95	16742.1	16749.06	55732.0
2023-06-23 15:00:00	NQ	Futures	16749.34	16785.21	16721.52	16754.62	84541.0
2023-06-23 16:00:00	NQ	Futures	16754.9	16769.64	16730.7	16747.11	17206.0
2023-06-23 00:00:00	YM	Futures	37327.4	37337.3	37294.6	37325.2	1196.0
2023-06-23 01:00:00	YM	Futures	37324.1	37344.9	37312.1	37339.5	1371.0
2023-06-23 02:00:00	YM	Futures	37339.5	37358.1	37316.5	37348.2	1935.0
2023-06-23 03:00:00	YM	Futures	37347.1	37400.8	37269.4	37318.7	8001.0
2023-06-23 04:00:00	YM	Futures	37319.7	37397.5	37319.7	37362.5	5576.0
2023-06-23 05:00:00	YM	Futures	37361.4	37384.4	37346.0	37381.1	2355.0
2023-06-23 06:00:00	YM	Futures	37375.6	37382.2	37342.8	37349.3	1827.0
2023-06-23 07:00:00	YM	Futures	37348.2	37385.5	37344.9	37362.5	2304.0
2023-06-23 08:00:00	YM	Futures	37363.6	37366.9	37249.6	37252.9	6605.0
2023-06-23 09:00:00	YM	Futures	37252.9	37302.2	37125.8	37281.4	27374.0
2023-06-23 10:00:00	YM	Futures	37279.2	37321.9	37239.8	37257.3	18293.0
2023-06-23 11:00:00	YM	Futures	37258.4	37300.0	37217.9	37293.5	9787.0
2023-06-23 12:00:00	YM	Futures	37293.5	37344.9	37266.1	37319.7	9209.0
2023-06-23 13:00:00	YM	Futures	37320.8	37348.2	37281.4	37311.0	5966.0
2023-06-23 14:00:00	YM	Futures	37311.0	37313.2	37177.3	37187.2	10229.0
2023-06-23 15:00:00	YM	Futures	37188.3	37290.2	37152.1	37232.1	18399.0

> showing 50 of 1,643 rows — these rows as CSV

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