PREVIEW / futures_1hour / 2021-11-23

all futures 1-hour files

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

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-23 00:00:00	ES	Futures	5284.71	5285.56	5270.6	5274.83	7418.0
2021-11-23 01:00:00	ES	Futures	5274.83	5278.5	5270.03	5275.96	7978.0
2021-11-23 02:00:00	ES	Futures	5275.68	5277.37	5259.31	5270.88	26488.0
2021-11-23 03:00:00	ES	Futures	5270.88	5274.55	5254.23	5266.93	40563.0
2021-11-23 04:00:00	ES	Futures	5267.21	5279.35	5261.85	5277.65	32119.0
2021-11-23 05:00:00	ES	Futures	5277.65	5283.58	5277.09	5277.09	22739.0
2021-11-23 06:00:00	ES	Futures	5277.09	5283.58	5268.91	5280.19	27432.0
2021-11-23 07:00:00	ES	Futures	5280.19	5285.27	5275.11	5278.5	28715.0
2021-11-23 08:00:00	ES	Futures	5278.22	5284.71	5277.65	5281.61	39653.0
2021-11-23 09:00:00	ES	Futures	5281.61	5300.51	5268.34	5294.59	227211.0
2021-11-23 10:00:00	ES	Futures	5294.87	5296.28	5254.51	5255.36	308169.0
2021-11-23 11:00:00	ES	Futures	5255.36	5277.37	5248.02	5268.34	271580.0
2021-11-23 12:00:00	ES	Futures	5268.34	5273.99	5256.49	5259.87	145712.0
2021-11-23 13:00:00	ES	Futures	5259.59	5276.24	5253.38	5268.62	143930.0
2021-11-23 14:00:00	ES	Futures	5268.62	5286.4	5260.44	5283.02	161646.0
2021-11-23 15:00:00	ES	Futures	5283.3	5295.72	5276.53	5291.2	239590.0
2021-11-23 16:00:00	ES	Futures	5291.2	5292.05	5281.89	5288.38	52923.0
2021-11-23 18:00:00	ES	Futures	5290.07	5291.2	5284.43	5285.56	5407.0
2021-11-23 19:00:00	ES	Futures	5285.84	5292.33	5285.84	5288.94	7135.0
2021-11-23 20:00:00	ES	Futures	5288.66	5292.89	5288.66	5291.2	6081.0
2021-11-23 21:00:00	ES	Futures	5291.2	5291.48	5285.27	5286.68	5485.0
2021-11-23 22:00:00	ES	Futures	5286.4	5287.25	5280.76	5283.86	4812.0
2021-11-23 23:00:00	ES	Futures	5283.86	5284.14	5277.94	5280.48	4324.0
2021-11-23 00:00:00	NQ	Futures	18965.05	18967.95	18920.42	18933.75	3675.0
2021-11-23 01:00:00	NQ	Futures	18933.75	18956.36	18918.39	18944.77	5118.0
2021-11-23 02:00:00	NQ	Futures	18945.06	18957.23	18881.3	18942.16	14188.0
2021-11-23 03:00:00	NQ	Futures	18941.29	18949.69	18865.94	18914.05	19105.0
2021-11-23 04:00:00	NQ	Futures	18914.34	18937.81	18892.89	18934.62	11746.0
2021-11-23 05:00:00	NQ	Futures	18934.33	18958.1	18923.9	18924.77	7519.0
2021-11-23 06:00:00	NQ	Futures	18923.9	18956.65	18896.08	18941.87	9268.0
2021-11-23 07:00:00	NQ	Futures	18942.45	18983.02	18921.58	18934.33	14358.0
2021-11-23 08:00:00	NQ	Futures	18934.04	18986.79	18930.28	18956.07	17459.0
2021-11-23 09:00:00	NQ	Futures	18956.07	19033.74	18874.92	19009.69	113354.0
2021-11-23 10:00:00	NQ	Futures	19009.4	19018.09	18736.39	18741.9	147333.0
2021-11-23 11:00:00	NQ	Futures	18742.48	18860.72	18711.46	18791.74	137003.0
2021-11-23 12:00:00	NQ	Futures	18790.87	18828.26	18736.39	18748.85	84620.0
2021-11-23 13:00:00	NQ	Futures	18748.56	18796.96	18685.67	18764.79	80995.0
2021-11-23 14:00:00	NQ	Futures	18765.37	18848.55	18708.57	18833.48	81177.0
2021-11-23 15:00:00	NQ	Futures	18833.77	18917.81	18804.21	18902.74	102418.0
2021-11-23 16:00:00	NQ	Futures	18902.45	18908.83	18862.75	18893.76	12545.0
2021-11-23 18:00:00	NQ	Futures	18896.37	18904.48	18876.37	18881.01	3144.0
2021-11-23 19:00:00	NQ	Futures	18881.01	18903.61	18881.01	18894.05	3603.0
2021-11-23 20:00:00	NQ	Futures	18895.21	18910.28	18889.7	18902.45	2996.0
2021-11-23 21:00:00	NQ	Futures	18902.45	18902.45	18876.95	18890.86	2830.0
2021-11-23 22:00:00	NQ	Futures	18890.86	18892.6	18868.26	18878.4	2471.0
2021-11-23 23:00:00	NQ	Futures	18878.4	18878.98	18857.24	18868.84	2481.0
2021-11-23 00:00:00	YM	Futures	39912.2	39920.0	39801.2	39830.3	1682.0
2021-11-23 01:00:00	YM	Futures	39830.3	39850.5	39794.5	39840.4	1399.0
2021-11-23 02:00:00	YM	Futures	39839.3	39846.0	39683.5	39767.6	6808.0
2021-11-23 03:00:00	YM	Futures	39766.4	39803.4	39646.5	39738.4	9183.0

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

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