PREVIEW / futures_1hour / 2022-07-08

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-07-08.parquet
  size:    57 KB
  rows:    1,640

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-07-08 00:00:00	ES	Futures	4406.57	4412.24	4405.72	4411.39	6123.0
2022-07-08 01:00:00	ES	Futures	4411.39	4412.52	4401.19	4403.46	6978.0
2022-07-08 02:00:00	ES	Futures	4403.46	4410.25	4401.47	4409.69	7642.0
2022-07-08 03:00:00	ES	Futures	4409.69	4418.19	4405.15	4412.24	16244.0
2022-07-08 04:00:00	ES	Futures	4411.95	4417.62	4403.74	4405.72	18887.0
2022-07-08 05:00:00	ES	Futures	4406.0	4414.22	4399.49	4412.52	16465.0
2022-07-08 06:00:00	ES	Futures	4412.24	4429.23	4410.82	4413.37	22359.0
2022-07-08 07:00:00	ES	Futures	4413.65	4422.15	4411.95	4418.75	14471.0
2022-07-08 08:00:00	ES	Futures	4418.75	4424.13	4382.78	4400.06	95919.0
2022-07-08 09:00:00	ES	Futures	4400.06	4419.89	4389.01	4394.39	196543.0
2022-07-08 10:00:00	ES	Futures	4394.39	4434.62	4386.74	4430.93	214767.0
2022-07-08 11:00:00	ES	Futures	4430.93	4443.96	4425.55	4436.03	149749.0
2022-07-08 12:00:00	ES	Futures	4436.03	4436.6	4402.32	4404.02	153873.0
2022-07-08 13:00:00	ES	Futures	4404.31	4425.83	4398.07	4419.32	119968.0
2022-07-08 14:00:00	ES	Futures	4419.04	4439.43	4414.79	4436.88	105066.0
2022-07-08 15:00:00	ES	Futures	4436.88	4440.85	4418.47	4421.3	200475.0
2022-07-08 16:00:00	ES	Futures	4421.3	4426.12	4418.19	4425.27	39431.0
2022-07-08 00:00:00	NQ	Futures	13974.01	13997.43	13971.11	13993.39	3555.0
2022-07-08 01:00:00	NQ	Futures	13993.1	13995.41	13956.36	13966.78	3982.0
2022-07-08 02:00:00	NQ	Futures	13966.49	13986.44	13954.34	13984.13	4989.0
2022-07-08 03:00:00	NQ	Futures	13983.84	14016.24	13967.93	13996.57	7550.0
2022-07-08 04:00:00	NQ	Futures	13995.99	14011.61	13966.78	13969.96	7248.0
2022-07-08 05:00:00	NQ	Futures	13970.82	13987.31	13944.21	13981.53	6760.0
2022-07-08 06:00:00	NQ	Futures	13980.37	14027.8	13956.36	13962.73	9653.0
2022-07-08 07:00:00	NQ	Futures	13963.59	13998.88	13960.7	13982.68	9725.0
2022-07-08 08:00:00	NQ	Futures	13983.26	14005.82	13828.52	13896.78	45869.0
2022-07-08 09:00:00	NQ	Futures	13896.2	13988.76	13858.31	13890.71	92466.0
2022-07-08 10:00:00	NQ	Futures	13890.71	14065.69	13865.25	14052.68	97271.0
2022-07-08 11:00:00	NQ	Futures	14052.97	14127.59	14046.03	14101.27	74339.0
2022-07-08 12:00:00	NQ	Futures	14101.56	14102.72	13933.8	13952.31	64819.0
2022-07-08 13:00:00	NQ	Futures	13952.89	14057.02	13928.02	14028.38	52022.0
2022-07-08 14:00:00	NQ	Futures	14028.38	14103.3	14010.45	14089.41	48379.0
2022-07-08 15:00:00	NQ	Futures	14089.41	14097.8	14045.74	14063.38	62255.0
2022-07-08 16:00:00	NQ	Futures	14062.8	14075.82	14052.1	14068.88	9965.0
2022-07-08 00:00:00	YM	Futures	35274.3	35312.6	35272.0	35302.5	954.0
2022-07-08 01:00:00	YM	Futures	35308.1	35316.0	35237.0	35250.6	1464.0
2022-07-08 02:00:00	YM	Futures	35250.6	35302.5	35237.0	35298.0	1269.0
2022-07-08 03:00:00	YM	Futures	35300.2	35353.3	35261.9	35307.0	2069.0
2022-07-08 04:00:00	YM	Futures	35309.3	35349.9	35246.1	35263.0	2387.0
2022-07-08 05:00:00	YM	Futures	35264.1	35346.5	35228.0	35333.0	2590.0
2022-07-08 06:00:00	YM	Futures	35333.0	35479.6	35329.6	35369.1	4274.0
2022-07-08 07:00:00	YM	Futures	35371.3	35436.8	35355.5	35411.9	2830.0
2022-07-08 08:00:00	YM	Futures	35413.1	35451.4	35198.7	35310.4	12880.0
2022-07-08 09:00:00	YM	Futures	35309.3	35410.8	35204.3	35241.6	27072.0
2022-07-08 10:00:00	YM	Futures	35242.7	35497.7	35189.7	35470.6	19773.0
2022-07-08 11:00:00	YM	Futures	35471.7	35531.5	35397.3	35466.1	12865.0
2022-07-08 12:00:00	YM	Futures	35467.2	35470.6	35268.6	35278.8	11985.0
2022-07-08 13:00:00	YM	Futures	35279.9	35388.2	35235.9	35352.1	9041.0
2022-07-08 14:00:00	YM	Futures	35351.0	35497.7	35326.2	35474.0	7709.0
2022-07-08 15:00:00	YM	Futures	35476.2	35506.7	35313.8	35339.7	15461.0

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

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