PREVIEW / futures_1hour / 2022-01-21

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-01-21.parquet
  size:    56 KB
  rows:    1,638

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-21 00:00:00	ES	Futures	5024.54	5041.8	5023.7	5037.84	13890.0
2022-01-21 01:00:00	ES	Futures	5037.84	5048.3	5030.77	5040.95	13017.0
2022-01-21 02:00:00	ES	Futures	5040.95	5059.05	5033.59	5053.67	22131.0
2022-01-21 03:00:00	ES	Futures	5053.39	5059.61	5038.68	5054.24	31946.0
2022-01-21 04:00:00	ES	Futures	5054.24	5061.03	5043.21	5058.76	22453.0
2022-01-21 05:00:00	ES	Futures	5058.76	5065.27	5053.11	5061.87	19254.0
2022-01-21 06:00:00	ES	Futures	5061.87	5061.87	5034.73	5045.47	32223.0
2022-01-21 07:00:00	ES	Futures	5045.19	5046.32	5026.52	5033.88	44415.0
2022-01-21 08:00:00	ES	Futures	5034.16	5042.08	5027.94	5036.42	51021.0
2022-01-21 09:00:00	ES	Futures	5036.42	5059.61	5020.02	5025.68	338057.0
2022-01-21 10:00:00	ES	Futures	5025.39	5065.27	4991.46	5053.11	553319.0
2022-01-21 11:00:00	ES	Futures	5053.11	5075.73	5024.26	5035.01	308362.0
2022-01-21 12:00:00	ES	Futures	5035.01	5040.95	5007.86	5016.63	246414.0
2022-01-21 13:00:00	ES	Futures	5016.34	5032.18	5001.36	5008.99	211112.0
2022-01-21 14:00:00	ES	Futures	5008.99	5021.72	4982.69	4984.1	227023.0
2022-01-21 15:00:00	ES	Futures	4983.82	4998.53	4960.63	4960.91	507174.0
2022-01-21 16:00:00	ES	Futures	4960.91	4969.4	4956.11	4956.39	115363.0
2022-01-21 00:00:00	NQ	Futures	16975.46	17060.09	16970.24	17040.09	8533.0
2022-01-21 01:00:00	NQ	Futures	17040.09	17077.48	17007.63	17044.73	7408.0
2022-01-21 02:00:00	NQ	Futures	17044.44	17135.44	17019.22	17116.6	14795.0
2022-01-21 03:00:00	NQ	Futures	17115.73	17147.61	17046.18	17111.67	21150.0
2022-01-21 04:00:00	NQ	Futures	17112.54	17150.22	17073.13	17136.89	13368.0
2022-01-21 05:00:00	NQ	Futures	17136.89	17176.3	17117.47	17155.73	10660.0
2022-01-21 06:00:00	NQ	Futures	17154.57	17154.57	17038.64	17097.76	19575.0
2022-01-21 07:00:00	NQ	Futures	17096.31	17099.21	17018.06	17050.23	17558.0
2022-01-21 08:00:00	NQ	Futures	17050.23	17089.65	17021.54	17059.51	23109.0
2022-01-21 09:00:00	NQ	Futures	17059.51	17178.62	16961.55	16983.29	129205.0
2022-01-21 10:00:00	NQ	Futures	16983.86	17178.91	16846.78	17116.02	178551.0
2022-01-21 11:00:00	NQ	Futures	17114.86	17224.99	16985.89	17037.19	110949.0
2022-01-21 12:00:00	NQ	Futures	17036.61	17090.52	16930.54	16974.01	85167.0
2022-01-21 13:00:00	NQ	Futures	16974.01	17041.83	16899.24	16934.02	72273.0
2022-01-21 14:00:00	NQ	Futures	16934.31	16991.69	16814.32	16822.15	66705.0
2022-01-21 15:00:00	NQ	Futures	16821.28	16896.34	16710.28	16711.73	136451.0
2022-01-21 16:00:00	NQ	Futures	16710.57	16754.33	16703.32	16706.22	24799.0
2022-01-21 00:00:00	YM	Futures	38776.7	38879.0	38768.9	38857.6	2573.0
2022-01-21 01:00:00	YM	Futures	38857.6	38935.2	38808.2	38894.7	2883.0
2022-01-21 02:00:00	YM	Futures	38884.6	38989.1	38827.3	38932.9	6509.0
2022-01-21 03:00:00	YM	Futures	38929.6	38970.0	38827.3	38946.4	9407.0
2022-01-21 04:00:00	YM	Futures	38947.5	38970.0	38859.9	38953.2	6617.0
2022-01-21 05:00:00	YM	Futures	38952.0	38985.8	38906.0	38973.4	3638.0
2022-01-21 06:00:00	YM	Futures	38966.6	38966.6	38799.2	38850.9	8126.0
2022-01-21 07:00:00	YM	Futures	38852.0	38864.4	38740.8	38782.3	8827.0
2022-01-21 08:00:00	YM	Futures	38785.7	38838.5	38757.6	38785.7	7881.0
2022-01-21 09:00:00	YM	Futures	38789.1	38959.9	38693.6	38811.6	44789.0
2022-01-21 10:00:00	YM	Futures	38812.7	39039.7	38577.8	38965.5	57657.0
2022-01-21 11:00:00	YM	Futures	38967.8	39088.0	38750.9	38825.0	28499.0
2022-01-21 12:00:00	YM	Futures	38825.0	38830.7	38632.9	38681.2	25608.0
2022-01-21 13:00:00	YM	Futures	38679.0	38785.7	38585.7	38653.1	23669.0
2022-01-21 14:00:00	YM	Futures	38652.0	38740.8	38455.3	38465.4	20854.0
2022-01-21 15:00:00	YM	Futures	38466.6	38573.3	38330.6	38346.3	36539.0

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

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