PREVIEW / futures_1hour / 2023-09-04

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-09-04.parquet
  size:    50 KB
  rows:    1,563

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-09-04 00:00:00	ES	Futures	4965.36	4965.91	4964.81	4965.64	1030.0
2023-09-04 01:00:00	ES	Futures	4965.64	4969.48	4964.54	4968.66	4104.0
2023-09-04 02:00:00	ES	Futures	4968.93	4970.03	4965.64	4968.66	5067.0
2023-09-04 03:00:00	ES	Futures	4968.66	4974.42	4967.83	4971.95	13575.0
2023-09-04 04:00:00	ES	Futures	4971.95	4975.24	4971.13	4973.32	6504.0
2023-09-04 05:00:00	ES	Futures	4973.6	4974.42	4971.4	4973.6	5651.0
2023-09-04 06:00:00	ES	Futures	4973.6	4975.52	4971.4	4973.6	4591.0
2023-09-04 07:00:00	ES	Futures	4973.6	4974.15	4970.03	4971.68	4434.0
2023-09-04 08:00:00	ES	Futures	4971.4	4975.52	4968.66	4970.03	8909.0
2023-09-04 09:00:00	ES	Futures	4970.03	4972.22	4968.11	4970.58	11862.0
2023-09-04 10:00:00	ES	Futures	4970.3	4970.85	4958.22	4958.22	20309.0
2023-09-04 11:00:00	ES	Futures	4958.5	4962.34	4957.95	4961.52	10490.0
2023-09-04 12:00:00	ES	Futures	4961.52	4964.26	4960.97	4961.79	5185.0
2023-09-04 18:00:00	ES	Futures	4963.17	4964.81	4960.15	4961.79	2963.0
2023-09-04 19:00:00	ES	Futures	4961.79	4964.54	4960.97	4963.17	2297.0
2023-09-04 20:00:00	ES	Futures	4962.89	4963.72	4955.48	4956.03	7443.0
2023-09-04 21:00:00	ES	Futures	4956.03	4959.87	4954.93	4957.13	5664.0
2023-09-04 22:00:00	ES	Futures	4956.85	4958.5	4955.48	4957.68	3888.0
2023-09-04 23:00:00	ES	Futures	4957.68	4957.95	4955.48	4956.3	2345.0
2023-09-04 00:00:00	NQ	Futures	17281.68	17283.63	17278.9	17281.68	650.0
2023-09-04 01:00:00	NQ	Futures	17281.4	17297.53	17276.39	17295.31	2800.0
2023-09-04 02:00:00	NQ	Futures	17295.86	17300.87	17281.96	17295.31	2932.0
2023-09-04 03:00:00	NQ	Futures	17295.31	17315.33	17291.41	17305.04	5168.0
2023-09-04 04:00:00	NQ	Futures	17304.76	17320.34	17299.48	17308.66	3336.0
2023-09-04 05:00:00	NQ	Futures	17308.38	17318.11	17300.59	17317.56	2457.0
2023-09-04 06:00:00	NQ	Futures	17317.56	17322.56	17302.82	17311.44	2710.0
2023-09-04 07:00:00	NQ	Futures	17311.99	17317.84	17300.31	17305.6	2623.0
2023-09-04 08:00:00	NQ	Futures	17305.04	17314.78	17295.31	17301.43	3529.0
2023-09-04 09:00:00	NQ	Futures	17301.7	17331.46	17295.86	17328.68	9247.0
2023-09-04 10:00:00	NQ	Futures	17328.13	17331.74	17264.71	17265.82	14613.0
2023-09-04 11:00:00	NQ	Futures	17265.82	17277.23	17257.76	17268.33	8827.0
2023-09-04 12:00:00	NQ	Futures	17268.61	17281.96	17268.33	17270.55	4489.0
2023-09-04 18:00:00	NQ	Futures	17275.0	17282.79	17259.71	17266.94	2026.0
2023-09-04 19:00:00	NQ	Futures	17266.38	17280.57	17261.37	17273.06	1685.0
2023-09-04 20:00:00	NQ	Futures	17272.78	17277.51	17235.23	17238.85	5224.0
2023-09-04 21:00:00	NQ	Futures	17238.85	17256.09	17230.78	17241.07	4878.0
2023-09-04 22:00:00	NQ	Futures	17241.35	17254.42	17235.51	17250.25	3920.0
2023-09-04 23:00:00	NQ	Futures	17249.97	17250.53	17237.73	17243.3	1997.0
2023-09-04 00:00:00	YM	Futures	38213.7	38214.8	38208.2	38213.7	157.0
2023-09-04 01:00:00	YM	Futures	38212.6	38234.5	38208.2	38231.2	538.0
2023-09-04 02:00:00	YM	Futures	38232.3	38243.3	38213.7	38237.8	1474.0
2023-09-04 03:00:00	YM	Futures	38238.9	38291.5	38232.3	38277.3	2101.0
2023-09-04 04:00:00	YM	Futures	38277.3	38300.3	38271.8	38292.6	1232.0
2023-09-04 05:00:00	YM	Futures	38293.7	38293.7	38268.5	38276.2	1007.0
2023-09-04 06:00:00	YM	Futures	38274.0	38294.8	38263.0	38274.0	884.0
2023-09-04 07:00:00	YM	Futures	38274.0	38280.5	38256.4	38266.3	700.0
2023-09-04 08:00:00	YM	Futures	38266.3	38310.1	38252.1	38259.7	1667.0
2023-09-04 09:00:00	YM	Futures	38259.7	38264.1	38217.0	38220.3	2750.0
2023-09-04 10:00:00	YM	Futures	38220.3	38221.4	38114.0	38117.3	5227.0
2023-09-04 11:00:00	YM	Futures	38119.5	38158.9	38114.0	38152.4	2594.0

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

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