PREVIEW / futures_1hour / 2023-12-11

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-12-11.parquet
  size:    61 KB
  rows:    1,946

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-11 00:00:00	ES	Futures	5001.56	5004.55	5000.75	5003.73	2063.0
2023-12-11 01:00:00	ES	Futures	5003.73	5005.64	5001.29	5001.29	2803.0
2023-12-11 02:00:00	ES	Futures	5001.02	5003.19	4998.85	5000.48	4664.0
2023-12-11 03:00:00	ES	Futures	5000.48	5003.19	4998.85	4999.66	6673.0
2023-12-11 04:00:00	ES	Futures	4999.66	5006.99	4998.85	5002.11	6751.0
2023-12-11 05:00:00	ES	Futures	5001.83	5004.82	4998.85	4999.12	4294.0
2023-12-11 06:00:00	ES	Futures	4999.12	5002.38	4996.13	5001.29	5348.0
2023-12-11 07:00:00	ES	Futures	5001.56	5003.46	4999.93	5002.92	5252.0
2023-12-11 08:00:00	ES	Futures	5002.65	5005.09	4998.85	5001.29	8940.0
2023-12-11 09:00:00	ES	Futures	5001.29	5006.99	4996.4	5006.72	78650.0
2023-12-11 10:00:00	ES	Futures	5006.45	5015.14	5001.56	5011.07	68125.0
2023-12-11 11:00:00	ES	Futures	5011.07	5014.05	5001.02	5008.08	63992.0
2023-12-11 12:00:00	ES	Futures	5008.08	5013.24	5005.64	5012.7	28091.0
2023-12-11 13:00:00	ES	Futures	5012.7	5021.39	5009.44	5020.3	34919.0
2023-12-11 14:00:00	ES	Futures	5020.3	5022.47	5018.13	5019.21	26898.0
2023-12-11 15:00:00	ES	Futures	5019.21	5026.27	5016.77	5023.83	75037.0
2023-12-11 16:00:00	ES	Futures	5023.83	5025.19	5021.93	5023.29	20843.0
2023-12-11 18:00:00	ES	Futures	5023.83	5024.92	5021.39	5024.37	1995.0
2023-12-11 19:00:00	ES	Futures	5024.37	5028.99	5024.1	5027.09	4109.0
2023-12-11 20:00:00	ES	Futures	5027.09	5027.36	5023.29	5025.73	3219.0
2023-12-11 21:00:00	ES	Futures	5025.46	5027.36	5025.46	5026.55	2199.0
2023-12-11 22:00:00	ES	Futures	5026.55	5028.45	5026.0	5026.27	1330.0
2023-12-11 23:00:00	ES	Futures	5026.55	5026.82	5025.46	5026.0	2859.0
2023-12-11 00:00:00	NQ	Futures	17636.46	17649.37	17632.62	17647.72	2011.0
2023-12-11 01:00:00	NQ	Futures	17647.17	17663.38	17643.6	17645.25	2856.0
2023-12-11 02:00:00	NQ	Futures	17644.43	17653.49	17635.64	17648.55	3003.0
2023-12-11 03:00:00	NQ	Futures	17648.0	17662.56	17642.23	17648.27	4260.0
2023-12-11 04:00:00	NQ	Futures	17648.0	17678.21	17644.43	17656.24	4415.0
2023-12-11 05:00:00	NQ	Futures	17657.89	17672.17	17643.88	17645.8	3143.0
2023-12-11 06:00:00	NQ	Futures	17646.35	17658.44	17628.5	17655.69	3779.0
2023-12-11 07:00:00	NQ	Futures	17656.51	17672.72	17650.47	17664.75	4130.0
2023-12-11 08:00:00	NQ	Futures	17663.93	17671.62	17642.51	17666.4	6683.0
2023-12-11 09:00:00	NQ	Futures	17666.13	17758.41	17654.04	17754.29	50352.0
2023-12-11 10:00:00	NQ	Futures	17755.12	17797.96	17726.83	17772.7	37162.0
2023-12-11 11:00:00	NQ	Futures	17772.97	17784.51	17712.0	17757.04	33015.0
2023-12-11 12:00:00	NQ	Futures	17756.49	17802.63	17739.74	17799.89	16114.0
2023-12-11 13:00:00	NQ	Futures	17799.61	17846.31	17785.06	17836.97	16936.0
2023-12-11 14:00:00	NQ	Futures	17836.42	17848.5	17816.09	17823.78	10203.0
2023-12-11 15:00:00	NQ	Futures	17824.33	17841.91	17809.78	17835.59	18974.0
2023-12-11 16:00:00	NQ	Futures	17835.87	17850.98	17829.55	17845.76	5305.0
2023-12-11 18:00:00	NQ	Futures	17842.19	17845.76	17830.38	17843.28	1775.0
2023-12-11 19:00:00	NQ	Futures	17844.11	17877.07	17842.19	17861.41	3965.0
2023-12-11 20:00:00	NQ	Futures	17860.31	17863.61	17847.13	17852.9	2502.0
2023-12-11 21:00:00	NQ	Futures	17852.62	17861.41	17850.7	17857.84	2092.0
2023-12-11 22:00:00	NQ	Futures	17857.84	17865.81	17855.64	17858.12	880.0
2023-12-11 23:00:00	NQ	Futures	17857.57	17862.51	17854.82	17858.12	908.0
2023-12-11 00:00:00	YM	Futures	39354.2	39372.5	39345.6	39364.9	520.0
2023-12-11 01:00:00	YM	Futures	39363.9	39376.8	39344.5	39346.7	782.0
2023-12-11 02:00:00	YM	Futures	39344.5	39357.4	39330.6	39333.8	1257.0
2023-12-11 03:00:00	YM	Futures	39333.8	39347.8	39316.6	39329.5	1599.0

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

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