PREVIEW / futures_1hour / 2021-08-09

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-08-09.parquet
  size:    62 KB
  rows:    1,946

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
2021-08-09 00:00:00	ES	Futures	4978.94	4979.78	4977.81	4978.66	1962.0
2021-08-09 01:00:00	ES	Futures	4978.94	4979.5	4976.97	4977.25	3702.0
2021-08-09 02:00:00	ES	Futures	4977.25	4977.25	4973.31	4975.56	8791.0
2021-08-09 03:00:00	ES	Futures	4975.56	4987.1	4974.99	4978.94	18809.0
2021-08-09 04:00:00	ES	Futures	4978.66	4982.03	4975.84	4980.91	10062.0
2021-08-09 05:00:00	ES	Futures	4980.91	4981.75	4978.37	4981.19	9683.0
2021-08-09 06:00:00	ES	Futures	4980.91	4984.29	4978.94	4979.22	11003.0
2021-08-09 07:00:00	ES	Futures	4979.22	4983.16	4978.37	4982.32	9271.0
2021-08-09 08:00:00	ES	Futures	4982.32	4984.85	4979.5	4983.72	14754.0
2021-08-09 09:00:00	ES	Futures	4983.72	4991.89	4974.71	4979.78	158693.0
2021-08-09 10:00:00	ES	Futures	4979.78	4985.69	4976.4	4980.91	112754.0
2021-08-09 11:00:00	ES	Futures	4980.91	4986.82	4979.5	4986.54	65107.0
2021-08-09 12:00:00	ES	Futures	4986.82	4986.82	4983.16	4984.85	39717.0
2021-08-09 13:00:00	ES	Futures	4984.85	4986.54	4983.44	4985.41	35297.0
2021-08-09 14:00:00	ES	Futures	4985.69	4991.61	4985.13	4988.23	58743.0
2021-08-09 15:00:00	ES	Futures	4988.51	4990.2	4982.6	4984.57	118153.0
2021-08-09 16:00:00	ES	Futures	4984.57	4988.51	4984.01	4986.82	30834.0
2021-08-09 18:00:00	ES	Futures	4986.54	4987.95	4982.88	4984.29	4141.0
2021-08-09 19:00:00	ES	Futures	4984.57	4984.85	4981.75	4984.29	3628.0
2021-08-09 20:00:00	ES	Futures	4984.29	4987.38	4984.01	4987.38	7572.0
2021-08-09 21:00:00	ES	Futures	4987.38	4987.38	4975.28	4976.12	12279.0
2021-08-09 22:00:00	ES	Futures	4975.84	4978.94	4974.43	4977.81	8733.0
2021-08-09 23:00:00	ES	Futures	4978.09	4978.09	4975.84	4976.97	3866.0
2021-08-09 00:00:00	NQ	Futures	17432.44	17438.23	17430.12	17436.49	1044.0
2021-08-09 01:00:00	NQ	Futures	17436.49	17443.45	17433.89	17438.81	2228.0
2021-08-09 02:00:00	NQ	Futures	17438.81	17445.18	17433.02	17435.63	3854.0
2021-08-09 03:00:00	NQ	Futures	17435.63	17484.58	17435.34	17471.84	7564.0
2021-08-09 04:00:00	NQ	Futures	17472.13	17504.57	17469.81	17500.22	6154.0
2021-08-09 05:00:00	NQ	Futures	17500.22	17503.41	17488.93	17496.46	4320.0
2021-08-09 06:00:00	NQ	Futures	17496.46	17516.45	17496.46	17507.76	5193.0
2021-08-09 07:00:00	NQ	Futures	17508.05	17527.74	17499.93	17514.13	5302.0
2021-08-09 08:00:00	NQ	Futures	17514.71	17517.32	17502.83	17505.73	4933.0
2021-08-09 09:00:00	NQ	Futures	17504.86	17541.65	17460.83	17507.47	69370.0
2021-08-09 10:00:00	NQ	Futures	17507.76	17541.36	17480.82	17505.73	64918.0
2021-08-09 11:00:00	NQ	Futures	17505.73	17523.4	17484.87	17519.63	39111.0
2021-08-09 12:00:00	NQ	Futures	17519.63	17528.03	17500.51	17513.84	24211.0
2021-08-09 13:00:00	NQ	Futures	17513.55	17524.56	17503.41	17521.95	18604.0
2021-08-09 14:00:00	NQ	Futures	17521.95	17549.47	17519.92	17533.25	27697.0
2021-08-09 15:00:00	NQ	Futures	17533.54	17538.75	17511.81	17523.11	37314.0
2021-08-09 16:00:00	NQ	Futures	17523.11	17534.99	17518.18	17527.74	8088.0
2021-08-09 18:00:00	NQ	Futures	17530.06	17532.09	17515.29	17519.05	1902.0
2021-08-09 19:00:00	NQ	Futures	17518.47	17521.37	17511.81	17518.18	1630.0
2021-08-09 20:00:00	NQ	Futures	17517.89	17526.87	17515.29	17526.87	2491.0
2021-08-09 21:00:00	NQ	Futures	17526.87	17526.87	17490.38	17493.56	4229.0
2021-08-09 22:00:00	NQ	Futures	17492.69	17507.47	17488.35	17504.28	3496.0
2021-08-09 23:00:00	NQ	Futures	17504.86	17506.89	17498.49	17503.12	1497.0
2021-08-09 00:00:00	YM	Futures	39157.4	39164.2	39142.9	39158.6	615.0
2021-08-09 01:00:00	YM	Futures	39157.4	39160.8	39137.3	39138.5	862.0
2021-08-09 02:00:00	YM	Futures	39138.5	39139.6	39102.7	39128.4	2570.0
2021-08-09 03:00:00	YM	Futures	39128.4	39193.2	39107.2	39120.6	3512.0

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

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