PREVIEW / futures_1hour / 2021-09-14

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-09-14.parquet
  size:    63 KB
  rows:    1,937

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-09-14 00:00:00	ES	Futures	5043.98	5044.83	5041.72	5043.7	2401.0
2021-09-14 01:00:00	ES	Futures	5043.7	5046.8	5042.29	5042.85	7385.0
2021-09-14 02:00:00	ES	Futures	5042.85	5043.42	5033.26	5033.54	14670.0
2021-09-14 03:00:00	ES	Futures	5033.54	5037.77	5026.49	5034.95	35349.0
2021-09-14 04:00:00	ES	Futures	5034.95	5043.7	5031.85	5040.88	33338.0
2021-09-14 05:00:00	ES	Futures	5040.88	5043.42	5036.08	5036.36	13600.0
2021-09-14 06:00:00	ES	Futures	5036.08	5041.44	5034.67	5038.34	8824.0
2021-09-14 07:00:00	ES	Futures	5038.62	5038.62	5025.07	5028.46	19938.0
2021-09-14 08:00:00	ES	Futures	5028.74	5056.68	5026.49	5048.22	78629.0
2021-09-14 09:00:00	ES	Futures	5048.22	5054.14	5027.33	5028.46	193949.0
2021-09-14 10:00:00	ES	Futures	5028.46	5029.02	5011.25	5015.48	270198.0
2021-09-14 11:00:00	ES	Futures	5015.48	5027.61	5015.2	5027.33	133846.0
2021-09-14 12:00:00	ES	Futures	5027.33	5030.44	5012.37	5014.35	114199.0
2021-09-14 13:00:00	ES	Futures	5014.07	5018.3	5005.04	5015.76	123020.0
2021-09-14 14:00:00	ES	Futures	5016.04	5017.17	4995.44	5005.32	154414.0
2021-09-14 15:00:00	ES	Futures	5005.6	5008.14	4996.01	5007.29	256220.0
2021-09-14 16:00:00	ES	Futures	5007.29	5010.68	5005.04	5008.99	47855.0
2021-09-14 18:00:00	ES	Futures	5008.71	5011.81	5007.58	5010.4	5680.0
2021-09-14 19:00:00	ES	Futures	5010.4	5013.79	5009.27	5013.5	4249.0
2021-09-14 20:00:00	ES	Futures	5013.5	5017.74	5010.96	5012.37	9333.0
2021-09-14 21:00:00	ES	Futures	5012.09	5015.2	5006.73	5007.86	9012.0
2021-09-14 22:00:00	ES	Futures	5007.86	5011.81	5002.5	5008.99	10660.0
2021-09-14 23:00:00	ES	Futures	5008.99	5014.07	5008.42	5012.66	5856.0
2021-09-14 00:00:00	NQ	Futures	17914.18	17917.66	17907.8	17911.86	1087.0
2021-09-14 01:00:00	NQ	Futures	17911.28	17921.71	17906.35	17908.96	2211.0
2021-09-14 02:00:00	NQ	Futures	17908.96	17910.41	17879.69	17879.98	4961.0
2021-09-14 03:00:00	NQ	Futures	17880.56	17888.96	17842.59	17871.57	8837.0
2021-09-14 04:00:00	NQ	Futures	17871.57	17902.59	17866.07	17892.73	6129.0
2021-09-14 05:00:00	NQ	Futures	17893.02	17900.85	17878.82	17879.4	2932.0
2021-09-14 06:00:00	NQ	Futures	17879.11	17899.4	17871.57	17887.8	2644.0
2021-09-14 07:00:00	NQ	Futures	17887.8	17892.15	17847.23	17855.06	6322.0
2021-09-14 08:00:00	NQ	Futures	17855.92	17966.34	17846.65	17948.38	25692.0
2021-09-14 09:00:00	NQ	Futures	17947.8	17996.78	17884.62	17890.12	75694.0
2021-09-14 10:00:00	NQ	Futures	17889.83	17908.96	17836.8	17864.62	79270.0
2021-09-14 11:00:00	NQ	Futures	17864.62	17942.0	17864.04	17941.13	41720.0
2021-09-14 12:00:00	NQ	Futures	17941.13	17956.2	17871.28	17879.4	36003.0
2021-09-14 13:00:00	NQ	Futures	17879.11	17890.41	17837.09	17877.66	39107.0
2021-09-14 14:00:00	NQ	Futures	17878.24	17886.07	17793.32	17835.35	50931.0
2021-09-14 15:00:00	NQ	Futures	17835.64	17841.14	17788.4	17832.74	61745.0
2021-09-14 16:00:00	NQ	Futures	17832.74	17854.48	17829.26	17839.12	8210.0
2021-09-14 18:00:00	NQ	Futures	17841.14	17850.42	17833.61	17848.1	2328.0
2021-09-14 19:00:00	NQ	Futures	17848.1	17861.43	17844.33	17860.85	1975.0
2021-09-14 20:00:00	NQ	Futures	17861.43	17871.28	17851.29	17854.77	3516.0
2021-09-14 21:00:00	NQ	Futures	17855.63	17862.01	17827.23	17832.74	3441.0
2021-09-14 22:00:00	NQ	Futures	17833.32	17847.81	17817.09	17837.38	4210.0
2021-09-14 23:00:00	NQ	Futures	17837.67	17854.48	17836.22	17851.58	2855.0
2021-09-14 00:00:00	YM	Futures	39039.0	39043.4	39022.1	39037.8	408.0
2021-09-14 01:00:00	YM	Futures	39036.7	39055.8	39022.1	39034.5	1220.0
2021-09-14 02:00:00	YM	Futures	39031.1	39033.4	38950.4	38956.0	2568.0
2021-09-14 03:00:00	YM	Futures	38957.1	39003.1	38903.3	38985.2	4041.0

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

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