PREVIEW / futures_1hour / 2023-09-19

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-09-19.parquet
  size:    64 KB
  rows:    2,016

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-19 00:00:00	ES	Futures	4889.14	4889.95	4886.69	4887.24	4401.0
2023-09-19 01:00:00	ES	Futures	4886.96	4887.78	4884.52	4886.15	5674.0
2023-09-19 02:00:00	ES	Futures	4886.42	4886.96	4883.98	4886.15	7600.0
2023-09-19 03:00:00	ES	Futures	4886.15	4895.38	4884.25	4894.02	18495.0
2023-09-19 04:00:00	ES	Futures	4893.75	4896.47	4893.21	4894.3	9083.0
2023-09-19 05:00:00	ES	Futures	4894.57	4898.1	4892.67	4897.01	9195.0
2023-09-19 06:00:00	ES	Futures	4896.74	4898.37	4895.11	4895.38	7472.0
2023-09-19 07:00:00	ES	Futures	4895.11	4896.47	4892.12	4894.3	10089.0
2023-09-19 08:00:00	ES	Futures	4894.57	4894.57	4883.71	4883.98	27884.0
2023-09-19 09:00:00	ES	Futures	4883.98	4885.33	4871.76	4872.3	191901.0
2023-09-19 10:00:00	ES	Futures	4872.3	4872.84	4853.56	4854.11	249015.0
2023-09-19 11:00:00	ES	Futures	4854.11	4859.27	4852.48	4857.09	126309.0
2023-09-19 12:00:00	ES	Futures	4857.09	4857.36	4847.05	4854.38	116487.0
2023-09-19 13:00:00	ES	Futures	4854.38	4872.84	4853.29	4871.76	138995.0
2023-09-19 14:00:00	ES	Futures	4871.76	4884.52	4869.58	4871.21	175858.0
2023-09-19 15:00:00	ES	Futures	4870.94	4882.89	4868.77	4878.27	207861.0
2023-09-19 16:00:00	ES	Futures	4878.27	4881.53	4878.27	4879.36	36756.0
2023-09-19 18:00:00	ES	Futures	4878.55	4880.45	4877.73	4878.82	2129.0
2023-09-19 19:00:00	ES	Futures	4879.09	4880.18	4878.0	4879.63	2271.0
2023-09-19 20:00:00	ES	Futures	4879.63	4880.18	4875.56	4876.37	6017.0
2023-09-19 21:00:00	ES	Futures	4876.37	4878.55	4874.2	4876.37	6703.0
2023-09-19 22:00:00	ES	Futures	4876.1	4876.92	4873.11	4873.93	4106.0
2023-09-19 23:00:00	ES	Futures	4873.93	4874.47	4871.21	4872.03	2870.0
2023-09-19 00:00:00	NQ	Futures	16928.38	16930.3	16913.0	16917.12	2594.0
2023-09-19 01:00:00	NQ	Futures	16917.12	16920.69	16904.76	16913.0	3403.0
2023-09-19 02:00:00	NQ	Futures	16913.27	16916.29	16896.79	16908.6	4031.0
2023-09-19 03:00:00	NQ	Futures	16908.88	16952.27	16898.17	16946.78	8260.0
2023-09-19 04:00:00	NQ	Futures	16947.06	16960.24	16943.21	16950.08	5546.0
2023-09-19 05:00:00	NQ	Futures	16951.18	16964.91	16939.91	16960.79	4669.0
2023-09-19 06:00:00	NQ	Futures	16960.79	16964.63	16949.53	16951.18	4274.0
2023-09-19 07:00:00	NQ	Futures	16950.63	16965.73	16938.54	16948.7	6403.0
2023-09-19 08:00:00	NQ	Futures	16949.25	16950.08	16899.81	16902.29	15170.0
2023-09-19 09:00:00	NQ	Futures	16901.46	16907.23	16813.02	16813.57	97199.0
2023-09-19 10:00:00	NQ	Futures	16813.84	16827.85	16752.87	16758.36	100348.0
2023-09-19 11:00:00	NQ	Futures	16758.09	16803.96	16755.34	16799.84	51584.0
2023-09-19 12:00:00	NQ	Futures	16799.84	16816.04	16763.3	16812.74	42051.0
2023-09-19 13:00:00	NQ	Futures	16812.74	16897.34	16806.98	16889.65	59689.0
2023-09-19 14:00:00	NQ	Futures	16889.93	16928.1	16862.18	16862.18	54437.0
2023-09-19 15:00:00	NQ	Futures	16862.73	16908.33	16851.2	16894.59	58339.0
2023-09-19 16:00:00	NQ	Futures	16894.59	16906.95	16893.22	16900.64	10126.0
2023-09-19 18:00:00	NQ	Futures	16892.12	16904.48	16891.85	16897.62	1744.0
2023-09-19 19:00:00	NQ	Futures	16897.34	16904.76	16891.85	16901.74	1671.0
2023-09-19 20:00:00	NQ	Futures	16901.46	16903.66	16877.84	16882.51	4002.0
2023-09-19 21:00:00	NQ	Futures	16881.69	16891.85	16868.5	16882.23	4923.0
2023-09-19 22:00:00	NQ	Futures	16881.96	16888.55	16871.25	16873.72	2555.0
2023-09-19 23:00:00	NQ	Futures	16873.45	16877.84	16861.63	16864.11	2595.0
2023-09-19 00:00:00	YM	Futures	37897.3	37901.6	37881.0	37885.3	661.0
2023-09-19 01:00:00	YM	Futures	37885.3	37885.3	37870.1	37879.9	710.0
2023-09-19 02:00:00	YM	Futures	37881.0	37885.3	37863.6	37879.9	1357.0
2023-09-19 03:00:00	YM	Futures	37878.8	37941.7	37869.1	37930.9	2674.0

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

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