PREVIEW / futures_1hour / 2023-03-09

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-03-09.parquet
  size:    68 KB
  rows:    2,027

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-09 00:00:00	ES	Futures	4462.52	4465.88	4461.96	4464.2	5113.0
2023-03-09 01:00:00	ES	Futures	4464.48	4466.44	4463.08	4465.32	5556.0
2023-03-09 02:00:00	ES	Futures	4465.04	4465.32	4459.72	4461.4	10639.0
2023-03-09 03:00:00	ES	Futures	4461.4	4463.08	4455.53	4458.61	23771.0
2023-03-09 04:00:00	ES	Futures	4458.61	4458.61	4450.22	4451.06	20242.0
2023-03-09 05:00:00	ES	Futures	4451.06	4457.21	4449.94	4457.21	16114.0
2023-03-09 06:00:00	ES	Futures	4457.21	4461.68	4456.09	4460.56	13645.0
2023-03-09 07:00:00	ES	Futures	4460.56	4461.12	4452.18	4455.53	19269.0
2023-03-09 08:00:00	ES	Futures	4455.25	4476.22	4451.34	4475.66	82181.0
2023-03-09 09:00:00	ES	Futures	4475.38	4495.79	4472.03	4487.69	255280.0
2023-03-09 10:00:00	ES	Futures	4487.69	4493.56	4472.31	4478.46	266453.0
2023-03-09 11:00:00	ES	Futures	4478.46	4479.58	4468.11	4468.39	187996.0
2023-03-09 12:00:00	ES	Futures	4468.67	4471.19	4453.01	4455.53	206883.0
2023-03-09 13:00:00	ES	Futures	4455.53	4459.17	4420.02	4424.77	279682.0
2023-03-09 14:00:00	ES	Futures	4424.77	4427.57	4404.08	4404.92	280924.0
2023-03-09 15:00:00	ES	Futures	4404.92	4408.0	4372.49	4384.51	496652.0
2023-03-09 16:00:00	ES	Futures	4384.51	4388.98	4376.68	4383.11	86304.0
2023-03-09 18:00:00	ES	Futures	4383.11	4383.39	4368.57	4375.28	18585.0
2023-03-09 19:00:00	ES	Futures	4375.0	4376.96	4366.06	4367.45	20743.0
2023-03-09 20:00:00	ES	Futures	4367.45	4370.81	4362.14	4365.78	19136.0
2023-03-09 21:00:00	ES	Futures	4365.78	4367.73	4353.47	4362.7	39095.0
2023-03-09 22:00:00	ES	Futures	4362.42	4362.98	4354.87	4355.15	12655.0
2023-03-09 23:00:00	ES	Futures	4355.15	4356.27	4347.32	4349.56	16908.0
2023-03-09 00:00:00	NQ	Futures	13888.15	13904.36	13884.45	13896.97	2647.0
2023-03-09 01:00:00	NQ	Futures	13897.25	13903.79	13891.85	13893.84	2302.0
2023-03-09 02:00:00	NQ	Futures	13894.12	13894.12	13867.95	13876.48	4648.0
2023-03-09 03:00:00	NQ	Futures	13876.77	13881.6	13841.49	13858.56	11539.0
2023-03-09 04:00:00	NQ	Futures	13858.27	13858.56	13816.45	13823.85	11430.0
2023-03-09 05:00:00	NQ	Futures	13823.57	13838.64	13810.76	13834.95	7880.0
2023-03-09 06:00:00	NQ	Futures	13834.95	13857.14	13831.82	13855.15	6407.0
2023-03-09 07:00:00	NQ	Futures	13855.71	13858.84	13831.82	13845.19	9244.0
2023-03-09 08:00:00	NQ	Futures	13844.33	13949.6	13828.4	13945.61	34626.0
2023-03-09 09:00:00	NQ	Futures	13946.18	14042.06	13917.45	14027.55	98161.0
2023-03-09 10:00:00	NQ	Futures	14027.55	14057.99	13976.91	13998.81	106868.0
2023-03-09 11:00:00	NQ	Futures	13998.81	14015.03	13975.2	13980.32	61219.0
2023-03-09 12:00:00	NQ	Futures	13980.61	13987.15	13902.66	13920.58	73654.0
2023-03-09 13:00:00	NQ	Futures	13921.15	13933.38	13770.65	13786.58	93639.0
2023-03-09 14:00:00	NQ	Futures	13787.15	13796.54	13732.81	13739.36	86234.0
2023-03-09 15:00:00	NQ	Futures	13739.64	13749.6	13630.11	13663.11	144311.0
2023-03-09 16:00:00	NQ	Futures	13663.4	13681.32	13644.62	13666.24	19643.0
2023-03-09 18:00:00	NQ	Futures	13661.4	13661.97	13605.36	13640.07	7101.0
2023-03-09 19:00:00	NQ	Futures	13639.5	13647.18	13610.2	13615.32	6181.0
2023-03-09 20:00:00	NQ	Futures	13615.32	13638.36	13590.85	13617.59	7521.0
2023-03-09 21:00:00	NQ	Futures	13617.59	13624.42	13571.5	13609.63	9217.0
2023-03-09 22:00:00	NQ	Futures	13609.34	13618.73	13585.44	13589.71	3971.0
2023-03-09 23:00:00	NQ	Futures	13590.0	13594.83	13573.5	13584.31	4184.0
2023-03-09 00:00:00	YM	Futures	36531.8	36548.5	36526.2	36536.2	542.0
2023-03-09 01:00:00	YM	Futures	36538.5	36551.8	36527.3	36548.5	637.0
2023-03-09 02:00:00	YM	Futures	36548.5	36549.6	36519.5	36527.3	1759.0
2023-03-09 03:00:00	YM	Futures	36529.6	36549.6	36499.5	36518.4	2348.0

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

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