PREVIEW / futures_1hour / 2021-11-09

all futures 1-hour files

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

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-11-09 00:00:00	ES	Futures	5285.27	5292.05	5285.27	5291.2	5251.0
2021-11-09 01:00:00	ES	Futures	5291.48	5293.18	5290.35	5291.76	3082.0
2021-11-09 02:00:00	ES	Futures	5291.76	5293.74	5289.22	5290.35	5276.0
2021-11-09 03:00:00	ES	Futures	5290.35	5300.8	5288.66	5299.38	17103.0
2021-11-09 04:00:00	ES	Futures	5299.1	5300.8	5295.72	5299.67	8477.0
2021-11-09 05:00:00	ES	Futures	5299.95	5302.77	5299.67	5300.23	7538.0
2021-11-09 06:00:00	ES	Futures	5300.23	5302.77	5299.1	5300.23	7977.0
2021-11-09 07:00:00	ES	Futures	5300.23	5301.36	5290.64	5292.89	20704.0
2021-11-09 08:00:00	ES	Futures	5292.89	5302.21	5291.76	5299.95	22492.0
2021-11-09 09:00:00	ES	Futures	5300.23	5306.16	5270.88	5276.53	191190.0
2021-11-09 10:00:00	ES	Futures	5276.53	5288.38	5267.49	5279.91	298988.0
2021-11-09 11:00:00	ES	Futures	5279.91	5284.14	5269.19	5272.29	134474.0
2021-11-09 12:00:00	ES	Futures	5272.29	5279.07	5264.11	5273.14	129075.0
2021-11-09 13:00:00	ES	Futures	5273.14	5278.5	5265.24	5267.78	86693.0
2021-11-09 14:00:00	ES	Futures	5267.78	5278.78	5266.08	5278.78	87991.0
2021-11-09 15:00:00	ES	Futures	5278.78	5283.02	5271.73	5281.61	152081.0
2021-11-09 16:00:00	ES	Futures	5281.89	5282.45	5276.53	5277.65	35271.0
2021-11-09 18:00:00	ES	Futures	5277.09	5278.22	5272.86	5273.99	5712.0
2021-11-09 19:00:00	ES	Futures	5273.7	5277.09	5270.32	5270.6	8639.0
2021-11-09 20:00:00	ES	Futures	5270.88	5273.42	5267.21	5270.88	11779.0
2021-11-09 21:00:00	ES	Futures	5270.88	5271.45	5261.0	5261.85	13061.0
2021-11-09 22:00:00	ES	Futures	5262.13	5263.54	5258.46	5261.57	9771.0
2021-11-09 23:00:00	ES	Futures	5261.57	5262.7	5259.87	5262.13	5947.0
2021-11-09 00:00:00	NQ	Futures	18896.37	18920.13	18896.37	18918.1	2247.0
2021-11-09 01:00:00	NQ	Futures	18918.68	18929.12	18913.47	18917.52	1855.0
2021-11-09 02:00:00	NQ	Futures	18917.81	18925.93	18904.77	18912.31	1932.0
2021-11-09 03:00:00	NQ	Futures	18912.6	18945.64	18898.4	18941.87	6298.0
2021-11-09 04:00:00	NQ	Futures	18941.29	18959.55	18937.81	18954.62	3519.0
2021-11-09 05:00:00	NQ	Futures	18955.2	18970.27	18954.33	18967.66	2967.0
2021-11-09 06:00:00	NQ	Futures	18967.95	18980.71	18959.26	18961.58	4099.0
2021-11-09 07:00:00	NQ	Futures	18961.0	18973.75	18935.78	18945.93	6687.0
2021-11-09 08:00:00	NQ	Futures	18945.93	18997.8	18940.71	18984.18	11334.0
2021-11-09 09:00:00	NQ	Futures	18983.6	19002.44	18777.54	18810.29	93524.0
2021-11-09 10:00:00	NQ	Futures	18809.42	18880.43	18767.98	18839.27	114498.0
2021-11-09 11:00:00	NQ	Futures	18838.98	18869.13	18792.32	18821.6	66874.0
2021-11-09 12:00:00	NQ	Futures	18821.89	18832.03	18762.76	18791.16	63661.0
2021-11-09 13:00:00	NQ	Futures	18790.58	18816.09	18733.78	18744.21	49143.0
2021-11-09 14:00:00	NQ	Futures	18744.21	18818.7	18736.97	18800.73	45494.0
2021-11-09 15:00:00	NQ	Futures	18801.02	18811.45	18763.05	18800.44	56050.0
2021-11-09 16:00:00	NQ	Futures	18800.44	18807.39	18772.91	18776.96	8366.0
2021-11-09 18:00:00	NQ	Futures	18781.6	18781.6	18756.97	18763.92	2240.0
2021-11-09 19:00:00	NQ	Futures	18763.05	18781.02	18751.46	18754.07	3388.0
2021-11-09 20:00:00	NQ	Futures	18754.65	18764.5	18738.13	18751.46	4037.0
2021-11-09 21:00:00	NQ	Futures	18751.75	18753.78	18714.07	18715.23	4576.0
2021-11-09 22:00:00	NQ	Futures	18715.23	18725.67	18701.9	18718.71	4465.0
2021-11-09 23:00:00	NQ	Futures	18719.29	18733.78	18713.2	18732.33	2392.0
2021-11-09 00:00:00	YM	Futures	40595.9	40645.2	40589.2	40636.3	1496.0
2021-11-09 01:00:00	YM	Futures	40637.4	40646.3	40628.4	40635.1	851.0
2021-11-09 02:00:00	YM	Futures	40635.1	40651.9	40622.8	40629.5	1042.0
2021-11-09 03:00:00	YM	Futures	40629.5	40715.8	40618.3	40703.5	3387.0

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

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