PREVIEW / futures_1hour / 2023-09-27

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-09-27.parquet
  size:    67 KB
  rows:    2,062

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-09-27 00:00:00	ES	Futures	4695.24	4699.86	4694.43	4699.59	6708.0
2023-09-27 01:00:00	ES	Futures	4699.59	4702.85	4696.6	4702.58	12316.0
2023-09-27 02:00:00	ES	Futures	4702.85	4704.48	4699.86	4702.58	13539.0
2023-09-27 03:00:00	ES	Futures	4702.3	4709.37	4698.5	4708.82	23851.0
2023-09-27 04:00:00	ES	Futures	4708.82	4710.45	4705.02	4706.92	18940.0
2023-09-27 05:00:00	ES	Futures	4707.19	4707.74	4699.86	4702.03	16848.0
2023-09-27 06:00:00	ES	Futures	4701.76	4703.66	4698.77	4703.12	14112.0
2023-09-27 07:00:00	ES	Futures	4702.85	4707.19	4698.77	4705.29	22827.0
2023-09-27 08:00:00	ES	Futures	4705.29	4706.92	4697.42	4706.11	36130.0
2023-09-27 09:00:00	ES	Futures	4705.83	4708.55	4693.89	4696.87	175722.0
2023-09-27 10:00:00	ES	Futures	4696.87	4699.32	4675.96	4677.59	258826.0
2023-09-27 11:00:00	ES	Futures	4677.59	4688.18	4671.35	4674.88	183091.0
2023-09-27 12:00:00	ES	Futures	4674.61	4674.88	4662.39	4665.92	171558.0
2023-09-27 13:00:00	ES	Futures	4665.64	4672.43	4645.82	4657.23	188437.0
2023-09-27 14:00:00	ES	Futures	4656.95	4690.63	4649.62	4685.74	258042.0
2023-09-27 15:00:00	ES	Futures	4685.47	4703.66	4674.06	4687.1	371753.0
2023-09-27 16:00:00	ES	Futures	4687.37	4696.33	4685.74	4694.43	65327.0
2023-09-27 18:00:00	ES	Futures	4696.06	4696.33	4686.55	4690.63	9947.0
2023-09-27 19:00:00	ES	Futures	4690.36	4694.43	4688.18	4693.89	5409.0
2023-09-27 20:00:00	ES	Futures	4693.89	4699.59	4691.99	4697.42	12183.0
2023-09-27 21:00:00	ES	Futures	4697.42	4698.5	4693.34	4696.33	12106.0
2023-09-27 22:00:00	ES	Futures	4696.06	4696.87	4686.55	4687.91	10983.0
2023-09-27 23:00:00	ES	Futures	4687.91	4688.18	4684.65	4686.28	7859.0
2023-09-27 00:00:00	NQ	Futures	16192.83	16209.03	16188.71	16207.66	3276.0
2023-09-27 01:00:00	NQ	Futures	16206.84	16218.65	16194.2	16217.55	4833.0
2023-09-27 02:00:00	NQ	Futures	16218.1	16225.51	16206.29	16214.8	5766.0
2023-09-27 03:00:00	NQ	Futures	16214.25	16253.25	16202.44	16252.15	10693.0
2023-09-27 04:00:00	NQ	Futures	16251.88	16255.73	16231.83	16238.7	8377.0
2023-09-27 05:00:00	NQ	Futures	16238.7	16242.27	16209.58	16217.55	7107.0
2023-09-27 06:00:00	NQ	Futures	16217.27	16225.51	16198.87	16221.67	7371.0
2023-09-27 07:00:00	NQ	Futures	16221.39	16236.22	16202.44	16224.96	9403.0
2023-09-27 08:00:00	NQ	Futures	16225.24	16234.58	16187.33	16228.81	16971.0
2023-09-27 09:00:00	NQ	Futures	16228.53	16266.71	16204.36	16220.84	76373.0
2023-09-27 10:00:00	NQ	Futures	16221.39	16232.1	16130.48	16137.89	104351.0
2023-09-27 11:00:00	NQ	Futures	16138.72	16198.6	16120.32	16132.4	69659.0
2023-09-27 12:00:00	NQ	Futures	16131.58	16132.95	16087.91	16103.01	63508.0
2023-09-27 13:00:00	NQ	Futures	16103.01	16133.77	16025.01	16062.36	72541.0
2023-09-27 14:00:00	NQ	Futures	16062.36	16211.23	16034.35	16193.1	93540.0
2023-09-27 15:00:00	NQ	Futures	16193.65	16283.74	16151.9	16198.32	107938.0
2023-09-27 16:00:00	NQ	Futures	16198.6	16237.6	16192.55	16223.32	19899.0
2023-09-27 18:00:00	NQ	Futures	16229.91	16232.38	16198.05	16211.23	4777.0
2023-09-27 19:00:00	NQ	Futures	16211.5	16232.38	16205.46	16232.38	3174.0
2023-09-27 20:00:00	NQ	Futures	16232.1	16253.53	16223.04	16247.21	5778.0
2023-09-27 21:00:00	NQ	Futures	16247.49	16250.51	16220.57	16235.68	6676.0
2023-09-27 22:00:00	NQ	Futures	16235.4	16240.07	16196.95	16202.44	6042.0
2023-09-27 23:00:00	NQ	Futures	16201.89	16203.26	16186.51	16194.48	5010.0
2023-09-27 00:00:00	YM	Futures	36796.2	36826.6	36788.6	36825.5	1172.0
2023-09-27 01:00:00	YM	Futures	36825.5	36845.0	36808.1	36843.9	1418.0
2023-09-27 02:00:00	YM	Futures	36843.9	36855.9	36825.5	36849.4	2119.0
2023-09-27 03:00:00	YM	Futures	36850.4	36886.2	36816.8	36883.0	4132.0

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

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