PREVIEW / futures_1hour / 2023-10-12

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-10-12.parquet
  size:    68 KB
  rows:    2,051

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-10-12 00:00:00	ES	Futures	4803.05	4804.68	4802.51	4804.41	3615.0
2023-10-12 01:00:00	ES	Futures	4804.41	4804.95	4802.24	4804.14	4807.0
2023-10-12 02:00:00	ES	Futures	4803.87	4809.57	4803.32	4808.48	11227.0
2023-10-12 03:00:00	ES	Futures	4808.48	4808.48	4799.52	4800.61	18797.0
2023-10-12 04:00:00	ES	Futures	4800.61	4806.85	4799.25	4806.85	13267.0
2023-10-12 05:00:00	ES	Futures	4806.85	4809.03	4805.23	4807.94	8884.0
2023-10-12 06:00:00	ES	Futures	4807.94	4811.47	4807.4	4808.21	13574.0
2023-10-12 07:00:00	ES	Futures	4808.21	4809.84	4805.5	4808.76	14569.0
2023-10-12 08:00:00	ES	Futures	4808.48	4812.56	4787.85	4795.18	121262.0
2023-10-12 09:00:00	ES	Futures	4795.18	4797.08	4773.18	4777.25	223286.0
2023-10-12 10:00:00	ES	Futures	4777.25	4791.38	4772.1	4784.86	251217.0
2023-10-12 11:00:00	ES	Futures	4784.86	4793.28	4779.43	4789.47	149486.0
2023-10-12 12:00:00	ES	Futures	4789.47	4798.44	4786.22	4789.2	134497.0
2023-10-12 13:00:00	ES	Futures	4789.47	4789.47	4743.31	4744.4	302416.0
2023-10-12 14:00:00	ES	Futures	4744.4	4754.72	4731.09	4750.1	231267.0
2023-10-12 15:00:00	ES	Futures	4750.37	4764.76	4749.56	4758.52	244993.0
2023-10-12 16:00:00	ES	Futures	4758.25	4762.05	4756.89	4758.52	48793.0
2023-10-12 18:00:00	ES	Futures	4758.52	4760.15	4755.8	4759.6	4557.0
2023-10-12 19:00:00	ES	Futures	4759.6	4762.32	4757.7	4760.96	4072.0
2023-10-12 20:00:00	ES	Futures	4760.96	4763.41	4759.06	4762.32	7022.0
2023-10-12 21:00:00	ES	Futures	4762.05	4764.76	4760.15	4763.68	7100.0
2023-10-12 22:00:00	ES	Futures	4763.41	4766.94	4762.32	4762.86	6615.0
2023-10-12 23:00:00	ES	Futures	4763.13	4765.03	4762.05	4763.13	3246.0
2023-10-12 00:00:00	NQ	Futures	16946.51	16952.27	16943.21	16950.9	2506.0
2023-10-12 01:00:00	NQ	Futures	16950.35	16951.72	16939.91	16949.53	2832.0
2023-10-12 02:00:00	NQ	Futures	16949.8	16972.05	16947.06	16967.93	6949.0
2023-10-12 03:00:00	NQ	Futures	16967.66	16969.03	16934.15	16942.11	9766.0
2023-10-12 04:00:00	NQ	Futures	16942.11	16960.51	16934.97	16960.24	7384.0
2023-10-12 05:00:00	NQ	Futures	16960.51	16966.28	16949.8	16958.59	4761.0
2023-10-12 06:00:00	NQ	Futures	16958.87	16971.5	16955.02	16957.77	6866.0
2023-10-12 07:00:00	NQ	Futures	16957.22	16965.73	16943.76	16958.32	7659.0
2023-10-12 08:00:00	NQ	Futures	16958.32	16969.85	16877.02	16909.15	51451.0
2023-10-12 09:00:00	NQ	Futures	16909.7	16937.17	16881.96	16903.66	86659.0
2023-10-12 10:00:00	NQ	Futures	16903.66	16986.33	16892.4	16951.45	112953.0
2023-10-12 11:00:00	NQ	Futures	16951.72	16992.92	16919.31	16966.83	69855.0
2023-10-12 12:00:00	NQ	Futures	16966.83	16994.85	16947.6	16958.32	55406.0
2023-10-12 13:00:00	NQ	Futures	16958.59	16962.16	16784.18	16788.57	113571.0
2023-10-12 14:00:00	NQ	Futures	16788.57	16811.92	16717.44	16786.1	89138.0
2023-10-12 15:00:00	NQ	Futures	16786.1	16847.63	16782.53	16826.2	78014.0
2023-10-12 16:00:00	NQ	Futures	16826.2	16842.68	16824.28	16835.82	13011.0
2023-10-12 18:00:00	NQ	Futures	16835.82	16838.56	16824.01	16836.37	2426.0
2023-10-12 19:00:00	NQ	Futures	16835.82	16849.55	16829.5	16842.41	2796.0
2023-10-12 20:00:00	NQ	Futures	16842.96	16854.49	16831.42	16844.61	4399.0
2023-10-12 21:00:00	NQ	Futures	16844.61	16851.47	16835.54	16847.63	4131.0
2023-10-12 22:00:00	NQ	Futures	16847.08	16859.44	16839.94	16841.86	3575.0
2023-10-12 23:00:00	NQ	Futures	16841.86	16849.0	16835.27	16840.76	2115.0
2023-10-12 00:00:00	YM	Futures	36943.7	36953.5	36941.6	36952.4	679.0
2023-10-12 01:00:00	YM	Futures	36951.3	36957.8	36940.5	36953.5	795.0
2023-10-12 02:00:00	YM	Futures	36953.5	36987.1	36947.0	36984.9	2416.0
2023-10-12 03:00:00	YM	Futures	36983.9	36983.9	36918.8	36927.5	2807.0

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

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