PREVIEW / futures_1hour / 2023-04-20

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-04-20.parquet
  size:    65 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-04-20 00:00:00	ES	Futures	4627.36	4628.2	4624.04	4624.59	3200.0
2023-04-20 01:00:00	ES	Futures	4624.87	4624.87	4620.71	4622.65	6867.0
2023-04-20 02:00:00	ES	Futures	4622.65	4626.25	4620.71	4622.37	8577.0
2023-04-20 03:00:00	ES	Futures	4622.65	4622.93	4600.74	4603.51	41875.0
2023-04-20 04:00:00	ES	Futures	4603.51	4605.18	4597.69	4600.18	26935.0
2023-04-20 05:00:00	ES	Futures	4600.18	4604.34	4598.8	4603.23	15752.0
2023-04-20 06:00:00	ES	Futures	4602.96	4606.29	4600.18	4606.01	15110.0
2023-04-20 07:00:00	ES	Futures	4606.01	4608.23	4600.74	4600.74	20054.0
2023-04-20 08:00:00	ES	Futures	4601.02	4605.18	4596.3	4604.34	48514.0
2023-04-20 09:00:00	ES	Futures	4604.07	4612.11	4598.52	4604.62	183692.0
2023-04-20 10:00:00	ES	Futures	4604.62	4618.49	4601.29	4616.82	211066.0
2023-04-20 11:00:00	ES	Futures	4616.82	4618.21	4606.56	4612.66	167308.0
2023-04-20 12:00:00	ES	Futures	4612.66	4623.76	4606.84	4622.65	139952.0
2023-04-20 13:00:00	ES	Futures	4622.93	4628.2	4621.26	4622.65	142053.0
2023-04-20 14:00:00	ES	Futures	4622.65	4622.93	4599.07	4604.62	233619.0
2023-04-20 15:00:00	ES	Futures	4604.62	4608.78	4589.64	4607.95	342809.0
2023-04-20 16:00:00	ES	Futures	4607.95	4613.22	4606.56	4608.23	70789.0
2023-04-20 18:00:00	ES	Futures	4608.23	4608.5	4605.45	4606.84	4980.0
2023-04-20 19:00:00	ES	Futures	4606.84	4609.34	4604.34	4605.73	5719.0
2023-04-20 20:00:00	ES	Futures	4605.45	4612.11	4604.34	4612.11	7178.0
2023-04-20 21:00:00	ES	Futures	4611.83	4612.39	4607.39	4609.34	6139.0
2023-04-20 22:00:00	ES	Futures	4609.06	4609.89	4606.84	4608.23	4010.0
2023-04-20 23:00:00	ES	Futures	4608.5	4611.0	4607.95	4609.61	4869.0
2023-04-20 00:00:00	NQ	Futures	14799.27	14800.12	14787.45	14791.11	1664.0
2023-04-20 01:00:00	NQ	Futures	14791.67	14791.95	14766.89	14771.4	4090.0
2023-04-20 02:00:00	NQ	Futures	14771.12	14795.33	14757.88	14788.57	6232.0
2023-04-20 03:00:00	NQ	Futures	14789.14	14790.26	14708.33	14718.18	14505.0
2023-04-20 04:00:00	NQ	Futures	14718.18	14723.53	14668.91	14680.46	13758.0
2023-04-20 05:00:00	NQ	Futures	14680.46	14696.79	14672.85	14693.41	7908.0
2023-04-20 06:00:00	NQ	Futures	14693.69	14717.06	14688.9	14712.83	6623.0
2023-04-20 07:00:00	NQ	Futures	14713.4	14721.28	14693.97	14693.97	8297.0
2023-04-20 08:00:00	NQ	Futures	14694.53	14726.35	14677.36	14718.18	19339.0
2023-04-20 09:00:00	NQ	Futures	14718.47	14781.25	14692.84	14771.12	88649.0
2023-04-20 10:00:00	NQ	Futures	14770.83	14818.7	14761.26	14786.6	91185.0
2023-04-20 11:00:00	NQ	Futures	14786.88	14810.25	14743.81	14795.33	67859.0
2023-04-20 12:00:00	NQ	Futures	14795.61	14838.97	14768.02	14837.28	60192.0
2023-04-20 13:00:00	NQ	Futures	14837.56	14866.0	14826.86	14832.78	53015.0
2023-04-20 14:00:00	NQ	Futures	14832.21	14833.62	14716.78	14741.83	86089.0
2023-04-20 15:00:00	NQ	Futures	14742.4	14751.41	14665.25	14727.48	104589.0
2023-04-20 16:00:00	NQ	Futures	14727.76	14750.84	14725.79	14743.24	17084.0
2023-04-20 18:00:00	NQ	Futures	14740.99	14741.27	14726.91	14734.51	2257.0
2023-04-20 19:00:00	NQ	Futures	14734.8	14746.06	14726.91	14733.95	2747.0
2023-04-20 20:00:00	NQ	Futures	14732.82	14760.14	14728.04	14760.14	3246.0
2023-04-20 21:00:00	NQ	Futures	14759.29	14762.11	14742.4	14746.62	3203.0
2023-04-20 22:00:00	NQ	Futures	14745.21	14752.53	14736.77	14740.43	2126.0
2023-04-20 23:00:00	NQ	Futures	14740.71	14751.13	14739.58	14745.49	1916.0
2023-04-20 00:00:00	YM	Futures	37600.4	37611.4	37584.9	37587.1	728.0
2023-04-20 01:00:00	YM	Futures	37589.3	37592.6	37565.0	37588.2	1207.0
2023-04-20 02:00:00	YM	Futures	37588.2	37605.9	37569.4	37569.4	1382.0
2023-04-20 03:00:00	YM	Futures	37570.5	37583.8	37398.1	37415.8	6369.0

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

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