PREVIEW / futures_1hour / 2023-10-20

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-10-20.parquet
  size:    56 KB
  rows:    1,669

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-10-20 00:00:00	ES	Futures	4667.0	4669.99	4666.19	4668.09	3727.0
2023-10-20 01:00:00	ES	Futures	4668.09	4668.63	4662.66	4663.47	5592.0
2023-10-20 02:00:00	ES	Futures	4663.47	4664.01	4652.61	4661.03	15989.0
2023-10-20 03:00:00	ES	Futures	4661.3	4667.55	4652.88	4664.29	35185.0
2023-10-20 04:00:00	ES	Futures	4664.56	4675.42	4659.67	4670.53	25333.0
2023-10-20 05:00:00	ES	Futures	4670.8	4671.35	4658.31	4663.2	24557.0
2023-10-20 06:00:00	ES	Futures	4663.2	4664.56	4657.23	4660.48	16985.0
2023-10-20 07:00:00	ES	Futures	4660.76	4670.26	4658.86	4668.09	30676.0
2023-10-20 08:00:00	ES	Futures	4667.82	4669.17	4651.25	4657.77	58964.0
2023-10-20 09:00:00	ES	Futures	4658.04	4673.25	4656.95	4657.23	295534.0
2023-10-20 10:00:00	ES	Futures	4656.95	4661.03	4626.81	4627.9	369091.0
2023-10-20 11:00:00	ES	Futures	4627.9	4642.56	4622.19	4638.22	257671.0
2023-10-20 12:00:00	ES	Futures	4638.22	4650.17	4626.54	4647.99	198972.0
2023-10-20 13:00:00	ES	Futures	4648.26	4654.24	4634.96	4647.45	214922.0
2023-10-20 14:00:00	ES	Futures	4647.72	4648.26	4625.73	4630.34	186978.0
2023-10-20 15:00:00	ES	Futures	4630.34	4635.5	4613.51	4614.86	352169.0
2023-10-20 16:00:00	ES	Futures	4614.86	4616.49	4609.43	4610.52	82732.0
2023-10-20 00:00:00	NQ	Futures	16312.31	16321.64	16307.64	16314.78	2424.0
2023-10-20 01:00:00	NQ	Futures	16314.5	16315.33	16290.06	16293.35	3717.0
2023-10-20 02:00:00	NQ	Futures	16292.81	16295.0	16255.73	16291.98	9296.0
2023-10-20 03:00:00	NQ	Futures	16291.98	16308.46	16263.97	16293.9	15464.0
2023-10-20 04:00:00	NQ	Futures	16294.45	16356.25	16283.47	16333.18	14818.0
2023-10-20 05:00:00	NQ	Futures	16334.0	16336.2	16291.98	16313.95	10428.0
2023-10-20 06:00:00	NQ	Futures	16313.95	16319.17	16286.49	16297.75	7488.0
2023-10-20 07:00:00	NQ	Futures	16298.02	16337.58	16286.76	16329.88	13066.0
2023-10-20 08:00:00	NQ	Futures	16329.34	16331.81	16265.06	16288.96	21603.0
2023-10-20 09:00:00	NQ	Futures	16288.96	16354.6	16271.93	16301.32	118036.0
2023-10-20 10:00:00	NQ	Futures	16301.05	16327.41	16130.48	16131.3	132580.0
2023-10-20 11:00:00	NQ	Futures	16131.58	16193.1	16106.58	16177.45	103862.0
2023-10-20 12:00:00	NQ	Futures	16178.27	16235.95	16134.87	16230.18	77224.0
2023-10-20 13:00:00	NQ	Futures	16230.73	16263.69	16188.71	16234.85	86348.0
2023-10-20 14:00:00	NQ	Futures	16234.85	16239.52	16137.62	16158.22	73282.0
2023-10-20 15:00:00	NQ	Futures	16158.77	16183.49	16097.24	16107.68	93191.0
2023-10-20 16:00:00	NQ	Futures	16107.96	16116.2	16089.83	16094.22	18540.0
2023-10-20 00:00:00	YM	Futures	36375.3	36392.7	36367.7	36379.6	949.0
2023-10-20 01:00:00	YM	Futures	36379.6	36382.9	36347.1	36351.4	1344.0
2023-10-20 02:00:00	YM	Futures	36350.3	36357.9	36286.3	36329.7	4077.0
2023-10-20 03:00:00	YM	Futures	36330.8	36374.2	36267.9	36354.7	7004.0
2023-10-20 04:00:00	YM	Futures	36354.7	36404.6	36317.8	36366.6	3744.0
2023-10-20 05:00:00	YM	Futures	36367.7	36376.4	36287.4	36317.8	3446.0
2023-10-20 06:00:00	YM	Futures	36316.7	36328.6	36275.5	36298.3	2398.0
2023-10-20 07:00:00	YM	Futures	36300.4	36349.3	36284.2	36333.0	6783.0
2023-10-20 08:00:00	YM	Futures	36330.8	36340.6	36235.4	36283.1	5482.0
2023-10-20 09:00:00	YM	Futures	36285.3	36404.6	36283.1	36307.0	31708.0
2023-10-20 10:00:00	YM	Futures	36304.8	36317.8	36171.4	36212.6	30134.0
2023-10-20 11:00:00	YM	Futures	36212.6	36289.6	36157.3	36266.8	22053.0
2023-10-20 12:00:00	YM	Futures	36265.7	36310.2	36180.0	36295.0	16621.0
2023-10-20 13:00:00	YM	Futures	36295.0	36324.3	36202.8	36272.2	16603.0
2023-10-20 14:00:00	YM	Futures	36272.2	36277.7	36142.1	36168.1	12569.0
2023-10-20 15:00:00	YM	Futures	36169.2	36196.3	36067.2	36073.7	18171.0

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

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