PREVIEW / futures_1hour / 2022-02-17

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-02-17.parquet
  size:    67 KB
  rows:    2,053

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-02-17 00:00:00	ES	Futures	5025.96	5040.38	5023.7	5034.73	15777.0
2022-02-17 01:00:00	ES	Futures	5034.73	5042.93	5027.09	5035.57	15775.0
2022-02-17 02:00:00	ES	Futures	5035.29	5045.76	5034.44	5043.78	11250.0
2022-02-17 03:00:00	ES	Futures	5043.49	5054.24	5019.17	5029.35	37898.0
2022-02-17 04:00:00	ES	Futures	5029.07	5034.16	5020.59	5026.81	15961.0
2022-02-17 05:00:00	ES	Futures	5026.52	5036.14	5024.26	5031.9	9183.0
2022-02-17 06:00:00	ES	Futures	5031.9	5033.59	5025.96	5031.9	12800.0
2022-02-17 07:00:00	ES	Futures	5031.9	5046.04	5031.05	5043.78	18428.0
2022-02-17 08:00:00	ES	Futures	5043.78	5050.0	5012.38	5015.21	57446.0
2022-02-17 09:00:00	ES	Futures	5015.21	5032.75	4986.93	4990.33	218086.0
2022-02-17 10:00:00	ES	Futures	4990.04	5000.79	4978.73	4991.46	226908.0
2022-02-17 11:00:00	ES	Futures	4991.74	5005.31	4988.35	4994.85	130718.0
2022-02-17 12:00:00	ES	Futures	4995.13	5002.2	4989.19	4994.0	80641.0
2022-02-17 13:00:00	ES	Futures	4994.0	4995.7	4980.71	4984.67	84408.0
2022-02-17 14:00:00	ES	Futures	4984.67	4984.67	4961.76	4962.61	120214.0
2022-02-17 15:00:00	ES	Futures	4962.61	4965.16	4940.84	4949.04	359033.0
2022-02-17 16:00:00	ES	Futures	4949.04	4953.56	4940.27	4948.75	67848.0
2022-02-17 18:00:00	ES	Futures	4948.75	4955.54	4941.68	4953.0	11417.0
2022-02-17 19:00:00	ES	Futures	4953.0	4956.39	4941.4	4949.89	12637.0
2022-02-17 20:00:00	ES	Futures	4950.17	4982.12	4944.79	4978.17	34313.0
2022-02-17 21:00:00	ES	Futures	4978.17	4981.28	4971.66	4976.47	14261.0
2022-02-17 22:00:00	ES	Futures	4976.47	4986.08	4973.92	4981.84	10214.0
2022-02-17 23:00:00	ES	Futures	4981.84	4990.33	4981.84	4982.69	7679.0
2022-02-17 00:00:00	NQ	Futures	16794.32	16852.87	16781.28	16832.87	8488.0
2022-02-17 01:00:00	NQ	Futures	16833.16	16864.17	16800.99	16834.32	8223.0
2022-02-17 02:00:00	NQ	Futures	16833.16	16878.95	16826.2	16863.3	9331.0
2022-02-17 03:00:00	NQ	Futures	16862.43	16907.06	16773.17	16820.41	20152.0
2022-02-17 04:00:00	NQ	Futures	16820.99	16840.41	16781.86	16807.08	8605.0
2022-02-17 05:00:00	NQ	Futures	16806.79	16837.22	16800.7	16817.8	5931.0
2022-02-17 06:00:00	NQ	Futures	16818.09	16828.52	16792.01	16820.41	6373.0
2022-02-17 07:00:00	NQ	Futures	16819.83	16874.31	16817.22	16863.59	8674.0
2022-02-17 08:00:00	NQ	Futures	16863.59	16884.46	16747.08	16761.29	27495.0
2022-02-17 09:00:00	NQ	Futures	16762.15	16813.16	16665.65	16697.53	88630.0
2022-02-17 10:00:00	NQ	Futures	16696.66	16729.12	16603.33	16648.55	87660.0
2022-02-17 11:00:00	NQ	Futures	16648.26	16703.9	16633.77	16645.65	56887.0
2022-02-17 12:00:00	NQ	Futures	16646.23	16656.95	16592.61	16633.77	41440.0
2022-02-17 13:00:00	NQ	Futures	16633.48	16637.24	16560.73	16582.18	42068.0
2022-02-17 14:00:00	NQ	Futures	16581.31	16581.31	16502.77	16505.67	46573.0
2022-02-17 15:00:00	NQ	Futures	16505.38	16514.36	16401.33	16422.49	94215.0
2022-02-17 16:00:00	NQ	Futures	16422.2	16432.34	16382.2	16411.48	20048.0
2022-02-17 18:00:00	NQ	Futures	16410.9	16444.52	16388.87	16431.76	7385.0
2022-02-17 19:00:00	NQ	Futures	16430.6	16445.38	16379.02	16414.37	7488.0
2022-02-17 20:00:00	NQ	Futures	16414.95	16567.11	16397.85	16545.95	18242.0
2022-02-17 21:00:00	NQ	Futures	16547.4	16559.28	16514.94	16538.71	7966.0
2022-02-17 22:00:00	NQ	Futures	16539.86	16575.8	16529.72	16554.94	6255.0
2022-02-17 23:00:00	NQ	Futures	16554.94	16576.38	16541.89	16545.08	4814.0
2022-02-17 00:00:00	YM	Futures	38993.6	39084.6	38979.0	39049.8	3555.0
2022-02-17 01:00:00	YM	Futures	39047.6	39102.6	38992.5	39055.4	4421.0
2022-02-17 02:00:00	YM	Futures	39053.2	39108.2	39048.7	39106.0	3469.0
2022-02-17 03:00:00	YM	Futures	39104.9	39163.3	38920.6	38968.9	10830.0

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

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