PREVIEW / futures_1hour / 2023-08-16

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-08-16.parquet
  size:    67 KB
  rows:    2,033

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-08-16 00:00:00	ES	Futures	4892.89	4893.17	4888.77	4890.42	3885.0
2023-08-16 01:00:00	ES	Futures	4890.7	4892.34	4888.5	4889.6	5036.0
2023-08-16 02:00:00	ES	Futures	4889.6	4892.07	4884.38	4891.24	10466.0
2023-08-16 03:00:00	ES	Futures	4891.52	4901.4	4890.42	4897.83	18944.0
2023-08-16 04:00:00	ES	Futures	4898.11	4905.24	4897.83	4901.4	16278.0
2023-08-16 05:00:00	ES	Futures	4901.4	4901.95	4888.77	4892.07	16376.0
2023-08-16 06:00:00	ES	Futures	4891.79	4893.71	4888.22	4890.15	11637.0
2023-08-16 07:00:00	ES	Futures	4890.42	4892.89	4883.83	4892.62	16069.0
2023-08-16 08:00:00	ES	Futures	4892.34	4894.54	4880.26	4881.36	29681.0
2023-08-16 09:00:00	ES	Futures	4881.36	4903.32	4879.99	4895.64	160501.0
2023-08-16 10:00:00	ES	Futures	4895.91	4903.05	4889.6	4900.58	170839.0
2023-08-16 11:00:00	ES	Futures	4900.85	4903.05	4882.19	4884.93	123094.0
2023-08-16 12:00:00	ES	Futures	4884.66	4888.5	4875.87	4876.42	115650.0
2023-08-16 13:00:00	ES	Futures	4876.42	4886.03	4867.91	4881.91	115004.0
2023-08-16 14:00:00	ES	Futures	4882.46	4891.24	4866.54	4877.24	199343.0
2023-08-16 15:00:00	ES	Futures	4876.97	4876.97	4851.71	4852.81	319870.0
2023-08-16 16:00:00	ES	Futures	4853.09	4856.66	4850.07	4852.81	69604.0
2023-08-16 18:00:00	ES	Futures	4853.91	4857.48	4853.36	4853.91	4882.0
2023-08-16 19:00:00	ES	Futures	4854.19	4855.01	4851.17	4852.26	5203.0
2023-08-16 20:00:00	ES	Futures	4851.99	4852.26	4845.13	4847.32	13450.0
2023-08-16 21:00:00	ES	Futures	4847.6	4849.79	4841.83	4849.79	13486.0
2023-08-16 22:00:00	ES	Futures	4849.79	4853.91	4847.87	4852.26	10401.0
2023-08-16 23:00:00	ES	Futures	4851.99	4856.93	4851.17	4856.66	8336.0
2023-08-16 00:00:00	NQ	Futures	16823.32	16827.21	16797.73	16810.25	3361.0
2023-08-16 01:00:00	NQ	Futures	16810.25	16823.32	16802.18	16810.25	3650.0
2023-08-16 02:00:00	NQ	Futures	16809.97	16822.48	16789.39	16817.76	5948.0
2023-08-16 03:00:00	NQ	Futures	16818.03	16859.48	16811.91	16845.29	9440.0
2023-08-16 04:00:00	NQ	Futures	16845.01	16872.55	16844.46	16852.24	7100.0
2023-08-16 05:00:00	NQ	Futures	16853.63	16856.69	16803.57	16819.7	8252.0
2023-08-16 06:00:00	NQ	Futures	16819.7	16831.38	16806.07	16810.8	6088.0
2023-08-16 07:00:00	NQ	Futures	16810.25	16816.09	16773.81	16810.52	10669.0
2023-08-16 08:00:00	NQ	Futures	16810.25	16819.98	16759.07	16762.96	15315.0
2023-08-16 09:00:00	NQ	Futures	16762.69	16829.99	16744.61	16800.79	79216.0
2023-08-16 10:00:00	NQ	Futures	16800.79	16848.07	16766.86	16829.16	87062.0
2023-08-16 11:00:00	NQ	Futures	16829.72	16845.57	16725.14	16737.38	65646.0
2023-08-16 12:00:00	NQ	Futures	16737.38	16752.39	16694.54	16705.11	54874.0
2023-08-16 13:00:00	NQ	Futures	16705.11	16761.3	16673.68	16742.1	49510.0
2023-08-16 14:00:00	NQ	Futures	16742.1	16784.66	16669.23	16723.19	84093.0
2023-08-16 15:00:00	NQ	Futures	16722.63	16722.91	16619.17	16620.0	98274.0
2023-08-16 16:00:00	NQ	Futures	16620.0	16630.85	16600.54	16617.78	20252.0
2023-08-16 18:00:00	NQ	Futures	16621.4	16635.58	16618.89	16620.56	2737.0
2023-08-16 19:00:00	NQ	Futures	16621.12	16623.62	16605.54	16610.55	2954.0
2023-08-16 20:00:00	NQ	Futures	16609.71	16611.94	16574.11	16593.3	8745.0
2023-08-16 21:00:00	NQ	Futures	16593.03	16600.54	16562.71	16599.14	7909.0
2023-08-16 22:00:00	NQ	Futures	16600.54	16618.61	16591.64	16614.44	5548.0
2023-08-16 23:00:00	NQ	Futures	16614.16	16629.74	16611.1	16628.9	4916.0
2023-08-16 00:00:00	YM	Futures	38364.9	38366.0	38341.9	38351.8	441.0
2023-08-16 01:00:00	YM	Futures	38351.8	38366.0	38336.4	38345.2	2835.0
2023-08-16 02:00:00	YM	Futures	38345.2	38370.4	38306.8	38356.1	6006.0
2023-08-16 03:00:00	YM	Futures	38355.0	38429.5	38353.9	38409.8	8158.0

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

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