PREVIEW / futures_1hour / 2023-08-15

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-08-15.parquet
  size:    66 KB
  rows:    2,038

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-15 00:00:00	ES	Futures	4957.4	4959.05	4956.03	4956.85	2471.0
2023-08-15 01:00:00	ES	Futures	4957.13	4958.5	4952.46	4954.93	6221.0
2023-08-15 02:00:00	ES	Futures	4954.93	4958.77	4948.89	4948.89	10100.0
2023-08-15 03:00:00	ES	Futures	4949.17	4952.46	4924.19	4924.46	43536.0
2023-08-15 04:00:00	ES	Futures	4924.73	4932.42	4919.79	4931.05	24840.0
2023-08-15 05:00:00	ES	Futures	4930.77	4931.6	4923.64	4925.83	15849.0
2023-08-15 06:00:00	ES	Futures	4925.83	4929.13	4914.03	4920.34	26340.0
2023-08-15 07:00:00	ES	Futures	4920.34	4923.36	4909.91	4912.93	27375.0
2023-08-15 08:00:00	ES	Futures	4912.93	4921.44	4908.26	4913.75	56192.0
2023-08-15 09:00:00	ES	Futures	4913.75	4931.32	4912.38	4915.68	207441.0
2023-08-15 10:00:00	ES	Futures	4915.68	4915.95	4895.64	4901.13	235485.0
2023-08-15 11:00:00	ES	Futures	4901.13	4915.4	4900.85	4914.3	127486.0
2023-08-15 12:00:00	ES	Futures	4914.58	4917.05	4899.75	4903.32	107349.0
2023-08-15 13:00:00	ES	Futures	4903.32	4909.64	4898.11	4902.22	87346.0
2023-08-15 14:00:00	ES	Futures	4902.5	4908.81	4898.66	4904.7	80070.0
2023-08-15 15:00:00	ES	Futures	4904.7	4906.07	4883.01	4890.7	272047.0
2023-08-15 16:00:00	ES	Futures	4890.7	4892.62	4887.95	4889.05	56703.0
2023-08-15 18:00:00	ES	Futures	4889.87	4892.34	4887.95	4891.52	4474.0
2023-08-15 19:00:00	ES	Futures	4891.52	4894.26	4890.97	4892.89	3272.0
2023-08-15 20:00:00	ES	Futures	4893.17	4893.44	4883.01	4889.05	11748.0
2023-08-15 21:00:00	ES	Futures	4888.77	4895.09	4886.58	4890.97	10788.0
2023-08-15 22:00:00	ES	Futures	4890.97	4894.54	4888.5	4891.52	5723.0
2023-08-15 23:00:00	ES	Futures	4891.79	4895.09	4891.52	4892.89	4318.0
2023-08-15 00:00:00	NQ	Futures	17043.88	17052.22	17039.43	17043.6	3013.0
2023-08-15 01:00:00	NQ	Futures	17044.15	17052.22	17024.69	17033.03	3827.0
2023-08-15 02:00:00	NQ	Futures	17032.75	17055.56	17002.99	17005.49	6820.0
2023-08-15 03:00:00	NQ	Futures	17006.05	17016.62	16912.6	16917.33	19568.0
2023-08-15 04:00:00	NQ	Futures	16917.6	16946.53	16896.74	16942.36	12933.0
2023-08-15 05:00:00	NQ	Futures	16942.08	16949.31	16913.99	16923.72	8229.0
2023-08-15 06:00:00	NQ	Futures	16923.72	16935.41	16865.04	16893.13	15038.0
2023-08-15 07:00:00	NQ	Futures	16892.57	16912.32	16866.43	16877.55	12316.0
2023-08-15 08:00:00	NQ	Futures	16878.39	16915.94	16856.97	16892.29	25842.0
2023-08-15 09:00:00	NQ	Futures	16892.57	16976.29	16882.84	16889.79	86993.0
2023-08-15 10:00:00	NQ	Futures	16890.35	16891.46	16807.46	16838.34	97444.0
2023-08-15 11:00:00	NQ	Futures	16839.17	16906.48	16838.34	16905.37	58391.0
2023-08-15 12:00:00	NQ	Futures	16905.37	16919.27	16852.52	16867.54	47981.0
2023-08-15 13:00:00	NQ	Futures	16867.82	16893.13	16841.12	16861.14	37552.0
2023-08-15 14:00:00	NQ	Futures	16861.7	16883.95	16842.51	16867.54	30000.0
2023-08-15 15:00:00	NQ	Futures	16867.54	16870.32	16771.03	16805.24	75675.0
2023-08-15 16:00:00	NQ	Futures	16805.52	16817.76	16795.23	16810.25	12631.0
2023-08-15 18:00:00	NQ	Futures	16811.08	16824.99	16809.41	16817.48	2656.0
2023-08-15 19:00:00	NQ	Futures	16816.64	16830.83	16812.19	16823.32	2145.0
2023-08-15 20:00:00	NQ	Futures	16824.15	16826.1	16779.37	16809.13	5965.0
2023-08-15 21:00:00	NQ	Futures	16809.69	16838.62	16801.62	16818.31	5961.0
2023-08-15 22:00:00	NQ	Futures	16819.15	16829.99	16804.96	16821.37	4373.0
2023-08-15 23:00:00	NQ	Futures	16821.37	16837.22	16819.7	16822.76	2903.0
2023-08-15 00:00:00	YM	Futures	38770.2	38776.8	38757.1	38761.5	421.0
2023-08-15 01:00:00	YM	Futures	38762.6	38770.2	38736.3	38749.4	1008.0
2023-08-15 02:00:00	YM	Futures	38749.4	38775.7	38710.0	38712.2	2254.0
2023-08-15 03:00:00	YM	Futures	38713.3	38747.2	38540.2	38543.5	8726.0

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

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