PREVIEW / futures_1hour / 2022-04-05

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-04-05.parquet
  size:    69 KB
  rows:    2,043

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-04-05 00:00:00	ES	Futures	5183.84	5186.39	5183.84	5185.54	1997.0
2022-04-05 01:00:00	ES	Futures	5185.54	5188.66	5185.26	5188.09	2620.0
2022-04-05 02:00:00	ES	Futures	5188.09	5190.07	5182.7	5184.97	6773.0
2022-04-05 03:00:00	ES	Futures	5184.97	5200.84	5183.55	5195.18	18620.0
2022-04-05 04:00:00	ES	Futures	5195.46	5197.73	5188.09	5188.94	7875.0
2022-04-05 05:00:00	ES	Futures	5188.94	5190.07	5178.45	5180.15	9832.0
2022-04-05 06:00:00	ES	Futures	5179.87	5182.99	5173.35	5179.02	14437.0
2022-04-05 07:00:00	ES	Futures	5178.74	5183.27	5174.48	5181.57	11787.0
2022-04-05 08:00:00	ES	Futures	5181.85	5184.4	5173.63	5174.77	19039.0
2022-04-05 09:00:00	ES	Futures	5174.77	5195.46	5170.23	5191.77	141969.0
2022-04-05 10:00:00	ES	Futures	5191.77	5202.54	5155.78	5170.8	273532.0
2022-04-05 11:00:00	ES	Futures	5170.52	5172.78	5152.38	5152.66	134905.0
2022-04-05 12:00:00	ES	Futures	5152.66	5157.19	5143.02	5153.23	109173.0
2022-04-05 13:00:00	ES	Futures	5152.94	5165.98	5140.76	5146.99	95680.0
2022-04-05 14:00:00	ES	Futures	5146.99	5152.38	5139.62	5141.32	93116.0
2022-04-05 15:00:00	ES	Futures	5141.04	5144.16	5110.71	5126.02	264601.0
2022-04-05 16:00:00	ES	Futures	5126.02	5131.97	5125.73	5131.68	47700.0
2022-04-05 18:00:00	ES	Futures	5131.68	5131.97	5126.02	5129.7	4871.0
2022-04-05 19:00:00	ES	Futures	5129.98	5131.4	5127.15	5128.0	3250.0
2022-04-05 20:00:00	ES	Futures	5128.28	5131.12	5116.1	5116.1	11394.0
2022-04-05 21:00:00	ES	Futures	5116.1	5123.47	5114.11	5115.81	10230.0
2022-04-05 22:00:00	ES	Futures	5115.81	5120.91	5115.25	5120.35	6692.0
2022-04-05 23:00:00	ES	Futures	5120.06	5122.33	5116.1	5118.36	4278.0
2022-04-05 00:00:00	NQ	Futures	17569.88	17584.09	17569.88	17576.26	1263.0
2022-04-05 01:00:00	NQ	Futures	17575.97	17589.6	17575.1	17584.67	1170.0
2022-04-05 02:00:00	NQ	Futures	17585.83	17594.82	17558.28	17573.07	3492.0
2022-04-05 03:00:00	NQ	Futures	17572.78	17628.16	17566.11	17615.4	10018.0
2022-04-05 04:00:00	NQ	Futures	17614.53	17620.62	17584.96	17588.15	4916.0
2022-04-05 05:00:00	NQ	Futures	17587.57	17591.92	17547.84	17558.57	5131.0
2022-04-05 06:00:00	NQ	Futures	17558.57	17567.56	17526.67	17552.19	7073.0
2022-04-05 07:00:00	NQ	Futures	17551.9	17566.69	17532.47	17559.15	5702.0
2022-04-05 08:00:00	NQ	Futures	17559.44	17570.46	17515.07	17520.0	10415.0
2022-04-05 09:00:00	NQ	Futures	17520.0	17556.54	17459.11	17479.7	70976.0
2022-04-05 10:00:00	NQ	Futures	17479.99	17515.36	17297.59	17359.36	121005.0
2022-04-05 11:00:00	NQ	Futures	17358.49	17373.27	17269.17	17272.94	67730.0
2022-04-05 12:00:00	NQ	Futures	17272.65	17298.46	17224.52	17274.1	51340.0
2022-04-05 13:00:00	NQ	Futures	17273.81	17329.78	17221.33	17250.62	46518.0
2022-04-05 14:00:00	NQ	Futures	17250.62	17292.95	17234.38	17247.72	43501.0
2022-04-05 15:00:00	NQ	Futures	17248.3	17262.5	17143.61	17202.19	84065.0
2022-04-05 16:00:00	NQ	Futures	17202.77	17238.44	17202.19	17237.86	11626.0
2022-04-05 18:00:00	NQ	Futures	17237.28	17237.57	17205.09	17217.56	2893.0
2022-04-05 19:00:00	NQ	Futures	17217.56	17222.2	17202.77	17206.83	2066.0
2022-04-05 20:00:00	NQ	Futures	17207.7	17217.85	17145.64	17150.57	5128.0
2022-04-05 21:00:00	NQ	Futures	17149.99	17174.64	17135.79	17151.73	4812.0
2022-04-05 22:00:00	NQ	Futures	17151.44	17174.64	17148.25	17164.78	2729.0
2022-04-05 23:00:00	NQ	Futures	17165.36	17177.54	17148.83	17158.98	2343.0
2022-04-05 00:00:00	YM	Futures	39210.8	39227.7	39208.6	39223.2	623.0
2022-04-05 01:00:00	YM	Futures	39223.2	39240.1	39216.5	39235.6	535.0
2022-04-05 02:00:00	YM	Futures	39237.9	39255.9	39204.1	39219.8	1355.0
2022-04-05 03:00:00	YM	Futures	39221.0	39325.8	39215.3	39302.1	5129.0

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

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