PREVIEW / futures_1hour / 2022-03-31

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-03-31.parquet
  size:    69 KB
  rows:    2,074

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-03-31 00:00:00	ES	Futures	5221.82	5222.67	5219.83	5221.82	2567.0
2022-03-31 01:00:00	ES	Futures	5222.1	5222.39	5215.87	5220.4	7393.0
2022-03-31 02:00:00	ES	Futures	5220.4	5222.39	5215.3	5221.25	6883.0
2022-03-31 03:00:00	ES	Futures	5221.54	5229.47	5219.83	5222.95	13991.0
2022-03-31 04:00:00	ES	Futures	5222.67	5222.67	5215.3	5218.98	11432.0
2022-03-31 05:00:00	ES	Futures	5219.27	5220.4	5215.58	5216.72	7414.0
2022-03-31 06:00:00	ES	Futures	5217.0	5219.55	5212.75	5213.32	12131.0
2022-03-31 07:00:00	ES	Futures	5213.03	5214.73	5204.53	5213.03	15404.0
2022-03-31 08:00:00	ES	Futures	5212.75	5218.7	5208.21	5211.9	17202.0
2022-03-31 09:00:00	ES	Futures	5211.9	5215.3	5193.76	5202.83	130063.0
2022-03-31 10:00:00	ES	Futures	5202.83	5212.18	5186.96	5208.78	180662.0
2022-03-31 11:00:00	ES	Futures	5209.06	5210.76	5195.18	5202.83	107713.0
2022-03-31 12:00:00	ES	Futures	5202.54	5204.81	5187.52	5188.66	86202.0
2022-03-31 13:00:00	ES	Futures	5188.66	5197.73	5183.84	5191.49	86413.0
2022-03-31 14:00:00	ES	Futures	5191.21	5192.06	5179.02	5187.52	107650.0
2022-03-31 15:00:00	ES	Futures	5187.52	5196.59	5131.68	5133.39	537229.0
2022-03-31 16:00:00	ES	Futures	5133.39	5151.81	5133.1	5148.41	155234.0
2022-03-31 18:00:00	ES	Futures	5148.41	5152.09	5143.87	5148.69	7892.0
2022-03-31 19:00:00	ES	Futures	5148.97	5153.23	5148.12	5150.11	4919.0
2022-03-31 20:00:00	ES	Futures	5150.11	5152.66	5143.31	5149.83	10750.0
2022-03-31 21:00:00	ES	Futures	5149.83	5152.94	5146.71	5149.54	7688.0
2022-03-31 22:00:00	ES	Futures	5149.54	5154.93	5148.41	5154.36	6063.0
2022-03-31 23:00:00	ES	Futures	5154.36	5157.76	5153.51	5154.36	4889.0
2022-03-31 00:00:00	NQ	Futures	17567.85	17571.33	17554.22	17564.37	1532.0
2022-03-31 01:00:00	NQ	Futures	17564.08	17567.56	17541.46	17556.25	3149.0
2022-03-31 02:00:00	NQ	Futures	17555.67	17566.4	17536.53	17558.28	3244.0
2022-03-31 03:00:00	NQ	Futures	17559.15	17608.15	17556.25	17578.87	8035.0
2022-03-31 04:00:00	NQ	Futures	17578.29	17582.93	17544.36	17564.95	5774.0
2022-03-31 05:00:00	NQ	Futures	17564.95	17567.85	17547.26	17555.09	2862.0
2022-03-31 06:00:00	NQ	Futures	17555.96	17563.5	17527.83	17529.86	5065.0
2022-03-31 07:00:00	NQ	Futures	17529.28	17539.43	17488.1	17531.6	8061.0
2022-03-31 08:00:00	NQ	Futures	17531.89	17555.38	17504.05	17522.32	11055.0
2022-03-31 09:00:00	NQ	Futures	17523.19	17531.89	17375.59	17429.53	70251.0
2022-03-31 10:00:00	NQ	Futures	17428.95	17508.98	17359.07	17487.24	87013.0
2022-03-31 11:00:00	NQ	Futures	17487.53	17492.16	17426.05	17452.15	51926.0
2022-03-31 12:00:00	NQ	Futures	17452.44	17460.56	17369.51	17376.46	45489.0
2022-03-31 13:00:00	NQ	Futures	17376.75	17435.04	17361.39	17400.53	43402.0
2022-03-31 14:00:00	NQ	Futures	17400.24	17431.85	17352.4	17428.95	46236.0
2022-03-31 15:00:00	NQ	Futures	17431.27	17473.61	17230.9	17247.72	109785.0
2022-03-31 16:00:00	NQ	Futures	17248.88	17310.06	17247.72	17302.52	28586.0
2022-03-31 18:00:00	NQ	Futures	17304.26	17309.19	17282.22	17298.75	2760.0
2022-03-31 19:00:00	NQ	Futures	17299.91	17307.74	17292.66	17296.43	2014.0
2022-03-31 20:00:00	NQ	Futures	17297.3	17310.64	17254.1	17281.64	4351.0
2022-03-31 21:00:00	NQ	Futures	17281.35	17297.3	17272.07	17288.6	3028.0
2022-03-31 22:00:00	NQ	Futures	17289.76	17308.61	17284.25	17307.74	2294.0
2022-03-31 23:00:00	NQ	Futures	17308.03	17327.46	17303.68	17309.77	2507.0
2022-03-31 00:00:00	YM	Futures	39623.4	39635.8	39615.5	39630.2	515.0
2022-03-31 01:00:00	YM	Futures	39632.4	39633.6	39591.9	39622.3	1309.0
2022-03-31 02:00:00	YM	Futures	39623.4	39635.8	39590.7	39629.1	1085.0
2022-03-31 03:00:00	YM	Futures	39631.3	39675.3	39618.9	39630.2	2535.0

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

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