PREVIEW / futures_1hour / 2022-04-08

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-04-08.parquet
  size:    56 KB
  rows:    1,625

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-08 00:00:00	ES	Futures	5097.67	5097.96	5092.57	5094.55	3558.0
2022-04-08 01:00:00	ES	Futures	5094.84	5104.19	5092.85	5103.06	5317.0
2022-04-08 02:00:00	ES	Futures	5103.06	5115.25	5101.07	5112.41	11219.0
2022-04-08 03:00:00	ES	Futures	5112.41	5119.78	5104.76	5118.65	18412.0
2022-04-08 04:00:00	ES	Futures	5118.65	5124.32	5110.71	5112.41	15022.0
2022-04-08 05:00:00	ES	Futures	5112.41	5112.41	5105.61	5109.86	10573.0
2022-04-08 06:00:00	ES	Futures	5109.86	5114.11	5102.77	5113.83	12733.0
2022-04-08 07:00:00	ES	Futures	5113.54	5118.93	5111.28	5114.68	15378.0
2022-04-08 08:00:00	ES	Futures	5114.96	5115.81	5097.96	5099.94	26289.0
2022-04-08 09:00:00	ES	Futures	5099.94	5099.94	5066.78	5068.48	183022.0
2022-04-08 10:00:00	ES	Futures	5068.19	5110.99	5066.49	5110.43	217086.0
2022-04-08 11:00:00	ES	Futures	5110.43	5115.81	5099.37	5107.88	152153.0
2022-04-08 12:00:00	ES	Futures	5107.88	5120.06	5102.21	5114.96	105550.0
2022-04-08 13:00:00	ES	Futures	5114.96	5115.25	5096.82	5099.66	87270.0
2022-04-08 14:00:00	ES	Futures	5099.37	5105.33	5086.05	5097.11	120165.0
2022-04-08 15:00:00	ES	Futures	5097.39	5106.18	5075.56	5087.18	223532.0
2022-04-08 16:00:00	ES	Futures	5087.18	5091.15	5081.23	5083.22	53088.0
2022-04-08 00:00:00	NQ	Futures	16869.59	16871.04	16848.13	16856.83	1587.0
2022-04-08 01:00:00	NQ	Futures	16856.54	16902.07	16850.16	16900.04	3371.0
2022-04-08 02:00:00	NQ	Futures	16899.46	16946.14	16889.31	16938.89	5696.0
2022-04-08 03:00:00	NQ	Futures	16938.02	16962.96	16906.13	16957.16	9211.0
2022-04-08 04:00:00	NQ	Futures	16956.58	16983.55	16909.6	16918.88	10375.0
2022-04-08 05:00:00	NQ	Futures	16918.01	16918.88	16886.41	16904.1	6885.0
2022-04-08 06:00:00	NQ	Futures	16904.39	16921.2	16864.95	16918.01	8715.0
2022-04-08 07:00:00	NQ	Futures	16917.72	16934.54	16904.97	16915.98	7980.0
2022-04-08 08:00:00	NQ	Futures	16915.98	16921.2	16830.44	16838.27	15165.0
2022-04-08 09:00:00	NQ	Futures	16836.82	16836.82	16601.07	16612.96	102862.0
2022-04-08 10:00:00	NQ	Futures	16613.54	16783.76	16606.58	16782.6	112642.0
2022-04-08 11:00:00	NQ	Futures	16782.31	16813.62	16691.83	16755.63	74671.0
2022-04-08 12:00:00	NQ	Futures	16756.5	16816.52	16733.01	16795.64	56602.0
2022-04-08 13:00:00	NQ	Futures	16795.93	16796.22	16679.36	16692.12	46520.0
2022-04-08 14:00:00	NQ	Futures	16692.7	16722.86	16630.36	16679.65	58739.0
2022-04-08 15:00:00	NQ	Futures	16679.65	16719.38	16598.75	16628.62	82248.0
2022-04-08 16:00:00	NQ	Futures	16628.91	16651.24	16615.57	16619.05	14459.0
2022-04-08 00:00:00	YM	Futures	38885.0	38886.1	38853.5	38868.1	682.0
2022-04-08 01:00:00	YM	Futures	38868.1	38931.2	38854.6	38918.8	1344.0
2022-04-08 02:00:00	YM	Futures	38920.0	38994.4	38909.8	38974.1	2967.0
2022-04-08 03:00:00	YM	Futures	38976.3	39044.0	38931.2	39037.2	4626.0
2022-04-08 04:00:00	YM	Futures	39036.1	39082.3	38993.2	39006.8	3713.0
2022-04-08 05:00:00	YM	Futures	39005.6	39005.6	38966.2	39000.0	1996.0
2022-04-08 06:00:00	YM	Futures	39001.1	39029.3	38958.3	39027.1	2368.0
2022-04-08 07:00:00	YM	Futures	39025.9	39063.1	39013.5	39033.8	2480.0
2022-04-08 08:00:00	YM	Futures	39036.1	39042.8	38938.0	38950.4	4362.0
2022-04-08 09:00:00	YM	Futures	38950.4	38950.4	38744.1	38828.7	23095.0
2022-04-08 10:00:00	YM	Futures	38828.7	39170.2	38818.5	39168.0	28079.0
2022-04-08 11:00:00	YM	Futures	39166.9	39205.2	39102.6	39162.3	18073.0
2022-04-08 12:00:00	YM	Futures	39161.2	39253.7	39127.4	39217.6	12443.0
2022-04-08 13:00:00	YM	Futures	39218.7	39221.0	39128.5	39149.9	7965.0
2022-04-08 14:00:00	YM	Futures	39147.7	39177.0	39044.0	39118.4	11953.0
2022-04-08 15:00:00	YM	Futures	39118.4	39171.4	38978.6	39060.9	17534.0

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

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