PREVIEW / futures_1hour / 2023-12-21

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-12-21.parquet
  size:    67 KB
  rows:    2,074

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
2023-12-21 00:00:00	ES	Futures	5119.34	5122.56	5118.26	5122.02	9290.0
2023-12-21 01:00:00	ES	Futures	5122.29	5123.9	5120.95	5123.1	11034.0
2023-12-21 02:00:00	ES	Futures	5123.1	5128.2	5122.83	5127.13	13936.0
2023-12-21 03:00:00	ES	Futures	5126.86	5131.15	5124.71	5129.54	26260.0
2023-12-21 04:00:00	ES	Futures	5129.54	5133.3	5128.74	5129.81	14966.0
2023-12-21 05:00:00	ES	Futures	5129.81	5130.08	5124.17	5124.71	14167.0
2023-12-21 06:00:00	ES	Futures	5124.98	5129.54	5124.44	5126.05	11413.0
2023-12-21 07:00:00	ES	Futures	5126.05	5131.15	5124.71	5129.27	15810.0
2023-12-21 08:00:00	ES	Futures	5129.01	5151.3	5124.98	5141.63	82011.0
2023-12-21 09:00:00	ES	Futures	5141.9	5146.46	5135.45	5137.33	194476.0
2023-12-21 10:00:00	ES	Futures	5137.33	5148.88	5127.93	5134.92	295045.0
2023-12-21 11:00:00	ES	Futures	5134.65	5140.56	5126.59	5128.2	150953.0
2023-12-21 12:00:00	ES	Futures	5127.93	5127.93	5113.97	5116.38	159075.0
2023-12-21 13:00:00	ES	Futures	5116.11	5128.47	5109.13	5128.2	149762.0
2023-12-21 14:00:00	ES	Futures	5128.2	5133.84	5123.63	5128.47	99787.0
2023-12-21 15:00:00	ES	Futures	5128.47	5155.06	5124.98	5151.84	243612.0
2023-12-21 16:00:00	ES	Futures	5151.84	5154.52	5149.96	5152.37	79763.0
2023-12-21 18:00:00	ES	Futures	5152.37	5153.99	5147.0	5149.69	8235.0
2023-12-21 19:00:00	ES	Futures	5149.69	5150.76	5147.0	5148.08	6244.0
2023-12-21 20:00:00	ES	Futures	5148.08	5148.88	5144.58	5145.93	8905.0
2023-12-21 21:00:00	ES	Futures	5145.66	5147.54	5144.58	5146.73	4067.0
2023-12-21 22:00:00	ES	Futures	5146.73	5148.34	5142.7	5146.2	6769.0
2023-12-21 23:00:00	ES	Futures	5146.2	5147.27	5145.39	5146.46	3198.0
2023-12-21 00:00:00	NQ	Futures	18266.51	18276.0	18262.17	18274.65	4182.0
2023-12-21 01:00:00	NQ	Futures	18274.92	18277.09	18265.7	18272.75	3500.0
2023-12-21 02:00:00	NQ	Futures	18273.02	18299.87	18270.85	18294.72	8024.0
2023-12-21 03:00:00	NQ	Futures	18294.17	18315.06	18290.38	18304.48	10606.0
2023-12-21 04:00:00	NQ	Futures	18305.02	18323.46	18297.7	18309.9	7896.0
2023-12-21 05:00:00	NQ	Futures	18310.45	18310.99	18289.29	18293.9	7021.0
2023-12-21 06:00:00	NQ	Futures	18293.63	18313.97	18293.09	18302.58	5782.0
2023-12-21 07:00:00	NQ	Futures	18302.31	18323.19	18297.7	18315.06	6743.0
2023-12-21 08:00:00	NQ	Futures	18314.52	18409.71	18290.38	18377.71	42946.0
2023-12-21 09:00:00	NQ	Futures	18378.25	18397.23	18317.77	18326.45	81109.0
2023-12-21 10:00:00	NQ	Futures	18326.45	18369.57	18271.94	18304.75	114286.0
2023-12-21 11:00:00	NQ	Futures	18304.48	18356.55	18291.73	18310.99	60358.0
2023-12-21 12:00:00	NQ	Futures	18310.72	18311.26	18252.14	18265.16	63023.0
2023-12-21 13:00:00	NQ	Futures	18265.43	18313.7	18241.29	18312.89	62646.0
2023-12-21 14:00:00	NQ	Futures	18312.89	18341.36	18295.53	18317.23	41658.0
2023-12-21 15:00:00	NQ	Futures	18317.23	18405.1	18304.48	18388.55	72708.0
2023-12-21 16:00:00	NQ	Futures	18388.55	18394.25	18377.98	18387.2	14170.0
2023-12-21 18:00:00	NQ	Futures	18394.25	18394.52	18368.21	18379.06	4752.0
2023-12-21 19:00:00	NQ	Futures	18378.79	18381.77	18365.23	18365.77	3678.0
2023-12-21 20:00:00	NQ	Futures	18365.77	18371.74	18341.36	18344.89	6097.0
2023-12-21 21:00:00	NQ	Futures	18345.16	18358.99	18342.18	18354.65	3613.0
2023-12-21 22:00:00	NQ	Futures	18354.65	18357.91	18334.04	18343.81	3391.0
2023-12-21 23:00:00	NQ	Futures	18343.81	18349.23	18341.64	18347.33	1973.0
2023-12-21 00:00:00	YM	Futures	40313.4	40342.4	40309.1	40338.1	1065.0
2023-12-21 01:00:00	YM	Futures	40340.2	40354.2	40332.7	40349.9	1211.0
2023-12-21 02:00:00	YM	Futures	40349.9	40376.7	40345.6	40361.7	1920.0
2023-12-21 03:00:00	YM	Futures	40361.7	40387.5	40345.6	40377.8	2910.0

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

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