PREVIEW / futures_1hour / 2023-09-06

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-09-06.parquet
  size:    64 KB
  rows:    1,984

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-09-06 00:00:00	ES	Futures	4938.19	4941.75	4937.91	4939.28	3059.0
2023-09-06 01:00:00	ES	Futures	4939.56	4942.3	4936.26	4941.75	7008.0
2023-09-06 02:00:00	ES	Futures	4941.48	4941.75	4934.89	4936.54	7790.0
2023-09-06 03:00:00	ES	Futures	4936.54	4936.54	4926.11	4929.95	29004.0
2023-09-06 04:00:00	ES	Futures	4929.68	4935.99	4929.13	4933.79	15608.0
2023-09-06 05:00:00	ES	Futures	4934.07	4935.99	4930.5	4934.07	12498.0
2023-09-06 06:00:00	ES	Futures	4934.34	4936.81	4932.15	4933.79	10541.0
2023-09-06 07:00:00	ES	Futures	4933.79	4936.54	4930.77	4933.52	15947.0
2023-09-06 08:00:00	ES	Futures	4933.79	4934.89	4927.75	4934.34	27043.0
2023-09-06 09:00:00	ES	Futures	4934.07	4934.89	4922.54	4928.3	156365.0
2023-09-06 10:00:00	ES	Futures	4928.03	4928.03	4902.77	4903.6	308893.0
2023-09-06 11:00:00	ES	Futures	4903.87	4907.17	4897.83	4901.95	171343.0
2023-09-06 12:00:00	ES	Futures	4901.95	4904.42	4884.93	4887.68	154502.0
2023-09-06 13:00:00	ES	Futures	4887.68	4902.22	4883.01	4899.2	154522.0
2023-09-06 14:00:00	ES	Futures	4899.48	4909.09	4897.83	4906.62	125397.0
2023-09-06 15:00:00	ES	Futures	4906.62	4911.83	4899.75	4909.36	243265.0
2023-09-06 16:00:00	ES	Futures	4909.36	4909.91	4905.79	4907.99	51707.0
2023-09-06 18:00:00	ES	Futures	4907.71	4909.09	4905.79	4906.62	3417.0
2023-09-06 19:00:00	ES	Futures	4906.89	4909.36	4906.89	4908.54	3234.0
2023-09-06 20:00:00	ES	Futures	4908.54	4910.19	4905.24	4906.07	5342.0
2023-09-06 21:00:00	ES	Futures	4906.07	4909.09	4904.97	4906.89	6149.0
2023-09-06 22:00:00	ES	Futures	4906.62	4907.44	4904.7	4905.52	3188.0
2023-09-06 23:00:00	ES	Futures	4905.79	4907.99	4904.42	4906.62	2660.0
2023-09-06 00:00:00	NQ	Futures	17246.36	17260.54	17244.13	17251.36	2007.0
2023-09-06 01:00:00	NQ	Futures	17251.64	17263.88	17239.68	17262.49	3424.0
2023-09-06 02:00:00	NQ	Futures	17261.93	17261.93	17229.11	17234.12	4170.0
2023-09-06 03:00:00	NQ	Futures	17234.12	17234.67	17175.99	17207.7	12501.0
2023-09-06 04:00:00	NQ	Futures	17208.53	17237.18	17203.25	17225.5	7169.0
2023-09-06 05:00:00	NQ	Futures	17225.77	17234.4	17207.42	17227.72	5875.0
2023-09-06 06:00:00	NQ	Futures	17228.28	17239.12	17222.71	17233.28	5275.0
2023-09-06 07:00:00	NQ	Futures	17233.84	17255.81	17224.11	17239.4	9395.0
2023-09-06 08:00:00	NQ	Futures	17239.96	17244.97	17215.48	17243.02	12577.0
2023-09-06 09:00:00	NQ	Futures	17242.46	17259.98	17200.19	17224.94	77686.0
2023-09-06 10:00:00	NQ	Futures	17225.22	17225.22	17103.95	17105.07	128377.0
2023-09-06 11:00:00	NQ	Futures	17105.34	17131.77	17075.31	17103.12	71540.0
2023-09-06 12:00:00	NQ	Futures	17102.84	17119.81	17036.37	17052.5	57601.0
2023-09-06 13:00:00	NQ	Futures	17052.22	17104.23	17033.31	17085.04	51588.0
2023-09-06 14:00:00	NQ	Futures	17085.6	17122.87	17072.25	17103.12	43466.0
2023-09-06 15:00:00	NQ	Futures	17103.12	17138.16	17076.42	17130.65	65053.0
2023-09-06 16:00:00	NQ	Futures	17130.65	17131.49	17113.97	17118.14	12949.0
2023-09-06 18:00:00	NQ	Futures	17116.19	17123.42	17109.52	17115.63	2107.0
2023-09-06 19:00:00	NQ	Futures	17116.19	17126.48	17114.52	17122.31	1707.0
2023-09-06 20:00:00	NQ	Futures	17122.03	17128.15	17106.18	17109.52	2918.0
2023-09-06 21:00:00	NQ	Futures	17108.96	17122.31	17100.89	17109.52	4325.0
2023-09-06 22:00:00	NQ	Futures	17109.52	17112.57	17100.62	17103.67	2564.0
2023-09-06 23:00:00	NQ	Futures	17103.95	17122.31	17098.95	17117.02	3140.0
2023-09-06 00:00:00	YM	Futures	37979.3	37997.9	37978.2	37982.6	430.0
2023-09-06 01:00:00	YM	Futures	37983.6	38000.1	37962.8	37999.0	867.0
2023-09-06 02:00:00	YM	Futures	37997.9	38000.1	37966.1	37979.3	1718.0
2023-09-06 03:00:00	YM	Futures	37979.3	37980.4	37907.0	37919.0	4550.0

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

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