PREVIEW / futures_1hour / 2023-01-10

all futures 1-hour files

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

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-01-10 00:00:00	ES	Futures	4364.66	4371.09	4363.26	4370.25	6181.0
2023-01-10 01:00:00	ES	Futures	4370.25	4373.61	4367.45	4371.37	6449.0
2023-01-10 02:00:00	ES	Futures	4371.37	4373.61	4366.34	4369.69	9597.0
2023-01-10 03:00:00	ES	Futures	4369.69	4379.48	4366.9	4371.09	23888.0
2023-01-10 04:00:00	ES	Futures	4371.09	4375.28	4364.38	4374.72	15861.0
2023-01-10 05:00:00	ES	Futures	4375.0	4378.36	4371.09	4373.61	12390.0
2023-01-10 06:00:00	ES	Futures	4373.89	4374.72	4360.46	4364.1	15158.0
2023-01-10 07:00:00	ES	Futures	4364.1	4364.66	4352.36	4358.51	29338.0
2023-01-10 08:00:00	ES	Futures	4358.23	4363.26	4352.64	4362.7	31286.0
2023-01-10 09:00:00	ES	Futures	4362.7	4392.34	4358.51	4383.11	291640.0
2023-01-10 10:00:00	ES	Futures	4382.83	4401.01	4358.79	4382.83	301461.0
2023-01-10 11:00:00	ES	Futures	4382.55	4387.87	4370.53	4379.76	146500.0
2023-01-10 12:00:00	ES	Futures	4379.48	4391.78	4369.13	4387.03	114852.0
2023-01-10 13:00:00	ES	Futures	4387.03	4396.81	4384.23	4395.97	99392.0
2023-01-10 14:00:00	ES	Futures	4395.97	4403.8	4392.34	4395.42	99406.0
2023-01-10 15:00:00	ES	Futures	4395.42	4408.84	4387.31	4408.56	180871.0
2023-01-10 16:00:00	ES	Futures	4408.56	4410.79	4405.48	4408.0	42694.0
2023-01-10 18:00:00	ES	Futures	4407.72	4410.23	4405.2	4409.4	5048.0
2023-01-10 19:00:00	ES	Futures	4409.4	4414.43	4408.84	4413.31	6424.0
2023-01-10 20:00:00	ES	Futures	4413.03	4413.59	4407.16	4410.23	6392.0
2023-01-10 21:00:00	ES	Futures	4410.23	4412.19	4407.72	4408.0	4042.0
2023-01-10 22:00:00	ES	Futures	4408.28	4410.23	4405.76	4409.67	3931.0
2023-01-10 23:00:00	ES	Futures	4409.67	4411.91	4408.0	4409.67	3963.0
2023-01-10 00:00:00	NQ	Futures	12682.75	12707.5	12675.92	12700.38	2863.0
2023-01-10 01:00:00	NQ	Futures	12700.1	12714.61	12692.42	12710.63	3372.0
2023-01-10 02:00:00	NQ	Futures	12710.63	12716.03	12689.86	12699.81	4728.0
2023-01-10 03:00:00	NQ	Futures	12699.81	12741.35	12694.41	12713.19	9335.0
2023-01-10 04:00:00	NQ	Futures	12713.47	12733.39	12694.98	12732.82	7614.0
2023-01-10 05:00:00	NQ	Futures	12731.96	12751.88	12718.31	12741.35	6965.0
2023-01-10 06:00:00	NQ	Futures	12741.92	12745.33	12673.36	12685.31	8929.0
2023-01-10 07:00:00	NQ	Futures	12685.87	12687.87	12624.71	12651.74	16163.0
2023-01-10 08:00:00	NQ	Futures	12650.6	12667.95	12627.55	12663.4	17057.0
2023-01-10 09:00:00	NQ	Futures	12663.12	12797.68	12651.74	12757.0	119469.0
2023-01-10 10:00:00	NQ	Futures	12757.85	12840.07	12655.15	12753.87	114650.0
2023-01-10 11:00:00	NQ	Futures	12754.72	12772.08	12708.92	12735.09	59327.0
2023-01-10 12:00:00	NQ	Futures	12735.66	12783.46	12696.4	12766.67	40306.0
2023-01-10 13:00:00	NQ	Futures	12767.24	12800.81	12754.15	12796.83	33074.0
2023-01-10 14:00:00	NQ	Futures	12796.54	12826.98	12785.16	12801.38	31849.0
2023-01-10 15:00:00	NQ	Futures	12801.38	12843.48	12764.96	12843.2	46587.0
2023-01-10 16:00:00	NQ	Futures	12842.92	12846.33	12833.24	12837.79	11047.0
2023-01-10 18:00:00	NQ	Futures	12839.22	12844.34	12824.42	12842.06	3080.0
2023-01-10 19:00:00	NQ	Futures	12842.06	12860.84	12841.21	12855.15	3572.0
2023-01-10 20:00:00	NQ	Futures	12855.15	12855.72	12827.84	12840.36	3040.0
2023-01-10 21:00:00	NQ	Futures	12840.64	12848.61	12831.25	12831.82	1958.0
2023-01-10 22:00:00	NQ	Futures	12832.39	12839.5	12825.56	12836.66	1934.0
2023-01-10 23:00:00	NQ	Futures	12836.66	12844.91	12828.98	12832.67	1899.0
2023-01-10 00:00:00	YM	Futures	37419.8	37463.2	37413.1	37458.8	876.0
2023-01-10 01:00:00	YM	Futures	37459.9	37475.5	37429.8	37455.4	916.0
2023-01-10 02:00:00	YM	Futures	37456.6	37472.2	37420.9	37445.4	1092.0
2023-01-10 03:00:00	YM	Futures	37448.8	37498.9	37423.1	37439.9	2447.0

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

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