PREVIEW / futures_1hour / 2023-11-06

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-11-06.parquet
  size:    68 KB
  rows:    2,116

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-11-06 00:00:00	ES	Futures	4754.72	4756.62	4753.9	4755.8	4007.0
2023-11-06 01:00:00	ES	Futures	4755.53	4759.33	4754.44	4758.52	5690.0
2023-11-06 02:00:00	ES	Futures	4758.52	4760.96	4756.07	4758.25	8447.0
2023-11-06 03:00:00	ES	Futures	4758.25	4762.86	4756.62	4759.88	15780.0
2023-11-06 04:00:00	ES	Futures	4760.15	4762.59	4757.97	4761.5	13974.0
2023-11-06 05:00:00	ES	Futures	4761.5	4763.95	4759.33	4762.05	10628.0
2023-11-06 06:00:00	ES	Futures	4761.78	4765.03	4760.15	4762.86	12705.0
2023-11-06 07:00:00	ES	Futures	4762.59	4763.41	4757.7	4761.23	16675.0
2023-11-06 08:00:00	ES	Futures	4761.23	4762.05	4756.07	4759.6	30736.0
2023-11-06 09:00:00	ES	Futures	4759.88	4768.02	4755.53	4760.15	201719.0
2023-11-06 10:00:00	ES	Futures	4760.15	4765.03	4752.27	4759.88	186486.0
2023-11-06 11:00:00	ES	Futures	4759.88	4763.95	4755.8	4761.23	103046.0
2023-11-06 12:00:00	ES	Futures	4761.5	4762.32	4749.56	4754.99	107673.0
2023-11-06 13:00:00	ES	Futures	4754.72	4755.26	4740.59	4747.65	134158.0
2023-11-06 14:00:00	ES	Futures	4747.38	4757.16	4740.87	4756.07	134638.0
2023-11-06 15:00:00	ES	Futures	4756.34	4763.68	4751.73	4762.59	210372.0
2023-11-06 16:00:00	ES	Futures	4762.32	4763.41	4757.7	4757.97	49228.0
2023-11-06 18:00:00	ES	Futures	4757.7	4757.7	4752.27	4753.9	7708.0
2023-11-06 19:00:00	ES	Futures	4753.9	4754.72	4752.0	4752.54	9020.0
2023-11-06 20:00:00	ES	Futures	4752.81	4756.62	4750.91	4754.44	9299.0
2023-11-06 21:00:00	ES	Futures	4754.72	4755.26	4752.27	4752.81	4419.0
2023-11-06 22:00:00	ES	Futures	4752.81	4754.17	4750.91	4752.27	6299.0
2023-11-06 23:00:00	ES	Futures	4752.27	4752.81	4750.1	4751.19	3513.0
2023-11-06 00:00:00	NQ	Futures	16676.79	16682.28	16671.29	16678.16	2293.0
2023-11-06 01:00:00	NQ	Futures	16678.16	16692.99	16676.24	16688.32	3038.0
2023-11-06 02:00:00	NQ	Futures	16688.6	16706.72	16682.28	16690.79	4506.0
2023-11-06 03:00:00	NQ	Futures	16691.07	16719.08	16682.0	16705.63	8198.0
2023-11-06 04:00:00	NQ	Futures	16705.9	16716.89	16693.54	16713.04	6901.0
2023-11-06 05:00:00	NQ	Futures	16713.32	16727.32	16706.72	16718.26	6495.0
2023-11-06 06:00:00	NQ	Futures	16718.26	16722.93	16707.0	16716.34	5220.0
2023-11-06 07:00:00	NQ	Futures	16715.51	16718.26	16697.39	16706.17	7022.0
2023-11-06 08:00:00	NQ	Futures	16706.45	16711.67	16687.5	16705.35	13106.0
2023-11-06 09:00:00	NQ	Futures	16705.9	16762.76	16696.29	16717.16	84012.0
2023-11-06 10:00:00	NQ	Futures	16717.71	16750.12	16683.1	16722.65	79572.0
2023-11-06 11:00:00	NQ	Futures	16722.93	16744.08	16692.99	16725.95	45995.0
2023-11-06 12:00:00	NQ	Futures	16726.5	16726.77	16679.81	16705.63	38057.0
2023-11-06 13:00:00	NQ	Futures	16706.45	16706.72	16631.47	16665.8	51598.0
2023-11-06 14:00:00	NQ	Futures	16666.07	16710.84	16637.23	16707.55	47932.0
2023-11-06 15:00:00	NQ	Futures	16707.27	16739.68	16693.54	16736.66	49515.0
2023-11-06 16:00:00	NQ	Futures	16736.39	16738.04	16717.16	16724.3	11739.0
2023-11-06 18:00:00	NQ	Futures	16716.06	16721.83	16703.7	16709.2	3292.0
2023-11-06 19:00:00	NQ	Futures	16709.2	16715.24	16702.33	16706.45	4005.0
2023-11-06 20:00:00	NQ	Futures	16705.9	16724.85	16698.48	16715.79	5636.0
2023-11-06 21:00:00	NQ	Futures	16716.34	16719.08	16707.55	16710.57	2571.0
2023-11-06 22:00:00	NQ	Futures	16710.02	16717.44	16703.43	16708.65	2882.0
2023-11-06 23:00:00	NQ	Futures	16709.2	16712.77	16703.15	16705.63	1594.0
2023-11-06 00:00:00	YM	Futures	37055.5	37067.4	37049.0	37056.5	495.0
2023-11-06 01:00:00	YM	Futures	37056.5	37078.2	37049.0	37077.2	914.0
2023-11-06 02:00:00	YM	Futures	37077.2	37085.8	37059.8	37071.7	2232.0
2023-11-06 03:00:00	YM	Futures	37071.7	37097.8	37065.2	37082.6	2702.0

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

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