PREVIEW / futures_1hour / 2022-04-18

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-04-18.parquet
  size:    55 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-04-18 00:00:00	ES	Futures	4950.28	4951.13	4944.9	4945.75	4040.0
2022-04-18 01:00:00	ES	Futures	4946.03	4953.12	4945.75	4951.98	4418.0
2022-04-18 02:00:00	ES	Futures	4952.27	4955.39	4948.87	4951.7	5733.0
2022-04-18 03:00:00	ES	Futures	4951.42	4952.27	4944.9	4949.72	3843.0
2022-04-18 04:00:00	ES	Futures	4949.72	4958.79	4949.43	4953.68	4374.0
2022-04-18 05:00:00	ES	Futures	4953.97	4954.25	4944.33	4948.87	3863.0
2022-04-18 06:00:00	ES	Futures	4948.58	4955.95	4948.02	4953.12	3951.0
2022-04-18 07:00:00	ES	Futures	4953.4	4968.14	4953.4	4959.64	12722.0
2022-04-18 08:00:00	ES	Futures	4959.64	4965.31	4955.39	4959.07	14026.0
2022-04-18 09:00:00	ES	Futures	4959.07	4992.23	4957.37	4972.96	149236.0
2022-04-18 10:00:00	ES	Futures	4972.96	4992.8	4965.02	4981.75	152740.0
2022-04-18 11:00:00	ES	Futures	4982.03	4986.56	4955.1	4965.87	99991.0
2022-04-18 12:00:00	ES	Futures	4965.87	4966.72	4948.3	4958.79	84947.0
2022-04-18 13:00:00	ES	Futures	4959.07	4995.35	4956.8	4988.83	115951.0
2022-04-18 14:00:00	ES	Futures	4988.83	4995.63	4978.63	4980.04	117389.0
2022-04-18 15:00:00	ES	Futures	4979.76	4982.03	4948.87	4976.08	208030.0
2022-04-18 16:00:00	ES	Futures	4976.08	4993.65	4974.09	4987.98	77278.0
2022-04-18 18:00:00	ES	Futures	4987.41	4993.37	4986.28	4988.83	4360.0
2022-04-18 19:00:00	ES	Futures	4989.11	5001.02	4986.85	5000.74	7710.0
2022-04-18 20:00:00	ES	Futures	5000.74	5000.74	4981.46	4984.58	11416.0
2022-04-18 21:00:00	ES	Futures	4984.3	4990.53	4979.76	4987.41	10458.0
2022-04-18 22:00:00	ES	Futures	4986.85	4987.7	4982.6	4986.28	4712.0
2022-04-18 23:00:00	ES	Futures	4986.56	4996.48	4986.0	4993.08	6593.0
2022-04-18 00:00:00	NQ	Futures	15968.93	15974.44	15946.02	15949.79	2672.0
2022-04-18 01:00:00	NQ	Futures	15952.11	15998.21	15949.5	15990.09	4233.0
2022-04-18 02:00:00	NQ	Futures	15990.96	16013.0	15983.42	15989.51	4267.0
2022-04-18 03:00:00	NQ	Futures	15989.51	15998.21	15972.12	15992.7	3716.0
2022-04-18 04:00:00	NQ	Futures	15992.41	16052.15	15991.54	16022.57	5891.0
2022-04-18 05:00:00	NQ	Futures	16022.28	16024.89	15981.1	16001.69	3986.0
2022-04-18 06:00:00	NQ	Futures	16001.4	16036.49	16000.53	16025.18	3543.0
2022-04-18 07:00:00	NQ	Futures	16024.31	16087.24	16024.31	16051.86	7877.0
2022-04-18 08:00:00	NQ	Futures	16052.15	16076.22	16008.94	16057.95	12081.0
2022-04-18 09:00:00	NQ	Futures	16057.95	16160.02	16037.94	16084.05	69644.0
2022-04-18 10:00:00	NQ	Futures	16083.76	16241.5	16047.51	16169.01	74265.0
2022-04-18 11:00:00	NQ	Futures	16169.01	16196.27	16050.12	16093.9	49825.0
2022-04-18 12:00:00	NQ	Futures	16093.62	16096.8	15990.38	16026.34	43664.0
2022-04-18 13:00:00	NQ	Futures	16026.63	16212.79	16012.71	16186.7	45187.0
2022-04-18 14:00:00	NQ	Futures	16187.28	16233.67	16154.51	16159.15	43927.0
2022-04-18 15:00:00	NQ	Futures	16158.57	16172.49	16034.75	16142.33	58009.0
2022-04-18 16:00:00	NQ	Futures	16142.04	16227.58	16138.85	16198.01	22771.0
2022-04-18 18:00:00	NQ	Futures	16195.4	16224.68	16192.21	16207.58	2694.0
2022-04-18 19:00:00	NQ	Futures	16207.87	16260.64	16199.17	16257.74	4578.0
2022-04-18 20:00:00	NQ	Futures	16257.74	16260.64	16172.49	16185.25	6489.0
2022-04-18 21:00:00	NQ	Futures	16184.67	16213.95	16161.47	16194.82	6152.0
2022-04-18 22:00:00	NQ	Futures	16193.66	16198.59	16175.1	16190.18	3073.0
2022-04-18 23:00:00	NQ	Futures	16190.76	16238.31	16186.7	16230.19	3964.0
2022-04-18 00:00:00	YM	Futures	38657.3	38664.1	38625.7	38638.1	1031.0
2022-04-18 01:00:00	YM	Futures	38637.0	38676.5	38630.2	38667.4	1488.0
2022-04-18 02:00:00	YM	Futures	38669.7	38687.7	38641.5	38672.0	1629.0
2022-04-18 03:00:00	YM	Futures	38673.1	38673.1	38613.3	38649.4	1636.0

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

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