PREVIEW / futures_1hour / 2022-03-21

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-03-21.parquet
  size:    68 KB
  rows:    2,037

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-21 00:00:00	ES	Futures	5037.58	5038.43	5031.06	5033.61	3999.0
2022-03-21 01:00:00	ES	Futures	5033.61	5034.18	5023.41	5028.8	8575.0
2022-03-21 02:00:00	ES	Futures	5029.08	5039.0	5029.08	5035.88	6355.0
2022-03-21 03:00:00	ES	Futures	5035.6	5039.0	5025.11	5033.9	12014.0
2022-03-21 04:00:00	ES	Futures	5033.9	5047.22	5033.33	5040.98	16417.0
2022-03-21 05:00:00	ES	Futures	5040.98	5048.35	5032.76	5042.97	12684.0
2022-03-21 06:00:00	ES	Futures	5043.25	5043.82	5035.32	5040.98	11970.0
2022-03-21 07:00:00	ES	Futures	5041.27	5055.72	5040.42	5050.05	19761.0
2022-03-21 08:00:00	ES	Futures	5050.05	5051.75	5042.68	5046.94	22341.0
2022-03-21 09:00:00	ES	Futures	5046.65	5071.31	5041.27	5042.4	152761.0
2022-03-21 10:00:00	ES	Futures	5042.68	5056.01	5028.8	5053.46	173522.0
2022-03-21 11:00:00	ES	Futures	5053.74	5063.38	5047.22	5059.97	131905.0
2022-03-21 12:00:00	ES	Futures	5060.26	5064.51	5022.56	5024.83	152279.0
2022-03-21 13:00:00	ES	Futures	5024.83	5027.95	5005.55	5026.53	152523.0
2022-03-21 14:00:00	ES	Futures	5026.53	5043.54	5017.46	5019.16	138374.0
2022-03-21 15:00:00	ES	Futures	5018.88	5049.2	5017.46	5048.64	205664.0
2022-03-21 16:00:00	ES	Futures	5048.64	5057.42	5045.8	5054.87	57549.0
2022-03-21 18:00:00	ES	Futures	5052.89	5053.74	5046.65	5047.5	4333.0
2022-03-21 19:00:00	ES	Futures	5047.22	5047.79	5039.85	5040.13	4681.0
2022-03-21 20:00:00	ES	Futures	5039.85	5039.85	5030.78	5031.06	9146.0
2022-03-21 21:00:00	ES	Futures	5031.35	5035.03	5025.96	5032.2	10142.0
2022-03-21 22:00:00	ES	Futures	5032.48	5041.83	5029.93	5037.58	8903.0
2022-03-21 23:00:00	ES	Futures	5037.87	5040.98	5033.05	5036.17	5748.0
2022-03-21 00:00:00	NQ	Futures	16669.8	16671.83	16645.73	16656.46	1867.0
2022-03-21 01:00:00	NQ	Futures	16654.72	16657.33	16594.69	16619.63	4661.0
2022-03-21 02:00:00	NQ	Futures	16621.08	16653.85	16609.77	16641.67	3219.0
2022-03-21 03:00:00	NQ	Futures	16640.8	16665.74	16600.78	16641.67	5483.0
2022-03-21 04:00:00	NQ	Futures	16642.83	16675.88	16631.52	16643.41	8658.0
2022-03-21 05:00:00	NQ	Futures	16643.99	16684.29	16612.38	16664.29	6780.0
2022-03-21 06:00:00	NQ	Futures	16664.29	16676.75	16641.96	16661.97	5041.0
2022-03-21 07:00:00	NQ	Futures	16661.97	16735.62	16660.52	16703.72	9607.0
2022-03-21 08:00:00	NQ	Futures	16704.3	16709.52	16657.04	16665.45	10196.0
2022-03-21 09:00:00	NQ	Futures	16664.0	16779.99	16578.16	16589.76	74258.0
2022-03-21 10:00:00	NQ	Futures	16590.05	16655.01	16503.06	16638.19	84872.0
2022-03-21 11:00:00	NQ	Futures	16638.77	16766.07	16612.67	16749.83	70129.0
2022-03-21 12:00:00	NQ	Futures	16750.41	16760.27	16523.07	16532.35	79294.0
2022-03-21 13:00:00	NQ	Futures	16532.64	16551.78	16451.73	16543.37	60037.0
2022-03-21 14:00:00	NQ	Futures	16542.21	16636.16	16503.93	16531.77	53809.0
2022-03-21 15:00:00	NQ	Futures	16530.61	16673.57	16519.3	16670.96	65333.0
2022-03-21 16:00:00	NQ	Futures	16670.38	16701.4	16664.0	16696.47	13609.0
2022-03-21 18:00:00	NQ	Futures	16690.96	16692.12	16661.68	16666.9	2619.0
2022-03-21 19:00:00	NQ	Futures	16665.74	16669.51	16634.13	16634.71	2588.0
2022-03-21 20:00:00	NQ	Futures	16633.84	16639.06	16599.62	16599.62	4394.0
2022-03-21 21:00:00	NQ	Futures	16600.2	16615.86	16579.03	16602.52	5282.0
2022-03-21 22:00:00	NQ	Futures	16602.81	16641.96	16590.92	16618.47	4552.0
2022-03-21 23:00:00	NQ	Futures	16619.34	16629.49	16601.94	16614.99	3015.0
2022-03-21 00:00:00	YM	Futures	38930.1	38932.4	38888.4	38896.3	629.0
2022-03-21 01:00:00	YM	Futures	38904.2	38912.1	38852.3	38883.9	1679.0
2022-03-21 02:00:00	YM	Futures	38886.1	38967.3	38886.1	38947.0	1922.0
2022-03-21 03:00:00	YM	Futures	38944.8	38970.7	38874.9	38924.5	3013.0

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

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