PREVIEW / futures_1hour / 2022-09-05

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-09-05.parquet
  size:    53 KB
  rows:    1,599

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-05 00:00:00	ES	Futures	4456.71	4458.98	4453.31	4455.58	4036.0
2022-09-05 01:00:00	ES	Futures	4455.86	4456.14	4446.23	4447.36	6674.0
2022-09-05 02:00:00	ES	Futures	4447.65	4464.08	4445.66	4460.39	11803.0
2022-09-05 03:00:00	ES	Futures	4460.68	4466.91	4443.11	4449.91	19624.0
2022-09-05 04:00:00	ES	Futures	4449.63	4455.86	4443.4	4454.44	9040.0
2022-09-05 05:00:00	ES	Futures	4454.73	4462.38	4445.38	4456.99	16411.0
2022-09-05 06:00:00	ES	Futures	4457.28	4460.68	4449.06	4449.35	9363.0
2022-09-05 07:00:00	ES	Futures	4449.06	4455.29	4442.83	4445.1	11070.0
2022-09-05 08:00:00	ES	Futures	4445.1	4452.18	4440.0	4450.76	13559.0
2022-09-05 09:00:00	ES	Futures	4450.76	4458.98	4450.2	4454.73	18591.0
2022-09-05 10:00:00	ES	Futures	4454.44	4461.81	4453.31	4460.96	12200.0
2022-09-05 11:00:00	ES	Futures	4460.68	4462.94	4456.14	4458.13	10315.0
2022-09-05 12:00:00	ES	Futures	4458.13	4464.93	4457.56	4460.11	7579.0
2022-09-05 18:00:00	ES	Futures	4460.11	4471.44	4455.29	4467.76	8739.0
2022-09-05 19:00:00	ES	Futures	4467.47	4468.61	4461.24	4463.51	6427.0
2022-09-05 20:00:00	ES	Futures	4463.23	4483.9	4457.28	4480.79	20656.0
2022-09-05 21:00:00	ES	Futures	4480.79	4483.62	4468.89	4469.46	12485.0
2022-09-05 22:00:00	ES	Futures	4469.74	4473.42	4464.93	4471.72	10829.0
2022-09-05 23:00:00	ES	Futures	4472.01	4472.29	4461.81	4464.36	6265.0
2022-09-05 00:00:00	NQ	Futures	14020.57	14032.14	14007.27	14017.97	2728.0
2022-09-05 01:00:00	NQ	Futures	14017.97	14018.84	13973.72	13981.24	4157.0
2022-09-05 02:00:00	NQ	Futures	13981.82	14033.59	13973.72	14026.07	7055.0
2022-09-05 03:00:00	NQ	Futures	14026.65	14046.89	13962.15	13981.53	12226.0
2022-09-05 04:00:00	NQ	Futures	13982.68	14006.11	13961.28	14000.91	6865.0
2022-09-05 05:00:00	NQ	Futures	14000.62	14025.2	13971.4	14014.79	7959.0
2022-09-05 06:00:00	NQ	Futures	14014.79	14023.18	13985.58	13989.34	5082.0
2022-09-05 07:00:00	NQ	Futures	13989.34	14004.09	13956.65	13964.75	5993.0
2022-09-05 08:00:00	NQ	Futures	13966.49	13995.99	13945.95	13993.67	8270.0
2022-09-05 09:00:00	NQ	Futures	13994.25	14050.65	13992.81	14036.77	14820.0
2022-09-05 10:00:00	NQ	Futures	14035.61	14069.45	14025.2	14053.55	9377.0
2022-09-05 11:00:00	NQ	Futures	14052.97	14070.61	14032.72	14044.0	6994.0
2022-09-05 12:00:00	NQ	Futures	14044.29	14077.26	14032.43	14040.82	6190.0
2022-09-05 18:00:00	NQ	Futures	14040.82	14094.62	14013.05	14079.87	6062.0
2022-09-05 19:00:00	NQ	Futures	14079.58	14085.65	14043.42	14054.41	3999.0
2022-09-05 20:00:00	NQ	Futures	14055.28	14148.42	14036.19	14134.24	10189.0
2022-09-05 21:00:00	NQ	Futures	14134.53	14154.2	14099.25	14101.56	6635.0
2022-09-05 22:00:00	NQ	Futures	14102.43	14117.76	14079.0	14111.39	8068.0
2022-09-05 23:00:00	NQ	Futures	14110.82	14112.84	14062.51	14075.24	4721.0
2022-09-05 00:00:00	YM	Futures	35426.6	35433.4	35399.5	35419.8	513.0
2022-09-05 01:00:00	YM	Futures	35419.8	35422.1	35363.4	35371.3	814.0
2022-09-05 02:00:00	YM	Futures	35372.4	35485.3	35353.3	35459.3	1797.0
2022-09-05 03:00:00	YM	Futures	35460.5	35504.5	35346.5	35393.9	2787.0
2022-09-05 04:00:00	YM	Futures	35392.8	35443.5	35347.6	35439.0	1335.0
2022-09-05 05:00:00	YM	Futures	35439.0	35479.6	35373.6	35462.7	2421.0
2022-09-05 06:00:00	YM	Futures	35462.7	35494.3	35404.0	35405.2	1435.0
2022-09-05 07:00:00	YM	Futures	35406.3	35446.9	35366.8	35384.9	1612.0
2022-09-05 08:00:00	YM	Futures	35387.1	35433.4	35362.3	35423.2	1915.0
2022-09-05 09:00:00	YM	Futures	35424.3	35477.4	35395.0	35406.3	2618.0
2022-09-05 10:00:00	YM	Futures	35405.2	35468.4	35401.8	35468.4	2432.0
2022-09-05 11:00:00	YM	Futures	35467.2	35475.1	35424.3	35435.6	1722.0

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

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