PREVIEW / futures_1hour / 2023-02-27

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-02-27.parquet
  size:    64 KB
  rows:    2,013

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-02-27 00:00:00	ES	Futures	4453.29	4453.57	4445.74	4447.14	7064.0
2023-02-27 01:00:00	ES	Futures	4447.42	4449.1	4446.02	4446.86	5192.0
2023-02-27 02:00:00	ES	Futures	4447.14	4456.65	4446.02	4455.53	9277.0
2023-02-27 03:00:00	ES	Futures	4455.53	4467.55	4455.53	4462.8	29161.0
2023-02-27 04:00:00	ES	Futures	4463.08	4470.07	4461.96	4465.88	16139.0
2023-02-27 05:00:00	ES	Futures	4465.88	4470.91	4465.6	4465.6	14050.0
2023-02-27 06:00:00	ES	Futures	4465.88	4469.51	4465.04	4467.27	13086.0
2023-02-27 07:00:00	ES	Futures	4467.27	4470.63	4463.92	4465.88	17502.0
2023-02-27 08:00:00	ES	Futures	4465.6	4489.92	4465.04	4485.45	60399.0
2023-02-27 09:00:00	ES	Futures	4485.45	4490.48	4475.94	4489.64	189843.0
2023-02-27 10:00:00	ES	Futures	4489.64	4501.39	4470.35	4477.34	339897.0
2023-02-27 11:00:00	ES	Futures	4477.62	4481.53	4459.44	4466.71	192566.0
2023-02-27 12:00:00	ES	Futures	4466.71	4473.15	4458.61	4471.75	120439.0
2023-02-27 13:00:00	ES	Futures	4472.03	4477.34	4465.04	4475.1	96828.0
2023-02-27 14:00:00	ES	Futures	4475.1	4480.97	4460.84	4462.8	129351.0
2023-02-27 15:00:00	ES	Futures	4462.8	4465.88	4449.66	4460.56	250919.0
2023-02-27 16:00:00	ES	Futures	4460.56	4464.76	4459.72	4464.2	49513.0
2023-02-27 18:00:00	ES	Futures	4464.2	4467.83	4462.8	4464.48	6848.0
2023-02-27 19:00:00	ES	Futures	4464.2	4469.23	4463.92	4466.44	5476.0
2023-02-27 20:00:00	ES	Futures	4466.71	4471.47	4464.48	4468.95	7717.0
2023-02-27 21:00:00	ES	Futures	4468.67	4470.35	4465.6	4468.39	5751.0
2023-02-27 22:00:00	ES	Futures	4468.67	4469.23	4466.71	4466.71	2802.0
2023-02-27 23:00:00	ES	Futures	4466.71	4467.55	4463.36	4464.2	4219.0
2023-02-27 00:00:00	NQ	Futures	13690.99	13693.27	13663.68	13669.09	3137.0
2023-02-27 01:00:00	NQ	Futures	13668.8	13676.77	13663.11	13669.37	2402.0
2023-02-27 02:00:00	NQ	Futures	13669.66	13702.37	13664.82	13698.39	4383.0
2023-02-27 03:00:00	NQ	Futures	13698.67	13738.79	13698.67	13720.01	11810.0
2023-02-27 04:00:00	NQ	Futures	13720.58	13744.48	13710.91	13722.0	7778.0
2023-02-27 05:00:00	NQ	Futures	13722.29	13744.48	13715.46	13716.03	6255.0
2023-02-27 06:00:00	NQ	Futures	13716.03	13736.23	13711.48	13728.26	4784.0
2023-02-27 07:00:00	NQ	Futures	13728.26	13743.05	13716.6	13722.29	6984.0
2023-02-27 08:00:00	NQ	Futures	13722.86	13829.83	13716.88	13812.19	27278.0
2023-02-27 09:00:00	NQ	Futures	13813.04	13828.12	13776.62	13823.0	75442.0
2023-02-27 10:00:00	NQ	Futures	13823.28	13871.36	13742.77	13773.78	106867.0
2023-02-27 11:00:00	NQ	Futures	13774.35	13790.85	13730.25	13770.37	66396.0
2023-02-27 12:00:00	NQ	Futures	13770.65	13794.26	13737.08	13790.57	44476.0
2023-02-27 13:00:00	NQ	Futures	13790.57	13807.92	13763.54	13801.66	42768.0
2023-02-27 14:00:00	NQ	Futures	13801.66	13820.44	13747.89	13756.99	53997.0
2023-02-27 15:00:00	NQ	Futures	13757.28	13768.09	13722.29	13751.31	75728.0
2023-02-27 16:00:00	NQ	Futures	13751.02	13771.5	13749.31	13764.39	11032.0
2023-02-27 18:00:00	NQ	Futures	13762.12	13778.33	13755.29	13762.4	4029.0
2023-02-27 19:00:00	NQ	Futures	13762.12	13782.88	13761.55	13774.06	2420.0
2023-02-27 20:00:00	NQ	Futures	13774.35	13802.23	13765.81	13792.27	4421.0
2023-02-27 21:00:00	NQ	Futures	13792.56	13799.1	13777.76	13794.26	3201.0
2023-02-27 22:00:00	NQ	Futures	13794.55	13795.4	13783.74	13786.01	1299.0
2023-02-27 23:00:00	NQ	Futures	13785.73	13790.85	13772.36	13776.91	2234.0
2023-02-27 00:00:00	YM	Futures	36593.1	36597.5	36547.4	36554.1	1245.0
2023-02-27 01:00:00	YM	Futures	36555.2	36567.4	36542.9	36551.8	1051.0
2023-02-27 02:00:00	YM	Futures	36553.0	36616.5	36542.9	36607.6	1535.0
2023-02-27 03:00:00	YM	Futures	36607.6	36712.3	36607.6	36678.9	5849.0

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

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