PREVIEW / futures_1hour / 2021-01-04

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-01-04.parquet
  size:    66 KB
  rows:    1,983

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-01-04 00:00:00	ES	Futures	4208.31	4209.43	4204.66	4209.15	4921.0
2021-01-04 01:00:00	ES	Futures	4209.15	4212.8	4208.03	4211.96	6957.0
2021-01-04 02:00:00	ES	Futures	4211.96	4227.4	4211.96	4226.56	16308.0
2021-01-04 03:00:00	ES	Futures	4226.56	4228.52	4220.66	4224.59	27948.0
2021-01-04 04:00:00	ES	Futures	4224.31	4236.1	4224.03	4233.57	19146.0
2021-01-04 05:00:00	ES	Futures	4233.29	4235.54	4229.08	4230.2	9832.0
2021-01-04 06:00:00	ES	Futures	4230.2	4233.29	4228.8	4229.64	7308.0
2021-01-04 07:00:00	ES	Futures	4229.64	4230.2	4224.59	4229.64	13584.0
2021-01-04 08:00:00	ES	Futures	4229.08	4229.92	4222.35	4223.47	20937.0
2021-01-04 09:00:00	ES	Futures	4223.47	4225.43	4194.84	4199.33	234502.0
2021-01-04 10:00:00	ES	Futures	4199.33	4201.86	4156.95	4159.48	293154.0
2021-01-04 11:00:00	ES	Futures	4159.48	4164.53	4121.59	4124.67	319063.0
2021-01-04 12:00:00	ES	Futures	4124.67	4128.04	4100.54	4116.81	256750.0
2021-01-04 13:00:00	ES	Futures	4116.81	4143.48	4114.29	4142.64	134196.0
2021-01-04 14:00:00	ES	Futures	4142.64	4143.2	4120.46	4135.9	169845.0
2021-01-04 15:00:00	ES	Futures	4135.9	4153.02	4125.52	4146.57	308975.0
2021-01-04 16:00:00	ES	Futures	4146.85	4152.18	4140.67	4149.37	61982.0
2021-01-04 18:00:00	ES	Futures	4148.25	4149.09	4138.71	4146.28	10518.0
2021-01-04 19:00:00	ES	Futures	4146.28	4153.58	4145.16	4152.18	11050.0
2021-01-04 20:00:00	ES	Futures	4152.46	4159.48	4152.18	4154.99	11377.0
2021-01-04 21:00:00	ES	Futures	4154.7	4158.91	4154.42	4156.95	5384.0
2021-01-04 22:00:00	ES	Futures	4156.95	4159.48	4141.79	4145.44	13459.0
2021-01-04 23:00:00	ES	Futures	4145.44	4146.57	4137.86	4143.2	8553.0
2021-01-04 00:00:00	NQ	Futures	14905.26	14906.13	14886.16	14897.73	2859.0
2021-01-04 01:00:00	NQ	Futures	14898.02	14929.28	14897.73	14924.07	4147.0
2021-01-04 02:00:00	NQ	Futures	14924.07	14972.99	14924.07	14972.41	9836.0
2021-01-04 03:00:00	NQ	Futures	14972.12	14996.14	14960.83	14972.12	9648.0
2021-01-04 04:00:00	NQ	Futures	14972.12	15003.96	14970.09	14991.22	5746.0
2021-01-04 05:00:00	NQ	Futures	14991.22	14996.72	14972.12	14980.8	4670.0
2021-01-04 06:00:00	NQ	Futures	14980.8	14992.09	14977.62	14981.67	4153.0
2021-01-04 07:00:00	NQ	Futures	14981.38	14996.14	14974.43	14995.56	5781.0
2021-01-04 08:00:00	NQ	Futures	14995.56	14997.01	14978.77	14982.54	8899.0
2021-01-04 09:00:00	NQ	Futures	14982.83	14985.43	14886.45	14911.92	72989.0
2021-01-04 10:00:00	NQ	Futures	14911.63	14924.36	14773.86	14774.72	102592.0
2021-01-04 11:00:00	NQ	Futures	14775.01	14798.46	14628.27	14628.85	108540.0
2021-01-04 12:00:00	NQ	Futures	14629.72	14645.35	14497.74	14583.7	94990.0
2021-01-04 13:00:00	NQ	Futures	14583.41	14676.61	14570.09	14672.26	48529.0
2021-01-04 14:00:00	NQ	Futures	14671.97	14675.74	14594.7	14661.84	51898.0
2021-01-04 15:00:00	NQ	Futures	14661.56	14713.07	14623.06	14689.34	66033.0
2021-01-04 16:00:00	NQ	Futures	14689.34	14700.63	14668.79	14689.63	10414.0
2021-01-04 18:00:00	NQ	Futures	14683.26	14690.5	14657.79	14674.87	4609.0
2021-01-04 19:00:00	NQ	Futures	14675.16	14700.63	14670.53	14696.0	3548.0
2021-01-04 20:00:00	NQ	Futures	14696.58	14729.28	14694.84	14718.57	4843.0
2021-01-04 21:00:00	NQ	Futures	14718.86	14731.89	14714.52	14725.52	2774.0
2021-01-04 22:00:00	NQ	Futures	14725.81	14735.07	14677.76	14690.5	6075.0
2021-01-04 23:00:00	NQ	Futures	14690.21	14695.42	14659.24	14676.32	4320.0
2021-01-04 00:00:00	YM	Futures	33824.9	33837.1	33797.2	33834.9	1130.0
2021-01-04 01:00:00	YM	Futures	33832.7	33863.7	33826.0	33849.3	1735.0
2021-01-04 02:00:00	YM	Futures	33850.4	33971.3	33850.4	33965.8	4484.0
2021-01-04 03:00:00	YM	Futures	33964.7	33979.1	33904.8	33939.2	5535.0

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

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