PREVIEW / futures_1hour / 2023-11-08

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-11-08.parquet
  size:    68 KB
  rows:    2,110

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-11-08 00:00:00	ES	Futures	4771.55	4772.64	4768.29	4768.84	4698.0
2023-11-08 01:00:00	ES	Futures	4768.84	4769.92	4766.66	4767.48	7616.0
2023-11-08 02:00:00	ES	Futures	4767.48	4769.11	4765.85	4767.48	7273.0
2023-11-08 03:00:00	ES	Futures	4767.48	4774.27	4766.12	4772.1	16679.0
2023-11-08 04:00:00	ES	Futures	4772.1	4774.0	4768.84	4771.82	14418.0
2023-11-08 05:00:00	ES	Futures	4771.82	4774.0	4769.38	4772.91	9143.0
2023-11-08 06:00:00	ES	Futures	4772.91	4778.07	4772.64	4776.17	12718.0
2023-11-08 07:00:00	ES	Futures	4775.9	4778.34	4773.18	4777.25	11660.0
2023-11-08 08:00:00	ES	Futures	4777.53	4780.79	4774.81	4778.34	25055.0
2023-11-08 09:00:00	ES	Futures	4778.07	4787.85	4778.07	4783.5	156441.0
2023-11-08 10:00:00	ES	Futures	4783.77	4784.86	4770.19	4771.01	211614.0
2023-11-08 11:00:00	ES	Futures	4771.28	4777.53	4765.03	4765.58	168393.0
2023-11-08 12:00:00	ES	Futures	4765.58	4766.39	4752.27	4762.59	159919.0
2023-11-08 13:00:00	ES	Futures	4762.86	4772.37	4760.42	4770.74	139964.0
2023-11-08 14:00:00	ES	Futures	4771.01	4777.53	4769.38	4770.47	104946.0
2023-11-08 15:00:00	ES	Futures	4770.47	4784.59	4770.19	4777.8	196617.0
2023-11-08 16:00:00	ES	Futures	4777.8	4778.07	4772.1	4772.37	40668.0
2023-11-08 18:00:00	ES	Futures	4772.1	4772.1	4768.84	4771.55	5599.0
2023-11-08 19:00:00	ES	Futures	4771.55	4773.45	4769.92	4771.28	5126.0
2023-11-08 20:00:00	ES	Futures	4771.28	4777.53	4771.01	4775.35	7538.0
2023-11-08 21:00:00	ES	Futures	4775.35	4777.25	4774.27	4774.54	4114.0
2023-11-08 22:00:00	ES	Futures	4774.27	4774.81	4772.1	4772.91	3700.0
2023-11-08 23:00:00	ES	Futures	4773.18	4775.9	4772.91	4775.63	2779.0
2023-11-08 00:00:00	NQ	Futures	16873.72	16876.74	16859.99	16863.28	4006.0
2023-11-08 01:00:00	NQ	Futures	16863.01	16865.48	16852.3	16855.32	4587.0
2023-11-08 02:00:00	NQ	Futures	16855.32	16863.56	16849.27	16856.14	4428.0
2023-11-08 03:00:00	NQ	Futures	16856.14	16884.43	16852.02	16869.87	9026.0
2023-11-08 04:00:00	NQ	Futures	16869.87	16883.33	16856.97	16874.27	7172.0
2023-11-08 05:00:00	NQ	Futures	16874.27	16884.98	16863.01	16880.86	5465.0
2023-11-08 06:00:00	NQ	Futures	16881.14	16895.42	16874.82	16884.98	7643.0
2023-11-08 07:00:00	NQ	Futures	16884.71	16895.97	16871.8	16893.77	7694.0
2023-11-08 08:00:00	NQ	Futures	16894.05	16906.95	16879.49	16891.02	15610.0
2023-11-08 09:00:00	NQ	Futures	16891.02	16938.54	16888.55	16908.33	76090.0
2023-11-08 10:00:00	NQ	Futures	16908.05	16914.37	16848.18	16857.51	98366.0
2023-11-08 11:00:00	NQ	Futures	16857.51	16885.81	16842.96	16850.92	77277.0
2023-11-08 12:00:00	NQ	Futures	16851.2	16853.94	16794.89	16841.31	55562.0
2023-11-08 13:00:00	NQ	Futures	16841.86	16883.06	16830.87	16873.72	48336.0
2023-11-08 14:00:00	NQ	Futures	16873.99	16905.03	16864.66	16869.33	39361.0
2023-11-08 15:00:00	NQ	Futures	16869.6	16913.27	16867.95	16901.46	48045.0
2023-11-08 16:00:00	NQ	Futures	16901.46	16902.56	16873.99	16874.82	10805.0
2023-11-08 18:00:00	NQ	Futures	16871.25	16874.27	16859.16	16873.17	3542.0
2023-11-08 19:00:00	NQ	Futures	16872.9	16881.41	16867.4	16870.7	3099.0
2023-11-08 20:00:00	NQ	Futures	16870.97	16894.32	16867.68	16885.26	4447.0
2023-11-08 21:00:00	NQ	Futures	16884.98	16891.02	16881.14	16881.14	2737.0
2023-11-08 22:00:00	NQ	Futures	16881.41	16884.16	16876.19	16879.76	2376.0
2023-11-08 23:00:00	NQ	Futures	16880.04	16889.1	16879.76	16888.83	1934.0
2023-11-08 00:00:00	YM	Futures	37091.3	37097.8	37070.6	37076.1	554.0
2023-11-08 01:00:00	YM	Futures	37075.0	37086.9	37060.9	37070.6	1310.0
2023-11-08 02:00:00	YM	Futures	37068.5	37082.6	37059.8	37078.2	1511.0
2023-11-08 03:00:00	YM	Futures	37078.2	37134.7	37070.6	37121.6	3081.0

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

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