PREVIEW / futures_1hour / 2021-12-09

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-12-09.parquet
  size:    65 KB
  rows:    1,996

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-12-09 00:00:00	ES	Futures	5295.43	5299.1	5294.59	5295.15	4345.0
2021-12-09 01:00:00	ES	Futures	5295.15	5301.08	5294.87	5299.95	3780.0
2021-12-09 02:00:00	ES	Futures	5299.95	5305.59	5298.82	5301.92	5503.0
2021-12-09 03:00:00	ES	Futures	5301.92	5303.05	5290.64	5293.74	15595.0
2021-12-09 04:00:00	ES	Futures	5293.74	5296.28	5289.51	5293.74	9459.0
2021-12-09 05:00:00	ES	Futures	5293.74	5294.02	5282.17	5287.81	15935.0
2021-12-09 06:00:00	ES	Futures	5287.53	5290.64	5280.19	5286.12	14824.0
2021-12-09 07:00:00	ES	Futures	5286.12	5293.18	5285.84	5289.22	15532.0
2021-12-09 08:00:00	ES	Futures	5289.22	5289.51	5280.19	5285.84	29754.0
2021-12-09 09:00:00	ES	Futures	5285.84	5298.82	5284.71	5289.79	165741.0
2021-12-09 10:00:00	ES	Futures	5289.79	5296.0	5276.24	5289.22	193037.0
2021-12-09 11:00:00	ES	Futures	5289.22	5296.56	5281.89	5286.4	106980.0
2021-12-09 12:00:00	ES	Futures	5286.4	5298.26	5282.73	5297.41	69749.0
2021-12-09 13:00:00	ES	Futures	5297.41	5299.67	5285.84	5291.76	99284.0
2021-12-09 14:00:00	ES	Futures	5292.05	5295.15	5277.37	5280.48	96606.0
2021-12-09 15:00:00	ES	Futures	5280.76	5286.97	5266.08	5268.06	261533.0
2021-12-09 16:00:00	ES	Futures	5268.34	5270.88	5262.98	5270.03	54955.0
2021-12-09 18:00:00	ES	Futures	5270.88	5277.94	5270.32	5274.83	5096.0
2021-12-09 19:00:00	ES	Futures	5274.83	5277.37	5269.19	5270.32	6430.0
2021-12-09 20:00:00	ES	Futures	5270.6	5276.24	5265.24	5274.55	6418.0
2021-12-09 21:00:00	ES	Futures	5274.55	5276.24	5273.42	5275.96	2435.0
2021-12-09 22:00:00	ES	Futures	5275.96	5277.94	5273.7	5274.27	2117.0
2021-12-09 23:00:00	ES	Futures	5274.55	5276.24	5270.88	5271.16	1626.0
2021-12-09 00:00:00	NQ	Futures	18966.21	18992.59	18961.0	18974.91	2423.0
2021-12-09 01:00:00	NQ	Futures	18974.91	18988.53	18971.72	18985.34	1699.0
2021-12-09 02:00:00	NQ	Futures	18985.63	19010.85	18981.28	19004.47	3831.0
2021-12-09 03:00:00	NQ	Futures	19003.89	19009.4	18968.82	18982.15	6171.0
2021-12-09 04:00:00	NQ	Futures	18983.6	18988.82	18949.69	18961.87	5271.0
2021-12-09 05:00:00	NQ	Futures	18961.29	18962.74	18916.37	18924.77	5984.0
2021-12-09 06:00:00	NQ	Futures	18924.48	18938.1	18898.69	18917.24	6642.0
2021-12-09 07:00:00	NQ	Futures	18916.37	18945.93	18914.92	18938.68	6606.0
2021-12-09 08:00:00	NQ	Futures	18938.39	18941.87	18906.51	18923.32	11422.0
2021-12-09 09:00:00	NQ	Futures	18923.32	19028.52	18921.29	18950.27	86588.0
2021-12-09 10:00:00	NQ	Futures	18950.85	18972.59	18841.88	18900.72	100420.0
2021-12-09 11:00:00	NQ	Futures	18900.14	18947.67	18873.76	18882.75	63532.0
2021-12-09 12:00:00	NQ	Futures	18882.46	18907.67	18853.77	18899.27	43251.0
2021-12-09 13:00:00	NQ	Futures	18898.69	18900.72	18786.53	18830.58	58906.0
2021-12-09 14:00:00	NQ	Futures	18830.58	18850.87	18771.17	18785.37	53644.0
2021-12-09 15:00:00	NQ	Futures	18785.95	18821.31	18709.73	18721.9	81540.0
2021-12-09 16:00:00	NQ	Futures	18720.45	18732.04	18687.7	18727.4	15402.0
2021-12-09 18:00:00	NQ	Futures	18732.04	18761.89	18725.38	18751.75	3660.0
2021-12-09 19:00:00	NQ	Futures	18751.46	18757.26	18730.3	18736.1	3448.0
2021-12-09 20:00:00	NQ	Futures	18735.23	18764.21	18714.65	18758.13	5203.0
2021-12-09 21:00:00	NQ	Futures	18758.99	18769.43	18753.2	18758.42	1867.0
2021-12-09 22:00:00	NQ	Futures	18758.13	18766.82	18749.72	18752.04	1292.0
2021-12-09 23:00:00	NQ	Futures	18752.91	18755.52	18734.94	18735.52	1267.0
2021-12-09 00:00:00	YM	Futures	39992.9	40020.9	39988.4	39988.4	942.0
2021-12-09 01:00:00	YM	Futures	39989.5	40053.4	39989.5	40039.9	1110.0
2021-12-09 02:00:00	YM	Futures	40042.2	40082.5	40028.7	40039.9	1560.0
2021-12-09 03:00:00	YM	Futures	40039.9	40048.9	39941.3	39964.8	4416.0

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

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