PREVIEW / futures_1hour / 2022-06-17

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-06-17.parquet
  size:    58 KB
  rows:    1,649

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
2022-06-17 00:00:00	ES	Futures	4179.95	4200.35	4179.67	4196.1	12700.0
2022-06-17 01:00:00	ES	Futures	4196.38	4202.05	4190.15	4190.15	13128.0
2022-06-17 02:00:00	ES	Futures	4190.44	4191.85	4172.02	4180.52	23046.0
2022-06-17 03:00:00	ES	Futures	4180.24	4195.53	4171.46	4193.83	28702.0
2022-06-17 04:00:00	ES	Futures	4193.83	4207.71	4186.75	4196.67	32428.0
2022-06-17 05:00:00	ES	Futures	4196.67	4206.58	4185.05	4198.93	25438.0
2022-06-17 06:00:00	ES	Futures	4198.65	4203.47	4190.72	4195.25	23371.0
2022-06-17 07:00:00	ES	Futures	4195.53	4207.71	4191.0	4197.23	26320.0
2022-06-17 08:00:00	ES	Futures	4197.23	4202.62	4178.82	4181.09	45136.0
2022-06-17 09:00:00	ES	Futures	4180.8	4205.73	4159.56	4194.68	275466.0
2022-06-17 10:00:00	ES	Futures	4194.68	4196.95	4123.3	4139.16	305024.0
2022-06-17 11:00:00	ES	Futures	4139.45	4182.22	4130.95	4153.89	278328.0
2022-06-17 12:00:00	ES	Futures	4153.89	4170.32	4145.11	4164.09	164546.0
2022-06-17 13:00:00	ES	Futures	4164.37	4199.5	4160.97	4181.94	179222.0
2022-06-17 14:00:00	ES	Futures	4182.22	4202.33	4178.82	4184.49	154823.0
2022-06-17 15:00:00	ES	Futures	4184.2	4193.27	4162.11	4164.37	315895.0
2022-06-17 16:00:00	ES	Futures	4164.66	4178.25	4163.81	4174.01	86603.0
2022-06-17 00:00:00	NQ	Futures	12988.28	13058.85	12984.81	13050.47	6380.0
2022-06-17 01:00:00	NQ	Futures	13050.18	13065.8	13022.12	13022.99	6373.0
2022-06-17 02:00:00	NQ	Futures	13024.15	13029.64	12952.7	12983.65	10553.0
2022-06-17 03:00:00	NQ	Futures	12985.39	13043.23	12955.02	13036.58	14689.0
2022-06-17 04:00:00	NQ	Futures	13036.0	13077.65	13014.31	13034.85	14667.0
2022-06-17 05:00:00	NQ	Futures	13034.27	13072.45	13017.2	13057.99	11676.0
2022-06-17 06:00:00	NQ	Futures	13057.7	13083.73	13035.14	13059.43	10156.0
2022-06-17 07:00:00	NQ	Futures	13060.3	13098.77	13043.81	13059.72	11004.0
2022-06-17 08:00:00	NQ	Futures	13059.43	13071.29	12992.91	13005.92	19411.0
2022-06-17 09:00:00	NQ	Futures	13004.77	13129.72	12920.89	13089.51	100528.0
2022-06-17 10:00:00	NQ	Futures	13089.8	13097.03	12864.2	12925.23	109129.0
2022-06-17 11:00:00	NQ	Futures	12925.8	13094.72	12886.47	12996.96	88565.0
2022-06-17 12:00:00	NQ	Futures	12997.82	13086.04	12966.59	13064.64	59733.0
2022-06-17 13:00:00	NQ	Futures	13064.64	13184.67	13054.8	13123.35	68171.0
2022-06-17 14:00:00	NQ	Futures	13123.35	13171.37	13096.17	13108.31	46070.0
2022-06-17 15:00:00	NQ	Futures	13108.02	13140.13	13038.32	13064.64	80169.0
2022-06-17 16:00:00	NQ	Futures	13064.64	13095.01	13062.04	13082.57	21283.0
2022-06-17 00:00:00	YM	Futures	33907.9	34051.2	33906.7	34015.0	2922.0
2022-06-17 01:00:00	YM	Futures	34017.3	34052.3	33975.6	33976.7	2190.0
2022-06-17 02:00:00	YM	Futures	33975.6	33983.5	33855.9	33905.6	4019.0
2022-06-17 03:00:00	YM	Futures	33907.9	34010.5	33843.5	33992.5	5583.0
2022-06-17 04:00:00	YM	Futures	33988.0	34089.5	33942.8	34022.9	5514.0
2022-06-17 05:00:00	YM	Futures	34022.9	34086.1	33916.9	34018.4	5285.0
2022-06-17 06:00:00	YM	Futures	34015.0	34036.5	33944.0	33977.8	3375.0
2022-06-17 07:00:00	YM	Futures	33981.2	34062.4	33947.3	33989.1	3328.0
2022-06-17 08:00:00	YM	Futures	33991.3	34042.1	33852.6	33862.7	12221.0
2022-06-17 09:00:00	YM	Futures	33861.6	34028.6	33648.3	33925.9	35364.0
2022-06-17 10:00:00	YM	Futures	33928.2	33945.1	33443.0	33547.9	39477.0
2022-06-17 11:00:00	YM	Futures	33550.2	33872.9	33496.0	33635.9	31693.0
2022-06-17 12:00:00	YM	Futures	33639.3	33751.0	33573.9	33713.8	15888.0
2022-06-17 13:00:00	YM	Futures	33713.8	33963.1	33690.1	33844.7	19512.0
2022-06-17 14:00:00	YM	Futures	33845.8	34004.9	33827.7	33871.7	13968.0
2022-06-17 15:00:00	YM	Futures	33872.9	33933.8	33687.8	33698.0	26941.0

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

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