PREVIEW / futures_1hour / 2023-10-17

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-10-17.parquet
  size:    67 KB
  rows:    2,066

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-17 00:00:00	ES	Futures	4774.81	4775.35	4772.91	4773.18	3192.0
2023-10-17 01:00:00	ES	Futures	4772.91	4777.8	4772.1	4777.53	6679.0
2023-10-17 02:00:00	ES	Futures	4777.53	4778.61	4771.28	4773.18	7352.0
2023-10-17 03:00:00	ES	Futures	4773.18	4782.14	4772.1	4780.51	15296.0
2023-10-17 04:00:00	ES	Futures	4780.24	4781.06	4765.85	4767.48	19244.0
2023-10-17 05:00:00	ES	Futures	4767.75	4777.25	4766.94	4773.18	12060.0
2023-10-17 06:00:00	ES	Futures	4773.18	4775.08	4766.39	4769.38	20515.0
2023-10-17 07:00:00	ES	Futures	4769.38	4771.55	4763.68	4770.74	21917.0
2023-10-17 08:00:00	ES	Futures	4770.47	4772.1	4754.44	4754.72	65669.0
2023-10-17 09:00:00	ES	Futures	4754.99	4756.07	4742.22	4745.21	251740.0
2023-10-17 10:00:00	ES	Futures	4745.21	4778.07	4743.58	4771.82	297661.0
2023-10-17 11:00:00	ES	Futures	4771.55	4797.89	4769.38	4795.18	237000.0
2023-10-17 12:00:00	ES	Futures	4795.18	4804.68	4787.85	4790.29	182921.0
2023-10-17 13:00:00	ES	Futures	4790.29	4792.46	4765.85	4768.84	163365.0
2023-10-17 14:00:00	ES	Futures	4768.84	4778.07	4761.5	4765.58	176297.0
2023-10-17 15:00:00	ES	Futures	4765.31	4782.41	4762.59	4782.14	251849.0
2023-10-17 16:00:00	ES	Futures	4782.14	4782.96	4775.63	4779.43	56147.0
2023-10-17 18:00:00	ES	Futures	4777.25	4778.61	4774.27	4775.08	5652.0
2023-10-17 19:00:00	ES	Futures	4775.35	4776.71	4770.74	4770.74	5449.0
2023-10-17 20:00:00	ES	Futures	4770.47	4771.28	4764.49	4765.58	12066.0
2023-10-17 21:00:00	ES	Futures	4765.31	4771.01	4764.22	4770.19	9556.0
2023-10-17 22:00:00	ES	Futures	4770.19	4776.44	4770.19	4773.72	9309.0
2023-10-17 23:00:00	ES	Futures	4774.0	4775.9	4771.01	4775.08	5415.0
2023-10-17 00:00:00	NQ	Futures	16781.43	16782.53	16769.07	16771.27	1873.0
2023-10-17 01:00:00	NQ	Futures	16771.27	16785.55	16769.07	16783.36	2870.0
2023-10-17 02:00:00	NQ	Futures	16783.9	16788.02	16763.03	16774.02	4819.0
2023-10-17 03:00:00	NQ	Futures	16773.74	16811.37	16769.35	16800.93	10431.0
2023-10-17 04:00:00	NQ	Futures	16800.38	16804.5	16741.88	16752.32	11263.0
2023-10-17 05:00:00	NQ	Futures	16752.87	16787.75	16748.47	16769.35	6954.0
2023-10-17 06:00:00	NQ	Futures	16769.07	16780.06	16744.63	16752.87	11927.0
2023-10-17 07:00:00	NQ	Futures	16751.77	16757.81	16726.5	16751.77	11849.0
2023-10-17 08:00:00	NQ	Futures	16752.04	16758.36	16659.21	16661.95	32152.0
2023-10-17 09:00:00	NQ	Futures	16662.5	16668.82	16535.06	16566.65	133574.0
2023-10-17 10:00:00	NQ	Futures	16567.19	16740.23	16557.86	16700.41	134930.0
2023-10-17 11:00:00	NQ	Futures	16700.13	16791.32	16684.48	16778.14	95027.0
2023-10-17 12:00:00	NQ	Futures	16778.41	16819.61	16770.17	16780.33	68133.0
2023-10-17 13:00:00	NQ	Futures	16780.88	16792.14	16689.69	16704.53	64281.0
2023-10-17 14:00:00	NQ	Futures	16704.8	16744.9	16676.51	16692.44	76242.0
2023-10-17 15:00:00	NQ	Futures	16692.17	16750.12	16675.69	16744.63	74558.0
2023-10-17 16:00:00	NQ	Futures	16744.35	16755.89	16729.52	16746.28	12361.0
2023-10-17 18:00:00	NQ	Futures	16739.68	16741.61	16727.32	16731.17	3042.0
2023-10-17 19:00:00	NQ	Futures	16731.17	16735.56	16709.2	16712.22	2800.0
2023-10-17 20:00:00	NQ	Futures	16710.57	16714.96	16684.75	16689.69	6107.0
2023-10-17 21:00:00	NQ	Futures	16689.69	16712.22	16683.65	16706.72	6086.0
2023-10-17 22:00:00	NQ	Futures	16707.0	16730.89	16707.0	16715.24	5345.0
2023-10-17 23:00:00	NQ	Futures	16715.51	16721.56	16701.51	16717.44	2904.0
2023-10-17 00:00:00	YM	Futures	36996.9	36996.9	36976.3	36978.4	683.0
2023-10-17 01:00:00	YM	Futures	36977.4	37006.6	36971.9	37005.6	1232.0
2023-10-17 02:00:00	YM	Futures	37005.6	37011.0	36966.5	36981.7	2042.0
2023-10-17 03:00:00	YM	Futures	36982.8	37042.4	36970.8	37032.7	2896.0

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

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