PREVIEW / futures_1hour / 2023-09-07

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-09-07.parquet
  size:    64 KB
  rows:    2,004

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-07 00:00:00	ES	Futures	4906.89	4907.17	4900.03	4901.4	6722.0
2023-09-07 01:00:00	ES	Futures	4901.13	4901.68	4897.56	4898.93	7337.0
2023-09-07 02:00:00	ES	Futures	4898.93	4900.3	4893.44	4895.64	11000.0
2023-09-07 03:00:00	ES	Futures	4895.91	4900.58	4890.15	4900.03	25324.0
2023-09-07 04:00:00	ES	Futures	4900.3	4900.58	4889.05	4895.09	20920.0
2023-09-07 05:00:00	ES	Futures	4895.36	4902.22	4894.54	4897.56	16249.0
2023-09-07 06:00:00	ES	Futures	4897.56	4899.48	4892.07	4893.71	11171.0
2023-09-07 07:00:00	ES	Futures	4893.71	4897.01	4887.4	4887.68	19358.0
2023-09-07 08:00:00	ES	Futures	4887.68	4889.87	4869.56	4872.03	68300.0
2023-09-07 09:00:00	ES	Futures	4872.03	4887.4	4869.56	4876.7	252711.0
2023-09-07 10:00:00	ES	Futures	4876.42	4890.15	4869.01	4883.28	259573.0
2023-09-07 11:00:00	ES	Futures	4883.28	4893.99	4881.36	4882.73	152487.0
2023-09-07 12:00:00	ES	Futures	4883.01	4896.46	4881.91	4888.22	116585.0
2023-09-07 13:00:00	ES	Futures	4888.5	4896.46	4886.3	4894.81	91906.0
2023-09-07 14:00:00	ES	Futures	4894.81	4897.83	4883.83	4893.71	108535.0
2023-09-07 15:00:00	ES	Futures	4893.99	4900.58	4886.03	4892.07	207382.0
2023-09-07 16:00:00	ES	Futures	4892.34	4894.81	4888.5	4894.26	44282.0
2023-09-07 18:00:00	ES	Futures	4895.36	4895.36	4893.71	4895.36	2348.0
2023-09-07 19:00:00	ES	Futures	4895.09	4895.36	4891.79	4893.99	3232.0
2023-09-07 20:00:00	ES	Futures	4893.99	4895.09	4887.68	4890.97	6540.0
2023-09-07 21:00:00	ES	Futures	4891.24	4893.17	4887.4	4892.34	5133.0
2023-09-07 22:00:00	ES	Futures	4892.34	4895.36	4891.52	4893.99	3439.0
2023-09-07 23:00:00	ES	Futures	4893.99	4895.36	4892.89	4894.81	2426.0
2023-09-07 00:00:00	NQ	Futures	17117.3	17118.97	17082.54	17086.15	5297.0
2023-09-07 01:00:00	NQ	Futures	17085.87	17088.1	17065.01	17068.63	4468.0
2023-09-07 02:00:00	NQ	Futures	17068.63	17075.86	17048.88	17056.39	5722.0
2023-09-07 03:00:00	NQ	Futures	17056.67	17069.19	17030.8	17067.52	12398.0
2023-09-07 04:00:00	NQ	Futures	17067.24	17068.07	16992.42	17018.84	15111.0
2023-09-07 05:00:00	NQ	Futures	17019.12	17059.17	17017.18	17033.59	11013.0
2023-09-07 06:00:00	NQ	Futures	17033.31	17042.76	17008.83	17016.34	6867.0
2023-09-07 07:00:00	NQ	Futures	17016.62	17035.53	16993.53	16997.15	12758.0
2023-09-07 08:00:00	NQ	Futures	16996.59	17007.16	16896.47	16910.93	36399.0
2023-09-07 09:00:00	NQ	Futures	16910.93	16955.99	16863.09	16902.31	120498.0
2023-09-07 10:00:00	NQ	Futures	16902.03	17000.77	16868.1	16947.64	106599.0
2023-09-07 11:00:00	NQ	Futures	16947.92	16991.59	16907.59	16915.66	67112.0
2023-09-07 12:00:00	NQ	Futures	16916.21	16991.31	16910.65	16955.15	47127.0
2023-09-07 13:00:00	NQ	Futures	16955.71	17007.72	16947.36	16998.82	40555.0
2023-09-07 14:00:00	NQ	Futures	16999.38	17018.84	16961.55	17009.94	41600.0
2023-09-07 15:00:00	NQ	Futures	17010.22	17034.7	16977.12	16995.76	61388.0
2023-09-07 16:00:00	NQ	Futures	16995.76	17007.44	16979.91	17006.33	12081.0
2023-09-07 18:00:00	NQ	Futures	17006.33	17009.39	17002.16	17005.49	1478.0
2023-09-07 19:00:00	NQ	Futures	17005.77	17009.39	16989.64	17000.21	2260.0
2023-09-07 20:00:00	NQ	Futures	17000.49	17008.55	16973.79	16986.86	4584.0
2023-09-07 21:00:00	NQ	Futures	16987.14	16996.87	16969.62	16992.14	3646.0
2023-09-07 22:00:00	NQ	Futures	16992.14	17006.61	16987.97	17000.49	2707.0
2023-09-07 23:00:00	NQ	Futures	17000.77	17008.55	16996.59	17008.0	1873.0
2023-09-07 00:00:00	YM	Futures	37758.0	37760.2	37705.4	37716.3	1116.0
2023-09-07 01:00:00	YM	Futures	37716.3	37724.0	37705.4	37716.3	925.0
2023-09-07 02:00:00	YM	Futures	37717.4	37721.8	37672.5	37686.8	2301.0
2023-09-07 03:00:00	YM	Futures	37688.9	37740.4	37660.5	37738.2	3592.0

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

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