PREVIEW / futures_1hour / 2023-06-20

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-06-20.parquet
  size:    66 KB
  rows:    2,034

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-06-20 00:00:00	ES	Futures	4879.71	4880.54	4877.52	4877.79	2753.0
2023-06-20 01:00:00	ES	Futures	4877.79	4879.44	4872.85	4877.24	6915.0
2023-06-20 02:00:00	ES	Futures	4877.24	4881.09	4875.32	4877.24	7080.0
2023-06-20 03:00:00	ES	Futures	4876.97	4883.56	4870.66	4883.01	21061.0
2023-06-20 04:00:00	ES	Futures	4883.01	4883.83	4866.54	4868.19	22854.0
2023-06-20 05:00:00	ES	Futures	4868.19	4872.58	4867.09	4870.38	11422.0
2023-06-20 06:00:00	ES	Futures	4870.11	4874.22	4869.01	4873.95	10142.0
2023-06-20 07:00:00	ES	Futures	4873.95	4877.52	4870.93	4876.15	16120.0
2023-06-20 08:00:00	ES	Futures	4876.15	4880.26	4873.68	4879.44	23110.0
2023-06-20 09:00:00	ES	Futures	4879.44	4880.81	4865.71	4867.91	166460.0
2023-06-20 10:00:00	ES	Futures	4867.91	4869.56	4842.93	4851.17	269981.0
2023-06-20 11:00:00	ES	Futures	4851.44	4858.58	4850.34	4854.46	136880.0
2023-06-20 12:00:00	ES	Futures	4854.73	4876.15	4852.26	4874.22	141851.0
2023-06-20 13:00:00	ES	Futures	4874.5	4880.54	4868.73	4870.11	116083.0
2023-06-20 14:00:00	ES	Futures	4870.38	4876.7	4867.91	4872.3	95843.0
2023-06-20 15:00:00	ES	Futures	4872.3	4876.97	4866.81	4868.73	198639.0
2023-06-20 16:00:00	ES	Futures	4868.73	4869.56	4862.15	4864.89	64749.0
2023-06-20 18:00:00	ES	Futures	4864.62	4869.28	4864.62	4865.99	4323.0
2023-06-20 19:00:00	ES	Futures	4865.99	4871.75	4865.99	4870.66	3205.0
2023-06-20 20:00:00	ES	Futures	4870.66	4873.68	4869.01	4871.75	5036.0
2023-06-20 21:00:00	ES	Futures	4871.75	4872.3	4869.83	4872.03	4365.0
2023-06-20 22:00:00	ES	Futures	4872.03	4872.3	4867.36	4868.46	5304.0
2023-06-20 23:00:00	ES	Futures	4868.73	4869.56	4866.81	4869.28	3098.0
2023-06-20 00:00:00	NQ	Futures	16952.65	16953.48	16944.31	16945.14	1850.0
2023-06-20 01:00:00	NQ	Futures	16944.86	16949.59	16925.11	16940.41	4432.0
2023-06-20 02:00:00	NQ	Futures	16940.97	16956.54	16935.68	16942.36	3913.0
2023-06-20 03:00:00	NQ	Futures	16941.8	16966.28	16919.83	16962.38	8733.0
2023-06-20 04:00:00	NQ	Futures	16962.38	16967.39	16875.61	16886.73	13318.0
2023-06-20 05:00:00	NQ	Futures	16886.73	16907.31	16880.89	16900.36	5498.0
2023-06-20 06:00:00	NQ	Futures	16899.53	16925.39	16896.74	16923.17	5794.0
2023-06-20 07:00:00	NQ	Futures	16923.45	16948.76	16919.27	16940.13	8150.0
2023-06-20 08:00:00	NQ	Futures	16939.86	16969.34	16935.68	16968.78	16014.0
2023-06-20 09:00:00	NQ	Futures	16969.34	17033.59	16915.38	16937.63	97569.0
2023-06-20 10:00:00	NQ	Futures	16937.91	16966.56	16828.6	16854.47	106650.0
2023-06-20 11:00:00	NQ	Futures	16854.75	16905.92	16853.36	16871.71	57370.0
2023-06-20 12:00:00	NQ	Futures	16872.27	16991.87	16864.76	16975.46	59528.0
2023-06-20 13:00:00	NQ	Futures	16975.73	17005.49	16945.42	16951.26	42753.0
2023-06-20 14:00:00	NQ	Futures	16951.81	16987.97	16943.19	16964.05	37216.0
2023-06-20 15:00:00	NQ	Futures	16964.61	17007.72	16942.91	16969.89	55641.0
2023-06-20 16:00:00	NQ	Futures	16969.89	16972.95	16943.75	16959.6	13386.0
2023-06-20 18:00:00	NQ	Futures	16963.22	16970.73	16953.76	16958.21	2224.0
2023-06-20 19:00:00	NQ	Futures	16958.77	16982.97	16957.66	16979.07	2448.0
2023-06-20 20:00:00	NQ	Futures	16978.52	16991.87	16972.4	16985.19	3568.0
2023-06-20 21:00:00	NQ	Futures	16984.36	16987.14	16975.46	16983.24	3114.0
2023-06-20 22:00:00	NQ	Futures	16982.69	16987.42	16962.11	16967.39	3254.0
2023-06-20 23:00:00	NQ	Futures	16967.67	16972.4	16960.72	16971.84	2016.0
2023-06-20 00:00:00	YM	Futures	37775.5	37779.9	37761.3	37763.4	685.0
2023-06-20 01:00:00	YM	Futures	37763.4	37771.1	37733.9	37761.3	960.0
2023-06-20 02:00:00	YM	Futures	37762.3	37788.6	37744.8	37760.2	1821.0
2023-06-20 03:00:00	YM	Futures	37759.1	37822.6	37712.0	37813.8	6640.0

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

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