PREVIEW / futures_1hour / 2023-04-06

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-04-06.parquet
  size:    61 KB
  rows:    1,836

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-06 00:00:00	ES	Futures	4556.08	4557.75	4555.53	4556.08	3352.0
2023-04-06 01:00:00	ES	Futures	4556.08	4558.03	4554.42	4557.47	6308.0
2023-04-06 02:00:00	ES	Futures	4557.47	4564.96	4556.64	4563.02	10121.0
2023-04-06 03:00:00	ES	Futures	4563.3	4569.4	4561.35	4566.9	15827.0
2023-04-06 04:00:00	ES	Futures	4566.9	4568.84	4564.68	4567.46	11342.0
2023-04-06 05:00:00	ES	Futures	4567.18	4568.29	4561.91	4562.46	13820.0
2023-04-06 06:00:00	ES	Futures	4562.74	4567.46	4557.19	4567.18	17734.0
2023-04-06 07:00:00	ES	Futures	4567.18	4574.11	4566.62	4573.83	19538.0
2023-04-06 08:00:00	ES	Futures	4573.83	4574.67	4559.69	4560.24	41982.0
2023-04-06 09:00:00	ES	Futures	4560.24	4561.35	4544.71	4549.98	169411.0
2023-04-06 10:00:00	ES	Futures	4549.98	4563.02	4549.15	4553.31	231566.0
2023-04-06 11:00:00	ES	Futures	4553.59	4572.45	4550.54	4572.17	148236.0
2023-04-06 12:00:00	ES	Futures	4572.17	4583.82	4572.17	4578.0	124985.0
2023-04-06 13:00:00	ES	Futures	4577.72	4584.93	4575.78	4580.77	93683.0
2023-04-06 14:00:00	ES	Futures	4581.05	4587.7	4579.38	4581.6	96377.0
2023-04-06 15:00:00	ES	Futures	4581.6	4585.21	4576.61	4584.65	161590.0
2023-04-06 16:00:00	ES	Futures	4584.37	4584.93	4582.43	4582.71	60182.0
2023-04-06 18:00:00	ES	Futures	4580.77	4583.26	4579.94	4581.6	3418.0
2023-04-06 19:00:00	ES	Futures	4581.6	4581.6	4579.1	4579.94	2294.0
2023-04-06 20:00:00	ES	Futures	4579.66	4581.05	4578.27	4579.38	2968.0
2023-04-06 21:00:00	ES	Futures	4579.38	4580.49	4577.44	4578.0	2078.0
2023-04-06 22:00:00	ES	Futures	4577.72	4580.77	4577.72	4579.38	1699.0
2023-04-06 23:00:00	ES	Futures	4579.38	4580.77	4579.38	4580.21	1051.0
2023-04-06 00:00:00	NQ	Futures	14669.76	14675.95	14666.38	14670.88	2294.0
2023-04-06 01:00:00	NQ	Futures	14670.88	14674.26	14661.31	14673.98	3458.0
2023-04-06 02:00:00	NQ	Futures	14673.7	14703.82	14670.04	14699.6	5015.0
2023-04-06 03:00:00	NQ	Futures	14699.88	14730.57	14693.69	14714.24	10427.0
2023-04-06 04:00:00	NQ	Futures	14713.68	14720.72	14692.84	14699.88	7110.0
2023-04-06 05:00:00	NQ	Futures	14699.6	14704.67	14645.54	14652.3	10346.0
2023-04-06 06:00:00	NQ	Futures	14652.02	14693.69	14624.15	14693.69	13473.0
2023-04-06 07:00:00	NQ	Futures	14693.13	14718.18	14688.06	14716.78	9683.0
2023-04-06 08:00:00	NQ	Futures	14716.49	14720.72	14657.65	14663.28	23499.0
2023-04-06 09:00:00	NQ	Futures	14663.0	14669.48	14588.11	14624.43	78923.0
2023-04-06 10:00:00	NQ	Futures	14624.71	14701.57	14620.2	14666.94	105079.0
2023-04-06 11:00:00	NQ	Futures	14667.5	14784.91	14660.18	14780.41	80754.0
2023-04-06 12:00:00	NQ	Futures	14780.69	14822.08	14780.69	14786.6	59834.0
2023-04-06 13:00:00	NQ	Futures	14786.88	14836.15	14777.31	14833.34	43604.0
2023-04-06 14:00:00	NQ	Futures	14833.62	14855.86	14825.46	14830.24	41354.0
2023-04-06 15:00:00	NQ	Futures	14830.52	14850.23	14813.91	14833.62	62540.0
2023-04-06 16:00:00	NQ	Futures	14833.9	14834.47	14820.11	14824.89	13595.0
2023-04-06 18:00:00	NQ	Futures	14824.05	14824.05	14798.43	14815.6	1630.0
2023-04-06 19:00:00	NQ	Futures	14815.6	14822.36	14811.66	14820.67	1578.0
2023-04-06 20:00:00	NQ	Futures	14820.39	14831.93	14813.91	14819.54	2847.0
2023-04-06 21:00:00	NQ	Futures	14818.98	14822.36	14811.66	14813.35	1504.0
2023-04-06 22:00:00	NQ	Futures	14813.35	14826.02	14812.5	14819.54	1215.0
2023-04-06 23:00:00	NQ	Futures	14819.82	14822.64	14816.73	14820.95	742.0
2023-04-06 00:00:00	YM	Futures	37136.2	37152.7	37132.8	37142.8	744.0
2023-04-06 01:00:00	YM	Futures	37142.8	37151.6	37128.4	37150.5	862.0
2023-04-06 02:00:00	YM	Futures	37150.5	37203.6	37149.4	37189.2	1739.0
2023-04-06 03:00:00	YM	Futures	37190.3	37231.2	37181.5	37214.6	2675.0

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

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