PREVIEW / futures_1hour / 2023-08-08

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-08-08.parquet
  size:    67 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-08-08 00:00:00	ES	Futures	4971.4	4974.42	4970.58	4973.32	2926.0
2023-08-08 01:00:00	ES	Futures	4973.6	4974.42	4965.91	4967.01	7008.0
2023-08-08 02:00:00	ES	Futures	4967.01	4967.56	4963.72	4965.64	12367.0
2023-08-08 03:00:00	ES	Futures	4965.64	4972.5	4963.17	4972.22	21853.0
2023-08-08 04:00:00	ES	Futures	4972.22	4973.32	4962.89	4967.56	15768.0
2023-08-08 05:00:00	ES	Futures	4967.56	4968.11	4956.03	4961.24	28762.0
2023-08-08 06:00:00	ES	Futures	4960.97	4963.44	4953.01	4955.48	26199.0
2023-08-08 07:00:00	ES	Futures	4955.48	4955.75	4942.58	4948.34	40908.0
2023-08-08 08:00:00	ES	Futures	4948.34	4951.91	4935.99	4948.62	53850.0
2023-08-08 09:00:00	ES	Futures	4948.62	4953.83	4930.5	4935.99	246954.0
2023-08-08 10:00:00	ES	Futures	4935.99	4939.56	4922.81	4924.46	306267.0
2023-08-08 11:00:00	ES	Futures	4924.46	4932.97	4921.44	4926.11	165035.0
2023-08-08 12:00:00	ES	Futures	4926.11	4940.38	4925.28	4935.99	117777.0
2023-08-08 13:00:00	ES	Futures	4936.26	4945.32	4935.71	4943.68	130132.0
2023-08-08 14:00:00	ES	Futures	4943.68	4958.22	4940.11	4955.75	141639.0
2023-08-08 15:00:00	ES	Futures	4955.75	4965.64	4953.56	4960.15	223036.0
2023-08-08 16:00:00	ES	Futures	4960.42	4961.79	4958.22	4960.15	45466.0
2023-08-08 18:00:00	ES	Futures	4959.32	4960.97	4958.22	4959.05	3312.0
2023-08-08 19:00:00	ES	Futures	4959.05	4960.7	4958.22	4959.32	2999.0
2023-08-08 20:00:00	ES	Futures	4959.32	4965.09	4958.22	4963.17	7246.0
2023-08-08 21:00:00	ES	Futures	4963.44	4968.11	4962.89	4965.09	7796.0
2023-08-08 22:00:00	ES	Futures	4965.09	4967.01	4963.44	4967.01	5227.0
2023-08-08 23:00:00	ES	Futures	4967.01	4967.28	4963.17	4963.99	3209.0
2023-08-08 00:00:00	NQ	Futures	17170.43	17184.05	17167.37	17179.6	1776.0
2023-08-08 01:00:00	NQ	Futures	17179.6	17182.66	17142.33	17146.78	4478.0
2023-08-08 02:00:00	NQ	Futures	17147.06	17152.9	17134.55	17142.89	6160.0
2023-08-08 03:00:00	NQ	Futures	17142.89	17176.82	17137.05	17175.71	8252.0
2023-08-08 04:00:00	NQ	Futures	17175.99	17182.66	17144.0	17169.31	7219.0
2023-08-08 05:00:00	NQ	Futures	17169.87	17171.82	17133.99	17156.8	8942.0
2023-08-08 06:00:00	NQ	Futures	17156.8	17165.14	17129.54	17141.78	8930.0
2023-08-08 07:00:00	NQ	Futures	17141.78	17145.67	17075.58	17100.89	18419.0
2023-08-08 08:00:00	NQ	Futures	17100.62	17125.65	17042.49	17105.9	25532.0
2023-08-08 09:00:00	NQ	Futures	17105.07	17119.53	16992.7	17014.95	95050.0
2023-08-08 10:00:00	NQ	Futures	17014.95	17030.25	16943.47	16945.7	123456.0
2023-08-08 11:00:00	NQ	Futures	16945.7	16989.36	16930.4	16948.76	71026.0
2023-08-08 12:00:00	NQ	Futures	16949.31	17013.28	16942.08	16992.14	46584.0
2023-08-08 13:00:00	NQ	Futures	16992.42	17028.02	16979.91	17022.46	49675.0
2023-08-08 14:00:00	NQ	Futures	17022.46	17071.69	17005.77	17060.84	46812.0
2023-08-08 15:00:00	NQ	Futures	17061.12	17099.5	17036.64	17077.53	69433.0
2023-08-08 16:00:00	NQ	Futures	17077.53	17087.82	17071.97	17078.36	11886.0
2023-08-08 18:00:00	NQ	Futures	17079.2	17088.1	17072.25	17076.42	2518.0
2023-08-08 19:00:00	NQ	Futures	17076.7	17083.37	17070.02	17080.87	1969.0
2023-08-08 20:00:00	NQ	Futures	17080.31	17112.3	17072.8	17101.73	5418.0
2023-08-08 21:00:00	NQ	Futures	17102.01	17127.32	17098.67	17113.97	5966.0
2023-08-08 22:00:00	NQ	Futures	17113.97	17122.31	17101.73	17120.64	4377.0
2023-08-08 23:00:00	NQ	Futures	17121.47	17122.59	17100.06	17103.67	2959.0
2023-08-08 00:00:00	YM	Futures	38882.0	38898.4	38873.2	38893.0	379.0
2023-08-08 01:00:00	YM	Futures	38894.0	38901.7	38846.9	38857.9	942.0
2023-08-08 02:00:00	YM	Futures	38857.9	38861.2	38833.8	38852.4	2460.0
2023-08-08 03:00:00	YM	Futures	38851.3	38886.4	38821.7	38883.1	3770.0

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

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