PREVIEW / futures_1hour / 2022-01-31

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-01-31.parquet
  size:    68 KB
  rows:    2,070

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-01-31 00:00:00	ES	Futures	5013.8	5018.04	5007.86	5016.63	6302.0
2022-01-31 01:00:00	ES	Futures	5016.91	5019.74	5008.43	5010.4	7780.0
2022-01-31 02:00:00	ES	Futures	5010.12	5010.97	5001.07	5009.56	14977.0
2022-01-31 03:00:00	ES	Futures	5009.56	5014.93	4994.29	5014.08	31004.0
2022-01-31 04:00:00	ES	Futures	5014.36	5017.47	5002.49	5008.99	17293.0
2022-01-31 05:00:00	ES	Futures	5008.99	5010.4	4994.85	4999.94	19591.0
2022-01-31 06:00:00	ES	Futures	4999.94	5003.33	4989.19	4994.57	19911.0
2022-01-31 07:00:00	ES	Futures	4994.85	4996.83	4972.23	4989.48	36829.0
2022-01-31 08:00:00	ES	Futures	4989.48	4997.4	4978.17	4992.87	39577.0
2022-01-31 09:00:00	ES	Futures	4993.15	5020.87	4980.43	5020.59	201418.0
2022-01-31 10:00:00	ES	Futures	5020.59	5048.58	5019.74	5041.51	248878.0
2022-01-31 11:00:00	ES	Futures	5041.51	5059.9	5027.09	5059.05	155714.0
2022-01-31 12:00:00	ES	Futures	5058.76	5068.1	5046.89	5065.55	117216.0
2022-01-31 13:00:00	ES	Futures	5065.55	5069.51	5056.78	5066.4	101945.0
2022-01-31 14:00:00	ES	Futures	5066.12	5077.71	5064.42	5074.32	105286.0
2022-01-31 15:00:00	ES	Futures	5074.04	5099.2	5047.17	5092.42	425588.0
2022-01-31 16:00:00	ES	Futures	5092.13	5092.98	5079.13	5081.11	88277.0
2022-01-31 18:00:00	ES	Futures	5082.8	5087.04	5077.71	5082.52	10443.0
2022-01-31 19:00:00	ES	Futures	5082.8	5086.2	5079.97	5083.93	7684.0
2022-01-31 20:00:00	ES	Futures	5083.93	5084.5	5067.53	5069.79	12596.0
2022-01-31 21:00:00	ES	Futures	5069.79	5074.6	5066.4	5072.06	7493.0
2022-01-31 22:00:00	ES	Futures	5072.06	5081.39	5070.64	5080.82	7948.0
2022-01-31 23:00:00	ES	Futures	5080.82	5082.24	5076.86	5081.67	3859.0
2022-01-31 00:00:00	NQ	Futures	16787.95	16804.47	16758.1	16795.77	5151.0
2022-01-31 01:00:00	NQ	Futures	16796.06	16812.29	16760.71	16773.75	5485.0
2022-01-31 02:00:00	NQ	Futures	16773.17	16784.47	16734.04	16780.41	8525.0
2022-01-31 03:00:00	NQ	Futures	16780.12	16848.23	16721.87	16837.51	16696.0
2022-01-31 04:00:00	NQ	Futures	16837.22	16863.88	16818.67	16835.19	9888.0
2022-01-31 05:00:00	NQ	Futures	16835.48	16840.41	16777.23	16807.95	9711.0
2022-01-31 06:00:00	NQ	Futures	16807.37	16823.31	16770.85	16796.93	9172.0
2022-01-31 07:00:00	NQ	Futures	16797.22	16804.47	16693.18	16754.33	15668.0
2022-01-31 08:00:00	NQ	Futures	16754.62	16790.85	16718.39	16776.07	16754.0
2022-01-31 09:00:00	NQ	Futures	16776.94	16964.74	16712.31	16959.81	80754.0
2022-01-31 10:00:00	NQ	Futures	16959.81	17069.65	16955.46	17057.77	91726.0
2022-01-31 11:00:00	NQ	Futures	17057.77	17134.86	16997.78	17125.59	64850.0
2022-01-31 12:00:00	NQ	Futures	17125.01	17138.63	17051.1	17129.35	44412.0
2022-01-31 13:00:00	NQ	Futures	17128.77	17141.53	17077.48	17127.9	38119.0
2022-01-31 14:00:00	NQ	Futures	17128.48	17187.03	17111.96	17169.64	38650.0
2022-01-31 15:00:00	NQ	Futures	17169.93	17290.2	17058.06	17271.36	102006.0
2022-01-31 16:00:00	NQ	Futures	17269.33	17271.36	17213.4	17236.01	19862.0
2022-01-31 18:00:00	NQ	Futures	17236.88	17256.0	17224.41	17236.59	5042.0
2022-01-31 19:00:00	NQ	Futures	17238.61	17251.37	17225.86	17245.57	4389.0
2022-01-31 20:00:00	NQ	Futures	17245.28	17246.73	17182.68	17191.66	6884.0
2022-01-31 21:00:00	NQ	Futures	17191.37	17213.4	17178.04	17205.86	4678.0
2022-01-31 22:00:00	NQ	Futures	17206.44	17242.96	17198.91	17239.19	5273.0
2022-01-31 23:00:00	NQ	Futures	17239.19	17246.73	17224.41	17238.32	2756.0
2022-01-31 00:00:00	YM	Futures	38948.7	38976.8	38909.3	38968.9	1045.0
2022-01-31 01:00:00	YM	Futures	38968.9	39009.4	38925.1	38931.8	1823.0
2022-01-31 02:00:00	YM	Futures	38935.2	38937.4	38874.5	38920.6	4135.0
2022-01-31 03:00:00	YM	Futures	38920.6	38920.6	38789.1	38904.8	9010.0

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

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