PREVIEW / futures_1hour / 2021-04-09

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-04-09.parquet
  size:    51 KB
  rows:    1,539

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
2021-04-09 00:00:00	ES	Futures	4602.56	4604.53	4601.43	4603.12	3798.0
2021-04-09 01:00:00	ES	Futures	4602.84	4603.96	4593.29	4596.38	11916.0
2021-04-09 02:00:00	ES	Futures	4596.1	4599.75	4594.97	4597.5	10926.0
2021-04-09 03:00:00	ES	Futures	4597.5	4603.96	4594.13	4603.12	17309.0
2021-04-09 04:00:00	ES	Futures	4602.84	4603.12	4596.1	4601.15	10593.0
2021-04-09 05:00:00	ES	Futures	4601.15	4601.43	4597.5	4600.87	8385.0
2021-04-09 06:00:00	ES	Futures	4600.87	4601.43	4596.38	4598.62	10979.0
2021-04-09 07:00:00	ES	Futures	4598.34	4606.21	4598.06	4602.28	14272.0
2021-04-09 08:00:00	ES	Futures	4602.28	4602.56	4589.35	4590.48	41258.0
2021-04-09 09:00:00	ES	Futures	4590.2	4602.28	4586.54	4602.0	147441.0
2021-04-09 10:00:00	ES	Futures	4602.0	4603.96	4594.41	4597.22	138959.0
2021-04-09 11:00:00	ES	Futures	4596.94	4606.77	4596.1	4605.37	90266.0
2021-04-09 12:00:00	ES	Futures	4605.65	4607.34	4602.84	4606.49	56461.0
2021-04-09 13:00:00	ES	Futures	4606.77	4612.39	4604.81	4610.71	55870.0
2021-04-09 14:00:00	ES	Futures	4610.71	4612.11	4608.18	4609.58	54553.0
2021-04-09 15:00:00	ES	Futures	4609.3	4632.06	4607.05	4629.53	247665.0
2021-04-09 16:00:00	ES	Futures	4629.25	4630.94	4619.7	4623.63	59042.0
2021-04-09 00:00:00	NQ	Futures	15975.8	15979.56	15968.85	15972.03	1804.0
2021-04-09 01:00:00	NQ	Futures	15972.61	15975.8	15890.11	15914.13	10547.0
2021-04-09 02:00:00	NQ	Futures	15914.13	15920.21	15878.53	15889.24	7619.0
2021-04-09 03:00:00	NQ	Futures	15888.95	15921.37	15872.16	15912.98	9803.0
2021-04-09 04:00:00	NQ	Futures	15912.11	15918.77	15887.79	15910.08	6696.0
2021-04-09 05:00:00	NQ	Futures	15910.08	15911.53	15884.9	15901.11	3934.0
2021-04-09 06:00:00	NQ	Futures	15901.4	15910.08	15874.18	15899.66	6574.0
2021-04-09 07:00:00	NQ	Futures	15898.79	15927.74	15890.69	15895.32	7655.0
2021-04-09 08:00:00	NQ	Futures	15895.61	15897.92	15804.42	15824.68	24272.0
2021-04-09 09:00:00	NQ	Futures	15824.1	15896.76	15805.57	15887.79	79372.0
2021-04-09 10:00:00	NQ	Futures	15888.08	15918.77	15867.53	15876.21	74306.0
2021-04-09 11:00:00	NQ	Futures	15876.21	15946.56	15858.26	15941.06	58557.0
2021-04-09 12:00:00	NQ	Futures	15941.06	15955.24	15923.4	15948.58	35559.0
2021-04-09 13:00:00	NQ	Futures	15948.3	15968.27	15937.87	15959.01	28100.0
2021-04-09 14:00:00	NQ	Futures	15958.72	15970.01	15938.74	15947.14	27982.0
2021-04-09 15:00:00	NQ	Futures	15947.43	16026.17	15929.48	16014.01	64435.0
2021-04-09 16:00:00	NQ	Futures	16014.3	16024.14	15983.03	15992.88	11828.0
2021-04-09 00:00:00	YM	Futures	37204.9	37226.0	37193.7	37216.0	1090.0
2021-04-09 01:00:00	YM	Futures	37217.1	37222.7	37179.3	37198.2	2477.0
2021-04-09 02:00:00	YM	Futures	37197.1	37238.3	37196.0	37232.7	2486.0
2021-04-09 03:00:00	YM	Futures	37233.8	37268.4	37207.1	37263.9	3296.0
2021-04-09 04:00:00	YM	Futures	37262.8	37267.2	37212.7	37259.5	2638.0
2021-04-09 05:00:00	YM	Futures	37259.5	37280.6	37240.5	37275.0	2479.0
2021-04-09 06:00:00	YM	Futures	37275.0	37281.7	37249.4	37252.8	2879.0
2021-04-09 07:00:00	YM	Futures	37251.7	37302.9	37249.4	37294.0	3937.0
2021-04-09 08:00:00	YM	Futures	37295.1	37298.4	37229.4	37229.4	4969.0
2021-04-09 09:00:00	YM	Futures	37229.4	37353.0	37209.3	37294.0	23273.0
2021-04-09 10:00:00	YM	Futures	37294.0	37304.0	37226.0	37276.2	17388.0
2021-04-09 11:00:00	YM	Futures	37276.2	37312.9	37267.2	37276.2	9763.0
2021-04-09 12:00:00	YM	Futures	37276.2	37311.8	37261.7	37295.1	9598.0
2021-04-09 13:00:00	YM	Futures	37295.1	37351.9	37280.6	37337.4	6270.0
2021-04-09 14:00:00	YM	Futures	37338.5	37366.4	37322.9	37348.6	6821.0
2021-04-09 15:00:00	YM	Futures	37347.4	37529.0	37340.8	37507.8	17768.0

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

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