PREVIEW / futures_1hour / 2023-01-12

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-01-12.parquet
  size:    69 KB
  rows:    2,078

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-12 00:00:00	ES	Futures	4466.99	4468.95	4465.32	4466.44	5512.0
2023-01-12 01:00:00	ES	Futures	4466.44	4467.55	4460.28	4460.56	5275.0
2023-01-12 02:00:00	ES	Futures	4460.56	4461.68	4457.49	4460.28	10404.0
2023-01-12 03:00:00	ES	Futures	4460.28	4461.68	4456.93	4460.56	17418.0
2023-01-12 04:00:00	ES	Futures	4460.56	4464.76	4458.61	4463.36	14741.0
2023-01-12 05:00:00	ES	Futures	4463.08	4463.08	4456.93	4461.68	13256.0
2023-01-12 06:00:00	ES	Futures	4461.68	4465.04	4460.28	4463.08	12041.0
2023-01-12 07:00:00	ES	Futures	4463.08	4474.26	4462.8	4473.7	26204.0
2023-01-12 08:00:00	ES	Futures	4473.43	4495.79	4422.26	4489.08	247570.0
2023-01-12 09:00:00	ES	Futures	4489.08	4497.75	4425.89	4440.43	356172.0
2023-01-12 10:00:00	ES	Futures	4440.43	4477.62	4439.59	4460.56	375510.0
2023-01-12 11:00:00	ES	Futures	4460.56	4472.59	4447.42	4470.07	207236.0
2023-01-12 12:00:00	ES	Futures	4470.07	4490.2	4467.83	4486.01	132567.0
2023-01-12 13:00:00	ES	Futures	4486.01	4493.84	4461.12	4491.88	191648.0
2023-01-12 14:00:00	ES	Futures	4491.88	4494.4	4474.54	4482.09	132150.0
2023-01-12 15:00:00	ES	Futures	4481.81	4483.77	4464.48	4476.78	221563.0
2023-01-12 16:00:00	ES	Futures	4476.78	4479.3	4474.54	4476.78	39971.0
2023-01-12 18:00:00	ES	Futures	4477.06	4479.58	4474.26	4478.74	5239.0
2023-01-12 19:00:00	ES	Futures	4478.74	4482.93	4477.62	4477.62	6626.0
2023-01-12 20:00:00	ES	Futures	4477.9	4480.42	4468.67	4471.19	11820.0
2023-01-12 21:00:00	ES	Futures	4470.91	4470.91	4463.36	4467.27	10008.0
2023-01-12 22:00:00	ES	Futures	4467.27	4469.79	4463.92	4466.71	4943.0
2023-01-12 23:00:00	ES	Futures	4466.71	4468.11	4465.88	4467.55	3344.0
2023-01-12 00:00:00	NQ	Futures	13071.93	13073.92	13065.39	13066.53	2194.0
2023-01-12 01:00:00	NQ	Futures	13066.53	13071.08	13051.17	13051.17	2452.0
2023-01-12 02:00:00	NQ	Futures	13051.45	13054.86	13030.68	13046.61	5740.0
2023-01-12 03:00:00	NQ	Futures	13046.61	13056.57	13030.97	13053.73	6805.0
2023-01-12 04:00:00	NQ	Futures	13054.29	13075.06	13047.75	13067.67	7905.0
2023-01-12 05:00:00	NQ	Futures	13067.38	13067.38	13028.97	13045.19	8006.0
2023-01-12 06:00:00	NQ	Futures	13044.91	13056.0	13040.07	13046.04	4667.0
2023-01-12 07:00:00	NQ	Futures	13046.04	13082.74	13043.48	13082.74	11783.0
2023-01-12 08:00:00	NQ	Futures	13082.17	13157.28	12848.89	13139.07	102677.0
2023-01-12 09:00:00	NQ	Futures	13139.36	13177.48	12871.93	12924.57	129438.0
2023-01-12 10:00:00	NQ	Futures	12924.85	13099.81	12921.72	13006.78	114751.0
2023-01-12 11:00:00	NQ	Futures	13006.78	13083.03	12959.56	13074.78	67810.0
2023-01-12 12:00:00	NQ	Futures	13075.63	13145.62	13056.86	13128.83	62132.0
2023-01-12 13:00:00	NQ	Futures	13128.83	13168.09	13031.82	13160.7	78935.0
2023-01-12 14:00:00	NQ	Futures	13161.26	13171.79	13105.5	13127.98	47887.0
2023-01-12 15:00:00	NQ	Futures	13128.26	13130.25	13068.52	13123.71	63611.0
2023-01-12 16:00:00	NQ	Futures	13122.57	13130.54	13109.49	13111.19	10238.0
2023-01-12 18:00:00	NQ	Futures	13119.16	13119.16	13102.94	13114.89	2465.0
2023-01-12 19:00:00	NQ	Futures	13114.04	13127.98	13107.21	13109.2	3651.0
2023-01-12 20:00:00	NQ	Futures	13109.49	13118.31	13071.93	13080.75	5241.0
2023-01-12 21:00:00	NQ	Futures	13080.47	13080.47	13054.29	13073.07	4900.0
2023-01-12 22:00:00	NQ	Futures	13073.64	13083.31	13061.69	13070.51	2434.0
2023-01-12 23:00:00	NQ	Futures	13069.94	13077.62	13065.96	13077.05	1820.0
2023-01-12 00:00:00	YM	Futures	38021.5	38038.2	38011.4	38020.3	999.0
2023-01-12 01:00:00	YM	Futures	38020.3	38025.9	37974.7	37974.7	739.0
2023-01-12 02:00:00	YM	Futures	37974.7	37988.0	37957.9	37978.0	1418.0
2023-01-12 03:00:00	YM	Futures	37975.8	37992.5	37959.1	37982.5	1920.0

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

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