PREVIEW / futures_1hour / 2022-09-06

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-09-06.parquet
  size:    69 KB
  rows:    2,040

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
2022-09-06 00:00:00	ES	Futures	4464.08	4467.76	4460.96	4462.09	5293.0
2022-09-06 01:00:00	ES	Futures	4462.09	4466.06	4459.26	4461.24	6984.0
2022-09-06 02:00:00	ES	Futures	4461.53	4472.01	4458.69	4470.02	11783.0
2022-09-06 03:00:00	ES	Futures	4470.02	4488.44	4467.47	4477.96	30111.0
2022-09-06 04:00:00	ES	Futures	4477.96	4478.81	4466.06	4475.97	18251.0
2022-09-06 05:00:00	ES	Futures	4476.26	4476.82	4464.08	4475.12	14020.0
2022-09-06 06:00:00	ES	Futures	4475.41	4490.7	4472.86	4478.24	19919.0
2022-09-06 07:00:00	ES	Futures	4478.24	4479.94	4465.78	4474.27	24732.0
2022-09-06 08:00:00	ES	Futures	4474.27	4483.05	4470.59	4472.57	29438.0
2022-09-06 09:00:00	ES	Futures	4472.86	4477.39	4428.1	4440.85	214241.0
2022-09-06 10:00:00	ES	Futures	4440.56	4464.64	4404.02	4457.84	403794.0
2022-09-06 11:00:00	ES	Futures	4457.84	4468.04	4442.83	4460.39	271396.0
2022-09-06 12:00:00	ES	Futures	4460.68	4464.36	4426.68	4440.85	182907.0
2022-09-06 13:00:00	ES	Futures	4440.56	4441.13	4411.95	4426.12	194522.0
2022-09-06 14:00:00	ES	Futures	4426.12	4441.98	4421.3	4426.68	179953.0
2022-09-06 15:00:00	ES	Futures	4426.97	4442.55	4418.75	4431.5	334925.0
2022-09-06 16:00:00	ES	Futures	4431.5	4432.92	4423.85	4428.38	51917.0
2022-09-06 18:00:00	ES	Futures	4427.53	4432.35	4426.12	4429.8	5802.0
2022-09-06 19:00:00	ES	Futures	4430.08	4430.93	4423.85	4425.83	5298.0
2022-09-06 20:00:00	ES	Futures	4425.55	4428.1	4400.34	4407.42	27905.0
2022-09-06 21:00:00	ES	Futures	4407.14	4412.8	4401.47	4410.54	13710.0
2022-09-06 22:00:00	ES	Futures	4410.54	4416.2	4407.42	4408.55	9422.0
2022-09-06 23:00:00	ES	Futures	4408.84	4410.82	4403.17	4410.54	8675.0
2022-09-06 00:00:00	NQ	Futures	14074.66	14094.62	14063.09	14067.43	3510.0
2022-09-06 01:00:00	NQ	Futures	14067.43	14089.7	14053.26	14072.35	4735.0
2022-09-06 02:00:00	NQ	Futures	14071.48	14114.87	14061.36	14105.32	6698.0
2022-09-06 03:00:00	NQ	Futures	14104.45	14166.35	14095.49	14113.42	15279.0
2022-09-06 04:00:00	NQ	Futures	14114.29	14128.46	14069.74	14127.01	10813.0
2022-09-06 05:00:00	NQ	Futures	14127.59	14128.17	14081.31	14109.37	7831.0
2022-09-06 06:00:00	NQ	Futures	14109.37	14156.52	14097.51	14111.39	9449.0
2022-09-06 07:00:00	NQ	Futures	14110.53	14113.42	14049.5	14093.17	11736.0
2022-09-06 08:00:00	NQ	Futures	14092.02	14118.63	14064.25	14079.29	13880.0
2022-09-06 09:00:00	NQ	Futures	14079.0	14101.85	13906.61	13936.69	93388.0
2022-09-06 10:00:00	NQ	Futures	13936.69	14027.52	13802.49	14003.22	144949.0
2022-09-06 11:00:00	NQ	Futures	14003.8	14049.5	13950.58	14023.18	100323.0
2022-09-06 12:00:00	NQ	Futures	14023.18	14045.45	13897.65	13950.87	72601.0
2022-09-06 13:00:00	NQ	Futures	13951.45	13954.92	13841.82	13892.73	65336.0
2022-09-06 14:00:00	NQ	Futures	13892.73	13954.92	13883.76	13901.41	59246.0
2022-09-06 15:00:00	NQ	Futures	13901.99	13960.99	13872.19	13908.64	80933.0
2022-09-06 16:00:00	NQ	Futures	13908.64	13915.0	13887.23	13906.9	12071.0
2022-09-06 18:00:00	NQ	Futures	13906.32	13923.1	13895.04	13906.61	2854.0
2022-09-06 19:00:00	NQ	Futures	13906.61	13911.24	13883.76	13890.71	3010.0
2022-09-06 20:00:00	NQ	Futures	13890.42	13900.54	13792.65	13828.81	12136.0
2022-09-06 21:00:00	NQ	Futures	13827.94	13853.68	13805.09	13846.16	6814.0
2022-09-06 22:00:00	NQ	Futures	13845.58	13859.47	13828.23	13833.73	4715.0
2022-09-06 23:00:00	NQ	Futures	13834.59	13841.53	13810.88	13839.22	4720.0
2022-09-06 00:00:00	YM	Futures	35463.8	35483.0	35441.3	35445.8	653.0
2022-09-06 01:00:00	YM	Futures	35446.9	35465.0	35421.0	35434.5	1113.0
2022-09-06 02:00:00	YM	Futures	35433.4	35504.5	35416.4	35488.7	1669.0
2022-09-06 03:00:00	YM	Futures	35488.7	35627.4	35472.9	35569.9	4412.0

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

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