PREVIEW / futures_1hour / 2023-11-16

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-11-16.parquet
  size:    67 KB
  rows:    2,108

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-11-16 00:00:00	ES	Futures	4901.63	4905.7	4901.36	4904.34	6853.0
2023-11-16 01:00:00	ES	Futures	4904.34	4908.69	4904.34	4907.87	6093.0
2023-11-16 02:00:00	ES	Futures	4907.87	4908.15	4904.34	4905.16	8782.0
2023-11-16 03:00:00	ES	Futures	4905.16	4908.42	4903.26	4906.79	17586.0
2023-11-16 04:00:00	ES	Futures	4906.79	4911.4	4903.8	4904.62	15286.0
2023-11-16 05:00:00	ES	Futures	4904.89	4909.78	4903.53	4906.79	9800.0
2023-11-16 06:00:00	ES	Futures	4906.79	4908.96	4904.62	4907.87	8477.0
2023-11-16 07:00:00	ES	Futures	4907.6	4908.15	4898.1	4899.73	30673.0
2023-11-16 08:00:00	ES	Futures	4899.46	4912.49	4896.47	4912.22	63324.0
2023-11-16 09:00:00	ES	Futures	4911.95	4915.75	4898.64	4914.39	184572.0
2023-11-16 10:00:00	ES	Futures	4914.66	4916.56	4897.01	4899.73	253199.0
2023-11-16 11:00:00	ES	Futures	4899.73	4902.71	4889.95	4896.74	188853.0
2023-11-16 12:00:00	ES	Futures	4897.01	4909.5	4895.65	4904.89	115843.0
2023-11-16 13:00:00	ES	Futures	4904.89	4906.24	4895.11	4898.64	105473.0
2023-11-16 14:00:00	ES	Futures	4898.64	4908.69	4897.28	4905.97	106756.0
2023-11-16 15:00:00	ES	Futures	4905.7	4914.39	4903.26	4913.03	187705.0
2023-11-16 16:00:00	ES	Futures	4912.76	4920.09	4912.49	4919.01	75673.0
2023-11-16 18:00:00	ES	Futures	4918.19	4918.74	4914.39	4914.39	6787.0
2023-11-16 19:00:00	ES	Futures	4914.39	4917.65	4913.58	4916.29	4803.0
2023-11-16 20:00:00	ES	Futures	4916.29	4918.19	4914.93	4917.11	5853.0
2023-11-16 21:00:00	ES	Futures	4917.11	4919.28	4916.02	4918.47	4387.0
2023-11-16 22:00:00	ES	Futures	4918.74	4921.18	4918.47	4920.91	4579.0
2023-11-16 23:00:00	ES	Futures	4920.91	4921.18	4918.19	4919.01	3085.0
2023-11-16 00:00:00	NQ	Futures	17414.53	17429.91	17409.59	17424.97	3815.0
2023-11-16 01:00:00	NQ	Futures	17424.97	17437.61	17424.42	17435.96	3648.0
2023-11-16 02:00:00	NQ	Futures	17436.23	17439.53	17414.26	17417.01	5796.0
2023-11-16 03:00:00	NQ	Futures	17417.01	17434.31	17411.79	17421.68	8064.0
2023-11-16 04:00:00	NQ	Futures	17421.68	17438.98	17409.59	17417.01	7902.0
2023-11-16 05:00:00	NQ	Futures	17417.01	17437.33	17413.71	17429.91	5530.0
2023-11-16 06:00:00	NQ	Futures	17429.64	17435.41	17414.53	17423.87	5353.0
2023-11-16 07:00:00	NQ	Futures	17423.6	17425.25	17390.09	17396.13	13380.0
2023-11-16 08:00:00	NQ	Futures	17395.86	17450.24	17382.95	17448.32	31144.0
2023-11-16 09:00:00	NQ	Futures	17448.32	17466.45	17386.52	17456.83	91210.0
2023-11-16 10:00:00	NQ	Futures	17456.83	17474.96	17374.71	17399.98	112080.0
2023-11-16 11:00:00	NQ	Futures	17400.8	17414.53	17355.21	17404.1	81842.0
2023-11-16 12:00:00	NQ	Futures	17404.1	17471.66	17397.23	17449.97	57910.0
2023-11-16 13:00:00	NQ	Futures	17450.51	17454.36	17393.66	17411.79	50732.0
2023-11-16 14:00:00	NQ	Futures	17412.06	17461.5	17404.1	17445.3	48386.0
2023-11-16 15:00:00	NQ	Futures	17444.75	17476.06	17430.19	17465.62	56377.0
2023-11-16 16:00:00	NQ	Futures	17465.9	17473.59	17452.16	17467.27	14053.0
2023-11-16 18:00:00	NQ	Futures	17466.17	17466.45	17449.69	17452.99	3031.0
2023-11-16 19:00:00	NQ	Futures	17453.26	17465.62	17449.69	17460.4	3185.0
2023-11-16 20:00:00	NQ	Futures	17460.13	17465.62	17454.91	17460.68	3185.0
2023-11-16 21:00:00	NQ	Futures	17460.4	17463.7	17453.81	17461.78	2638.0
2023-11-16 22:00:00	NQ	Futures	17461.78	17471.11	17461.23	17470.02	2766.0
2023-11-16 23:00:00	NQ	Futures	17470.29	17470.84	17460.13	17461.5	2144.0
2023-11-16 00:00:00	YM	Futures	37981.9	38005.7	37981.9	37994.9	903.0
2023-11-16 01:00:00	YM	Futures	37994.9	38022.0	37993.8	38020.9	1342.0
2023-11-16 02:00:00	YM	Futures	38020.9	38023.1	38000.3	38014.4	1514.0
2023-11-16 03:00:00	YM	Futures	38013.3	38039.4	38001.4	38028.5	3206.0

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

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