PREVIEW / futures_1hour / 2022-07-07

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-07-07.parquet
  size:    68 KB
  rows:    2,044

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
2022-07-07 00:00:00	ES	Futures	4362.1	4368.05	4360.96	4367.76	4668.0
2022-07-07 01:00:00	ES	Futures	4367.76	4380.51	4366.35	4372.58	10838.0
2022-07-07 02:00:00	ES	Futures	4372.58	4376.83	4366.91	4370.03	8544.0
2022-07-07 03:00:00	ES	Futures	4369.75	4379.38	4364.93	4376.26	20154.0
2022-07-07 04:00:00	ES	Futures	4376.26	4382.21	4365.78	4372.01	25695.0
2022-07-07 05:00:00	ES	Futures	4372.01	4378.53	4366.91	4368.33	24084.0
2022-07-07 06:00:00	ES	Futures	4368.05	4374.28	4361.81	4374.0	14822.0
2022-07-07 07:00:00	ES	Futures	4374.0	4379.94	4366.63	4378.81	14649.0
2022-07-07 08:00:00	ES	Futures	4378.81	4383.34	4371.16	4379.38	29021.0
2022-07-07 09:00:00	ES	Futures	4379.38	4409.69	4376.83	4407.42	175629.0
2022-07-07 10:00:00	ES	Futures	4407.42	4412.24	4392.12	4407.14	190813.0
2022-07-07 11:00:00	ES	Futures	4407.14	4414.79	4402.61	4412.8	123776.0
2022-07-07 12:00:00	ES	Futures	4413.09	4419.04	4410.25	4414.79	107816.0
2022-07-07 13:00:00	ES	Futures	4414.79	4419.89	4406.85	4419.04	86749.0
2022-07-07 14:00:00	ES	Futures	4419.04	4425.55	4417.9	4423.85	91499.0
2022-07-07 15:00:00	ES	Futures	4424.13	4435.18	4420.45	4424.42	245550.0
2022-07-07 16:00:00	ES	Futures	4424.42	4424.42	4416.49	4418.19	48327.0
2022-07-07 18:00:00	ES	Futures	4415.64	4420.17	4414.79	4419.04	4899.0
2022-07-07 19:00:00	ES	Futures	4418.75	4419.6	4413.37	4415.92	4902.0
2022-07-07 20:00:00	ES	Futures	4415.64	4422.72	4411.67	4421.3	8151.0
2022-07-07 21:00:00	ES	Futures	4421.3	4424.7	4415.64	4417.34	6878.0
2022-07-07 22:00:00	ES	Futures	4417.62	4422.72	4405.44	4407.7	9918.0
2022-07-07 23:00:00	ES	Futures	4407.42	4415.35	4405.15	4406.29	11690.0
2022-07-07 00:00:00	NQ	Futures	13758.52	13786.87	13758.52	13785.42	3174.0
2022-07-07 01:00:00	NQ	Futures	13786.29	13826.49	13779.35	13795.83	6805.0
2022-07-07 02:00:00	NQ	Futures	13795.83	13810.01	13769.8	13786.0	6378.0
2022-07-07 03:00:00	NQ	Futures	13785.13	13813.19	13761.13	13796.99	10101.0
2022-07-07 04:00:00	NQ	Futures	13796.41	13842.4	13784.27	13804.8	9770.0
2022-07-07 05:00:00	NQ	Futures	13804.51	13825.05	13776.46	13779.06	9176.0
2022-07-07 06:00:00	NQ	Futures	13778.19	13805.38	13756.21	13800.75	6270.0
2022-07-07 07:00:00	NQ	Futures	13801.91	13823.31	13777.32	13819.26	5757.0
2022-07-07 08:00:00	NQ	Futures	13818.68	13825.63	13778.48	13801.62	12850.0
2022-07-07 09:00:00	NQ	Futures	13802.2	13940.17	13782.53	13923.68	74819.0
2022-07-07 10:00:00	NQ	Futures	13923.39	13963.02	13872.19	13941.61	84763.0
2022-07-07 11:00:00	NQ	Futures	13941.61	13986.44	13914.71	13986.15	57708.0
2022-07-07 12:00:00	NQ	Futures	13986.44	14007.56	13969.67	14001.19	51308.0
2022-07-07 13:00:00	NQ	Futures	14001.48	14030.41	13974.87	14029.25	40793.0
2022-07-07 14:00:00	NQ	Futures	14029.54	14052.97	14017.68	14039.08	41302.0
2022-07-07 15:00:00	NQ	Futures	14039.08	14078.42	14025.49	14041.4	76871.0
2022-07-07 16:00:00	NQ	Futures	14040.82	14044.0	14016.24	14022.02	12725.0
2022-07-07 18:00:00	NQ	Futures	14016.52	14026.07	14000.33	14012.19	3390.0
2022-07-07 19:00:00	NQ	Futures	14012.47	14015.95	13995.7	14004.67	3296.0
2022-07-07 20:00:00	NQ	Futures	14004.38	14025.49	13988.76	14022.6	5243.0
2022-07-07 21:00:00	NQ	Futures	14022.89	14034.75	14008.43	14013.63	4497.0
2022-07-07 22:00:00	NQ	Futures	14014.21	14030.7	13960.99	13970.25	6420.0
2022-07-07 23:00:00	NQ	Futures	13970.25	14002.93	13959.25	13973.43	6797.0
2022-07-07 00:00:00	YM	Futures	35011.4	35055.4	35003.5	35047.5	721.0
2022-07-07 01:00:00	YM	Futures	35048.6	35143.4	35037.3	35087.0	1936.0
2022-07-07 02:00:00	YM	Futures	35084.7	35117.4	35050.9	35072.3	1317.0
2022-07-07 03:00:00	YM	Futures	35071.2	35158.1	35043.0	35131.0	2671.0

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

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