PREVIEW / futures_1hour / 2021-11-25

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-11-25.parquet
  size:    49 KB
  rows:    1,467

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-11-25 00:00:00	ES	Futures	5319.7	5322.81	5318.86	5322.81	3270.0
2021-11-25 01:00:00	ES	Futures	5322.81	5324.5	5322.81	5324.22	3955.0
2021-11-25 02:00:00	ES	Futures	5324.22	5324.78	5319.99	5320.55	4793.0
2021-11-25 03:00:00	ES	Futures	5320.55	5323.09	5317.73	5322.81	8674.0
2021-11-25 04:00:00	ES	Futures	5322.81	5323.09	5316.88	5317.16	4259.0
2021-11-25 05:00:00	ES	Futures	5317.16	5317.73	5313.78	5316.88	4924.0
2021-11-25 06:00:00	ES	Futures	5316.88	5318.29	5312.37	5317.45	4510.0
2021-11-25 07:00:00	ES	Futures	5317.16	5317.45	5313.5	5313.78	5403.0
2021-11-25 08:00:00	ES	Futures	5313.5	5314.34	5308.42	5309.83	6974.0
2021-11-25 09:00:00	ES	Futures	5309.54	5315.47	5306.44	5315.47	10987.0
2021-11-25 10:00:00	ES	Futures	5315.19	5315.47	5309.54	5310.39	7896.0
2021-11-25 11:00:00	ES	Futures	5310.39	5313.21	5309.26	5312.65	6505.0
2021-11-25 12:00:00	ES	Futures	5312.65	5314.06	5310.39	5311.8	3163.0
2021-11-25 18:00:00	ES	Futures	5314.34	5315.19	5289.79	5291.76	19027.0
2021-11-25 19:00:00	ES	Futures	5292.05	5292.05	5277.94	5282.45	18410.0
2021-11-25 20:00:00	ES	Futures	5282.73	5283.86	5267.21	5273.14	22373.0
2021-11-25 21:00:00	ES	Futures	5273.42	5274.27	5252.54	5259.03	24220.0
2021-11-25 22:00:00	ES	Futures	5258.75	5262.98	5250.56	5253.1	13416.0
2021-11-25 23:00:00	ES	Futures	5253.38	5257.62	5249.15	5252.82	13676.0
2021-11-25 00:00:00	NQ	Futures	19004.18	19027.66	19002.44	19026.21	3295.0
2021-11-25 01:00:00	NQ	Futures	19026.79	19038.67	19024.18	19037.51	2962.0
2021-11-25 02:00:00	NQ	Futures	19037.22	19039.54	19023.6	19023.89	2662.0
2021-11-25 03:00:00	NQ	Futures	19024.76	19053.74	19019.25	19050.84	6302.0
2021-11-25 04:00:00	NQ	Futures	19051.42	19053.16	19028.52	19030.26	2229.0
2021-11-25 05:00:00	NQ	Futures	19031.71	19034.61	19019.83	19022.73	2517.0
2021-11-25 06:00:00	NQ	Futures	19022.73	19027.66	18983.89	19009.98	4844.0
2021-11-25 07:00:00	NQ	Futures	19009.4	19025.05	18998.38	19003.31	3168.0
2021-11-25 08:00:00	NQ	Futures	19003.02	19012.3	18991.43	18999.54	3136.0
2021-11-25 09:00:00	NQ	Futures	18998.67	19031.13	18977.81	19028.52	9589.0
2021-11-25 10:00:00	NQ	Futures	19028.52	19032.87	19007.08	19010.56	7142.0
2021-11-25 11:00:00	NQ	Futures	19010.56	19024.18	19003.89	19019.25	4451.0
2021-11-25 12:00:00	NQ	Futures	19019.83	19029.1	19011.14	19017.22	2442.0
2021-11-25 18:00:00	NQ	Futures	19018.67	19027.08	18964.48	18978.1	5640.0
2021-11-25 19:00:00	NQ	Futures	18977.23	18981.57	18918.68	18935.78	9553.0
2021-11-25 20:00:00	NQ	Futures	18936.07	18940.71	18898.11	18921.0	10040.0
2021-11-25 21:00:00	NQ	Futures	18921.87	18925.06	18844.49	18881.3	11350.0
2021-11-25 22:00:00	NQ	Futures	18881.59	18905.35	18867.39	18881.01	7068.0
2021-11-25 23:00:00	NQ	Futures	18881.01	18896.37	18857.82	18881.88	7375.0
2021-11-25 00:00:00	YM	Futures	40204.7	40222.6	40199.1	40222.6	829.0
2021-11-25 01:00:00	YM	Futures	40222.6	40237.2	40219.3	40233.9	1134.0
2021-11-25 02:00:00	YM	Futures	40235.0	40240.6	40203.6	40213.7	1744.0
2021-11-25 03:00:00	YM	Futures	40212.6	40215.9	40167.7	40209.2	3017.0
2021-11-25 04:00:00	YM	Futures	40209.2	40209.2	40153.1	40158.7	1589.0
2021-11-25 05:00:00	YM	Futures	40157.6	40159.9	40120.6	40150.9	2303.0
2021-11-25 06:00:00	YM	Futures	40149.8	40177.8	40133.0	40174.4	1650.0
2021-11-25 07:00:00	YM	Futures	40174.4	40174.4	40140.8	40143.1	1421.0
2021-11-25 08:00:00	YM	Futures	40140.8	40140.8	40084.8	40096.0	1997.0
2021-11-25 09:00:00	YM	Futures	40094.9	40152.0	40076.9	40134.1	3336.0
2021-11-25 10:00:00	YM	Futures	40133.0	40133.0	40078.0	40093.7	2646.0
2021-11-25 11:00:00	YM	Futures	40094.9	40130.7	40088.1	40126.2	1750.0

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

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