PREVIEW / futures_1hour / 2023-10-13

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-10-13.parquet
  size:    57 KB
  rows:    1,656

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-13 00:00:00	ES	Futures	4763.13	4765.03	4761.5	4761.78	3573.0
2023-10-13 01:00:00	ES	Futures	4762.05	4764.22	4760.69	4762.86	5761.0
2023-10-13 02:00:00	ES	Futures	4762.86	4764.49	4758.52	4763.13	8681.0
2023-10-13 03:00:00	ES	Futures	4762.86	4769.11	4761.5	4765.31	16997.0
2023-10-13 04:00:00	ES	Futures	4765.58	4770.47	4757.97	4759.33	18273.0
2023-10-13 05:00:00	ES	Futures	4759.06	4760.42	4743.58	4744.67	29887.0
2023-10-13 06:00:00	ES	Futures	4744.67	4752.27	4741.68	4749.01	35118.0
2023-10-13 07:00:00	ES	Futures	4749.01	4759.06	4748.2	4755.53	27756.0
2023-10-13 08:00:00	ES	Futures	4755.53	4774.54	4749.28	4773.45	64261.0
2023-10-13 09:00:00	ES	Futures	4773.45	4787.85	4771.55	4781.6	223110.0
2023-10-13 10:00:00	ES	Futures	4781.33	4781.6	4745.21	4747.38	338204.0
2023-10-13 11:00:00	ES	Futures	4747.11	4748.47	4728.1	4731.36	277298.0
2023-10-13 12:00:00	ES	Futures	4731.36	4753.9	4729.46	4739.51	195416.0
2023-10-13 13:00:00	ES	Futures	4739.78	4742.22	4715.07	4731.9	249767.0
2023-10-13 14:00:00	ES	Futures	4731.9	4740.05	4724.84	4734.08	197556.0
2023-10-13 15:00:00	ES	Futures	4734.08	4743.85	4720.5	4733.81	304678.0
2023-10-13 16:00:00	ES	Futures	4733.53	4733.81	4725.39	4726.74	64750.0
2023-10-13 00:00:00	NQ	Futures	16840.21	16844.88	16829.22	16831.97	2961.0
2023-10-13 01:00:00	NQ	Futures	16831.42	16842.13	16827.85	16832.25	4177.0
2023-10-13 02:00:00	NQ	Futures	16831.97	16841.03	16815.22	16836.37	5836.0
2023-10-13 03:00:00	NQ	Futures	16835.54	16853.94	16822.36	16834.72	8270.0
2023-10-13 04:00:00	NQ	Futures	16834.44	16848.73	16795.99	16803.96	9385.0
2023-10-13 05:00:00	NQ	Futures	16803.68	16807.53	16729.52	16731.99	15602.0
2023-10-13 06:00:00	NQ	Futures	16731.44	16758.64	16718.53	16749.57	16473.0
2023-10-13 07:00:00	NQ	Futures	16749.3	16783.08	16747.92	16773.47	13918.0
2023-10-13 08:00:00	NQ	Futures	16774.29	16845.7	16753.69	16841.31	27281.0
2023-10-13 09:00:00	NQ	Futures	16841.03	16882.78	16812.2	16861.09	87437.0
2023-10-13 10:00:00	NQ	Futures	16858.06	16858.06	16685.03	16700.68	121202.0
2023-10-13 11:00:00	NQ	Futures	16700.68	16710.02	16599.88	16610.59	96852.0
2023-10-13 12:00:00	NQ	Futures	16610.87	16700.41	16602.9	16661.13	75568.0
2023-10-13 13:00:00	NQ	Futures	16661.13	16663.88	16548.24	16608.39	88644.0
2023-10-13 14:00:00	NQ	Futures	16608.39	16637.78	16578.73	16623.23	66666.0
2023-10-13 15:00:00	NQ	Futures	16623.5	16665.52	16569.67	16613.34	92737.0
2023-10-13 16:00:00	NQ	Futures	16613.61	16615.81	16591.37	16597.96	15622.0
2023-10-13 00:00:00	YM	Futures	36699.6	36712.7	36691.0	36696.4	762.0
2023-10-13 01:00:00	YM	Futures	36696.4	36708.3	36692.1	36704.0	1203.0
2023-10-13 02:00:00	YM	Futures	36704.0	36712.7	36672.5	36708.3	2288.0
2023-10-13 03:00:00	YM	Futures	36708.3	36758.2	36698.6	36734.4	5140.0
2023-10-13 04:00:00	YM	Futures	36736.5	36770.2	36694.2	36700.7	4735.0
2023-10-13 05:00:00	YM	Futures	36701.8	36706.2	36598.8	36617.2	7082.0
2023-10-13 06:00:00	YM	Futures	36617.2	36692.1	36594.4	36656.3	7894.0
2023-10-13 07:00:00	YM	Futures	36657.3	36726.8	36641.1	36697.5	4329.0
2023-10-13 08:00:00	YM	Futures	36697.5	36790.8	36651.9	36789.7	8991.0
2023-10-13 09:00:00	YM	Futures	36789.7	37016.4	36771.2	36948.1	36266.0
2023-10-13 10:00:00	YM	Futures	36944.8	36944.8	36699.6	36718.1	35016.0
2023-10-13 11:00:00	YM	Futures	36717.0	36744.1	36611.8	36646.5	22660.0
2023-10-13 12:00:00	YM	Futures	36645.4	36824.4	36628.1	36724.6	18881.0
2023-10-13 13:00:00	YM	Futures	36723.5	36750.6	36565.1	36694.2	24331.0
2023-10-13 14:00:00	YM	Futures	36695.3	36744.1	36634.6	36691.0	17080.0
2023-10-13 15:00:00	YM	Futures	36692.1	36756.1	36608.5	36701.8	24987.0

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

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