PREVIEW / futures_1hour / 2023-06-16

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-06-16.parquet
  size:    56 KB
  rows:    1,629

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-16 00:00:00	ES	Futures	4903.05	4905.52	4901.95	4903.32	4503.0
2023-06-16 01:00:00	ES	Futures	4903.32	4908.26	4902.22	4907.71	6442.0
2023-06-16 02:00:00	ES	Futures	4907.44	4911.01	4902.77	4907.17	12047.0
2023-06-16 03:00:00	ES	Futures	4907.17	4907.71	4900.03	4906.07	18466.0
2023-06-16 04:00:00	ES	Futures	4906.07	4917.05	4905.24	4915.13	22294.0
2023-06-16 05:00:00	ES	Futures	4915.13	4917.05	4912.38	4913.48	23088.0
2023-06-16 06:00:00	ES	Futures	4913.48	4914.58	4906.89	4909.91	19113.0
2023-06-16 07:00:00	ES	Futures	4910.19	4916.77	4909.36	4912.38	22800.0
2023-06-16 08:00:00	ES	Futures	4912.38	4924.19	4910.46	4922.54	41494.0
2023-06-16 09:00:00	ES	Futures	4922.54	4934.34	4907.17	4912.93	294496.0
2023-06-16 10:00:00	ES	Futures	4912.66	4926.11	4908.81	4915.95	254700.0
2023-06-16 11:00:00	ES	Futures	4915.95	4921.44	4902.77	4913.21	213046.0
2023-06-16 12:00:00	ES	Futures	4913.21	4926.11	4910.19	4923.36	132119.0
2023-06-16 13:00:00	ES	Futures	4923.36	4924.46	4909.64	4914.3	111382.0
2023-06-16 14:00:00	ES	Futures	4914.03	4915.4	4899.75	4900.3	112869.0
2023-06-16 15:00:00	ES	Futures	4900.3	4903.32	4887.4	4892.62	316546.0
2023-06-16 16:00:00	ES	Futures	4892.62	4900.58	4892.07	4896.19	73677.0
2023-06-16 00:00:00	NQ	Futures	17073.08	17081.7	17065.85	17070.58	2269.0
2023-06-16 01:00:00	NQ	Futures	17071.13	17097.83	17064.46	17095.05	3494.0
2023-06-16 02:00:00	NQ	Futures	17093.94	17108.68	17078.36	17088.66	5704.0
2023-06-16 03:00:00	NQ	Futures	17087.82	17093.11	17061.68	17086.71	7914.0
2023-06-16 04:00:00	NQ	Futures	17088.93	17143.73	17088.93	17129.82	11367.0
2023-06-16 05:00:00	NQ	Futures	17130.1	17143.73	17116.47	17128.15	9450.0
2023-06-16 06:00:00	NQ	Futures	17128.15	17129.82	17097.56	17123.42	7782.0
2023-06-16 07:00:00	NQ	Futures	17123.42	17159.58	17119.81	17137.88	10157.0
2023-06-16 08:00:00	NQ	Futures	17137.61	17181.55	17132.88	17169.31	17943.0
2023-06-16 09:00:00	NQ	Futures	17169.04	17216.87	17058.34	17087.26	117197.0
2023-06-16 10:00:00	NQ	Futures	17089.77	17149.57	17070.3	17104.23	87708.0
2023-06-16 11:00:00	NQ	Futures	17104.51	17151.79	17048.6	17103.95	67604.0
2023-06-16 12:00:00	NQ	Futures	17103.95	17150.68	17088.38	17136.22	48359.0
2023-06-16 13:00:00	NQ	Futures	17136.22	17143.17	17080.03	17104.23	44862.0
2023-06-16 14:00:00	NQ	Futures	17103.4	17108.96	17034.14	17036.64	45204.0
2023-06-16 15:00:00	NQ	Futures	17036.92	17048.88	16975.46	16993.53	85649.0
2023-06-16 16:00:00	NQ	Futures	16993.81	17036.37	16993.53	17022.46	17228.0
2023-06-16 00:00:00	YM	Futures	38013.2	38030.8	38007.8	38016.5	634.0
2023-06-16 01:00:00	YM	Futures	38015.4	38040.6	38007.8	38028.6	1862.0
2023-06-16 02:00:00	YM	Futures	38027.5	38061.4	38013.2	38038.4	3378.0
2023-06-16 03:00:00	YM	Futures	38037.3	38045.0	37997.9	38034.0	3772.0
2023-06-16 04:00:00	YM	Futures	38034.0	38079.0	38008.8	38073.5	5041.0
2023-06-16 05:00:00	YM	Futures	38074.6	38095.4	38049.4	38056.0	4773.0
2023-06-16 06:00:00	YM	Futures	38056.0	38063.6	38009.9	38022.0	4716.0
2023-06-16 07:00:00	YM	Futures	38024.2	38060.3	38015.4	38041.7	3985.0
2023-06-16 08:00:00	YM	Futures	38039.5	38110.7	38024.2	38102.0	4356.0
2023-06-16 09:00:00	YM	Futures	38100.9	38221.4	38036.2	38069.1	31326.0
2023-06-16 10:00:00	YM	Futures	38075.7	38163.3	38040.6	38077.9	22351.0
2023-06-16 11:00:00	YM	Futures	38080.1	38088.8	37983.6	38034.0	15174.0
2023-06-16 12:00:00	YM	Futures	38035.1	38121.7	38016.5	38112.9	9322.0
2023-06-16 13:00:00	YM	Futures	38111.8	38120.6	38031.9	38051.6	7837.0
2023-06-16 14:00:00	YM	Futures	38051.6	38061.4	37974.9	37980.4	8868.0
2023-06-16 15:00:00	YM	Futures	37980.4	37996.8	37889.4	37925.6	19035.0

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

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