PREVIEW / futures_1hour / 2023-06-22

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-06-22.parquet
  size:    67 KB
  rows:    2,049

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-22 00:00:00	ES	Futures	4840.46	4840.73	4835.79	4836.07	3422.0
2023-06-22 01:00:00	ES	Futures	4836.34	4836.34	4831.95	4833.87	8245.0
2023-06-22 02:00:00	ES	Futures	4834.15	4834.15	4826.46	4829.75	16568.0
2023-06-22 03:00:00	ES	Futures	4829.75	4832.77	4824.54	4827.56	38828.0
2023-06-22 04:00:00	ES	Futures	4827.83	4834.15	4826.46	4830.3	19986.0
2023-06-22 05:00:00	ES	Futures	4830.58	4835.79	4830.03	4833.6	13184.0
2023-06-22 06:00:00	ES	Futures	4833.32	4834.15	4825.36	4828.11	15999.0
2023-06-22 07:00:00	ES	Futures	4827.83	4830.3	4823.71	4830.03	25871.0
2023-06-22 08:00:00	ES	Futures	4830.03	4836.07	4827.83	4828.93	35260.0
2023-06-22 09:00:00	ES	Futures	4828.93	4841.83	4824.54	4838.26	172044.0
2023-06-22 10:00:00	ES	Futures	4837.71	4851.71	4829.75	4834.97	209633.0
2023-06-22 11:00:00	ES	Futures	4834.97	4850.07	4834.69	4846.77	149958.0
2023-06-22 12:00:00	ES	Futures	4847.05	4848.15	4839.36	4843.2	107007.0
2023-06-22 13:00:00	ES	Futures	4842.93	4848.42	4833.87	4847.87	108644.0
2023-06-22 14:00:00	ES	Futures	4848.15	4856.66	4845.95	4856.11	110499.0
2023-06-22 15:00:00	ES	Futures	4856.11	4858.3	4844.03	4857.48	208490.0
2023-06-22 16:00:00	ES	Futures	4857.48	4861.05	4853.64	4859.13	49911.0
2023-06-22 18:00:00	ES	Futures	4859.68	4860.22	4857.75	4859.4	3106.0
2023-06-22 19:00:00	ES	Futures	4859.4	4859.95	4857.2	4857.48	2343.0
2023-06-22 20:00:00	ES	Futures	4857.48	4857.48	4853.36	4854.19	5990.0
2023-06-22 21:00:00	ES	Futures	4854.19	4854.46	4843.48	4845.4	11537.0
2023-06-22 22:00:00	ES	Futures	4845.13	4845.68	4839.09	4840.73	8746.0
2023-06-22 23:00:00	ES	Futures	4840.46	4842.93	4837.17	4837.71	8199.0
2023-06-22 00:00:00	NQ	Futures	16719.85	16721.8	16699.55	16703.72	3110.0
2023-06-22 01:00:00	NQ	Futures	16704.0	16704.28	16674.8	16688.15	7380.0
2023-06-22 02:00:00	NQ	Futures	16688.7	16690.65	16658.11	16678.41	7255.0
2023-06-22 03:00:00	NQ	Futures	16678.41	16706.78	16654.49	16690.37	15730.0
2023-06-22 04:00:00	NQ	Futures	16689.82	16698.16	16672.29	16679.8	7166.0
2023-06-22 05:00:00	NQ	Futures	16680.36	16714.57	16677.3	16710.68	4729.0
2023-06-22 06:00:00	NQ	Futures	16710.68	16712.62	16661.17	16668.96	8195.0
2023-06-22 07:00:00	NQ	Futures	16668.96	16687.59	16654.49	16684.53	11404.0
2023-06-22 08:00:00	NQ	Futures	16684.81	16714.29	16667.84	16677.58	15642.0
2023-06-22 09:00:00	NQ	Futures	16677.02	16795.51	16647.82	16780.21	94104.0
2023-06-22 10:00:00	NQ	Futures	16780.76	16853.63	16750.17	16779.65	102406.0
2023-06-22 11:00:00	NQ	Futures	16779.1	16889.24	16777.15	16864.2	79803.0
2023-06-22 12:00:00	NQ	Futures	16864.48	16865.87	16811.08	16828.88	48296.0
2023-06-22 13:00:00	NQ	Futures	16828.88	16861.42	16779.65	16858.64	47367.0
2023-06-22 14:00:00	NQ	Futures	16858.64	16900.36	16838.62	16898.69	44255.0
2023-06-22 15:00:00	NQ	Futures	16898.69	16930.4	16852.8	16924.56	66390.0
2023-06-22 16:00:00	NQ	Futures	16925.39	16952.65	16917.33	16947.36	17512.0
2023-06-22 18:00:00	NQ	Futures	16950.42	16950.42	16939.58	16941.8	1899.0
2023-06-22 19:00:00	NQ	Futures	16941.52	16943.47	16934.01	16934.85	1597.0
2023-06-22 20:00:00	NQ	Futures	16934.57	16935.68	16914.27	16915.66	3584.0
2023-06-22 21:00:00	NQ	Futures	16915.38	16919.27	16871.44	16878.67	6137.0
2023-06-22 22:00:00	NQ	Futures	16878.11	16883.67	16854.75	16863.37	4579.0
2023-06-22 23:00:00	NQ	Futures	16863.37	16879.22	16857.53	16862.26	3779.0
2023-06-22 00:00:00	YM	Futures	37497.2	37498.3	37467.6	37473.1	578.0
2023-06-22 01:00:00	YM	Futures	37473.1	37473.1	37449.0	37456.7	1141.0
2023-06-22 02:00:00	YM	Futures	37458.9	37465.5	37412.9	37424.9	3338.0
2023-06-22 03:00:00	YM	Futures	37423.8	37429.3	37364.7	37394.2	9094.0

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

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