PREVIEW / futures_1hour / 2023-09-13

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-09-13.parquet
  size:    64 KB
  rows:    1,994

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-13 00:00:00	ES	Futures	4894.26	4900.3	4893.44	4900.03	1111.0
2023-09-13 01:00:00	ES	Futures	4900.3	4901.13	4893.71	4896.19	1255.0
2023-09-13 02:00:00	ES	Futures	4895.91	4900.03	4892.89	4899.48	1690.0
2023-09-13 03:00:00	ES	Futures	4899.75	4907.71	4897.01	4902.22	6712.0
2023-09-13 04:00:00	ES	Futures	4902.22	4904.7	4896.46	4897.01	3645.0
2023-09-13 05:00:00	ES	Futures	4896.73	4901.95	4895.91	4900.58	2906.0
2023-09-13 06:00:00	ES	Futures	4900.58	4900.58	4892.62	4898.38	2561.0
2023-09-13 07:00:00	ES	Futures	4898.38	4904.7	4893.44	4903.05	3455.0
2023-09-13 08:00:00	ES	Futures	4903.05	4908.81	4882.73	4903.6	27991.0
2023-09-13 09:00:00	ES	Futures	4903.87	4915.95	4896.73	4912.11	36175.0
2023-09-13 10:00:00	ES	Futures	4912.38	4915.13	4891.52	4913.48	38472.0
2023-09-13 11:00:00	ES	Futures	4913.75	4919.24	4907.44	4915.4	18977.0
2023-09-13 12:00:00	ES	Futures	4915.4	4918.7	4909.64	4915.95	14068.0
2023-09-13 13:00:00	ES	Futures	4915.95	4920.34	4913.75	4917.05	9428.0
2023-09-13 14:00:00	ES	Futures	4917.05	4918.42	4896.19	4903.87	19695.0
2023-09-13 15:00:00	ES	Futures	4904.15	4910.46	4894.26	4907.17	33149.0
2023-09-13 16:00:00	ES	Futures	4906.89	4911.83	4905.24	4911.83	5160.0
2023-09-13 18:00:00	ES	Futures	4910.19	4911.28	4908.54	4909.64	1046.0
2023-09-13 19:00:00	ES	Futures	4909.91	4913.48	4909.36	4912.38	503.0
2023-09-13 20:00:00	ES	Futures	4912.66	4918.15	4911.56	4917.32	1652.0
2023-09-13 21:00:00	ES	Futures	4917.32	4920.07	4914.85	4917.05	1845.0
2023-09-13 22:00:00	ES	Futures	4917.05	4919.24	4914.58	4918.97	1103.0
2023-09-13 23:00:00	ES	Futures	4919.24	4922.81	4918.97	4922.54	1271.0
2023-09-13 00:00:00	NQ	Futures	17004.66	17033.31	17001.32	17032.75	786.0
2023-09-13 01:00:00	NQ	Futures	17033.59	17038.04	17003.83	17013.0	737.0
2023-09-13 02:00:00	NQ	Futures	17011.89	17023.29	16991.87	17022.46	1262.0
2023-09-13 03:00:00	NQ	Futures	17021.63	17060.56	17010.5	17028.86	3902.0
2023-09-13 04:00:00	NQ	Futures	17030.25	17040.82	17004.1	17004.66	1779.0
2023-09-13 05:00:00	NQ	Futures	17005.22	17024.13	16999.93	17015.79	1123.0
2023-09-13 06:00:00	NQ	Futures	17015.51	17016.9	16980.18	17002.43	1928.0
2023-09-13 07:00:00	NQ	Futures	17003.55	17041.65	16985.19	17036.09	1543.0
2023-09-13 08:00:00	NQ	Futures	17034.98	17052.22	16924.56	17023.02	10557.0
2023-09-13 09:00:00	NQ	Futures	17023.29	17096.44	17001.88	17081.15	17657.0
2023-09-13 10:00:00	NQ	Futures	17081.7	17107.29	16979.07	17091.44	18565.0
2023-09-13 11:00:00	NQ	Futures	17090.88	17142.06	17069.74	17116.75	13065.0
2023-09-13 12:00:00	NQ	Futures	17118.42	17146.51	17088.1	17128.71	9560.0
2023-09-13 13:00:00	NQ	Futures	17129.54	17159.86	17119.53	17142.61	7984.0
2023-09-13 14:00:00	NQ	Futures	17142.89	17150.4	17054.72	17087.82	10658.0
2023-09-13 15:00:00	NQ	Futures	17088.38	17095.05	17036.64	17086.15	13355.0
2023-09-13 16:00:00	NQ	Futures	17086.71	17111.46	17079.48	17107.85	1610.0
2023-09-13 18:00:00	NQ	Futures	17102.56	17108.4	17097.28	17103.12	316.0
2023-09-13 19:00:00	NQ	Futures	17102.56	17118.69	17099.78	17115.91	187.0
2023-09-13 20:00:00	NQ	Futures	17116.75	17136.77	17109.52	17133.99	521.0
2023-09-13 21:00:00	NQ	Futures	17134.55	17151.79	17126.76	17136.49	702.0
2023-09-13 22:00:00	NQ	Futures	17136.77	17147.06	17126.2	17147.06	212.0
2023-09-13 23:00:00	NQ	Futures	17149.57	17164.86	17144.84	17164.86	431.0
2023-09-13 00:00:00	YM	Futures	37891.8	37930.9	37886.4	37930.9	472.0
2023-09-13 01:00:00	YM	Futures	37929.8	37935.2	37896.2	37914.6	721.0
2023-09-13 02:00:00	YM	Futures	37912.4	37945.0	37896.2	37945.0	1240.0
2023-09-13 03:00:00	YM	Futures	37946.1	38002.5	37925.5	37965.6	4047.0

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

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