PREVIEW / futures_1hour / 2023-11-07

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-11-07.parquet
  size:    68 KB
  rows:    2,113

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-11-07 00:00:00	ES	Futures	4750.91	4752.54	4749.28	4752.27	4655.0
2023-11-07 01:00:00	ES	Futures	4752.0	4752.54	4748.47	4750.1	6183.0
2023-11-07 02:00:00	ES	Futures	4750.1	4750.91	4746.03	4747.65	8963.0
2023-11-07 03:00:00	ES	Futures	4747.93	4756.34	4746.3	4754.44	15980.0
2023-11-07 04:00:00	ES	Futures	4754.72	4754.99	4748.2	4748.47	12723.0
2023-11-07 05:00:00	ES	Futures	4748.47	4754.99	4747.38	4751.73	11839.0
2023-11-07 06:00:00	ES	Futures	4751.46	4752.54	4742.5	4747.65	14474.0
2023-11-07 07:00:00	ES	Futures	4747.65	4752.0	4747.11	4751.73	23744.0
2023-11-07 08:00:00	ES	Futures	4752.0	4758.52	4750.1	4758.25	37712.0
2023-11-07 09:00:00	ES	Futures	4758.25	4763.13	4749.28	4760.69	186745.0
2023-11-07 10:00:00	ES	Futures	4760.42	4781.33	4758.79	4778.61	228548.0
2023-11-07 11:00:00	ES	Futures	4778.61	4782.14	4772.37	4775.08	133018.0
2023-11-07 12:00:00	ES	Futures	4775.35	4775.35	4763.95	4773.45	127859.0
2023-11-07 13:00:00	ES	Futures	4773.18	4781.6	4771.55	4779.16	112644.0
2023-11-07 14:00:00	ES	Futures	4779.16	4781.6	4774.27	4775.35	82779.0
2023-11-07 15:00:00	ES	Futures	4775.63	4782.96	4768.02	4775.63	225183.0
2023-11-07 16:00:00	ES	Futures	4775.35	4776.98	4774.0	4776.71	43362.0
2023-11-07 18:00:00	ES	Futures	4776.71	4776.71	4773.18	4774.0	5660.0
2023-11-07 19:00:00	ES	Futures	4774.0	4775.9	4772.64	4773.18	5771.0
2023-11-07 20:00:00	ES	Futures	4773.45	4774.0	4771.28	4772.91	6678.0
2023-11-07 21:00:00	ES	Futures	4773.18	4775.63	4771.55	4775.08	4528.0
2023-11-07 22:00:00	ES	Futures	4775.08	4775.63	4768.29	4769.92	6130.0
2023-11-07 23:00:00	ES	Futures	4770.19	4772.37	4769.92	4771.82	3266.0
2023-11-07 00:00:00	NQ	Futures	16705.63	16711.39	16695.74	16708.1	2661.0
2023-11-07 01:00:00	NQ	Futures	16708.1	16713.59	16691.89	16699.03	3214.0
2023-11-07 02:00:00	NQ	Futures	16698.76	16701.78	16681.73	16685.85	4470.0
2023-11-07 03:00:00	NQ	Futures	16685.85	16729.52	16683.1	16721.83	9497.0
2023-11-07 04:00:00	NQ	Futures	16721.83	16725.4	16691.07	16692.17	7420.0
2023-11-07 05:00:00	NQ	Futures	16691.89	16714.96	16686.12	16700.96	6046.0
2023-11-07 06:00:00	NQ	Futures	16700.68	16705.63	16673.22	16692.99	7608.0
2023-11-07 07:00:00	NQ	Futures	16692.72	16727.05	16691.34	16724.85	13993.0
2023-11-07 08:00:00	NQ	Futures	16725.13	16758.09	16721.01	16756.99	19380.0
2023-11-07 09:00:00	NQ	Futures	16757.54	16813.02	16725.95	16806.98	95517.0
2023-11-07 10:00:00	NQ	Futures	16806.98	16914.37	16779.51	16905.58	105832.0
2023-11-07 11:00:00	NQ	Futures	16905.58	16922.34	16869.6	16891.57	59128.0
2023-11-07 12:00:00	NQ	Futures	16891.85	16894.32	16841.58	16888.83	53840.0
2023-11-07 13:00:00	NQ	Futures	16889.38	16927.55	16881.41	16920.14	45804.0
2023-11-07 14:00:00	NQ	Futures	16920.14	16932.77	16897.89	16904.48	36548.0
2023-11-07 15:00:00	NQ	Futures	16905.03	16928.1	16868.78	16892.12	69202.0
2023-11-07 16:00:00	NQ	Futures	16891.57	16898.44	16888.0	16892.95	11342.0
2023-11-07 18:00:00	NQ	Futures	16889.65	16892.12	16878.94	16884.71	3432.0
2023-11-07 19:00:00	NQ	Futures	16884.71	16893.22	16877.02	16880.59	4206.0
2023-11-07 20:00:00	NQ	Futures	16880.86	16885.26	16874.82	16881.41	4104.0
2023-11-07 21:00:00	NQ	Futures	16882.23	16892.12	16876.19	16890.75	3375.0
2023-11-07 22:00:00	NQ	Futures	16890.47	16892.95	16862.18	16868.23	4286.0
2023-11-07 23:00:00	NQ	Futures	16868.5	16874.82	16866.3	16873.72	2423.0
2023-11-07 00:00:00	YM	Futures	36966.5	36975.2	36956.7	36970.8	643.0
2023-11-07 01:00:00	YM	Futures	36970.8	36970.8	36941.6	36951.3	997.0
2023-11-07 02:00:00	YM	Futures	36951.3	36969.8	36939.4	36960.0	2130.0
2023-11-07 03:00:00	YM	Futures	36958.9	37007.7	36945.9	36992.5	3845.0

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

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