PREVIEW / futures_1hour / 2023-01-26

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-01-26.parquet
  size:    67 KB
  rows:    2,068

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-01-26 00:00:00	ES	Futures	4514.81	4522.08	4514.25	4520.4	5794.0
2023-01-26 01:00:00	ES	Futures	4520.4	4527.39	4519.0	4524.03	12235.0
2023-01-26 02:00:00	ES	Futures	4524.03	4524.03	4518.44	4520.96	10587.0
2023-01-26 03:00:00	ES	Futures	4520.96	4528.79	4519.56	4520.12	15326.0
2023-01-26 04:00:00	ES	Futures	4520.12	4525.43	4512.01	4513.41	14247.0
2023-01-26 05:00:00	ES	Futures	4513.41	4521.8	4513.13	4519.28	9133.0
2023-01-26 06:00:00	ES	Futures	4519.28	4521.8	4515.93	4518.16	11318.0
2023-01-26 07:00:00	ES	Futures	4518.16	4539.41	4517.6	4532.98	28397.0
2023-01-26 08:00:00	ES	Futures	4532.98	4538.29	4515.09	4535.22	57569.0
2023-01-26 09:00:00	ES	Futures	4535.5	4550.04	4513.13	4521.24	235695.0
2023-01-26 10:00:00	ES	Futures	4521.52	4540.81	4504.18	4507.82	291096.0
2023-01-26 11:00:00	ES	Futures	4507.82	4524.31	4504.74	4523.2	194560.0
2023-01-26 12:00:00	ES	Futures	4523.47	4536.06	4522.64	4528.51	136003.0
2023-01-26 13:00:00	ES	Futures	4528.79	4543.89	4522.08	4536.9	121167.0
2023-01-26 14:00:00	ES	Futures	4536.9	4545.84	4532.42	4543.33	111757.0
2023-01-26 15:00:00	ES	Futures	4543.33	4559.82	4539.41	4557.31	217569.0
2023-01-26 16:00:00	ES	Futures	4557.31	4559.26	4548.64	4549.48	54925.0
2023-01-26 18:00:00	ES	Futures	4546.4	4547.8	4543.05	4543.89	7842.0
2023-01-26 19:00:00	ES	Futures	4543.61	4548.64	4542.49	4545.56	5042.0
2023-01-26 20:00:00	ES	Futures	4545.56	4548.64	4543.33	4543.89	5755.0
2023-01-26 21:00:00	ES	Futures	4543.89	4547.52	4543.89	4545.84	3770.0
2023-01-26 22:00:00	ES	Futures	4545.84	4546.96	4542.21	4543.05	3222.0
2023-01-26 23:00:00	ES	Futures	4543.05	4546.4	4542.21	4545.0	3138.0
2023-01-26 00:00:00	NQ	Futures	13560.12	13586.58	13556.14	13581.75	3921.0
2023-01-26 01:00:00	NQ	Futures	13582.32	13606.5	13574.35	13587.72	5901.0
2023-01-26 02:00:00	NQ	Futures	13588.29	13593.7	13568.66	13583.45	5675.0
2023-01-26 03:00:00	NQ	Futures	13584.02	13613.61	13577.48	13583.45	8716.0
2023-01-26 04:00:00	NQ	Futures	13583.74	13610.76	13559.56	13562.97	8910.0
2023-01-26 05:00:00	NQ	Futures	13562.69	13597.11	13560.98	13589.71	5920.0
2023-01-26 06:00:00	NQ	Futures	13590.0	13605.64	13582.03	13594.83	6422.0
2023-01-26 07:00:00	NQ	Futures	13593.7	13658.56	13592.27	13647.75	14500.0
2023-01-26 08:00:00	NQ	Futures	13648.03	13667.09	13576.06	13652.59	30909.0
2023-01-26 09:00:00	NQ	Futures	13652.3	13741.06	13595.4	13627.55	113523.0
2023-01-26 10:00:00	NQ	Futures	13628.4	13710.91	13549.88	13564.96	97852.0
2023-01-26 11:00:00	NQ	Futures	13564.96	13628.69	13546.75	13621.86	65330.0
2023-01-26 12:00:00	NQ	Futures	13622.14	13675.35	13618.45	13653.72	51086.0
2023-01-26 13:00:00	NQ	Futures	13653.72	13708.92	13621.58	13687.01	39131.0
2023-01-26 14:00:00	NQ	Futures	13687.29	13727.98	13670.51	13719.44	38810.0
2023-01-26 15:00:00	NQ	Futures	13720.58	13782.31	13702.37	13775.2	72098.0
2023-01-26 16:00:00	NQ	Futures	13774.92	13784.31	13719.16	13724.56	19317.0
2023-01-26 18:00:00	NQ	Futures	13711.48	13714.61	13694.98	13700.67	4446.0
2023-01-26 19:00:00	NQ	Futures	13700.67	13723.14	13698.67	13710.91	3410.0
2023-01-26 20:00:00	NQ	Futures	13710.91	13722.0	13694.41	13697.25	3097.0
2023-01-26 21:00:00	NQ	Futures	13697.25	13711.48	13696.97	13705.79	1533.0
2023-01-26 22:00:00	NQ	Futures	13706.35	13710.05	13685.3	13686.72	2083.0
2023-01-26 23:00:00	NQ	Futures	13686.72	13698.39	13684.45	13693.27	1786.0
2023-01-26 00:00:00	YM	Futures	37690.5	37739.6	37686.1	37724.0	1012.0
2023-01-26 01:00:00	YM	Futures	37724.0	37771.9	37717.3	37750.7	1924.0
2023-01-26 02:00:00	YM	Futures	37749.6	37750.7	37711.7	37717.3	1755.0
2023-01-26 03:00:00	YM	Futures	37718.4	37785.2	37706.1	37708.4	2560.0

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

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