PREVIEW / futures_1hour / 2023-09-12

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-09-12.parquet
  size:    61 KB
  rows:    1,942

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-12 00:00:00	ES	Futures	4926.66	4928.3	4923.91	4924.19	1109.0
2023-09-12 01:00:00	ES	Futures	4924.73	4926.38	4922.81	4925.56	1657.0
2023-09-12 02:00:00	ES	Futures	4925.56	4928.3	4924.73	4926.38	2667.0
2023-09-12 03:00:00	ES	Futures	4926.11	4928.03	4917.05	4918.97	7048.0
2023-09-12 04:00:00	ES	Futures	4918.97	4922.26	4915.95	4917.87	4935.0
2023-09-12 05:00:00	ES	Futures	4917.6	4921.17	4914.85	4919.24	4460.0
2023-09-12 06:00:00	ES	Futures	4919.24	4922.81	4918.15	4921.71	3888.0
2023-09-12 07:00:00	ES	Futures	4921.71	4921.99	4914.3	4914.85	5421.0
2023-09-12 08:00:00	ES	Futures	4914.85	4922.54	4914.03	4916.22	10813.0
2023-09-12 09:00:00	ES	Futures	4915.95	4922.81	4909.09	4920.89	45133.0
2023-09-12 10:00:00	ES	Futures	4920.89	4921.44	4905.24	4905.52	45425.0
2023-09-12 11:00:00	ES	Futures	4905.24	4915.95	4903.87	4914.3	28814.0
2023-09-12 12:00:00	ES	Futures	4914.3	4919.79	4913.21	4916.77	20538.0
2023-09-12 13:00:00	ES	Futures	4916.77	4931.32	4912.11	4914.03	34470.0
2023-09-12 14:00:00	ES	Futures	4914.03	4914.85	4901.95	4903.05	26494.0
2023-09-12 15:00:00	ES	Futures	4903.32	4904.97	4895.91	4902.5	49275.0
2023-09-12 16:00:00	ES	Futures	4902.22	4905.52	4901.95	4902.77	9231.0
2023-09-12 18:00:00	ES	Futures	4902.22	4903.05	4900.3	4902.22	777.0
2023-09-12 19:00:00	ES	Futures	4901.95	4903.87	4900.85	4903.05	485.0
2023-09-12 20:00:00	ES	Futures	4903.05	4904.15	4901.13	4902.22	1284.0
2023-09-12 21:00:00	ES	Futures	4902.5	4904.7	4896.73	4898.38	2053.0
2023-09-12 22:00:00	ES	Futures	4898.66	4900.3	4893.99	4895.64	1930.0
2023-09-12 23:00:00	ES	Futures	4895.64	4896.73	4893.71	4894.26	844.0
2023-09-12 00:00:00	NQ	Futures	17212.15	17217.99	17201.3	17202.41	869.0
2023-09-12 01:00:00	NQ	Futures	17202.97	17210.2	17194.35	17205.47	1134.0
2023-09-12 02:00:00	NQ	Futures	17206.3	17222.71	17202.13	17215.76	1428.0
2023-09-12 03:00:00	NQ	Futures	17214.93	17221.88	17166.81	17177.1	3845.0
2023-09-12 04:00:00	NQ	Futures	17176.54	17179.88	17157.08	17163.19	2745.0
2023-09-12 05:00:00	NQ	Futures	17162.92	17181.83	17154.02	17173.76	2220.0
2023-09-12 06:00:00	NQ	Futures	17172.65	17196.85	17171.26	17189.9	2223.0
2023-09-12 07:00:00	NQ	Futures	17190.17	17191.84	17156.24	17157.63	2260.0
2023-09-12 08:00:00	NQ	Futures	17158.19	17183.78	17149.84	17156.24	4061.0
2023-09-12 09:00:00	NQ	Futures	17155.69	17201.02	17120.64	17191.29	25416.0
2023-09-12 10:00:00	NQ	Futures	17191.56	17196.57	17073.36	17075.58	25335.0
2023-09-12 11:00:00	NQ	Futures	17075.58	17101.45	17046.38	17085.87	17853.0
2023-09-12 12:00:00	NQ	Futures	17086.43	17111.46	17080.59	17090.88	10734.0
2023-09-12 13:00:00	NQ	Futures	17091.99	17153.46	17059.73	17072.8	15861.0
2023-09-12 14:00:00	NQ	Futures	17073.08	17077.53	17025.52	17030.53	12885.0
2023-09-12 15:00:00	NQ	Futures	17031.08	17041.09	17009.11	17024.13	16287.0
2023-09-12 16:00:00	NQ	Futures	17024.13	17036.64	17018.84	17031.64	2896.0
2023-09-12 18:00:00	NQ	Futures	17031.08	17038.87	17026.63	17036.09	656.0
2023-09-12 19:00:00	NQ	Futures	17034.42	17038.87	17027.74	17034.14	243.0
2023-09-12 20:00:00	NQ	Futures	17032.75	17037.2	17022.46	17031.36	559.0
2023-09-12 21:00:00	NQ	Futures	17032.47	17043.04	17008.28	17015.51	1035.0
2023-09-12 22:00:00	NQ	Futures	17014.95	17026.08	16995.48	17006.05	1011.0
2023-09-12 23:00:00	NQ	Futures	17006.05	17013.0	17001.32	17004.1	389.0
2023-09-12 00:00:00	YM	Futures	37974.3	37980.8	37954.8	37958.0	320.0
2023-09-12 01:00:00	YM	Futures	37959.1	37967.8	37948.2	37958.0	506.0
2023-09-12 02:00:00	YM	Futures	37959.1	37976.5	37951.5	37962.3	950.0
2023-09-12 03:00:00	YM	Futures	37961.3	37976.5	37904.9	37914.6	2191.0

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

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