PREVIEW / futures_1hour / 2023-10-16

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-10-16.parquet
  size:    66 KB
  rows:    2,058

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-16 00:00:00	ES	Futures	4743.31	4744.12	4741.14	4743.31	3632.0
2023-10-16 01:00:00	ES	Futures	4743.31	4743.31	4735.71	4741.14	7113.0
2023-10-16 02:00:00	ES	Futures	4741.14	4752.0	4740.32	4748.74	13270.0
2023-10-16 03:00:00	ES	Futures	4748.74	4749.83	4734.08	4737.61	26785.0
2023-10-16 04:00:00	ES	Futures	4737.61	4745.48	4730.0	4741.68	21675.0
2023-10-16 05:00:00	ES	Futures	4741.41	4745.21	4739.24	4741.68	13517.0
2023-10-16 06:00:00	ES	Futures	4741.68	4746.57	4736.25	4746.57	16637.0
2023-10-16 07:00:00	ES	Futures	4746.3	4753.9	4742.22	4749.01	24962.0
2023-10-16 08:00:00	ES	Futures	4749.28	4760.15	4743.85	4758.52	49565.0
2023-10-16 09:00:00	ES	Futures	4758.25	4768.56	4755.26	4763.41	212802.0
2023-10-16 10:00:00	ES	Futures	4763.41	4792.19	4757.97	4791.1	280967.0
2023-10-16 11:00:00	ES	Futures	4791.38	4794.91	4776.71	4781.87	158060.0
2023-10-16 12:00:00	ES	Futures	4781.87	4784.86	4776.44	4782.14	98287.0
2023-10-16 13:00:00	ES	Futures	4782.14	4791.65	4763.68	4787.3	192889.0
2023-10-16 14:00:00	ES	Futures	4787.57	4790.29	4777.8	4787.85	105910.0
2023-10-16 15:00:00	ES	Futures	4787.85	4792.73	4778.88	4782.14	278957.0
2023-10-16 16:00:00	ES	Futures	4781.87	4787.3	4778.61	4785.94	69748.0
2023-10-16 18:00:00	ES	Futures	4786.22	4786.76	4780.79	4781.33	4057.0
2023-10-16 19:00:00	ES	Futures	4781.33	4783.23	4776.44	4781.87	6721.0
2023-10-16 20:00:00	ES	Futures	4781.87	4783.77	4779.16	4780.51	7223.0
2023-10-16 21:00:00	ES	Futures	4780.51	4780.51	4776.44	4777.25	6653.0
2023-10-16 22:00:00	ES	Futures	4777.25	4778.61	4775.63	4776.17	4805.0
2023-10-16 23:00:00	ES	Futures	4776.17	4778.61	4771.82	4774.81	6557.0
2023-10-16 00:00:00	NQ	Futures	16659.21	16663.88	16652.07	16660.86	2189.0
2023-10-16 01:00:00	NQ	Futures	16661.4	16663.6	16629.54	16651.79	4461.0
2023-10-16 02:00:00	NQ	Futures	16651.52	16683.38	16648.77	16666.62	7430.0
2023-10-16 03:00:00	NQ	Futures	16665.8	16669.1	16595.49	16608.94	14195.0
2023-10-16 04:00:00	NQ	Futures	16608.12	16638.33	16571.04	16624.05	12131.0
2023-10-16 05:00:00	NQ	Futures	16623.5	16632.56	16607.3	16614.44	6967.0
2023-10-16 06:00:00	NQ	Futures	16614.16	16623.23	16579.83	16621.58	11199.0
2023-10-16 07:00:00	NQ	Futures	16621.85	16652.07	16602.63	16638.61	10950.0
2023-10-16 08:00:00	NQ	Futures	16639.16	16677.61	16617.18	16668.0	19500.0
2023-10-16 09:00:00	NQ	Futures	16668.27	16765.5	16660.86	16729.8	100994.0
2023-10-16 10:00:00	NQ	Futures	16729.52	16837.74	16710.02	16818.24	103366.0
2023-10-16 11:00:00	NQ	Futures	16818.51	16833.89	16771.0	16776.49	54500.0
2023-10-16 12:00:00	NQ	Futures	16777.04	16797.64	16761.11	16789.67	41734.0
2023-10-16 13:00:00	NQ	Futures	16789.67	16832.8	16712.77	16819.34	73374.0
2023-10-16 14:00:00	NQ	Futures	16819.34	16834.72	16792.42	16827.85	49929.0
2023-10-16 15:00:00	NQ	Futures	16828.68	16849.82	16791.87	16802.31	81132.0
2023-10-16 16:00:00	NQ	Futures	16802.03	16817.69	16787.2	16814.67	13276.0
2023-10-16 18:00:00	NQ	Futures	16815.77	16816.59	16793.52	16796.54	2272.0
2023-10-16 19:00:00	NQ	Futures	16796.26	16804.78	16778.14	16798.74	3375.0
2023-10-16 20:00:00	NQ	Futures	16799.01	16806.15	16785.28	16792.14	3820.0
2023-10-16 21:00:00	NQ	Futures	16792.14	16794.62	16782.81	16788.57	3294.0
2023-10-16 22:00:00	NQ	Futures	16788.3	16792.42	16783.63	16785.83	2393.0
2023-10-16 23:00:00	NQ	Futures	16785.83	16796.26	16768.52	16781.43	4897.0
2023-10-16 00:00:00	YM	Futures	36735.4	36737.6	36719.2	36737.6	746.0
2023-10-16 01:00:00	YM	Futures	36736.5	36740.9	36691.0	36721.3	1450.0
2023-10-16 02:00:00	YM	Futures	36720.3	36804.9	36715.9	36795.1	3750.0
2023-10-16 03:00:00	YM	Futures	36795.1	36809.2	36715.9	36747.4	5102.0

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

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