PREVIEW / futures_1hour / 2023-11-09

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-11-09.parquet
  size:    69 KB
  rows:    2,096

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-09 00:00:00	ES	Futures	4775.63	4777.53	4774.0	4774.27	4330.0
2023-11-09 01:00:00	ES	Futures	4774.27	4779.43	4773.45	4779.16	6315.0
2023-11-09 02:00:00	ES	Futures	4779.16	4779.43	4774.81	4776.98	6165.0
2023-11-09 03:00:00	ES	Futures	4776.98	4784.59	4772.1	4779.43	20950.0
2023-11-09 04:00:00	ES	Futures	4779.43	4781.87	4776.17	4779.7	12366.0
2023-11-09 05:00:00	ES	Futures	4779.7	4790.29	4779.16	4789.2	18779.0
2023-11-09 06:00:00	ES	Futures	4788.93	4789.75	4780.51	4781.33	14254.0
2023-11-09 07:00:00	ES	Futures	4781.06	4785.94	4781.06	4785.94	13016.0
2023-11-09 08:00:00	ES	Futures	4785.67	4792.73	4784.86	4791.38	39032.0
2023-11-09 09:00:00	ES	Futures	4791.38	4793.55	4773.18	4783.23	175793.0
2023-11-09 10:00:00	ES	Futures	4782.96	4786.22	4763.41	4772.91	238570.0
2023-11-09 11:00:00	ES	Futures	4772.91	4785.4	4772.64	4782.41	173691.0
2023-11-09 12:00:00	ES	Futures	4782.41	4783.23	4774.54	4780.24	110418.0
2023-11-09 13:00:00	ES	Futures	4779.97	4781.06	4753.09	4756.62	367354.0
2023-11-09 14:00:00	ES	Futures	4756.34	4756.34	4736.52	4738.97	319182.0
2023-11-09 15:00:00	ES	Futures	4738.97	4744.12	4733.53	4739.24	304117.0
2023-11-09 16:00:00	ES	Futures	4738.97	4743.04	4738.42	4741.14	51797.0
2023-11-09 18:00:00	ES	Futures	4740.87	4741.41	4732.99	4736.25	9224.0
2023-11-09 19:00:00	ES	Futures	4735.98	4736.52	4729.73	4736.25	13539.0
2023-11-09 20:00:00	ES	Futures	4736.52	4740.59	4735.98	4739.24	9533.0
2023-11-09 21:00:00	ES	Futures	4738.97	4741.41	4737.34	4739.51	8515.0
2023-11-09 22:00:00	ES	Futures	4739.51	4741.41	4738.97	4740.05	4492.0
2023-11-09 23:00:00	ES	Futures	4740.05	4743.58	4739.78	4742.5	5418.0
2023-11-09 00:00:00	NQ	Futures	16888.55	16898.99	16883.33	16884.98	3176.0
2023-11-09 01:00:00	NQ	Futures	16884.98	16911.07	16879.21	16908.88	5051.0
2023-11-09 02:00:00	NQ	Futures	16909.15	16909.98	16891.02	16897.07	4473.0
2023-11-09 03:00:00	NQ	Futures	16896.79	16916.84	16876.74	16889.1	10186.0
2023-11-09 04:00:00	NQ	Futures	16889.1	16896.24	16877.84	16889.93	8824.0
2023-11-09 05:00:00	NQ	Futures	16889.93	16921.24	16887.73	16913.27	7935.0
2023-11-09 06:00:00	NQ	Futures	16913.27	16915.74	16878.39	16882.23	9607.0
2023-11-09 07:00:00	NQ	Futures	16881.69	16902.29	16880.86	16901.46	7661.0
2023-11-09 08:00:00	NQ	Futures	16901.19	16924.26	16893.22	16922.61	19927.0
2023-11-09 09:00:00	NQ	Futures	16923.16	16944.58	16881.41	16944.58	79642.0
2023-11-09 10:00:00	NQ	Futures	16944.31	16955.3	16859.99	16906.95	104208.0
2023-11-09 11:00:00	NQ	Futures	16907.23	16978.37	16904.48	16966.01	71545.0
2023-11-09 12:00:00	NQ	Futures	16966.56	16967.93	16898.17	16936.07	47597.0
2023-11-09 13:00:00	NQ	Futures	16936.34	16939.36	16814.94	16856.42	112827.0
2023-11-09 14:00:00	NQ	Futures	16855.87	16855.87	16759.73	16767.15	98729.0
2023-11-09 15:00:00	NQ	Futures	16767.42	16780.61	16739.96	16763.85	76348.0
2023-11-09 16:00:00	NQ	Futures	16764.13	16769.9	16757.26	16760.56	14110.0
2023-11-09 18:00:00	NQ	Futures	16759.73	16759.73	16725.68	16735.56	4907.0
2023-11-09 19:00:00	NQ	Futures	16735.29	16737.49	16708.1	16735.84	7826.0
2023-11-09 20:00:00	NQ	Futures	16735.56	16751.22	16733.64	16745.45	5959.0
2023-11-09 21:00:00	NQ	Futures	16745.18	16750.67	16736.66	16743.53	3466.0
2023-11-09 22:00:00	NQ	Futures	16743.53	16749.85	16738.31	16742.98	2452.0
2023-11-09 23:00:00	NQ	Futures	16742.71	16758.91	16741.61	16752.32	2652.0
2023-11-09 00:00:00	YM	Futures	37071.7	37084.8	37060.9	37062.0	520.0
2023-11-09 01:00:00	YM	Futures	37060.9	37092.3	37056.5	37088.0	1005.0
2023-11-09 02:00:00	YM	Futures	37088.0	37091.3	37058.7	37073.9	1594.0
2023-11-09 03:00:00	YM	Futures	37072.8	37134.7	37038.1	37103.2	4183.0

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

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