PREVIEW / futures_1hour / 2022-07-21

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-07-21.parquet
  size:    70 KB
  rows:    2,050

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-21 00:00:00	ES	Futures	4483.05	4489.85	4479.37	4486.74	5408.0
2022-07-21 01:00:00	ES	Futures	4486.45	4503.73	4484.47	4499.77	10727.0
2022-07-21 02:00:00	ES	Futures	4500.33	4502.32	4487.59	4489.0	12552.0
2022-07-21 03:00:00	ES	Futures	4489.29	4495.8	4478.81	4480.51	16973.0
2022-07-21 04:00:00	ES	Futures	4480.79	4482.2	4470.59	4479.66	17608.0
2022-07-21 05:00:00	ES	Futures	4479.94	4485.32	4475.69	4484.75	10360.0
2022-07-21 06:00:00	ES	Futures	4485.04	4491.27	4479.37	4482.2	11775.0
2022-07-21 07:00:00	ES	Futures	4482.2	4486.45	4475.69	4481.07	16997.0
2022-07-21 08:00:00	ES	Futures	4480.79	4508.55	4472.86	4499.48	65988.0
2022-07-21 09:00:00	ES	Futures	4499.48	4500.33	4466.06	4490.42	240371.0
2022-07-21 10:00:00	ES	Futures	4490.7	4500.33	4453.31	4484.75	327437.0
2022-07-21 11:00:00	ES	Futures	4484.75	4502.88	4479.37	4497.22	216739.0
2022-07-21 12:00:00	ES	Futures	4497.22	4522.15	4495.8	4518.46	157071.0
2022-07-21 13:00:00	ES	Futures	4518.46	4521.58	4499.48	4508.83	185056.0
2022-07-21 14:00:00	ES	Futures	4508.83	4519.31	4506.0	4513.93	153242.0
2022-07-21 15:00:00	ES	Futures	4514.21	4535.74	4513.36	4535.46	210549.0
2022-07-21 16:00:00	ES	Futures	4535.18	4537.73	4516.76	4522.43	74173.0
2022-07-21 18:00:00	ES	Futures	4518.75	4521.01	4512.8	4516.76	8097.0
2022-07-21 19:00:00	ES	Futures	4516.76	4518.75	4513.65	4514.5	3751.0
2022-07-21 20:00:00	ES	Futures	4514.5	4518.18	4510.25	4517.61	6219.0
2022-07-21 21:00:00	ES	Futures	4517.61	4523.0	4511.1	4518.75	6163.0
2022-07-21 22:00:00	ES	Futures	4519.03	4520.16	4511.95	4513.65	4935.0
2022-07-21 23:00:00	ES	Futures	4513.65	4517.33	4512.23	4517.05	2478.0
2022-07-21 00:00:00	NQ	Futures	14383.57	14413.07	14373.16	14397.74	3577.0
2022-07-21 01:00:00	NQ	Futures	14397.16	14448.94	14387.91	14441.71	5881.0
2022-07-21 02:00:00	NQ	Futures	14444.02	14451.54	14389.64	14396.3	7580.0
2022-07-21 03:00:00	NQ	Futures	14395.43	14431.0	14365.64	14391.38	10351.0
2022-07-21 04:00:00	NQ	Futures	14391.96	14397.16	14352.04	14388.77	9885.0
2022-07-21 05:00:00	NQ	Futures	14388.77	14428.69	14380.1	14426.67	6008.0
2022-07-21 06:00:00	NQ	Futures	14426.09	14460.8	14417.41	14424.06	8015.0
2022-07-21 07:00:00	NQ	Futures	14424.35	14436.5	14407.86	14428.4	8351.0
2022-07-21 08:00:00	NQ	Futures	14427.24	14531.95	14394.85	14492.9	32894.0
2022-07-21 09:00:00	NQ	Futures	14492.61	14496.08	14356.96	14458.48	92308.0
2022-07-21 10:00:00	NQ	Futures	14459.06	14509.68	14315.6	14435.92	99308.0
2022-07-21 11:00:00	NQ	Futures	14435.05	14513.44	14421.46	14493.48	57375.0
2022-07-21 12:00:00	NQ	Futures	14494.06	14601.94	14490.88	14585.46	55979.0
2022-07-21 13:00:00	NQ	Futures	14585.75	14599.92	14515.17	14553.35	46832.0
2022-07-21 14:00:00	NQ	Futures	14553.35	14597.61	14545.25	14580.83	37944.0
2022-07-21 15:00:00	NQ	Futures	14581.12	14630.87	14569.84	14629.71	59225.0
2022-07-21 16:00:00	NQ	Futures	14629.71	14641.57	14514.59	14545.83	31679.0
2022-07-21 18:00:00	NQ	Futures	14530.5	14536.58	14504.18	14524.14	4838.0
2022-07-21 19:00:00	NQ	Futures	14524.14	14532.24	14511.99	14517.2	3192.0
2022-07-21 20:00:00	NQ	Futures	14517.49	14525.01	14495.5	14522.69	3629.0
2022-07-21 21:00:00	NQ	Futures	14522.98	14542.94	14503.02	14529.35	3334.0
2022-07-21 22:00:00	NQ	Futures	14528.48	14532.53	14497.82	14509.39	3020.0
2022-07-21 23:00:00	NQ	Futures	14509.39	14520.96	14499.26	14518.06	1864.0
2022-07-21 00:00:00	YM	Futures	35897.1	35947.9	35874.6	35924.2	968.0
2022-07-21 01:00:00	YM	Futures	35923.1	36044.9	35909.5	36017.9	2207.0
2022-07-21 02:00:00	YM	Futures	36021.2	36042.7	35938.9	35949.0	2537.0
2022-07-21 03:00:00	YM	Futures	35950.2	35995.3	35856.5	35862.1	3901.0

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

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