PREVIEW / futures_1hour / 2023-07-13

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-07-13.parquet
  size:    68 KB
  rows:    2,062

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-07-13 00:00:00	ES	Futures	4962.07	4963.17	4959.32	4959.87	8216.0
2023-07-13 01:00:00	ES	Futures	4959.6	4962.07	4958.5	4959.6	7301.0
2023-07-13 02:00:00	ES	Futures	4959.6	4962.34	4957.68	4960.42	8225.0
2023-07-13 03:00:00	ES	Futures	4960.15	4965.09	4957.95	4963.72	17469.0
2023-07-13 04:00:00	ES	Futures	4963.72	4967.28	4962.34	4966.46	14898.0
2023-07-13 05:00:00	ES	Futures	4966.46	4969.48	4962.89	4963.44	16953.0
2023-07-13 06:00:00	ES	Futures	4963.44	4967.01	4961.24	4965.64	10445.0
2023-07-13 07:00:00	ES	Futures	4965.64	4968.11	4962.89	4967.83	16714.0
2023-07-13 08:00:00	ES	Futures	4968.11	4970.85	4960.7	4967.83	43949.0
2023-07-13 09:00:00	ES	Futures	4967.83	4976.62	4964.54	4975.52	164336.0
2023-07-13 10:00:00	ES	Futures	4975.52	4976.07	4968.93	4974.97	149448.0
2023-07-13 11:00:00	ES	Futures	4975.24	4976.89	4969.48	4976.07	95727.0
2023-07-13 12:00:00	ES	Futures	4976.07	4981.28	4974.97	4977.99	85264.0
2023-07-13 13:00:00	ES	Futures	4977.99	4980.46	4972.77	4978.81	68331.0
2023-07-13 14:00:00	ES	Futures	4978.54	4985.4	4977.99	4985.4	84207.0
2023-07-13 15:00:00	ES	Futures	4985.4	4997.75	4984.3	4988.15	213040.0
2023-07-13 16:00:00	ES	Futures	4988.15	4989.24	4982.93	4984.58	51960.0
2023-07-13 18:00:00	ES	Futures	4984.58	4987.87	4983.48	4986.5	3938.0
2023-07-13 19:00:00	ES	Futures	4986.5	4988.42	4983.75	4985.68	3481.0
2023-07-13 20:00:00	ES	Futures	4985.95	4985.95	4979.09	4980.73	10960.0
2023-07-13 21:00:00	ES	Futures	4980.73	4983.48	4979.91	4982.93	7711.0
2023-07-13 22:00:00	ES	Futures	4983.21	4986.77	4982.93	4985.95	6886.0
2023-07-13 23:00:00	ES	Futures	4985.95	4988.15	4985.68	4987.05	4460.0
2023-07-13 00:00:00	NQ	Futures	17245.52	17294.19	17240.52	17241.91	6317.0
2023-07-13 01:00:00	NQ	Futures	17241.35	17254.14	17229.11	17243.3	4241.0
2023-07-13 02:00:00	NQ	Futures	17243.3	17264.99	17232.45	17250.25	4963.0
2023-07-13 03:00:00	NQ	Futures	17250.81	17280.57	17242.18	17271.39	7160.0
2023-07-13 04:00:00	NQ	Futures	17272.22	17296.7	17265.82	17294.19	7273.0
2023-07-13 05:00:00	NQ	Futures	17294.47	17310.6	17281.96	17292.53	6531.0
2023-07-13 06:00:00	NQ	Futures	17292.53	17308.94	17284.46	17298.64	6192.0
2023-07-13 07:00:00	NQ	Futures	17298.09	17304.76	17284.18	17302.54	7790.0
2023-07-13 08:00:00	NQ	Futures	17303.09	17334.52	17275.28	17308.66	25453.0
2023-07-13 09:00:00	NQ	Futures	17308.38	17379.3	17300.04	17362.06	84943.0
2023-07-13 10:00:00	NQ	Futures	17362.34	17369.57	17310.05	17365.67	88092.0
2023-07-13 11:00:00	NQ	Futures	17365.67	17394.88	17335.64	17390.15	54843.0
2023-07-13 12:00:00	NQ	Futures	17389.87	17425.47	17382.92	17413.23	51385.0
2023-07-13 13:00:00	NQ	Futures	17413.23	17435.21	17396.55	17422.97	34847.0
2023-07-13 14:00:00	NQ	Futures	17422.69	17451.62	17418.52	17447.17	46586.0
2023-07-13 15:00:00	NQ	Futures	17447.44	17512.53	17443.27	17473.31	79800.0
2023-07-13 16:00:00	NQ	Futures	17473.03	17480.54	17459.4	17466.36	15764.0
2023-07-13 18:00:00	NQ	Futures	17465.52	17484.44	17463.02	17475.26	2482.0
2023-07-13 19:00:00	NQ	Futures	17475.26	17487.77	17471.36	17480.26	3187.0
2023-07-13 20:00:00	NQ	Futures	17480.54	17481.38	17444.39	17458.01	6289.0
2023-07-13 21:00:00	NQ	Futures	17457.74	17483.05	17455.79	17478.04	5449.0
2023-07-13 22:00:00	NQ	Futures	17478.87	17498.62	17473.59	17493.06	4458.0
2023-07-13 23:00:00	NQ	Futures	17493.06	17498.9	17487.22	17493.34	2937.0
2023-07-13 00:00:00	YM	Futures	37920.1	37924.5	37889.4	37891.6	1442.0
2023-07-13 01:00:00	YM	Futures	37892.7	37909.2	37888.3	37888.3	1092.0
2023-07-13 02:00:00	YM	Futures	37889.4	37903.7	37871.9	37897.1	1582.0
2023-07-13 03:00:00	YM	Futures	37898.2	37930.0	37877.4	37922.3	2413.0

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

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