PREVIEW / futures_1hour / 2023-07-11

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-07-11.parquet
  size:    65 KB
  rows:    2,010

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-07-11 00:00:00	ES	Futures	4883.28	4883.28	4881.36	4883.01	3313.0
2023-07-11 01:00:00	ES	Futures	4883.01	4886.03	4879.71	4885.48	6541.0
2023-07-11 02:00:00	ES	Futures	4885.2	4892.07	4884.38	4889.05	13702.0
2023-07-11 03:00:00	ES	Futures	4889.05	4890.7	4880.26	4880.26	18517.0
2023-07-11 04:00:00	ES	Futures	4880.54	4883.01	4874.22	4877.79	17471.0
2023-07-11 05:00:00	ES	Futures	4877.79	4887.4	4875.87	4886.85	15566.0
2023-07-11 06:00:00	ES	Futures	4886.85	4887.95	4883.28	4883.83	11749.0
2023-07-11 07:00:00	ES	Futures	4883.83	4890.97	4883.56	4890.42	15637.0
2023-07-11 08:00:00	ES	Futures	4890.42	4894.26	4886.58	4893.17	27783.0
2023-07-11 09:00:00	ES	Futures	4893.17	4895.91	4879.99	4888.22	188905.0
2023-07-11 10:00:00	ES	Futures	4888.22	4892.89	4877.52	4890.97	190983.0
2023-07-11 11:00:00	ES	Futures	4890.97	4900.58	4888.22	4900.03	130729.0
2023-07-11 12:00:00	ES	Futures	4900.3	4903.05	4889.05	4896.73	126102.0
2023-07-11 13:00:00	ES	Futures	4896.73	4898.93	4889.87	4895.36	79293.0
2023-07-11 14:00:00	ES	Futures	4895.36	4900.03	4886.85	4899.48	115621.0
2023-07-11 15:00:00	ES	Futures	4899.48	4917.6	4896.19	4911.56	232346.0
2023-07-11 16:00:00	ES	Futures	4911.56	4911.83	4908.54	4910.73	58954.0
2023-07-11 18:00:00	ES	Futures	4909.36	4913.75	4908.54	4913.21	4197.0
2023-07-11 19:00:00	ES	Futures	4913.21	4915.4	4909.91	4910.73	5669.0
2023-07-11 20:00:00	ES	Futures	4910.73	4911.83	4908.54	4909.64	5668.0
2023-07-11 21:00:00	ES	Futures	4909.64	4911.56	4908.26	4909.36	5728.0
2023-07-11 22:00:00	ES	Futures	4909.36	4914.03	4909.36	4914.03	4071.0
2023-07-11 23:00:00	ES	Futures	4913.75	4914.85	4913.21	4913.48	3451.0
2023-07-11 00:00:00	NQ	Futures	16905.65	16906.76	16897.86	16903.98	1687.0
2023-07-11 01:00:00	NQ	Futures	16904.53	16920.94	16891.46	16917.6	3970.0
2023-07-11 02:00:00	NQ	Futures	16917.33	16952.93	16915.1	16944.31	6527.0
2023-07-11 03:00:00	NQ	Futures	16943.75	16946.81	16908.43	16910.37	7065.0
2023-07-11 04:00:00	NQ	Futures	16910.1	16918.16	16887.29	16904.53	7721.0
2023-07-11 05:00:00	NQ	Futures	16905.09	16937.35	16897.58	16934.29	6182.0
2023-07-11 06:00:00	NQ	Futures	16934.29	16934.29	16913.43	16913.43	4672.0
2023-07-11 07:00:00	NQ	Futures	16913.99	16944.86	16911.76	16942.08	7279.0
2023-07-11 08:00:00	NQ	Futures	16942.91	16954.6	16924.0	16942.91	14023.0
2023-07-11 09:00:00	NQ	Futures	16942.91	16947.64	16845.29	16872.83	91399.0
2023-07-11 10:00:00	NQ	Futures	16872.55	16923.72	16809.69	16905.65	98125.0
2023-07-11 11:00:00	NQ	Futures	16905.92	16950.98	16869.21	16950.15	69352.0
2023-07-11 12:00:00	NQ	Futures	16950.15	16966.0	16889.24	16927.34	55190.0
2023-07-11 13:00:00	NQ	Futures	16927.06	16937.07	16882.84	16914.27	35340.0
2023-07-11 14:00:00	NQ	Futures	16914.27	16926.23	16862.53	16921.5	43168.0
2023-07-11 15:00:00	NQ	Futures	16921.78	16997.98	16906.76	16975.73	65833.0
2023-07-11 16:00:00	NQ	Futures	16975.73	16984.36	16966.0	16979.91	13196.0
2023-07-11 18:00:00	NQ	Futures	16974.9	16992.14	16971.84	16991.03	2300.0
2023-07-11 19:00:00	NQ	Futures	16990.75	17000.21	16979.35	16981.85	3607.0
2023-07-11 20:00:00	NQ	Futures	16981.85	16987.42	16972.12	16978.79	2740.0
2023-07-11 21:00:00	NQ	Futures	16978.52	16989.08	16971.01	16977.12	3596.0
2023-07-11 22:00:00	NQ	Futures	16976.85	16997.15	16976.29	16996.59	2626.0
2023-07-11 23:00:00	NQ	Futures	16996.59	17001.04	16990.2	16994.65	2418.0
2023-07-11 00:00:00	YM	Futures	37419.4	37420.5	37405.2	37417.3	697.0
2023-07-11 01:00:00	YM	Futures	37416.2	37429.3	37395.3	37428.2	1003.0
2023-07-11 02:00:00	YM	Futures	37427.1	37479.7	37423.8	37454.5	3300.0
2023-07-11 03:00:00	YM	Futures	37455.6	37461.1	37397.5	37398.6	3600.0

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

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