PREVIEW / futures_1hour / 2023-07-10

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-07-10.parquet
  size:    65 KB
  rows:    2,000

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-07-10 00:00:00	ES	Futures	4858.03	4862.69	4856.11	4860.5	5914.0
2023-07-10 01:00:00	ES	Futures	4860.5	4861.32	4845.95	4846.77	17593.0
2023-07-10 02:00:00	ES	Futures	4846.77	4849.79	4843.75	4848.69	14061.0
2023-07-10 03:00:00	ES	Futures	4848.69	4853.09	4843.75	4851.71	29683.0
2023-07-10 04:00:00	ES	Futures	4851.99	4861.32	4851.17	4857.2	20531.0
2023-07-10 05:00:00	ES	Futures	4857.48	4861.6	4856.93	4859.13	10841.0
2023-07-10 06:00:00	ES	Futures	4858.85	4864.07	4856.66	4864.07	10011.0
2023-07-10 07:00:00	ES	Futures	4864.07	4870.93	4863.52	4869.83	24542.0
2023-07-10 08:00:00	ES	Futures	4869.56	4873.68	4864.07	4865.99	32524.0
2023-07-10 09:00:00	ES	Futures	4866.26	4877.52	4862.69	4874.5	179914.0
2023-07-10 10:00:00	ES	Futures	4874.22	4882.73	4866.26	4869.28	213488.0
2023-07-10 11:00:00	ES	Futures	4869.28	4874.5	4862.42	4867.09	159343.0
2023-07-10 12:00:00	ES	Futures	4867.36	4873.4	4857.75	4872.3	141640.0
2023-07-10 13:00:00	ES	Futures	4872.3	4878.07	4870.93	4873.4	87339.0
2023-07-10 14:00:00	ES	Futures	4873.13	4878.34	4868.19	4876.42	87977.0
2023-07-10 15:00:00	ES	Futures	4876.7	4881.91	4869.56	4881.36	159423.0
2023-07-10 16:00:00	ES	Futures	4881.36	4884.38	4879.99	4881.09	51287.0
2023-07-10 18:00:00	ES	Futures	4881.64	4882.19	4878.34	4881.36	3191.0
2023-07-10 19:00:00	ES	Futures	4881.36	4881.91	4878.89	4881.91	2614.0
2023-07-10 20:00:00	ES	Futures	4881.91	4883.83	4878.34	4883.28	7285.0
2023-07-10 21:00:00	ES	Futures	4883.28	4884.66	4879.99	4880.54	7141.0
2023-07-10 22:00:00	ES	Futures	4880.81	4883.83	4879.44	4883.56	5443.0
2023-07-10 23:00:00	ES	Futures	4883.28	4884.38	4882.73	4883.28	3744.0
2023-07-10 00:00:00	NQ	Futures	16832.22	16853.91	16825.27	16846.4	4261.0
2023-07-10 01:00:00	NQ	Futures	16846.4	16850.02	16781.88	16786.05	8629.0
2023-07-10 02:00:00	NQ	Futures	16785.77	16802.18	16774.65	16794.67	7111.0
2023-07-10 03:00:00	NQ	Futures	16794.95	16819.42	16780.49	16815.25	9861.0
2023-07-10 04:00:00	NQ	Futures	16815.53	16852.24	16808.58	16826.66	8455.0
2023-07-10 05:00:00	NQ	Futures	16826.66	16843.07	16818.59	16825.82	5183.0
2023-07-10 06:00:00	NQ	Futures	16826.38	16845.57	16816.92	16843.62	5047.0
2023-07-10 07:00:00	NQ	Futures	16843.9	16887.84	16841.67	16883.12	11773.0
2023-07-10 08:00:00	NQ	Futures	16883.67	16907.31	16858.64	16872.55	16891.0
2023-07-10 09:00:00	NQ	Futures	16872.83	16926.78	16782.99	16815.81	97106.0
2023-07-10 10:00:00	NQ	Futures	16815.25	16915.1	16811.36	16852.24	99213.0
2023-07-10 11:00:00	NQ	Futures	16852.24	16884.23	16809.69	16816.92	67265.0
2023-07-10 12:00:00	NQ	Futures	16817.2	16861.7	16758.24	16853.63	68026.0
2023-07-10 13:00:00	NQ	Futures	16853.91	16889.24	16841.4	16856.97	44170.0
2023-07-10 14:00:00	NQ	Futures	16857.53	16902.03	16836.95	16897.58	41737.0
2023-07-10 15:00:00	NQ	Futures	16897.58	16900.64	16853.63	16899.25	48371.0
2023-07-10 16:00:00	NQ	Futures	16899.53	16930.68	16897.02	16902.59	14902.0
2023-07-10 18:00:00	NQ	Futures	16905.65	16905.92	16887.29	16898.41	2337.0
2023-07-10 19:00:00	NQ	Futures	16898.97	16902.59	16887.57	16901.75	2393.0
2023-07-10 20:00:00	NQ	Futures	16901.47	16905.92	16883.67	16904.81	3833.0
2023-07-10 21:00:00	NQ	Futures	16904.25	16913.99	16892.57	16893.69	4058.0
2023-07-10 22:00:00	NQ	Futures	16893.41	16908.43	16889.51	16907.31	2705.0
2023-07-10 23:00:00	NQ	Futures	16907.04	16909.82	16903.14	16905.65	1621.0
2023-07-10 00:00:00	YM	Futures	37124.7	37154.3	37111.6	37141.2	726.0
2023-07-10 01:00:00	YM	Futures	37141.2	37146.7	37057.9	37064.5	2268.0
2023-07-10 02:00:00	YM	Futures	37063.4	37082.0	37038.2	37072.2	2501.0
2023-07-10 03:00:00	YM	Futures	37071.1	37102.8	37032.7	37088.6	3890.0

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

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