PREVIEW / futures_1hour / 2022-09-30

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-09-30.parquet
  size:    58 KB
  rows:    1,639

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
2022-09-30 00:00:00	ES	Futures	4109.44	4117.34	4104.65	4114.24	9634.0
2022-09-30 01:00:00	ES	Futures	4114.24	4127.49	4113.39	4117.34	15103.0
2022-09-30 02:00:00	ES	Futures	4117.34	4136.79	4117.34	4132.56	27879.0
2022-09-30 03:00:00	ES	Futures	4132.56	4157.65	4132.28	4156.52	49329.0
2022-09-30 04:00:00	ES	Futures	4156.24	4164.98	4149.47	4162.72	33713.0
2022-09-30 05:00:00	ES	Futures	4163.0	4163.29	4142.99	4146.65	28504.0
2022-09-30 06:00:00	ES	Futures	4146.37	4160.47	4137.07	4140.74	29164.0
2022-09-30 07:00:00	ES	Futures	4140.74	4142.43	4121.85	4129.74	38774.0
2022-09-30 08:00:00	ES	Futures	4129.74	4146.09	4105.22	4128.33	133538.0
2022-09-30 09:00:00	ES	Futures	4128.05	4133.41	4089.15	4122.13	334114.0
2022-09-30 10:00:00	ES	Futures	4122.41	4139.89	4105.5	4134.53	371704.0
2022-09-30 11:00:00	ES	Futures	4134.53	4154.55	4118.18	4120.72	294013.0
2022-09-30 12:00:00	ES	Futures	4121.0	4125.79	4107.75	4117.62	201608.0
2022-09-30 13:00:00	ES	Futures	4117.34	4121.28	4094.79	4098.17	195076.0
2022-09-30 14:00:00	ES	Futures	4098.45	4107.47	4077.31	4079.56	259285.0
2022-09-30 15:00:00	ES	Futures	4079.85	4095.91	4055.32	4056.17	594135.0
2022-09-30 16:00:00	ES	Futures	4056.17	4073.64	4053.91	4064.06	127902.0
2022-09-30 00:00:00	NQ	Futures	12866.17	12898.63	12849.21	12888.58	6016.0
2022-09-30 01:00:00	NQ	Futures	12888.58	12938.86	12885.42	12902.37	8626.0
2022-09-30 02:00:00	NQ	Futures	12902.08	12980.52	12902.08	12966.16	13476.0
2022-09-30 03:00:00	NQ	Futures	12966.44	13045.74	12965.29	13028.22	22598.0
2022-09-30 04:00:00	NQ	Futures	13027.93	13042.87	12990.58	13036.26	17169.0
2022-09-30 05:00:00	NQ	Futures	13036.84	13037.99	12965.01	12978.22	14548.0
2022-09-30 06:00:00	NQ	Futures	12977.65	13021.9	12945.76	12958.97	13836.0
2022-09-30 07:00:00	NQ	Futures	12959.26	12965.58	12899.5	12927.08	19664.0
2022-09-30 08:00:00	NQ	Futures	12927.65	12987.13	12831.4	12918.17	53865.0
2022-09-30 09:00:00	NQ	Futures	12918.46	12948.05	12806.69	12908.4	106076.0
2022-09-30 10:00:00	NQ	Futures	12907.54	13006.09	12868.46	12986.84	106486.0
2022-09-30 11:00:00	NQ	Futures	12986.84	13052.93	12913.86	12924.78	85899.0
2022-09-30 12:00:00	NQ	Futures	12925.36	12944.03	12871.63	12903.23	61102.0
2022-09-30 13:00:00	NQ	Futures	12902.08	12915.01	12815.02	12826.8	58252.0
2022-09-30 14:00:00	NQ	Futures	12827.09	12862.72	12763.88	12770.2	75000.0
2022-09-30 15:00:00	NQ	Futures	12770.2	12827.95	12670.21	12677.11	126055.0
2022-09-30 16:00:00	NQ	Futures	12677.39	12738.31	12670.5	12709.29	29962.0
2022-09-30 00:00:00	YM	Futures	32745.7	32795.0	32707.5	32777.1	1390.0
2022-09-30 01:00:00	YM	Futures	32774.8	32864.6	32769.2	32799.5	2276.0
2022-09-30 02:00:00	YM	Futures	32802.9	32931.9	32801.8	32900.5	3268.0
2022-09-30 03:00:00	YM	Futures	32899.4	33094.7	32897.2	33085.7	6737.0
2022-09-30 04:00:00	YM	Futures	33089.1	33160.9	33047.5	33145.2	4703.0
2022-09-30 05:00:00	YM	Futures	33147.4	33150.8	33007.1	33028.5	3589.0
2022-09-30 06:00:00	YM	Futures	33028.5	33129.5	32965.6	32992.5	3973.0
2022-09-30 07:00:00	YM	Futures	32994.8	33004.9	32843.3	32903.9	5058.0
2022-09-30 08:00:00	YM	Futures	32901.6	32999.3	32747.9	32891.5	16441.0
2022-09-30 09:00:00	YM	Futures	32889.3	32928.6	32605.4	32847.8	31410.0
2022-09-30 10:00:00	YM	Futures	32846.7	32909.5	32673.8	32870.2	24718.0
2022-09-30 11:00:00	YM	Futures	32871.3	33008.3	32740.0	32759.1	19049.0
2022-09-30 12:00:00	YM	Futures	32758.0	32782.7	32657.0	32734.4	14008.0
2022-09-30 13:00:00	YM	Futures	32733.3	32768.1	32570.6	32587.4	12744.0
2022-09-30 14:00:00	YM	Futures	32587.4	32653.6	32439.3	32456.1	17549.0
2022-09-30 15:00:00	YM	Futures	32456.1	32576.2	32283.3	32302.4	30298.0

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

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