PREVIEW / futures_1hour / 2023-03-20

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-03-20.parquet
  size:    71 KB
  rows:    2,078

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
2023-03-20 00:00:00	ES	Futures	4384.4	4386.07	4374.97	4379.41	10574.0
2023-03-20 01:00:00	ES	Futures	4379.41	4383.57	4375.25	4376.91	9795.0
2023-03-20 02:00:00	ES	Futures	4376.91	4378.02	4328.65	4337.81	42156.0
2023-03-20 03:00:00	ES	Futures	4338.08	4351.4	4332.81	4349.18	39640.0
2023-03-20 04:00:00	ES	Futures	4349.46	4360.83	4323.66	4358.89	71807.0
2023-03-20 05:00:00	ES	Futures	4359.16	4379.13	4354.45	4376.36	49634.0
2023-03-20 06:00:00	ES	Futures	4376.08	4387.18	4369.43	4384.13	41297.0
2023-03-20 07:00:00	ES	Futures	4384.13	4386.9	4368.04	4377.47	34526.0
2023-03-20 08:00:00	ES	Futures	4377.47	4399.66	4369.43	4393.0	49621.0
2023-03-20 09:00:00	ES	Futures	4393.0	4402.15	4378.58	4397.44	224822.0
2023-03-20 10:00:00	ES	Futures	4397.16	4414.36	4388.56	4412.97	243600.0
2023-03-20 11:00:00	ES	Futures	4412.97	4426.01	4405.2	4406.31	170575.0
2023-03-20 12:00:00	ES	Futures	4406.59	4415.19	4386.62	4411.31	177494.0
2023-03-20 13:00:00	ES	Futures	4411.58	4422.12	4409.92	4412.97	109578.0
2023-03-20 14:00:00	ES	Futures	4412.97	4417.13	4400.77	4409.64	117477.0
2023-03-20 15:00:00	ES	Futures	4409.36	4425.45	4404.09	4420.46	190854.0
2023-03-20 16:00:00	ES	Futures	4420.18	4424.62	4418.52	4423.79	39967.0
2023-03-20 18:00:00	ES	Futures	4422.68	4425.45	4419.63	4422.95	5499.0
2023-03-20 19:00:00	ES	Futures	4422.95	4422.95	4417.68	4420.74	4883.0
2023-03-20 20:00:00	ES	Futures	4420.74	4435.44	4417.41	4425.73	20121.0
2023-03-20 21:00:00	ES	Futures	4426.01	4428.78	4419.35	4427.11	12121.0
2023-03-20 22:00:00	ES	Futures	4427.11	4430.44	4425.45	4427.67	5422.0
2023-03-20 23:00:00	ES	Futures	4427.67	4427.67	4423.51	4424.62	3510.0
2023-03-20 00:00:00	NQ	Futures	14266.01	14278.96	14230.53	14253.34	5565.0
2023-03-20 01:00:00	NQ	Futures	14254.47	14266.57	14241.51	14250.24	4151.0
2023-03-20 02:00:00	NQ	Futures	14249.4	14255.59	14113.97	14157.89	16737.0
2023-03-20 03:00:00	NQ	Futures	14158.17	14196.47	14136.21	14180.7	15708.0
2023-03-20 04:00:00	NQ	Futures	14180.42	14211.67	14106.09	14210.26	29065.0
2023-03-20 05:00:00	NQ	Futures	14210.26	14261.5	14193.37	14251.09	16227.0
2023-03-20 06:00:00	NQ	Futures	14249.96	14283.75	14232.5	14253.06	12432.0
2023-03-20 07:00:00	NQ	Futures	14252.78	14263.19	14205.48	14233.35	12552.0
2023-03-20 08:00:00	NQ	Futures	14233.07	14289.94	14208.01	14271.08	20824.0
2023-03-20 09:00:00	NQ	Futures	14271.36	14273.61	14110.87	14150.85	93633.0
2023-03-20 10:00:00	NQ	Futures	14150.29	14247.99	14139.31	14240.39	94604.0
2023-03-20 11:00:00	NQ	Futures	14240.67	14300.08	14206.04	14208.85	78635.0
2023-03-20 12:00:00	NQ	Futures	14209.42	14244.33	14151.14	14231.66	70287.0
2023-03-20 13:00:00	NQ	Futures	14231.66	14272.77	14227.16	14259.25	45454.0
2023-03-20 14:00:00	NQ	Futures	14258.69	14288.82	14228.0	14260.1	48640.0
2023-03-20 15:00:00	NQ	Futures	14259.82	14311.9	14239.83	14295.01	63907.0
2023-03-20 16:00:00	NQ	Futures	14294.73	14308.24	14287.41	14304.02	11057.0
2023-03-20 18:00:00	NQ	Futures	14302.61	14305.15	14286.28	14299.51	2321.0
2023-03-20 19:00:00	NQ	Futures	14299.23	14300.64	14282.06	14294.45	2257.0
2023-03-20 20:00:00	NQ	Futures	14294.17	14345.41	14283.75	14307.4	7159.0
2023-03-20 21:00:00	NQ	Futures	14307.96	14309.93	14276.43	14298.67	5485.0
2023-03-20 22:00:00	NQ	Futures	14298.11	14314.72	14296.42	14304.3	3125.0
2023-03-20 23:00:00	NQ	Futures	14303.46	14307.68	14290.5	14298.11	1814.0
2023-03-20 00:00:00	YM	Futures	35447.2	35452.8	35386.4	35405.2	2127.0
2023-03-20 01:00:00	YM	Futures	35405.2	35438.4	35374.3	35379.8	2489.0
2023-03-20 02:00:00	YM	Futures	35380.9	35392.0	34990.7	35036.1	8365.0
2023-03-20 03:00:00	YM	Futures	35039.4	35159.9	35005.1	35142.2	6991.0

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

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