PREVIEW / futures_1hour / 2023-01-19

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-01-19.parquet
  size:    68 KB
  rows:    2,066

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-01-19 00:00:00	ES	Futures	4408.0	4409.67	4403.8	4405.2	6060.0
2023-01-19 01:00:00	ES	Futures	4405.2	4407.72	4401.85	4402.13	7727.0
2023-01-19 02:00:00	ES	Futures	4402.41	4404.92	4397.09	4403.24	17892.0
2023-01-19 03:00:00	ES	Futures	4403.52	4411.63	4395.97	4395.97	26642.0
2023-01-19 04:00:00	ES	Futures	4395.97	4402.13	4392.34	4393.74	20505.0
2023-01-19 05:00:00	ES	Futures	4394.3	4398.21	4387.31	4390.38	20162.0
2023-01-19 06:00:00	ES	Futures	4390.66	4390.66	4379.48	4382.55	29085.0
2023-01-19 07:00:00	ES	Futures	4382.55	4383.39	4373.33	4375.0	35409.0
2023-01-19 08:00:00	ES	Futures	4375.0	4383.39	4369.41	4381.99	73149.0
2023-01-19 09:00:00	ES	Futures	4381.71	4399.61	4377.24	4386.47	230507.0
2023-01-19 10:00:00	ES	Futures	4386.47	4393.74	4366.9	4371.37	278945.0
2023-01-19 11:00:00	ES	Futures	4371.37	4384.23	4363.82	4369.97	203478.0
2023-01-19 12:00:00	ES	Futures	4369.97	4383.95	4369.69	4378.92	137277.0
2023-01-19 13:00:00	ES	Futures	4378.64	4401.85	4378.08	4392.62	196428.0
2023-01-19 14:00:00	ES	Futures	4392.34	4406.88	4386.19	4400.17	168073.0
2023-01-19 15:00:00	ES	Futures	4400.17	4404.92	4378.08	4380.6	256238.0
2023-01-19 16:00:00	ES	Futures	4380.6	4392.62	4379.48	4384.51	74350.0
2023-01-19 18:00:00	ES	Futures	4389.82	4390.38	4381.99	4381.99	7374.0
2023-01-19 19:00:00	ES	Futures	4381.99	4390.1	4381.43	4388.15	7796.0
2023-01-19 20:00:00	ES	Futures	4388.15	4390.94	4385.07	4389.82	7861.0
2023-01-19 21:00:00	ES	Futures	4390.1	4390.1	4385.35	4385.91	4558.0
2023-01-19 22:00:00	ES	Futures	4385.63	4389.26	4385.07	4387.31	3876.0
2023-01-19 23:00:00	ES	Futures	4387.59	4389.54	4386.75	4388.98	3344.0
2023-01-19 00:00:00	NQ	Futures	13051.17	13057.99	13038.08	13042.63	2205.0
2023-01-19 01:00:00	NQ	Futures	13042.91	13053.44	13028.41	13029.54	2605.0
2023-01-19 02:00:00	NQ	Futures	13029.83	13033.53	13004.51	13022.43	6023.0
2023-01-19 03:00:00	NQ	Futures	13024.42	13071.65	13017.88	13017.88	11228.0
2023-01-19 04:00:00	NQ	Futures	13018.16	13045.19	12997.96	13001.66	9017.0
2023-01-19 05:00:00	NQ	Futures	13002.52	13013.33	12973.21	12986.87	9240.0
2023-01-19 06:00:00	NQ	Futures	12987.72	12989.71	12942.77	12954.72	11545.0
2023-01-19 07:00:00	NQ	Futures	12954.15	12959.84	12923.14	12932.53	14182.0
2023-01-19 08:00:00	NQ	Futures	12932.82	12966.95	12910.06	12958.99	29110.0
2023-01-19 09:00:00	NQ	Futures	12958.42	13025.85	12914.61	12968.66	93661.0
2023-01-19 10:00:00	NQ	Futures	12968.66	12993.13	12883.03	12899.25	89756.0
2023-01-19 11:00:00	NQ	Futures	12899.53	12953.01	12868.8	12891.85	60911.0
2023-01-19 12:00:00	NQ	Futures	12892.13	12940.21	12890.71	12922.29	43428.0
2023-01-19 13:00:00	NQ	Futures	12922.29	13002.52	12917.45	12968.95	54328.0
2023-01-19 14:00:00	NQ	Futures	12969.23	13034.66	12949.03	13002.23	49096.0
2023-01-19 15:00:00	NQ	Futures	13003.09	13020.72	12918.02	12927.98	59114.0
2023-01-19 16:00:00	NQ	Futures	12927.41	12991.99	12922.0	12965.53	22800.0
2023-01-19 18:00:00	NQ	Futures	12974.07	12980.33	12951.88	12954.44	3911.0
2023-01-19 19:00:00	NQ	Futures	12954.72	12977.77	12952.73	12973.5	4081.0
2023-01-19 20:00:00	NQ	Futures	12973.78	12981.75	12962.12	12976.91	3106.0
2023-01-19 21:00:00	NQ	Futures	12977.48	12978.33	12960.13	12963.26	1707.0
2023-01-19 22:00:00	NQ	Futures	12963.26	12974.07	12960.7	12966.39	1449.0
2023-01-19 23:00:00	NQ	Futures	12966.95	12974.92	12964.11	12972.08	1188.0
2023-01-19 00:00:00	YM	Futures	37151.3	37159.1	37115.6	37123.4	868.0
2023-01-19 01:00:00	YM	Futures	37123.4	37144.6	37107.8	37107.8	1478.0
2023-01-19 02:00:00	YM	Futures	37112.3	37133.5	37071.1	37115.6	3436.0
2023-01-19 03:00:00	YM	Futures	37119.0	37165.8	37034.3	37036.5	4436.0

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

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