PREVIEW / futures_1hour / 2021-07-16

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-07-16.parquet
  size:    54 KB
  rows:    1,585

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
2021-07-16 00:00:00	ES	Futures	4900.38	4902.06	4899.25	4901.5	2710.0
2021-07-16 01:00:00	ES	Futures	4901.78	4903.47	4899.25	4899.53	4884.0
2021-07-16 02:00:00	ES	Futures	4899.25	4904.04	4894.46	4902.63	8601.0
2021-07-16 03:00:00	ES	Futures	4902.35	4907.41	4897.84	4904.32	22329.0
2021-07-16 04:00:00	ES	Futures	4904.04	4907.13	4898.69	4906.57	13684.0
2021-07-16 05:00:00	ES	Futures	4906.57	4910.79	4904.32	4909.39	21539.0
2021-07-16 06:00:00	ES	Futures	4909.39	4910.79	4902.35	4909.1	23769.0
2021-07-16 07:00:00	ES	Futures	4909.1	4910.79	4906.85	4909.67	19475.0
2021-07-16 08:00:00	ES	Futures	4909.67	4916.43	4909.1	4915.02	36206.0
2021-07-16 09:00:00	ES	Futures	4914.74	4919.8	4904.32	4907.7	196997.0
2021-07-16 10:00:00	ES	Futures	4907.98	4908.54	4884.33	4892.21	307873.0
2021-07-16 11:00:00	ES	Futures	4891.93	4893.34	4881.51	4890.24	173469.0
2021-07-16 12:00:00	ES	Futures	4890.24	4896.71	4888.55	4890.52	87808.0
2021-07-16 13:00:00	ES	Futures	4890.8	4895.03	4883.2	4884.89	83620.0
2021-07-16 14:00:00	ES	Futures	4884.89	4885.17	4871.94	4873.91	163840.0
2021-07-16 15:00:00	ES	Futures	4873.91	4875.6	4859.26	4864.61	296549.0
2021-07-16 16:00:00	ES	Futures	4864.9	4867.43	4859.55	4864.05	83413.0
2021-07-16 00:00:00	NQ	Futures	17120.45	17128.56	17113.5	17125.96	2137.0
2021-07-16 01:00:00	NQ	Futures	17125.96	17143.05	17123.64	17125.09	3073.0
2021-07-16 02:00:00	NQ	Futures	17123.64	17137.83	17102.78	17128.85	4506.0
2021-07-16 03:00:00	NQ	Futures	17129.14	17165.93	17111.47	17157.82	7481.0
2021-07-16 04:00:00	NQ	Futures	17157.24	17157.82	17121.61	17147.1	6907.0
2021-07-16 05:00:00	NQ	Futures	17146.52	17163.04	17136.38	17161.01	5476.0
2021-07-16 06:00:00	NQ	Futures	17161.88	17171.44	17140.15	17169.99	7741.0
2021-07-16 07:00:00	NQ	Futures	17169.41	17179.26	17157.24	17166.51	6942.0
2021-07-16 08:00:00	NQ	Futures	17165.64	17203.59	17159.56	17192.0	12571.0
2021-07-16 09:00:00	NQ	Futures	17192.0	17229.66	17152.32	17169.12	75701.0
2021-07-16 10:00:00	NQ	Futures	17168.54	17174.04	17078.45	17106.26	98292.0
2021-07-16 11:00:00	NQ	Futures	17106.55	17115.53	17028.33	17064.25	78074.0
2021-07-16 12:00:00	NQ	Futures	17064.25	17115.24	17061.07	17101.91	39345.0
2021-07-16 13:00:00	NQ	Futures	17101.33	17129.43	17074.39	17080.19	33026.0
2021-07-16 14:00:00	NQ	Futures	17080.48	17083.66	17035.87	17040.79	44591.0
2021-07-16 15:00:00	NQ	Futures	17040.79	17049.77	16982.27	17002.26	74187.0
2021-07-16 16:00:00	NQ	Futures	17001.97	17010.08	16985.75	16996.76	12368.0
2021-07-16 00:00:00	YM	Futures	38956.3	38972.0	38950.8	38968.6	864.0
2021-07-16 01:00:00	YM	Futures	38970.9	38980.9	38947.4	38947.4	1207.0
2021-07-16 02:00:00	YM	Futures	38946.3	38983.2	38909.4	38972.0	2051.0
2021-07-16 03:00:00	YM	Futures	38972.0	39007.7	38937.4	38972.0	4042.0
2021-07-16 04:00:00	YM	Futures	38970.9	39011.1	38935.1	39010.0	3122.0
2021-07-16 05:00:00	YM	Futures	39007.7	39035.7	38987.6	39015.6	3181.0
2021-07-16 06:00:00	YM	Futures	39016.7	39026.7	38947.4	38993.2	3595.0
2021-07-16 07:00:00	YM	Futures	38993.2	39008.9	38977.6	38995.4	2378.0
2021-07-16 08:00:00	YM	Futures	38994.3	39046.8	38991.0	39024.5	5247.0
2021-07-16 09:00:00	YM	Futures	39024.5	39075.9	38960.8	39012.2	21597.0
2021-07-16 10:00:00	YM	Futures	39010.0	39031.2	38773.1	38843.5	32270.0
2021-07-16 11:00:00	YM	Futures	38845.7	38865.8	38782.1	38863.6	14121.0
2021-07-16 12:00:00	YM	Futures	38864.7	38901.6	38827.9	38842.4	7652.0
2021-07-16 13:00:00	YM	Futures	38842.4	38859.1	38775.3	38788.8	7248.0
2021-07-16 14:00:00	YM	Futures	38791.0	38791.0	38664.7	38689.3	13800.0
2021-07-16 15:00:00	YM	Futures	38690.4	38690.4	38575.4	38616.7	22282.0

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

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