PREVIEW / futures_1hour / 2023-10-18

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-10-18.parquet
  size:    68 KB
  rows:    2,052

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-10-18 00:00:00	ES	Futures	4775.08	4776.71	4773.72	4774.27	3193.0
2023-10-18 01:00:00	ES	Futures	4774.27	4778.34	4771.82	4777.53	7971.0
2023-10-18 02:00:00	ES	Futures	4777.53	4778.07	4767.48	4767.48	10490.0
2023-10-18 03:00:00	ES	Futures	4767.75	4771.55	4763.13	4770.74	25647.0
2023-10-18 04:00:00	ES	Futures	4770.74	4776.17	4766.39	4773.72	18388.0
2023-10-18 05:00:00	ES	Futures	4774.0	4776.44	4763.68	4765.03	18064.0
2023-10-18 06:00:00	ES	Futures	4765.03	4767.21	4755.8	4759.06	29840.0
2023-10-18 07:00:00	ES	Futures	4759.33	4764.76	4758.25	4762.05	25556.0
2023-10-18 08:00:00	ES	Futures	4762.05	4767.21	4754.72	4756.07	48227.0
2023-10-18 09:00:00	ES	Futures	4756.34	4766.94	4753.09	4758.25	216070.0
2023-10-18 10:00:00	ES	Futures	4758.25	4771.28	4738.42	4742.5	347713.0
2023-10-18 11:00:00	ES	Futures	4742.5	4753.9	4738.97	4741.95	217665.0
2023-10-18 12:00:00	ES	Futures	4741.68	4752.81	4729.73	4731.09	210830.0
2023-10-18 13:00:00	ES	Futures	4730.82	4756.34	4726.2	4741.68	312592.0
2023-10-18 14:00:00	ES	Futures	4741.68	4750.37	4723.21	4727.29	217627.0
2023-10-18 15:00:00	ES	Futures	4727.29	4727.56	4704.21	4717.51	361434.0
2023-10-18 16:00:00	ES	Futures	4717.24	4726.2	4717.24	4722.4	85005.0
2023-10-18 18:00:00	ES	Futures	4721.31	4722.4	4715.07	4715.61	11114.0
2023-10-18 19:00:00	ES	Futures	4715.61	4718.87	4713.98	4718.6	9291.0
2023-10-18 20:00:00	ES	Futures	4718.33	4721.59	4714.52	4720.23	11593.0
2023-10-18 21:00:00	ES	Futures	4720.23	4723.76	4712.08	4713.71	16355.0
2023-10-18 22:00:00	ES	Futures	4713.44	4715.88	4707.74	4708.55	8939.0
2023-10-18 23:00:00	ES	Futures	4708.55	4709.37	4702.3	4706.11	9366.0
2023-10-18 00:00:00	NQ	Futures	16717.99	16722.11	16711.12	16711.67	1998.0
2023-10-18 01:00:00	NQ	Futures	16711.94	16725.4	16703.98	16721.28	4456.0
2023-10-18 02:00:00	NQ	Futures	16721.01	16722.93	16683.1	16683.38	7087.0
2023-10-18 03:00:00	NQ	Futures	16683.65	16704.25	16658.93	16700.13	14187.0
2023-10-18 04:00:00	NQ	Futures	16700.68	16714.41	16675.41	16703.98	10427.0
2023-10-18 05:00:00	NQ	Futures	16704.8	16715.24	16649.32	16661.95	12694.0
2023-10-18 06:00:00	NQ	Futures	16661.95	16674.31	16631.19	16640.53	12726.0
2023-10-18 07:00:00	NQ	Futures	16640.53	16666.07	16637.51	16650.42	11108.0
2023-10-18 08:00:00	NQ	Futures	16650.14	16671.02	16617.46	16621.3	19818.0
2023-10-18 09:00:00	NQ	Futures	16621.3	16698.21	16614.44	16660.58	108179.0
2023-10-18 10:00:00	NQ	Futures	16660.58	16725.68	16582.03	16590.54	135070.0
2023-10-18 11:00:00	NQ	Futures	16590.82	16653.99	16587.79	16621.03	80625.0
2023-10-18 12:00:00	NQ	Futures	16621.3	16674.59	16568.02	16577.36	84146.0
2023-10-18 13:00:00	NQ	Futures	16577.36	16669.92	16551.26	16604.55	110468.0
2023-10-18 14:00:00	NQ	Futures	16605.37	16631.74	16529.02	16547.42	82702.0
2023-10-18 15:00:00	NQ	Futures	16547.69	16548.52	16457.05	16505.67	99838.0
2023-10-18 16:00:00	NQ	Futures	16505.94	16560.05	16505.67	16547.14	26141.0
2023-10-18 18:00:00	NQ	Futures	16529.29	16540.28	16512.81	16516.11	6639.0
2023-10-18 19:00:00	NQ	Futures	16515.83	16523.52	16509.79	16521.05	3915.0
2023-10-18 20:00:00	NQ	Futures	16521.6	16537.53	16508.69	16531.76	5603.0
2023-10-18 21:00:00	NQ	Futures	16531.49	16543.3	16499.35	16507.59	8565.0
2023-10-18 22:00:00	NQ	Futures	16507.87	16516.38	16482.6	16485.34	5348.0
2023-10-18 23:00:00	NQ	Futures	16484.8	16488.09	16458.98	16475.18	5431.0
2023-10-18 00:00:00	YM	Futures	37017.5	37030.5	37008.8	37012.1	739.0
2023-10-18 01:00:00	YM	Futures	37012.1	37042.4	37000.1	37037.0	1028.0
2023-10-18 02:00:00	YM	Futures	37035.9	37042.4	36970.8	36971.9	2098.0
2023-10-18 03:00:00	YM	Futures	36970.8	36998.0	36942.6	36996.9	5599.0

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

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