PREVIEW / futures_1hour / 2023-07-05

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-07-05.parquet
  size:    65 KB
  rows:    1,970

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-05 00:00:00	ES	Futures	4929.13	4929.13	4927.75	4928.3	2986.0
2023-07-05 01:00:00	ES	Futures	4928.3	4929.68	4927.75	4928.3	3604.0
2023-07-05 02:00:00	ES	Futures	4928.03	4928.85	4918.42	4918.97	13629.0
2023-07-05 03:00:00	ES	Futures	4919.24	4923.64	4917.87	4920.62	23114.0
2023-07-05 04:00:00	ES	Futures	4920.62	4922.81	4918.15	4919.24	15821.0
2023-07-05 05:00:00	ES	Futures	4919.24	4919.79	4905.52	4910.19	30435.0
2023-07-05 06:00:00	ES	Futures	4909.91	4914.03	4908.54	4912.66	14324.0
2023-07-05 07:00:00	ES	Futures	4912.66	4913.21	4906.89	4907.17	18043.0
2023-07-05 08:00:00	ES	Futures	4907.17	4907.99	4904.15	4906.34	24934.0
2023-07-05 09:00:00	ES	Futures	4906.62	4925.56	4905.79	4923.91	154867.0
2023-07-05 10:00:00	ES	Futures	4924.19	4931.05	4920.62	4930.5	151476.0
2023-07-05 11:00:00	ES	Futures	4930.5	4931.6	4923.36	4925.01	102385.0
2023-07-05 12:00:00	ES	Futures	4924.73	4925.83	4918.42	4923.09	103589.0
2023-07-05 13:00:00	ES	Futures	4923.36	4925.83	4921.44	4925.01	50027.0
2023-07-05 14:00:00	ES	Futures	4924.73	4928.3	4913.75	4926.93	138222.0
2023-07-05 15:00:00	ES	Futures	4926.93	4930.22	4922.54	4923.09	145314.0
2023-07-05 16:00:00	ES	Futures	4923.09	4923.91	4921.17	4921.44	37094.0
2023-07-05 18:00:00	ES	Futures	4921.17	4923.09	4919.79	4920.07	2876.0
2023-07-05 19:00:00	ES	Futures	4920.34	4922.54	4918.97	4920.07	2564.0
2023-07-05 20:00:00	ES	Futures	4919.79	4920.34	4915.4	4916.22	6951.0
2023-07-05 21:00:00	ES	Futures	4916.22	4919.52	4915.68	4918.97	4767.0
2023-07-05 22:00:00	ES	Futures	4918.97	4920.07	4915.13	4916.22	7172.0
2023-07-05 23:00:00	ES	Futures	4916.22	4916.5	4907.44	4907.71	11763.0
2023-07-05 00:00:00	NQ	Futures	17071.13	17071.41	17065.29	17066.96	1355.0
2023-07-05 01:00:00	NQ	Futures	17067.24	17075.03	17065.29	17068.07	2091.0
2023-07-05 02:00:00	NQ	Futures	17067.8	17070.3	17008.0	17010.78	7852.0
2023-07-05 03:00:00	NQ	Futures	17011.06	17033.59	17007.72	17024.69	7921.0
2023-07-05 04:00:00	NQ	Futures	17024.41	17039.98	17013.28	17018.57	6308.0
2023-07-05 05:00:00	NQ	Futures	17018.84	17025.8	16971.84	16985.19	9043.0
2023-07-05 06:00:00	NQ	Futures	16984.91	17015.51	16979.63	17011.06	6966.0
2023-07-05 07:00:00	NQ	Futures	17010.5	17014.12	16988.81	16989.36	6553.0
2023-07-05 08:00:00	NQ	Futures	16990.2	17004.66	16978.52	17002.71	10800.0
2023-07-05 09:00:00	NQ	Futures	17002.99	17128.15	16996.59	17103.12	86229.0
2023-07-05 10:00:00	NQ	Futures	17104.79	17168.48	17095.33	17148.73	77571.0
2023-07-05 11:00:00	NQ	Futures	17149.01	17150.68	17072.8	17079.2	57009.0
2023-07-05 12:00:00	NQ	Futures	17079.48	17106.73	17064.18	17093.11	45097.0
2023-07-05 13:00:00	NQ	Futures	17093.11	17110.63	17080.03	17100.62	25756.0
2023-07-05 14:00:00	NQ	Futures	17100.89	17119.53	17048.6	17105.07	54687.0
2023-07-05 15:00:00	NQ	Futures	17105.07	17123.98	17085.87	17088.1	42780.0
2023-07-05 16:00:00	NQ	Futures	17088.1	17091.99	17078.36	17082.26	9834.0
2023-07-05 18:00:00	NQ	Futures	17081.42	17088.38	17078.09	17079.2	1625.0
2023-07-05 19:00:00	NQ	Futures	17078.92	17095.05	17078.36	17086.15	1978.0
2023-07-05 20:00:00	NQ	Futures	17086.71	17087.82	17057.5	17063.07	4200.0
2023-07-05 21:00:00	NQ	Futures	17062.79	17082.81	17058.9	17080.59	3697.0
2023-07-05 22:00:00	NQ	Futures	17080.59	17083.37	17065.57	17067.8	3204.0
2023-07-05 23:00:00	NQ	Futures	17067.52	17067.8	17019.4	17021.07	7058.0
2023-07-05 00:00:00	YM	Futures	37902.6	37902.6	37896.0	37901.5	385.0
2023-07-05 01:00:00	YM	Futures	37900.4	37907.0	37896.0	37899.3	512.0
2023-07-05 02:00:00	YM	Futures	37899.3	37905.9	37854.4	37857.7	2078.0
2023-07-05 03:00:00	YM	Futures	37858.8	37887.2	37844.5	37864.2	3553.0

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

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