PREVIEW / futures_1hour / 2023-04-13

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-04-13.parquet
  size:    67 KB
  rows:    2,041

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-04-13 00:00:00	ES	Futures	4573.0	4574.67	4572.17	4574.39	3227.0
2023-04-13 01:00:00	ES	Futures	4574.39	4575.78	4571.34	4573.56	4786.0
2023-04-13 02:00:00	ES	Futures	4573.56	4581.32	4572.45	4579.94	10130.0
2023-04-13 03:00:00	ES	Futures	4579.94	4583.54	4577.72	4578.83	21152.0
2023-04-13 04:00:00	ES	Futures	4578.55	4582.99	4573.83	4575.5	13525.0
2023-04-13 05:00:00	ES	Futures	4575.22	4583.82	4573.83	4578.83	11889.0
2023-04-13 06:00:00	ES	Futures	4578.83	4579.1	4571.34	4574.11	12268.0
2023-04-13 07:00:00	ES	Futures	4574.11	4577.16	4569.12	4569.67	13614.0
2023-04-13 08:00:00	ES	Futures	4569.95	4590.48	4568.29	4585.76	54818.0
2023-04-13 09:00:00	ES	Futures	4585.76	4587.98	4575.78	4580.77	172073.0
2023-04-13 10:00:00	ES	Futures	4580.77	4600.74	4578.55	4593.25	229842.0
2023-04-13 11:00:00	ES	Futures	4593.53	4602.68	4593.53	4601.29	126401.0
2023-04-13 12:00:00	ES	Futures	4601.29	4608.5	4601.29	4607.39	101954.0
2023-04-13 13:00:00	ES	Futures	4607.67	4622.09	4603.23	4620.71	124757.0
2023-04-13 14:00:00	ES	Futures	4620.98	4632.08	4619.6	4630.97	143124.0
2023-04-13 15:00:00	ES	Futures	4631.25	4634.02	4626.25	4629.86	219815.0
2023-04-13 16:00:00	ES	Futures	4629.86	4629.86	4624.04	4624.87	76581.0
2023-04-13 18:00:00	ES	Futures	4624.87	4628.47	4622.93	4627.09	6634.0
2023-04-13 19:00:00	ES	Futures	4627.36	4628.47	4624.59	4626.53	4948.0
2023-04-13 20:00:00	ES	Futures	4626.81	4632.36	4624.87	4630.41	8966.0
2023-04-13 21:00:00	ES	Futures	4630.69	4630.97	4625.7	4627.36	6764.0
2023-04-13 22:00:00	ES	Futures	4627.36	4628.75	4625.7	4626.25	4587.0
2023-04-13 23:00:00	ES	Futures	4626.25	4629.58	4625.7	4627.92	4206.0
2023-04-13 00:00:00	NQ	Futures	14610.35	14615.42	14606.97	14611.19	1646.0
2023-04-13 01:00:00	NQ	Futures	14610.91	14620.2	14598.81	14605.84	3280.0
2023-04-13 02:00:00	NQ	Futures	14606.13	14651.46	14603.03	14644.7	7012.0
2023-04-13 03:00:00	NQ	Futures	14644.14	14648.64	14621.33	14626.68	7485.0
2023-04-13 04:00:00	NQ	Futures	14627.24	14641.04	14603.03	14612.6	6955.0
2023-04-13 05:00:00	NQ	Futures	14612.32	14661.31	14607.53	14636.53	8335.0
2023-04-13 06:00:00	NQ	Futures	14636.25	14638.5	14609.79	14619.36	5836.0
2023-04-13 07:00:00	NQ	Futures	14619.08	14639.35	14598.52	14601.34	7704.0
2023-04-13 08:00:00	NQ	Futures	14601.9	14683.55	14592.61	14668.91	24702.0
2023-04-13 09:00:00	NQ	Futures	14668.91	14731.7	14644.42	14716.49	87505.0
2023-04-13 10:00:00	NQ	Futures	14716.49	14796.46	14702.14	14764.08	100128.0
2023-04-13 11:00:00	NQ	Futures	14764.08	14802.65	14764.08	14797.58	51847.0
2023-04-13 12:00:00	NQ	Futures	14797.86	14819.26	14791.95	14807.44	40530.0
2023-04-13 13:00:00	NQ	Futures	14807.44	14860.93	14787.73	14856.99	45193.0
2023-04-13 14:00:00	NQ	Futures	14857.27	14886.27	14850.23	14873.6	45657.0
2023-04-13 15:00:00	NQ	Futures	14873.88	14897.53	14863.47	14877.82	66450.0
2023-04-13 16:00:00	NQ	Futures	14877.54	14878.11	14842.91	14844.04	15669.0
2023-04-13 18:00:00	NQ	Futures	14846.85	14865.72	14839.81	14859.81	4118.0
2023-04-13 19:00:00	NQ	Futures	14859.24	14864.31	14846.57	14856.71	2426.0
2023-04-13 20:00:00	NQ	Futures	14856.71	14883.17	14846.85	14873.88	4850.0
2023-04-13 21:00:00	NQ	Futures	14874.16	14874.16	14854.74	14862.62	3464.0
2023-04-13 22:00:00	NQ	Futures	14862.34	14865.44	14853.89	14855.58	1930.0
2023-04-13 23:00:00	NQ	Futures	14855.86	14870.5	14852.77	14864.03	2204.0
2023-04-13 00:00:00	YM	Futures	37363.8	37380.4	37360.5	37380.4	956.0
2023-04-13 01:00:00	YM	Futures	37380.4	37388.2	37363.8	37374.9	1049.0
2023-04-13 02:00:00	YM	Futures	37376.0	37409.2	37368.3	37407.0	2261.0
2023-04-13 03:00:00	YM	Futures	37405.8	37444.5	37390.4	37414.7	2959.0

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

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