PREVIEW / futures_1hour / 2022-07-04

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-07-04.parquet
  size:    55 KB
  rows:    1,622

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-04 00:00:00	ES	Futures	4310.83	4311.68	4303.46	4309.13	3527.0
2022-07-04 01:00:00	ES	Futures	4309.13	4316.21	4306.01	4315.92	5192.0
2022-07-04 02:00:00	ES	Futures	4315.92	4324.99	4312.24	4317.62	7668.0
2022-07-04 03:00:00	ES	Futures	4317.62	4321.02	4302.61	4306.01	13676.0
2022-07-04 04:00:00	ES	Futures	4305.73	4310.83	4303.46	4306.58	6491.0
2022-07-04 05:00:00	ES	Futures	4306.58	4325.84	4303.74	4323.29	9487.0
2022-07-04 06:00:00	ES	Futures	4323.86	4326.69	4317.06	4324.42	5012.0
2022-07-04 07:00:00	ES	Futures	4324.14	4329.24	4319.61	4324.71	6201.0
2022-07-04 08:00:00	ES	Futures	4324.42	4328.39	4322.72	4326.69	6047.0
2022-07-04 09:00:00	ES	Futures	4326.69	4330.94	4318.47	4319.04	10884.0
2022-07-04 10:00:00	ES	Futures	4319.04	4319.61	4312.24	4317.06	9274.0
2022-07-04 11:00:00	ES	Futures	4317.06	4324.99	4317.06	4317.91	9733.0
2022-07-04 12:00:00	ES	Futures	4318.19	4324.14	4317.34	4321.02	3992.0
2022-07-04 18:00:00	ES	Futures	4321.02	4345.1	4321.02	4343.12	9273.0
2022-07-04 19:00:00	ES	Futures	4343.4	4371.16	4343.4	4358.98	16238.0
2022-07-04 20:00:00	ES	Futures	4358.7	4363.23	4355.3	4358.7	8145.0
2022-07-04 21:00:00	ES	Futures	4358.42	4362.1	4349.35	4360.96	9858.0
2022-07-04 22:00:00	ES	Futures	4360.96	4361.81	4348.78	4350.48	7526.0
2022-07-04 23:00:00	ES	Futures	4350.48	4355.58	4346.23	4346.8	5423.0
2022-07-04 00:00:00	NQ	Futures	13344.04	13347.23	13315.99	13333.34	2222.0
2022-07-04 01:00:00	NQ	Futures	13333.92	13361.98	13325.24	13360.24	3315.0
2022-07-04 02:00:00	NQ	Futures	13358.51	13393.79	13348.67	13372.1	4265.0
2022-07-04 03:00:00	NQ	Futures	13372.1	13384.83	13320.04	13329.29	5878.0
2022-07-04 04:00:00	NQ	Futures	13328.42	13351.85	13324.66	13342.02	3642.0
2022-07-04 05:00:00	NQ	Futures	13341.73	13397.55	13330.45	13385.4	4974.0
2022-07-04 06:00:00	NQ	Futures	13385.4	13397.55	13364.29	13385.4	2991.0
2022-07-04 07:00:00	NQ	Futures	13384.54	13394.66	13364.29	13380.2	3575.0
2022-07-04 08:00:00	NQ	Futures	13378.46	13391.19	13368.63	13379.04	2920.0
2022-07-04 09:00:00	NQ	Futures	13379.04	13396.11	13355.9	13361.11	5701.0
2022-07-04 10:00:00	NQ	Futures	13361.11	13365.45	13340.57	13357.64	6638.0
2022-07-04 11:00:00	NQ	Futures	13357.06	13385.4	13356.48	13366.31	5153.0
2022-07-04 12:00:00	NQ	Futures	13366.89	13391.19	13363.42	13367.47	3121.0
2022-07-04 18:00:00	NQ	Futures	13370.07	13489.24	13370.07	13481.43	6431.0
2022-07-04 19:00:00	NQ	Futures	13481.43	13593.08	13478.54	13532.34	9496.0
2022-07-04 20:00:00	NQ	Futures	13531.18	13556.63	13521.64	13534.94	4309.0
2022-07-04 21:00:00	NQ	Futures	13533.21	13541.88	13494.45	13532.05	5890.0
2022-07-04 22:00:00	NQ	Futures	13532.05	13536.68	13478.25	13485.77	5201.0
2022-07-04 23:00:00	NQ	Futures	13485.48	13506.6	13479.7	13482.88	3518.0
2022-07-04 00:00:00	YM	Futures	34860.2	34866.9	34812.8	34850.0	619.0
2022-07-04 01:00:00	YM	Futures	34852.3	34901.9	34834.2	34898.5	907.0
2022-07-04 02:00:00	YM	Futures	34895.2	34965.1	34872.6	34906.4	1343.0
2022-07-04 03:00:00	YM	Futures	34906.4	34932.4	34807.1	34838.7	2473.0
2022-07-04 04:00:00	YM	Futures	34834.2	34862.4	34808.3	34825.2	1840.0
2022-07-04 05:00:00	YM	Futures	34824.1	34976.4	34806.0	34961.7	2246.0
2022-07-04 06:00:00	YM	Futures	34962.9	34985.4	34909.8	34977.5	1008.0
2022-07-04 07:00:00	YM	Futures	34977.5	35017.0	34948.2	34988.8	1502.0
2022-07-04 08:00:00	YM	Futures	34985.4	35032.8	34975.3	35022.7	1210.0
2022-07-04 09:00:00	YM	Futures	35022.7	35052.0	34934.6	34947.1	2372.0
2022-07-04 10:00:00	YM	Futures	34947.1	34953.8	34888.4	34918.8	2822.0
2022-07-04 11:00:00	YM	Futures	34918.8	34966.2	34896.3	34915.5	1979.0

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

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