PREVIEW / futures_1hour / 2021-04-08

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-04-08.parquet
  size:    61 KB
  rows:    1,909

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-08 00:00:00	ES	Futures	4594.13	4594.97	4593.29	4594.13	3179.0
2021-04-08 01:00:00	ES	Futures	4594.41	4599.75	4593.57	4598.91	8626.0
2021-04-08 02:00:00	ES	Futures	4598.91	4599.47	4593.01	4593.01	11505.0
2021-04-08 03:00:00	ES	Futures	4593.29	4594.41	4589.35	4589.63	16061.0
2021-04-08 04:00:00	ES	Futures	4589.35	4592.16	4585.42	4588.23	11422.0
2021-04-08 05:00:00	ES	Futures	4587.95	4590.2	4584.01	4588.51	9760.0
2021-04-08 06:00:00	ES	Futures	4588.51	4591.88	4587.39	4587.39	11242.0
2021-04-08 07:00:00	ES	Futures	4587.67	4591.6	4587.39	4589.91	9274.0
2021-04-08 08:00:00	ES	Futures	4589.91	4591.6	4584.86	4587.11	21849.0
2021-04-08 09:00:00	ES	Futures	4587.11	4589.91	4580.08	4586.54	151112.0
2021-04-08 10:00:00	ES	Futures	4586.54	4589.07	4577.55	4584.86	188467.0
2021-04-08 11:00:00	ES	Futures	4585.14	4590.48	4583.45	4588.51	98403.0
2021-04-08 12:00:00	ES	Futures	4588.51	4593.85	4587.39	4589.63	69982.0
2021-04-08 13:00:00	ES	Futures	4589.91	4592.72	4587.95	4590.48	51419.0
2021-04-08 14:00:00	ES	Futures	4590.48	4595.25	4589.35	4594.69	46052.0
2021-04-08 15:00:00	ES	Futures	4594.97	4596.66	4590.76	4595.82	139387.0
2021-04-08 16:00:00	ES	Futures	4595.82	4606.21	4594.69	4605.65	65070.0
2021-04-08 18:00:00	ES	Futures	4605.65	4605.65	4602.0	4604.53	5295.0
2021-04-08 19:00:00	ES	Futures	4604.53	4607.62	4603.12	4607.34	5476.0
2021-04-08 20:00:00	ES	Futures	4607.34	4610.71	4605.93	4609.86	18601.0
2021-04-08 21:00:00	ES	Futures	4609.86	4610.71	4602.0	4602.0	12293.0
2021-04-08 22:00:00	ES	Futures	4602.0	4602.28	4598.91	4599.75	8641.0
2021-04-08 23:00:00	ES	Futures	4599.75	4603.12	4598.34	4602.56	4519.0
2021-04-08 00:00:00	NQ	Futures	15865.5	15873.32	15864.05	15869.84	1951.0
2021-04-08 01:00:00	NQ	Futures	15870.13	15903.13	15865.5	15896.76	4631.0
2021-04-08 02:00:00	NQ	Futures	15897.34	15906.32	15880.26	15883.16	4780.0
2021-04-08 03:00:00	NQ	Futures	15883.45	15885.19	15864.92	15868.68	5611.0
2021-04-08 04:00:00	NQ	Futures	15867.82	15879.4	15853.34	15868.68	4671.0
2021-04-08 05:00:00	NQ	Futures	15868.97	15882.0	15845.81	15879.97	5000.0
2021-04-08 06:00:00	NQ	Futures	15880.26	15915.0	15880.26	15890.69	7520.0
2021-04-08 07:00:00	NQ	Futures	15890.69	15900.82	15876.79	15887.5	6189.0
2021-04-08 08:00:00	NQ	Futures	15887.79	15898.5	15868.1	15882.29	11217.0
2021-04-08 09:00:00	NQ	Futures	15881.71	15926.58	15866.66	15921.95	73281.0
2021-04-08 10:00:00	NQ	Futures	15921.95	15928.03	15854.5	15887.21	88447.0
2021-04-08 11:00:00	NQ	Futures	15887.21	15907.19	15860.0	15901.69	50502.0
2021-04-08 12:00:00	NQ	Futures	15901.69	15918.48	15879.68	15893.0	32876.0
2021-04-08 13:00:00	NQ	Futures	15893.29	15909.21	15883.74	15899.66	25646.0
2021-04-08 14:00:00	NQ	Futures	15899.66	15922.53	15895.61	15904.87	25595.0
2021-04-08 15:00:00	NQ	Futures	15904.87	15924.85	15894.74	15921.95	44094.0
2021-04-08 16:00:00	NQ	Futures	15922.24	15968.27	15918.48	15967.11	14162.0
2021-04-08 18:00:00	NQ	Futures	15964.51	15968.85	15949.45	15963.06	2795.0
2021-04-08 19:00:00	NQ	Futures	15962.48	15983.03	15959.59	15982.75	3125.0
2021-04-08 20:00:00	NQ	Futures	15982.75	16022.12	15977.53	16021.54	8330.0
2021-04-08 21:00:00	NQ	Futures	16020.96	16028.49	15989.98	15991.43	5779.0
2021-04-08 22:00:00	NQ	Futures	15990.85	15992.59	15965.66	15968.56	5188.0
2021-04-08 23:00:00	NQ	Futures	15968.27	15977.82	15958.72	15976.38	2877.0
2021-04-08 00:00:00	YM	Futures	37183.7	37189.3	37170.3	37178.1	712.0
2021-04-08 01:00:00	YM	Futures	37178.1	37227.2	37173.7	37220.5	2386.0
2021-04-08 02:00:00	YM	Futures	37221.6	37224.9	37175.9	37177.0	2132.0
2021-04-08 03:00:00	YM	Futures	37177.0	37199.3	37148.1	37153.6	3628.0

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

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