PREVIEW / futures_1hour / 2023-09-11

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-09-11.parquet
  size:    60 KB
  rows:    1,932

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-09-11 00:00:00	ES	Futures	4902.22	4908.26	4902.22	4908.26	2043.0
2023-09-11 01:00:00	ES	Futures	4907.99	4913.48	4907.99	4912.93	3588.0
2023-09-11 02:00:00	ES	Futures	4912.93	4915.4	4911.01	4913.75	5126.0
2023-09-11 03:00:00	ES	Futures	4913.48	4922.26	4913.48	4919.52	15028.0
2023-09-11 04:00:00	ES	Futures	4919.52	4920.62	4912.11	4913.75	8068.0
2023-09-11 05:00:00	ES	Futures	4913.75	4919.24	4913.48	4918.97	6208.0
2023-09-11 06:00:00	ES	Futures	4918.97	4920.34	4914.3	4920.07	5446.0
2023-09-11 07:00:00	ES	Futures	4919.79	4922.54	4916.77	4917.87	9406.0
2023-09-11 08:00:00	ES	Futures	4917.6	4925.83	4916.22	4925.01	13646.0
2023-09-11 09:00:00	ES	Futures	4925.28	4934.07	4913.75	4914.03	113586.0
2023-09-11 10:00:00	ES	Futures	4914.3	4923.91	4911.28	4913.21	103216.0
2023-09-11 11:00:00	ES	Futures	4913.21	4919.79	4908.26	4913.21	67673.0
2023-09-11 12:00:00	ES	Futures	4913.48	4923.36	4912.93	4922.54	42793.0
2023-09-11 13:00:00	ES	Futures	4922.26	4931.05	4920.07	4929.68	33375.0
2023-09-11 14:00:00	ES	Futures	4929.68	4931.6	4926.11	4930.22	32143.0
2023-09-11 15:00:00	ES	Futures	4930.5	4933.52	4925.56	4930.77	60863.0
2023-09-11 16:00:00	ES	Futures	4930.77	4932.15	4928.03	4928.03	16315.0
2023-09-11 18:00:00	ES	Futures	4927.75	4929.68	4924.73	4925.28	1976.0
2023-09-11 19:00:00	ES	Futures	4925.28	4927.21	4924.46	4925.28	1471.0
2023-09-11 20:00:00	ES	Futures	4925.28	4925.56	4921.44	4922.26	2674.0
2023-09-11 21:00:00	ES	Futures	4922.26	4925.01	4919.79	4921.99	2612.0
2023-09-11 22:00:00	ES	Futures	4921.71	4925.28	4920.89	4925.28	1289.0
2023-09-11 23:00:00	ES	Futures	4925.56	4927.48	4923.91	4926.93	1256.0
2023-09-11 00:00:00	NQ	Futures	17044.43	17066.68	17042.21	17065.57	1656.0
2023-09-11 01:00:00	NQ	Futures	17066.13	17093.11	17066.13	17091.16	3531.0
2023-09-11 02:00:00	NQ	Futures	17091.16	17103.95	17081.7	17095.33	2883.0
2023-09-11 03:00:00	NQ	Futures	17094.77	17135.66	17092.83	17117.02	6699.0
2023-09-11 04:00:00	NQ	Futures	17118.97	17132.32	17092.27	17099.5	4903.0
2023-09-11 05:00:00	NQ	Futures	17100.06	17117.86	17099.22	17114.52	2643.0
2023-09-11 06:00:00	NQ	Futures	17114.52	17124.26	17095.89	17122.87	3289.0
2023-09-11 07:00:00	NQ	Futures	17122.03	17149.57	17112.02	17131.21	6303.0
2023-09-11 08:00:00	NQ	Futures	17131.49	17161.25	17124.26	17159.02	7507.0
2023-09-11 09:00:00	NQ	Futures	17158.74	17186.56	17079.2	17093.66	56769.0
2023-09-11 10:00:00	NQ	Futures	17094.5	17123.42	17065.01	17086.15	41855.0
2023-09-11 11:00:00	NQ	Futures	17085.6	17137.61	17073.91	17098.11	26866.0
2023-09-11 12:00:00	NQ	Futures	17098.39	17136.22	17090.05	17128.15	18381.0
2023-09-11 13:00:00	NQ	Futures	17128.43	17210.2	17118.69	17208.25	22417.0
2023-09-11 14:00:00	NQ	Futures	17208.81	17226.61	17192.4	17217.99	13634.0
2023-09-11 15:00:00	NQ	Futures	17218.26	17241.35	17202.97	17216.6	20205.0
2023-09-11 16:00:00	NQ	Futures	17216.6	17226.05	17211.59	17212.15	4485.0
2023-09-11 18:00:00	NQ	Futures	17206.86	17209.09	17193.51	17195.18	1666.0
2023-09-11 19:00:00	NQ	Futures	17195.18	17206.86	17195.18	17199.63	837.0
2023-09-11 20:00:00	NQ	Futures	17199.35	17201.58	17181.55	17186.84	1739.0
2023-09-11 21:00:00	NQ	Futures	17186.28	17202.41	17179.88	17192.12	1636.0
2023-09-11 22:00:00	NQ	Futures	17190.73	17206.58	17187.11	17205.75	1122.0
2023-09-11 23:00:00	NQ	Futures	17206.3	17214.65	17200.19	17212.15	984.0
2023-09-11 00:00:00	YM	Futures	37891.8	37930.9	37890.8	37929.8	646.0
2023-09-11 01:00:00	YM	Futures	37929.8	37965.6	37925.5	37964.5	900.0
2023-09-11 02:00:00	YM	Futures	37964.5	37976.5	37952.6	37968.9	1123.0
2023-09-11 03:00:00	YM	Futures	37968.9	38035.0	37968.9	38020.9	3260.0

> showing 50 of 1,932 rows — these rows as CSV

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