PREVIEW / futures_1hour / 2021-11-22

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-11-22.parquet
  size:    66 KB
  rows:    1,993

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-11-22 00:00:00	ES	Futures	5312.93	5313.78	5311.24	5313.78	3275.0
2021-11-22 01:00:00	ES	Futures	5313.5	5316.32	5311.8	5313.5	3732.0
2021-11-22 02:00:00	ES	Futures	5313.5	5316.88	5311.8	5314.06	5429.0
2021-11-22 03:00:00	ES	Futures	5313.78	5318.57	5312.93	5315.75	12709.0
2021-11-22 04:00:00	ES	Futures	5315.75	5319.14	5314.62	5316.6	10107.0
2021-11-22 05:00:00	ES	Futures	5316.88	5320.55	5315.75	5317.16	9528.0
2021-11-22 06:00:00	ES	Futures	5317.16	5324.5	5314.06	5314.91	17193.0
2021-11-22 07:00:00	ES	Futures	5314.62	5318.29	5311.8	5313.78	20095.0
2021-11-22 08:00:00	ES	Futures	5314.06	5318.29	5308.13	5316.88	29347.0
2021-11-22 09:00:00	ES	Futures	5316.88	5342.85	5315.19	5341.43	239736.0
2021-11-22 10:00:00	ES	Futures	5341.72	5351.31	5341.43	5342.85	206210.0
2021-11-22 11:00:00	ES	Futures	5342.85	5343.97	5302.77	5312.08	245994.0
2021-11-22 12:00:00	ES	Futures	5312.08	5324.5	5307.0	5318.86	191959.0
2021-11-22 13:00:00	ES	Futures	5318.86	5324.5	5314.62	5319.14	84534.0
2021-11-22 14:00:00	ES	Futures	5319.42	5332.4	5317.73	5331.27	93065.0
2021-11-22 15:00:00	ES	Futures	5331.27	5338.33	5280.76	5283.02	317916.0
2021-11-22 16:00:00	ES	Futures	5283.02	5287.81	5276.53	5287.53	90736.0
2021-11-22 18:00:00	ES	Futures	5289.79	5291.76	5287.25	5288.94	7913.0
2021-11-22 19:00:00	ES	Futures	5288.94	5293.18	5285.56	5290.07	8589.0
2021-11-22 20:00:00	ES	Futures	5290.07	5291.48	5283.02	5284.99	11204.0
2021-11-22 21:00:00	ES	Futures	5284.99	5285.27	5273.42	5281.04	11978.0
2021-11-22 22:00:00	ES	Futures	5281.32	5284.43	5279.63	5281.04	6661.0
2021-11-22 23:00:00	ES	Futures	5281.32	5285.27	5281.04	5284.71	3541.0
2021-11-22 00:00:00	NQ	Futures	19257.19	19267.62	19251.1	19266.75	2234.0
2021-11-22 01:00:00	NQ	Futures	19266.46	19271.97	19258.06	19262.99	1401.0
2021-11-22 02:00:00	NQ	Futures	19262.99	19279.8	19255.45	19271.68	2672.0
2021-11-22 03:00:00	NQ	Futures	19271.39	19284.43	19260.67	19274.0	4836.0
2021-11-22 04:00:00	NQ	Futures	19274.87	19301.24	19273.71	19289.65	7011.0
2021-11-22 05:00:00	NQ	Futures	19289.94	19297.19	19274.0	19281.83	4267.0
2021-11-22 06:00:00	NQ	Futures	19282.4	19297.19	19278.06	19291.68	5399.0
2021-11-22 07:00:00	NQ	Futures	19291.1	19298.63	19275.74	19283.56	6892.0
2021-11-22 08:00:00	NQ	Futures	19284.43	19306.46	19278.93	19302.98	9703.0
2021-11-22 09:00:00	NQ	Futures	19303.56	19403.55	19282.98	19384.71	98537.0
2021-11-22 10:00:00	NQ	Futures	19384.71	19438.04	19348.19	19358.63	94454.0
2021-11-22 11:00:00	NQ	Futures	19358.34	19366.16	19076.05	19135.18	150808.0
2021-11-22 12:00:00	NQ	Futures	19134.89	19198.65	19088.23	19161.26	119645.0
2021-11-22 13:00:00	NQ	Futures	19161.55	19186.19	19120.98	19140.97	52448.0
2021-11-22 14:00:00	NQ	Futures	19141.55	19218.93	19137.21	19209.95	46092.0
2021-11-22 15:00:00	NQ	Futures	19210.24	19242.41	18985.34	18992.59	108673.0
2021-11-22 16:00:00	NQ	Futures	18993.17	19019.83	18970.85	19010.27	25469.0
2021-11-22 18:00:00	NQ	Futures	19010.85	19028.81	19003.02	19008.82	4426.0
2021-11-22 19:00:00	NQ	Futures	19009.4	19027.08	18993.46	19017.51	4000.0
2021-11-22 20:00:00	NQ	Futures	19017.8	19022.73	18973.46	18983.31	6327.0
2021-11-22 21:00:00	NQ	Futures	18984.76	18985.34	18918.39	18956.07	9553.0
2021-11-22 22:00:00	NQ	Futures	18955.2	18970.56	18942.45	18946.22	4193.0
2021-11-22 23:00:00	NQ	Futures	18946.8	18967.37	18946.8	18964.48	2086.0
2021-11-22 00:00:00	YM	Futures	39968.2	39971.6	39952.5	39968.2	631.0
2021-11-22 01:00:00	YM	Futures	39967.1	39994.0	39959.2	39972.7	768.0
2021-11-22 02:00:00	YM	Futures	39972.7	40004.1	39957.0	39967.1	2052.0
2021-11-22 03:00:00	YM	Futures	39966.0	40024.2	39964.8	39991.7	3611.0

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

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