PREVIEW / futures_1hour / 2023-04-11

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-04-11.parquet
  size:    65 KB
  rows:    2,032

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-04-11 00:00:00	ES	Futures	4593.25	4594.91	4591.03	4591.31	3952.0
2023-04-11 01:00:00	ES	Futures	4591.31	4595.19	4591.03	4594.36	4995.0
2023-04-11 02:00:00	ES	Futures	4594.36	4597.13	4592.97	4593.25	8149.0
2023-04-11 03:00:00	ES	Futures	4592.97	4595.47	4590.48	4591.86	17674.0
2023-04-11 04:00:00	ES	Futures	4591.86	4596.86	4591.59	4596.3	9682.0
2023-04-11 05:00:00	ES	Futures	4596.58	4602.96	4596.3	4601.85	12695.0
2023-04-11 06:00:00	ES	Futures	4601.85	4602.4	4595.19	4596.86	10403.0
2023-04-11 07:00:00	ES	Futures	4596.86	4598.24	4584.93	4587.7	21582.0
2023-04-11 08:00:00	ES	Futures	4587.43	4594.08	4586.32	4589.37	21885.0
2023-04-11 09:00:00	ES	Futures	4589.37	4596.02	4585.76	4587.43	151731.0
2023-04-11 10:00:00	ES	Futures	4587.15	4593.25	4580.49	4585.76	183135.0
2023-04-11 11:00:00	ES	Futures	4585.76	4594.08	4585.21	4592.97	131915.0
2023-04-11 12:00:00	ES	Futures	4592.97	4598.8	4590.75	4597.41	119590.0
2023-04-11 13:00:00	ES	Futures	4597.41	4602.68	4594.36	4601.85	91584.0
2023-04-11 14:00:00	ES	Futures	4601.85	4605.45	4598.8	4603.23	86667.0
2023-04-11 15:00:00	ES	Futures	4603.51	4606.01	4584.65	4590.48	216625.0
2023-04-11 16:00:00	ES	Futures	4590.2	4593.25	4589.64	4591.03	46494.0
2023-04-11 18:00:00	ES	Futures	4590.2	4592.97	4589.64	4591.86	3369.0
2023-04-11 19:00:00	ES	Futures	4591.59	4593.8	4591.03	4592.42	3804.0
2023-04-11 20:00:00	ES	Futures	4592.42	4593.53	4589.09	4591.31	5922.0
2023-04-11 21:00:00	ES	Futures	4591.31	4593.25	4588.53	4590.75	6984.0
2023-04-11 22:00:00	ES	Futures	4590.75	4592.69	4590.75	4591.86	3274.0
2023-04-11 23:00:00	ES	Futures	4591.86	4592.14	4589.64	4590.2	3278.0
2023-04-11 00:00:00	NQ	Futures	14811.66	14819.54	14805.18	14805.75	2140.0
2023-04-11 01:00:00	NQ	Futures	14805.75	14826.86	14803.49	14822.36	3159.0
2023-04-11 02:00:00	NQ	Futures	14822.64	14836.15	14818.14	14819.82	3844.0
2023-04-11 03:00:00	NQ	Futures	14820.39	14843.19	14812.22	14827.14	8347.0
2023-04-11 04:00:00	NQ	Futures	14827.14	14855.86	14825.46	14855.3	5796.0
2023-04-11 05:00:00	NQ	Futures	14855.02	14875.57	14853.33	14874.45	6614.0
2023-04-11 06:00:00	NQ	Futures	14875.01	14875.85	14837.0	14842.91	7183.0
2023-04-11 07:00:00	NQ	Futures	14842.63	14847.42	14782.1	14794.2	14601.0
2023-04-11 08:00:00	NQ	Futures	14794.2	14817.29	14788.01	14794.48	11404.0
2023-04-11 09:00:00	NQ	Futures	14794.2	14824.89	14745.21	14760.7	79382.0
2023-04-11 10:00:00	NQ	Futures	14761.26	14775.62	14705.8	14713.4	96114.0
2023-04-11 11:00:00	NQ	Futures	14713.12	14748.31	14701.01	14726.07	63175.0
2023-04-11 12:00:00	NQ	Futures	14726.35	14758.73	14711.99	14750.56	55515.0
2023-04-11 13:00:00	NQ	Futures	14750.84	14780.69	14728.32	14777.87	42089.0
2023-04-11 14:00:00	NQ	Futures	14778.15	14790.54	14757.88	14783.5	37932.0
2023-04-11 15:00:00	NQ	Futures	14784.07	14791.11	14710.02	14727.19	72050.0
2023-04-11 16:00:00	NQ	Futures	14727.48	14739.3	14725.22	14732.26	11930.0
2023-04-11 18:00:00	NQ	Futures	14723.81	14739.58	14723.81	14736.77	2159.0
2023-04-11 19:00:00	NQ	Futures	14736.77	14749.44	14735.08	14741.55	2164.0
2023-04-11 20:00:00	NQ	Futures	14741.55	14746.34	14726.63	14735.08	3042.0
2023-04-11 21:00:00	NQ	Futures	14734.8	14742.4	14715.65	14727.76	3883.0
2023-04-11 22:00:00	NQ	Futures	14727.48	14732.54	14720.72	14727.76	1886.0
2023-04-11 23:00:00	NQ	Futures	14728.04	14728.6	14720.15	14722.97	1437.0
2023-04-11 00:00:00	YM	Futures	37351.7	37367.2	37336.2	37336.2	582.0
2023-04-11 01:00:00	YM	Futures	37337.3	37357.2	37335.1	37346.2	993.0
2023-04-11 02:00:00	YM	Futures	37346.2	37365.0	37335.1	37339.5	1815.0
2023-04-11 03:00:00	YM	Futures	37339.5	37355.0	37303.1	37313.0	3323.0

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

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