PREVIEW / futures_1hour / 2023-07-06

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-07-06.parquet
  size:    68 KB
  rows:    2,079

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-06 00:00:00	ES	Futures	4907.71	4908.26	4900.3	4905.79	14789.0
2023-07-06 01:00:00	ES	Futures	4905.79	4907.17	4901.95	4905.24	8155.0
2023-07-06 02:00:00	ES	Futures	4905.24	4909.09	4904.7	4906.89	11800.0
2023-07-06 03:00:00	ES	Futures	4906.89	4907.44	4899.2	4901.68	36536.0
2023-07-06 04:00:00	ES	Futures	4901.68	4905.24	4899.75	4901.95	21158.0
2023-07-06 05:00:00	ES	Futures	4901.95	4904.15	4898.66	4902.22	15972.0
2023-07-06 06:00:00	ES	Futures	4902.5	4904.42	4900.03	4901.68	15930.0
2023-07-06 07:00:00	ES	Futures	4901.68	4905.24	4898.38	4899.2	20875.0
2023-07-06 08:00:00	ES	Futures	4899.2	4899.48	4877.52	4882.19	107318.0
2023-07-06 09:00:00	ES	Futures	4882.46	4884.11	4863.79	4868.73	281506.0
2023-07-06 10:00:00	ES	Futures	4869.01	4869.01	4853.91	4854.73	261272.0
2023-07-06 11:00:00	ES	Futures	4854.73	4865.99	4852.81	4865.17	185885.0
2023-07-06 12:00:00	ES	Futures	4865.17	4877.52	4864.89	4876.7	132167.0
2023-07-06 13:00:00	ES	Futures	4876.97	4883.01	4874.77	4882.73	119161.0
2023-07-06 14:00:00	ES	Futures	4882.73	4887.4	4877.52	4886.3	109308.0
2023-07-06 15:00:00	ES	Futures	4886.58	4886.85	4879.99	4882.46	230627.0
2023-07-06 16:00:00	ES	Futures	4882.19	4884.93	4879.44	4880.54	46923.0
2023-07-06 18:00:00	ES	Futures	4876.7	4882.19	4876.7	4881.09	4296.0
2023-07-06 19:00:00	ES	Futures	4881.36	4883.28	4880.54	4881.09	3728.0
2023-07-06 20:00:00	ES	Futures	4881.09	4883.01	4877.24	4882.73	9002.0
2023-07-06 21:00:00	ES	Futures	4882.73	4884.11	4878.34	4879.71	8508.0
2023-07-06 22:00:00	ES	Futures	4879.44	4881.91	4878.34	4881.09	4876.0
2023-07-06 23:00:00	ES	Futures	4881.36	4883.01	4880.54	4881.64	3833.0
2023-07-06 00:00:00	NQ	Futures	17020.79	17022.18	16986.3	17008.28	7000.0
2023-07-06 01:00:00	NQ	Futures	17008.0	17016.06	16993.53	17008.83	4560.0
2023-07-06 02:00:00	NQ	Futures	17008.55	17028.58	17001.88	17013.0	5505.0
2023-07-06 03:00:00	NQ	Futures	17013.28	17014.12	16982.13	16998.54	10681.0
2023-07-06 04:00:00	NQ	Futures	16998.82	17027.19	16996.32	17013.56	7869.0
2023-07-06 05:00:00	NQ	Futures	17014.12	17029.41	17000.77	17021.63	5836.0
2023-07-06 06:00:00	NQ	Futures	17021.35	17026.63	16997.98	17004.66	6922.0
2023-07-06 07:00:00	NQ	Futures	17005.22	17027.19	17002.16	17009.39	7912.0
2023-07-06 08:00:00	NQ	Futures	17009.11	17011.06	16870.88	16902.31	47135.0
2023-07-06 09:00:00	NQ	Futures	16902.31	16926.23	16831.66	16863.65	107052.0
2023-07-06 10:00:00	NQ	Futures	16861.7	16884.51	16811.91	16825.27	89315.0
2023-07-06 11:00:00	NQ	Futures	16825.27	16882.84	16814.14	16865.04	56217.0
2023-07-06 12:00:00	NQ	Futures	16865.32	16932.35	16863.37	16927.62	45806.0
2023-07-06 13:00:00	NQ	Futures	16927.62	16952.65	16900.64	16952.65	42526.0
2023-07-06 14:00:00	NQ	Futures	16952.65	16968.22	16922.89	16964.05	36188.0
2023-07-06 15:00:00	NQ	Futures	16964.61	16967.39	16935.68	16950.15	49998.0
2023-07-06 16:00:00	NQ	Futures	16950.15	16957.66	16927.9	16935.13	11049.0
2023-07-06 18:00:00	NQ	Futures	16923.45	16942.36	16923.45	16937.91	2257.0
2023-07-06 19:00:00	NQ	Futures	16938.74	16951.26	16936.8	16939.86	2779.0
2023-07-06 20:00:00	NQ	Futures	16939.58	16952.65	16926.78	16951.54	3869.0
2023-07-06 21:00:00	NQ	Futures	16951.54	16958.49	16930.12	16934.01	4281.0
2023-07-06 22:00:00	NQ	Futures	16933.74	16946.81	16928.73	16942.36	2797.0
2023-07-06 23:00:00	NQ	Futures	16941.8	16953.21	16939.86	16947.64	2145.0
2023-07-06 00:00:00	YM	Futures	37687.9	37691.1	37652.8	37683.5	1837.0
2023-07-06 01:00:00	YM	Futures	37683.5	37687.9	37658.3	37681.3	1251.0
2023-07-06 02:00:00	YM	Futures	37680.2	37707.6	37674.7	37691.1	1825.0
2023-07-06 03:00:00	YM	Futures	37692.2	37695.5	37634.2	37644.0	4974.0

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

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