PREVIEW / futures_1hour / 2023-11-03

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-11-03.parquet
  size:    58 KB
  rows:    1,682

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-03 00:00:00	ES	Futures	4705.56	4706.65	4704.75	4706.11	2608.0
2023-11-03 01:00:00	ES	Futures	4706.11	4708.55	4705.83	4707.74	2323.0
2023-11-03 02:00:00	ES	Futures	4707.74	4708.82	4705.56	4705.83	4033.0
2023-11-03 03:00:00	ES	Futures	4705.83	4707.74	4702.03	4703.12	9600.0
2023-11-03 04:00:00	ES	Futures	4703.12	4705.29	4701.22	4702.85	15577.0
2023-11-03 05:00:00	ES	Futures	4703.12	4704.21	4699.05	4702.85	16024.0
2023-11-03 06:00:00	ES	Futures	4703.12	4705.02	4701.22	4701.49	13790.0
2023-11-03 07:00:00	ES	Futures	4701.22	4707.46	4699.59	4707.19	23066.0
2023-11-03 08:00:00	ES	Futures	4707.19	4737.34	4703.39	4731.63	133286.0
2023-11-03 09:00:00	ES	Futures	4731.63	4755.8	4727.83	4752.27	263296.0
2023-11-03 10:00:00	ES	Futures	4752.54	4761.23	4736.25	4746.84	330199.0
2023-11-03 11:00:00	ES	Futures	4746.84	4758.52	4739.78	4755.8	161933.0
2023-11-03 12:00:00	ES	Futures	4755.8	4765.58	4754.44	4764.49	131257.0
2023-11-03 13:00:00	ES	Futures	4764.49	4766.12	4754.17	4763.13	122937.0
2023-11-03 14:00:00	ES	Futures	4763.13	4769.11	4756.07	4768.29	118128.0
2023-11-03 15:00:00	ES	Futures	4768.29	4770.47	4751.73	4752.27	246559.0
2023-11-03 16:00:00	ES	Futures	4752.0	4757.7	4751.73	4756.07	61798.0
2023-11-03 00:00:00	NQ	Futures	16432.88	16435.91	16426.57	16432.33	1498.0
2023-11-03 01:00:00	NQ	Futures	16431.79	16444.42	16430.69	16441.95	1499.0
2023-11-03 02:00:00	NQ	Futures	16441.95	16443.6	16428.49	16429.31	2442.0
2023-11-03 03:00:00	NQ	Futures	16429.04	16438.65	16417.23	16422.17	5173.0
2023-11-03 04:00:00	NQ	Futures	16421.9	16428.21	16413.38	16418.05	8126.0
2023-11-03 05:00:00	NQ	Futures	16418.05	16428.21	16406.24	16422.72	6717.0
2023-11-03 06:00:00	NQ	Futures	16422.72	16430.96	16411.19	16418.33	5317.0
2023-11-03 07:00:00	NQ	Futures	16418.05	16450.74	16404.59	16449.09	11328.0
2023-11-03 08:00:00	NQ	Futures	16449.64	16551.81	16413.93	16529.84	55326.0
2023-11-03 09:00:00	NQ	Futures	16529.84	16633.39	16500.18	16616.36	101753.0
2023-11-03 10:00:00	NQ	Futures	16618.28	16659.21	16536.43	16602.08	111659.0
2023-11-03 11:00:00	NQ	Futures	16602.35	16651.24	16572.69	16637.51	65339.0
2023-11-03 12:00:00	NQ	Futures	16637.78	16692.99	16628.99	16685.03	51476.0
2023-11-03 13:00:00	NQ	Futures	16684.75	16704.53	16651.79	16690.24	49558.0
2023-11-03 14:00:00	NQ	Futures	16690.24	16719.63	16666.62	16714.41	43216.0
2023-11-03 15:00:00	NQ	Futures	16714.69	16730.89	16671.02	16671.57	72083.0
2023-11-03 16:00:00	NQ	Futures	16671.29	16688.32	16668.27	16684.48	12820.0
2023-11-03 00:00:00	YM	Futures	36827.7	36836.3	36822.2	36835.2	630.0
2023-11-03 01:00:00	YM	Futures	36835.2	36846.1	36832.0	36841.8	404.0
2023-11-03 02:00:00	YM	Futures	36842.8	36852.6	36835.2	36836.3	706.0
2023-11-03 03:00:00	YM	Futures	36836.3	36845.0	36801.6	36803.8	2001.0
2023-11-03 04:00:00	YM	Futures	36804.9	36811.4	36779.9	36791.9	3279.0
2023-11-03 05:00:00	YM	Futures	36794.0	36807.0	36768.0	36799.5	2240.0
2023-11-03 06:00:00	YM	Futures	36798.4	36810.3	36777.8	36777.8	1903.0
2023-11-03 07:00:00	YM	Futures	36777.8	36808.1	36771.2	36803.8	2516.0
2023-11-03 08:00:00	YM	Futures	36804.9	36995.8	36781.0	36955.7	13946.0
2023-11-03 09:00:00	YM	Futures	36955.7	37030.5	36928.5	36980.6	27090.0
2023-11-03 10:00:00	YM	Futures	36980.6	37037.0	36891.7	36961.1	24972.0
2023-11-03 11:00:00	YM	Futures	36962.2	37062.0	36931.8	37043.5	13438.0
2023-11-03 12:00:00	YM	Futures	37045.7	37111.9	37033.8	37110.8	11113.0
2023-11-03 13:00:00	YM	Futures	37110.8	37134.7	37032.7	37092.3	10101.0
2023-11-03 14:00:00	YM	Futures	37091.3	37126.0	37042.4	37119.5	8844.0
2023-11-03 15:00:00	YM	Futures	37119.5	37120.5	37013.2	37027.3	16200.0

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

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