PREVIEW / futures_1hour / 2023-02-01

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-02-01.parquet
  size:    70 KB
  rows:    2,114

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-02-01 00:00:00	ES	Futures	4562.9	4564.58	4560.94	4563.18	4516.0
2023-02-01 01:00:00	ES	Futures	4562.9	4564.3	4561.22	4562.62	4945.0
2023-02-01 02:00:00	ES	Futures	4562.62	4566.25	4561.22	4564.86	7624.0
2023-02-01 03:00:00	ES	Futures	4564.86	4568.21	4558.71	4560.66	21480.0
2023-02-01 04:00:00	ES	Futures	4560.66	4561.5	4555.91	4557.31	14035.0
2023-02-01 05:00:00	ES	Futures	4557.31	4559.54	4553.11	4555.35	14783.0
2023-02-01 06:00:00	ES	Futures	4555.35	4560.94	4554.23	4560.66	13480.0
2023-02-01 07:00:00	ES	Futures	4560.66	4568.49	4558.98	4566.53	29041.0
2023-02-01 08:00:00	ES	Futures	4566.53	4569.05	4557.03	4558.43	41354.0
2023-02-01 09:00:00	ES	Futures	4558.71	4574.08	4555.91	4572.13	161886.0
2023-02-01 10:00:00	ES	Futures	4572.13	4574.08	4546.4	4548.64	206033.0
2023-02-01 11:00:00	ES	Futures	4548.64	4564.3	4546.12	4553.39	128304.0
2023-02-01 12:00:00	ES	Futures	4553.39	4554.51	4544.17	4548.64	91453.0
2023-02-01 13:00:00	ES	Futures	4548.36	4563.18	4546.4	4555.35	86649.0
2023-02-01 14:00:00	ES	Futures	4555.07	4617.98	4527.95	4605.12	472009.0
2023-02-01 15:00:00	ES	Futures	4605.12	4656.29	4604.84	4624.13	511855.0
2023-02-01 16:00:00	ES	Futures	4623.85	4638.11	4616.3	4633.08	85782.0
2023-02-01 18:00:00	ES	Futures	4636.44	4646.22	4636.16	4641.75	16647.0
2023-02-01 19:00:00	ES	Futures	4641.47	4642.31	4632.24	4638.39	15446.0
2023-02-01 20:00:00	ES	Futures	4638.67	4641.19	4629.73	4634.48	13843.0
2023-02-01 21:00:00	ES	Futures	4634.76	4635.6	4626.65	4628.89	9487.0
2023-02-01 22:00:00	ES	Futures	4629.17	4634.76	4627.77	4633.92	5719.0
2023-02-01 23:00:00	ES	Futures	4633.92	4640.35	4633.08	4638.39	7075.0
2023-02-01 00:00:00	NQ	Futures	13777.19	13785.44	13769.8	13780.32	2004.0
2023-02-01 01:00:00	NQ	Futures	13779.75	13787.72	13772.64	13784.31	2224.0
2023-02-01 02:00:00	NQ	Futures	13784.02	13803.94	13775.77	13799.38	4054.0
2023-02-01 03:00:00	NQ	Futures	13799.67	13824.14	13790.85	13800.81	8015.0
2023-02-01 04:00:00	NQ	Futures	13800.81	13809.91	13784.88	13789.43	6510.0
2023-02-01 05:00:00	NQ	Futures	13789.71	13799.95	13774.06	13781.75	5916.0
2023-02-01 06:00:00	NQ	Futures	13782.6	13806.5	13777.76	13805.64	6379.0
2023-02-01 07:00:00	NQ	Futures	13805.93	13847.75	13799.1	13831.25	13389.0
2023-02-01 08:00:00	NQ	Futures	13830.68	13836.65	13803.37	13809.63	19026.0
2023-02-01 09:00:00	NQ	Futures	13809.63	13835.52	13770.94	13825.84	61636.0
2023-02-01 10:00:00	NQ	Futures	13826.13	13833.24	13748.46	13755.0	63947.0
2023-02-01 11:00:00	NQ	Futures	13754.72	13819.01	13743.05	13793.98	38958.0
2023-02-01 12:00:00	NQ	Futures	13793.69	13806.21	13766.67	13795.4	25324.0
2023-02-01 13:00:00	NQ	Futures	13795.97	13839.5	13788.29	13814.18	25873.0
2023-02-01 14:00:00	NQ	Futures	13807.63	14095.26	13718.59	14042.06	168129.0
2023-02-01 15:00:00	NQ	Futures	14043.2	14243.2	14042.34	14134.52	149716.0
2023-02-01 16:00:00	NQ	Futures	14133.95	14252.58	14104.08	14230.68	35613.0
2023-02-01 18:00:00	NQ	Futures	14247.46	14292.7	14246.32	14275.63	10904.0
2023-02-01 19:00:00	NQ	Futures	14275.63	14277.62	14236.37	14265.67	7736.0
2023-02-01 20:00:00	NQ	Futures	14266.24	14273.35	14233.81	14251.16	7013.0
2023-02-01 21:00:00	NQ	Futures	14251.45	14256.57	14226.69	14235.8	4120.0
2023-02-01 22:00:00	NQ	Futures	14235.51	14259.7	14230.68	14252.3	2924.0
2023-02-01 23:00:00	NQ	Futures	14252.87	14275.91	14251.16	14270.22	3119.0
2023-02-01 00:00:00	YM	Futures	37974.7	37983.6	37964.6	37975.8	518.0
2023-02-01 01:00:00	YM	Futures	37975.8	37980.2	37957.9	37966.9	631.0
2023-02-01 02:00:00	YM	Futures	37965.7	37984.7	37955.7	37975.8	1141.0
2023-02-01 03:00:00	YM	Futures	37975.8	37990.3	37907.8	37926.7	2317.0

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

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