PREVIEW / futures_1hour / 2021-12-23

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-12-23.parquet
  size:    54 KB
  rows:    1,611

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
2021-12-23 00:00:00	ES	Futures	5304.52	5306.78	5304.52	5305.37	2311.0
2021-12-23 01:00:00	ES	Futures	5305.65	5309.04	5303.39	5306.22	3465.0
2021-12-23 02:00:00	ES	Futures	5306.22	5307.91	5303.95	5306.5	4465.0
2021-12-23 03:00:00	ES	Futures	5306.5	5312.15	5298.86	5310.17	12862.0
2021-12-23 04:00:00	ES	Futures	5310.17	5312.72	5306.5	5308.48	7269.0
2021-12-23 05:00:00	ES	Futures	5308.76	5315.55	5307.63	5314.13	5497.0
2021-12-23 06:00:00	ES	Futures	5314.13	5316.68	5313.29	5316.68	8714.0
2021-12-23 07:00:00	ES	Futures	5316.4	5319.79	5314.7	5318.66	11506.0
2021-12-23 08:00:00	ES	Futures	5318.09	5320.64	5307.35	5313.29	27176.0
2021-12-23 09:00:00	ES	Futures	5313.29	5335.06	5311.59	5329.12	177439.0
2021-12-23 10:00:00	ES	Futures	5329.12	5340.15	5327.14	5339.59	140509.0
2021-12-23 11:00:00	ES	Futures	5339.87	5344.11	5336.48	5342.41	87068.0
2021-12-23 12:00:00	ES	Futures	5342.41	5342.41	5337.61	5339.87	48759.0
2021-12-23 13:00:00	ES	Futures	5339.59	5343.55	5335.91	5342.13	44523.0
2021-12-23 14:00:00	ES	Futures	5342.41	5348.07	5341.0	5347.79	51612.0
2021-12-23 15:00:00	ES	Futures	5347.79	5352.03	5333.36	5333.65	207447.0
2021-12-23 16:00:00	ES	Futures	5333.93	5337.89	5332.52	5335.63	56718.0
2021-12-23 00:00:00	NQ	Futures	18749.14	18758.99	18749.14	18754.65	1055.0
2021-12-23 01:00:00	NQ	Futures	18755.52	18768.56	18742.48	18754.65	2736.0
2021-12-23 02:00:00	NQ	Futures	18754.94	18760.15	18741.03	18754.07	2233.0
2021-12-23 03:00:00	NQ	Futures	18754.94	18761.6	18716.68	18750.88	6373.0
2021-12-23 04:00:00	NQ	Futures	18750.88	18761.31	18742.77	18756.68	2421.0
2021-12-23 05:00:00	NQ	Futures	18756.39	18784.5	18750.3	18776.96	2715.0
2021-12-23 06:00:00	NQ	Futures	18777.25	18788.27	18768.27	18783.34	2686.0
2021-12-23 07:00:00	NQ	Futures	18783.92	18796.67	18774.93	18794.64	4193.0
2021-12-23 08:00:00	NQ	Futures	18794.64	18804.21	18745.66	18772.33	10248.0
2021-12-23 09:00:00	NQ	Futures	18772.91	18830.0	18752.91	18818.7	66819.0
2021-12-23 10:00:00	NQ	Futures	18820.73	18889.7	18810.0	18888.83	60726.0
2021-12-23 11:00:00	NQ	Futures	18888.54	18920.71	18883.04	18919.26	36977.0
2021-12-23 12:00:00	NQ	Futures	18918.97	18923.03	18895.79	18917.81	24942.0
2021-12-23 13:00:00	NQ	Futures	18918.1	18937.23	18894.92	18927.67	20834.0
2021-12-23 14:00:00	NQ	Futures	18928.25	18941.87	18911.15	18939.26	19747.0
2021-12-23 15:00:00	NQ	Futures	18938.68	18961.0	18887.09	18888.83	53707.0
2021-12-23 16:00:00	NQ	Futures	18888.83	18901.87	18879.56	18899.56	11248.0
2021-12-23 00:00:00	YM	Futures	40062.4	40080.3	40060.1	40070.2	391.0
2021-12-23 01:00:00	YM	Futures	40073.6	40099.4	40055.6	40072.5	738.0
2021-12-23 02:00:00	YM	Futures	40073.6	40091.6	40056.7	40083.7	1437.0
2021-12-23 03:00:00	YM	Futures	40084.8	40144.4	40046.6	40135.4	4054.0
2021-12-23 04:00:00	YM	Futures	40133.2	40154.5	40097.2	40111.8	2201.0
2021-12-23 05:00:00	YM	Futures	40111.8	40166.9	40103.9	40153.4	1326.0
2021-12-23 06:00:00	YM	Futures	40154.5	40174.7	40146.6	40165.7	1615.0
2021-12-23 07:00:00	YM	Futures	40166.9	40190.5	40155.6	40174.7	1655.0
2021-12-23 08:00:00	YM	Futures	40177.0	40198.3	40111.8	40138.8	3115.0
2021-12-23 09:00:00	YM	Futures	40137.6	40324.2	40116.3	40266.9	17799.0
2021-12-23 10:00:00	YM	Futures	40266.9	40327.6	40243.3	40296.1	13101.0
2021-12-23 11:00:00	YM	Futures	40293.9	40316.3	40254.5	40313.0	7476.0
2021-12-23 12:00:00	YM	Futures	40311.8	40311.8	40270.3	40290.5	4081.0
2021-12-23 13:00:00	YM	Futures	40290.5	40319.7	40268.0	40313.0	5563.0
2021-12-23 14:00:00	YM	Futures	40315.2	40379.3	40310.7	40370.3	5990.0
2021-12-23 15:00:00	YM	Futures	40369.2	40396.1	40256.8	40265.8	12414.0

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

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