PREVIEW / futures_1hour / 2023-10-11

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-10-11.parquet
  size:    67 KB
  rows:    2,053

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-11 00:00:00	ES	Futures	4772.37	4774.0	4771.01	4771.28	2745.0
2023-10-11 01:00:00	ES	Futures	4771.28	4773.18	4770.19	4770.47	5321.0
2023-10-11 02:00:00	ES	Futures	4770.47	4773.18	4766.39	4770.19	9863.0
2023-10-11 03:00:00	ES	Futures	4770.19	4779.43	4770.19	4772.37	24827.0
2023-10-11 04:00:00	ES	Futures	4772.37	4778.61	4769.11	4777.53	20146.0
2023-10-11 05:00:00	ES	Futures	4777.53	4781.33	4774.27	4779.16	11661.0
2023-10-11 06:00:00	ES	Futures	4779.43	4782.69	4777.25	4781.6	12465.0
2023-10-11 07:00:00	ES	Futures	4781.6	4788.93	4781.06	4784.86	20887.0
2023-10-11 08:00:00	ES	Futures	4784.59	4787.85	4773.45	4787.85	79764.0
2023-10-11 09:00:00	ES	Futures	4787.57	4790.83	4777.8	4780.51	194048.0
2023-10-11 10:00:00	ES	Futures	4780.51	4781.6	4769.11	4780.24	197766.0
2023-10-11 11:00:00	ES	Futures	4780.51	4784.04	4766.12	4768.84	167608.0
2023-10-11 12:00:00	ES	Futures	4768.84	4769.92	4758.79	4765.31	134700.0
2023-10-11 13:00:00	ES	Futures	4765.31	4768.02	4754.72	4761.78	112308.0
2023-10-11 14:00:00	ES	Futures	4762.05	4778.34	4761.23	4775.35	134543.0
2023-10-11 15:00:00	ES	Futures	4775.35	4791.92	4773.72	4788.93	181410.0
2023-10-11 16:00:00	ES	Futures	4788.93	4800.88	4788.66	4800.07	94477.0
2023-10-11 18:00:00	ES	Futures	4798.71	4798.98	4795.99	4798.71	4290.0
2023-10-11 19:00:00	ES	Futures	4798.44	4801.15	4797.89	4800.61	4374.0
2023-10-11 20:00:00	ES	Futures	4800.61	4803.6	4798.98	4801.97	7849.0
2023-10-11 21:00:00	ES	Futures	4801.7	4803.05	4800.34	4801.15	6561.0
2023-10-11 22:00:00	ES	Futures	4801.15	4801.97	4799.25	4800.34	4674.0
2023-10-11 23:00:00	ES	Futures	4800.61	4803.32	4800.34	4803.32	3525.0
2023-10-11 00:00:00	NQ	Futures	16806.43	16814.39	16798.74	16801.48	2254.0
2023-10-11 01:00:00	NQ	Futures	16801.76	16812.47	16797.64	16800.11	3509.0
2023-10-11 02:00:00	NQ	Futures	16799.84	16807.8	16783.08	16795.17	5419.0
2023-10-11 03:00:00	NQ	Futures	16794.89	16828.13	16794.34	16804.23	12133.0
2023-10-11 04:00:00	NQ	Futures	16804.23	16818.24	16780.06	16811.65	12483.0
2023-10-11 05:00:00	NQ	Futures	16811.37	16828.68	16798.74	16822.63	7441.0
2023-10-11 06:00:00	NQ	Futures	16823.18	16840.21	16810.0	16833.89	8581.0
2023-10-11 07:00:00	NQ	Futures	16833.89	16859.71	16833.34	16846.25	11824.0
2023-10-11 08:00:00	NQ	Futures	16846.25	16852.3	16792.14	16849.82	36341.0
2023-10-11 09:00:00	NQ	Futures	16849.27	16905.31	16827.03	16842.68	91698.0
2023-10-11 10:00:00	NQ	Futures	16842.41	16882.78	16810.0	16872.62	89404.0
2023-10-11 11:00:00	NQ	Futures	16872.9	16900.64	16800.66	16824.28	70345.0
2023-10-11 12:00:00	NQ	Futures	16823.73	16825.38	16782.81	16813.29	50797.0
2023-10-11 13:00:00	NQ	Futures	16813.57	16818.51	16757.81	16789.67	47306.0
2023-10-11 14:00:00	NQ	Futures	16788.3	16855.32	16783.9	16837.19	58194.0
2023-10-11 15:00:00	NQ	Futures	16837.19	16903.38	16826.2	16894.05	62782.0
2023-10-11 16:00:00	NQ	Futures	16894.32	16937.72	16891.02	16931.12	19200.0
2023-10-11 18:00:00	NQ	Futures	16927.55	16928.1	16916.84	16924.26	2641.0
2023-10-11 19:00:00	NQ	Futures	16924.26	16936.89	16921.24	16935.79	3271.0
2023-10-11 20:00:00	NQ	Futures	16935.52	16953.37	16930.85	16945.68	5452.0
2023-10-11 21:00:00	NQ	Futures	16945.68	16950.9	16936.89	16941.01	3663.0
2023-10-11 22:00:00	NQ	Futures	16941.01	16943.76	16932.5	16937.44	3012.0
2023-10-11 23:00:00	NQ	Futures	16937.44	16946.78	16935.79	16946.78	2081.0
2023-10-11 00:00:00	YM	Futures	36815.7	36826.6	36803.8	36807.0	570.0
2023-10-11 01:00:00	YM	Futures	36806.0	36820.1	36795.1	36797.3	885.0
2023-10-11 02:00:00	YM	Futures	36796.2	36820.1	36776.7	36800.5	2147.0
2023-10-11 03:00:00	YM	Futures	36799.5	36873.2	36795.1	36815.7	4338.0

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

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